Worksheet.ExportDataTable Malfunction

[l.iglesias]

Hello,

I'm trying to use the ExportDataTable with the attached excel in order to get only the data rows, and not the headers and the first 2 empty rows. In order to accomplish this I'm executing the folowing sheet.ExportDataTable(4, 1, 9, 8, false);

According to the definition of the method, this call should return from the row 4 to the row 9 the first 8 columns, without exporting column names. Well, I've been making some tests and it seems the firstRow parameters is being ignored. What i'm getting executing this is the rows between 1 and 9 into the DataTable.

Am i doing something wrong?

I'm using version 7.0.0.7040

[Gary.zhang]

Hello,

Thanks for your feedback.
We have noticed the issue you mentioned, which has been transferred to our Dev team, once there are any progress, we will inform you immediately. Sorry for inconvenience. And there is another method you can use.

Code: Select all

Workbook book = new Workbook();
book.LoadFromFile("Example.XLS");
Worksheet sheet = book.Worksheets[0];
DataTable dt = sheet.ExportDataTable(sheet.Range["A4:H9"], false);


Sincerely,
Gary
E-iceblue support team

[Gary.zhang]

Hello,

Regarding the issue, please download the Spire.Xls7.4 and test it again. And sheet.ExportDataTable(4, 1, 9, 8, false) function means that it starts from the row 4 and get 9 rows not to row 9, if you want to get 5 rows, you have to set it like this

Code: Select all

sheet.ExportDataTable(4, 1, 5(it is maxRows not row 5),8, false) ;


If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team