in ExportDataTable the filtered row are not saved

[marco del frate]

Good morning,

i'm using an sfspreadsheet with autofilters.

I notd that if i use the ExportoDataTable function while the worksheet si filtered, the row that are no visibile due to the filter, will not be exported into the datatable.

Is this what expected?

Is it possible to export to datatable all the used range even if some filter is applied?

Thank You

Best regards

[Dhanasekar Mohanraj]

Hi Marco del frate,

Currently, we are checking the reported issue with the provided details. We will check and update you with further details on Mar 07, 2023.

We appreciate your patience until then.

Regards,

Dhanasekar M.

[Dhanasekar Mohanraj]

Marco del frate,

We have checked the reported scenario on our end. By default, hidden rows will not be exported to the data table while using the ExportDataTable method. However, you can overcome this by using the ExportHiddenRows as shown below,

DataTable customersTable = worksheet.ExportDataTable(worksheet.UsedRange, ExcelExportDataTableOptions.ExportHiddenRows);

If this post is helpful, please consider Accepting it as the solution so that other members can locate it more quickly.