Get sheets names from excel ASP.Net

Question

I am getting sheets names sorting alphabetically by next code.

        OleDbConnection connection = new OleDbConnection(string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}; Extended Properties=\"Excel 8.0;HDR=No;\"", filePath));
        OleDbCommand command = new OleDbCommand();
        DataTable tableOfData = null;
        command.Connection = connection;
        try
        {
            connection.Open();
            tableOfData = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            string tablename = tableOfData.Rows[0]["TABLE_NAME"].ToString();
            tableOfData = new DataTable();
            command.CommandText = "Select * FROM [" + tablename + "]";
            tableOfData.Load(command.ExecuteReader());
        }
        catch (Exception ex)
        {
        }

I want only to read them with original order. Any idea?

Code return first sheet alphabetical not actual first one in sheet. — Aya Aboud, Dec 15 '16 at 07:51

score 0 · Accepted Answer · edited May 23 '17 at 11:45

0

After many search i found out that "OLEDB" not support reading sheets in original order (read sheets names in alphabetical order only) but there are many way support reading sheets names in original order from excel file.

Helped link: Reading sheets in original order from excel file,
OLEDB does not preserve the sheet order as they were in Excel.

edited May 23 '17 at 11:45

Community

1
1

answered Dec 19 '16 at 11:43

Aya Aboud

371
2
4
16

Get sheets names from excel ASP.Net

1 Answers1