Import Hidden sheet

Dec 27, 2016 at 7:47 AM
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

        While lexcReader.Read

        End While

        lexcReader.Close()
        lexcReader.Dispose()

        Return lresult.Tables(0)
Thanks, any quick reply will be apprecited.