Asp.net C# 遍历Excel中的表格名称
string strConn =
"
Provider=Microsoft.Jet.OLEDB.4.0;
" +
"
Data Source=
" + filePath +
"
;
" +
"
Extended Properties=\"Excel 8.0\"
";
// string strConn_ACE = "Provider=Microsoft.ACE.OLEDB.12.0;data source=" + filePath + ";Extended Properties='Excel 12.0;HDR=NO;IMEX=1'";
// new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("DataBase/hooyesDatabase.mdb"));
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter da = null;
DataTable dtSheetName = null;
string SheetName = "";
dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, " TABLE " });
for ( int i = 0; i < dtSheetName.Rows.Count; i++)
{
SheetName = ( string)dtSheetName.Rows[i][ " TABLE_NAME "];
if (SheetName.Contains( " $ ") && !SheetName.Replace( " ' ", "").EndsWith( " $ "))
{
continue;
}
if (SheetName == " 已售号码$ ")
{
break;
}
}
// string strConn_ACE = "Provider=Microsoft.ACE.OLEDB.12.0;data source=" + filePath + ";Extended Properties='Excel 12.0;HDR=NO;IMEX=1'";
// new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("DataBase/hooyesDatabase.mdb"));
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter da = null;
DataTable dtSheetName = null;
string SheetName = "";
dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, " TABLE " });
for ( int i = 0; i < dtSheetName.Rows.Count; i++)
{
SheetName = ( string)dtSheetName.Rows[i][ " TABLE_NAME "];
if (SheetName.Contains( " $ ") && !SheetName.Replace( " ' ", "").EndsWith( " $ "))
{
continue;
}
if (SheetName == " 已售号码$ ")
{
break;
}
}