Obtain the sheet name in Excel

///
/// This mehtodd retrieves the Excel sheet names from
/// An Excel Workbook.
///
/// The Excel file.
/// String []
Private string [] getexcelsheetnames (string excelfile)
{
Oledbconnection objconn = NULL;
System. Data. datatable dt = NULL; try
{
// Connection string. Change the Excel file to the file you
// Will search.
String connstring = "provider = Microsoft. Jet. oledb.4.0;" +
"Data Source =" + excelfile + "; extended properties = Excel 8.0 ;";
// Create connection object by using the preceding connection string.
Objconn = new oledbconnection (connstring );
// Open connection with the database.
Objconn. open ();
// Get the data table containg the schema guid.
Dt = objconn. getoledbschematable (oledbschemaguid. Tables, null );

If (Dt = NULL)
{
Return NULL;
} String [] excelsheets = new string [DT. Rows. Count];
Int I = 0; // Add the sheet name to the string array.
Foreach (datarow row in DT. Rows)
{
Excelsheets [I] = row ["table_name"]. tostring ();
I ++;
} // Loop through all of the sheets if you want too...
For (Int J = 0; j <excelsheets. length; j ++)
{
// Query each Excel sheet.
} Return excelsheets;
}
Catch (exception ex)
{
Return NULL;
}
Finally
{
// Clean up.
If (objconn! = NULL)
{
Objconn. Close ();
Objconn. Dispose ();
}
If (DT! = NULL)
{
DT. Dispose ();
}
}
}