Ignore Hidden Columns while Exporting Worksheet Data to Data Table
Contents
[
Hide
]
Sometimes, you want to ignore hidden columns while exporting worksheet data to a data table. You can achieve it using Aspose.Cells by setting the ExportTableOptions.PlotVisibleColumns to true. By default, its value is false, so you need to set it true to ignore the hidden columns.
The following sample code explains the usage of ExportTableOptions.PlotVisibleColumns property in ignoring the hidden columns while exporting the worksheet entire data to the data table.