Working with empty cells in the worksheet in .NET

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 :slight_smile:

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.3.1.3

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.