Same code Imports different rows using XlsIo ver 4.1 and ver 6.3

[Phani N]

I am trying to use version 6.3 of Syncfusion and my existing code in 4.1 is behaving differently in 6.3.

I have attached the solutions I have created using 4.1 and 6.3 using the exact same excel handler logic and also the excel file I am trying to import. 4.1 imports 3 rows whereas 6.3 imports only 2. Am I doing anything wrong? Should I be changing the code for 6.3?

Thanks




Import Discrepency_54c0377d.renameToZip

[Phani N]

I guess the upload failed in the last post. trying again.



Import Discrepency_8b061e2f.zip

[Vijesh Narayanan]

Hi Phani,

Thank you for using Essential XlsIO.

You just have to make a small modification, as given in the following code snippet, to your code to get the desired output.

dt = sheet.ExportDataTable(
 sheet.Range[OFFSET, 1, sheet.UsedRange.Rows.GetUpperBound(0)+1,
 sheet.UsedRange.Columns.GetUpperBound(0)+1],
 ExcelExportDataTableOptions.ColumnNames | 
 ExcelExportDataTableOptions.ComputedFormulaValues);

Please try this and let me know if you have any further questions.

Regards,
Vijesh