Working with Excel ? In Asp.net?

Question

In web application, i write the code for displaying the data in excel sheet to gridview. it is working fine but, can i track the sheet name of that particular excel sheet. For example i have sample.xls in that how can i find the sheet name. i write the query like this

    OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);

How can i find the sheet name of the particular excel and if the excel sheet having more than one sheet then how can i display the data. can you help me.

KV Prajapati · Accepted Answer · 2012-01-05 05:02:09Z

1

Use OleDbConnection.GetOleDbSchemaTable Method.

using (OleDbConnection connection = new 
               OleDbConnection(connectionString))
    {
        connection.Open();
        DataTable schemaTable = connection.GetOleDbSchemaTable(
            OleDbSchemaGuid.Tables,
            new object[] { null, null, null, "TABLE" });
        return schemaTable;
    }

answered Jan 5, 2012 at 5:02

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Working with Excel ? In Asp.net?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related