ExportDataTable and ExportDataTableAsString

Aspose.Cells Product Family
1
  1. Try to export an excel sheet with 2 blank lines to a datatable/datatableasstring. Set export column name property to false. Notice datatable adds the two blank lines as the last two rows of table. The first row of data table is the first non blank row.

    2. Repeat workflow with an excel with column header followed by two blank lines. Set export column name to true. Notice the blank lines remain in correct order.

    Is it possible to make these consistent? I think case 1 should be modified so the blank lines are in the first two rows.

    Attached test program
2

Hi,


Thanks for the sample project.

I have tested your scenario/ case using your sample project with your template file(s).
I observed the issue as you mentioned by using the first case. Using Cells.ExportDataTable/ExportDataTableAsString, the two blank rows (in the worksheet) are the last two records instead of the first two records of the table. I have logged a ticket with an id “CELLSNET-44780” for your issue. We will look into your issue soon.

Once we have an update on it, we will let you know here.

Thank you.
3

Hi,


Thanks for using Aspose.Cells.

Please change your code

var datatable = cells.ExportDataTable(cells.MinRow, cells.MinColumn, cells.MaxRow + 1, cells.MaxColumn + 1, false);

as

var datatable = cells.ExportDataTable(0, 0, cells.MaxRow + 1, cells.MaxColumn + 1, false);

and it should fix your issue. Let us know your feedback and have a good day.