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