I have an excel containing many information. Column for information that’s no longer needed but important is hidden while the latest one remain visible. Is there a way for me to read only the visible one?
you can use datatable.DefaultView.ToTable(False,“Column Name1”,“Column Name2”).
with all the columns you need
can you explain more on it? will it work if total column and column name is uncertain?
No this will work only if you know the column names
You can try reading the excel file with the Excel Application Scope and Read range by setting the Preserve Format property to True. The column name will be read but the values of the hidden column will not be read (empty values)