I am trying to get Sheet name from excel file. i am using Using following Code. But its returning Empty Datatable. I am working in VB.NET (Framework version 2) . Please check my code and provide me the idea.
Private Sub GetExcelSheetNames(ByVal fileName As String)
    Dim strconn As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & 
          fileName & ";Extended Properties=""Excel 12.0 Xml;HDR=YES"";"
    Dim conn As New OleDbConnection(strconn)
    conn.Open()
    Dim dtSheets As DataTable = 
              conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
    Dim drSheet As DataRow
    For Each drSheet In dtSheets.Rows
       Console.WriteLine(drSheet("TABLE_NAME").ToString())
    Next
    conn.Close()
End Sub
