How to read data from .xls files if it contains some hidden rows or columns

Feb 6, 2012 at 10:24 AM

Hi,

How to read data from .xls files if it contains some hidden rows or columns?

ExcelReaderFactory.CreateBinaryReader returns no data from .xls file if column and rows are hidden. It works fine with .xlsx file.