We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

in ExportDataTable the filtered row are not saved

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

2 Replies 1 reply marked as answer

DM Dhanasekar Mohanraj Syncfusion Team March 3, 2023 02:04 PM UTC

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.


Dhanasekar M.

DM Dhanasekar Mohanraj Syncfusion Team March 7, 2023 01:57 PM UTC

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.

Marked as answer
Live Chat Icon For mobile
Up arrow icon