Export Visible Rows Data from Worksheet
This example shows how to export data from the following worksheet. Rows 5, 6 and 7 are hidden.
|Sample data in worksheet, rows 5, 6 and 7 are hidden|
Once the data is exported to a data table using the Worksheet.Cells.ExportDataTable() method with the ExportTableOptions.PlotVisibleRows option, it will look like this. Hidden rows are plotted as blank rows
|Hidden rows are exported to the data table as blank rows|