怎么读取excel文件中的所有sheet名称？

[programmeraaron]

DataSet ds = new DataSet();
OleDbDataAdapter ad;
string strDbPath = strExcelFilePath;
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strExcelFilePath + ";Extended Properties=Excel 8.0;";
OleDbConnection Conn = new OleDbConnection(strConn);
Conn.Open();
string strSQL = "SELECT * FROM [sheet1$]";
ad = new OleDbDataAdapter(strSQL, Conn);
ad.Fill(ds);
Conn.Close();
Conn.Dispose();
return ds;

这是我读取“sheet1”时用的，如何得到当前excel文件中的所有sheet?

[cocoguo]

bConnection.Open();
DataTable dt=bConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[]{null,null,null,"TABLE"});
foreach(DataRow dr in dt.Rows)
{
MessageBox.Show(dr["TABLE_NAME"].ToString());
}

[孟子E章]

int totalSheets = ThisWorkbook.Sheets.Count;
for(int i=0;i<totalSheets;i++)
Response.Write(ThisWorkbook.Sheets[i].Name);

[孟子E章]

也可以

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();
}
}
}