Hello Petko Petkov ,
Based on the article http://www.igniteui.com/javascript-excel-library/excel-import-data I implemented import functionality . But When I try to upload an excel which has 4 rows where 1st and 3rd rows are empty rows then the worksheet.rows() is getting only 3 rows and ignoring the last row.
Please check this . I tested this in http://www.igniteui.com/javascript-excel-library/excel-import-data .
Thanks,
Balakumar
Hi Balakumar,
Please note that the approach implemented at http://www.igniteui.com/javascript-excel-library/excel-import-data requires that the data in the excel file start from A1 cell, therefore an empty first row or column will break the logic and no grid will be created on the page.
Please let me know if you have further questions on the matter, I will be glad to help.
Hello Hristo ,
My requirement is to avoid Empty rows and load just the rows with data . This is the data in excel I try to upload.
(There is an empty row added after each row with data)
After Import in http://www.igniteui.com/javascript-excel-library/excel-import-data I dont see the last row where Emp NAme is Keta.
I have another question too . The js files which is used to provide these functionalities , are they Open source ?
Bala
Hello Balakumar,
The worksheet's row object is created when a value in a row's cell is read/written or the row itself is read. Initially, when the worksheet is created from the Uint8Array object the empty rows are ignored, therefore the worksheet.rows().count() returns the number of rows containing data.
You can modify the sample code to hardcode this value or modify the logic that iterates through all rows.
Regarding your other question - a considerable part of Ignite LoB is open source, but the igGrid and JavaScript Excel Engine is not part of it. You can view the IgniteUI OSS repo at https://github.com/IgniteUI/ignite-ui