GetSheets with code activity and vb.net

Help
8

@KevinDS,

Try with this code,

Dim fileName = "C:\ExcelFile.xlsx"
    Dim connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & fileName & ";Extended Properties=""Excel 12.0;IMEX=1;HDR=NO;TypeGuessRows=0;ImportMixedTypes=Text"""

    Using conn = New OleDbConnection(connectionString)
        conn.Open()
        Dim sheets = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
1 Like