Hello, i’m trying to use aspose to import data drom excel files, unfortunatly in some worksheets some cells are empty which cause a big changement in the row.GetCellByIndex(…) function
meaning when the counter find an empty cell in the row the function row.GetCellByIndex() will changes the indexs of all the cells for example :
with non empty cells in the row :
the function: row.GetCellByIndex(5).StringValue; will return a different value when we will have a blank cells
anyone can help me to deal with this and fix the indexs even with empty cells in my file
Thx
Hi,
If you still find the issue with it, kindly create a sample console application (runnable), zip it and post us here to reproduce the issue on our end. Also, provide your template Excel file here, this will help us really to evaluate your issue precisely to consequently figure it out soon.
Thank you.