I am using IExcelDataReader in my Project in order to import the Excel worksheet into DataTable. Everything works fine but in one of my project the excel sheet is hidden, and IExcelDataReader doea not import the excel which is hidden.
Please help me out on this its very urgent.
Below is my sample code:
'Create a new DataTable.
Dim dt As New DataTable()
Dim lstream As FileStream = File.Open(strFileName, FileMode.Open, FileAccess.Read)
Dim lexcReader As IExcelDataReader = ExcelReaderFactory.CreateBinaryReader(lstream)
Dim lresult As DataSet = lexcReader.AsDataSet
lexcReader.IsFirstRowAsColumnNames = True
Thanks, any quick reply will be apprecited.