首页 > 代码库 > Asp.net C# 遍历Excel中的表格名称
Asp.net C# 遍历Excel中的表格名称
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;
}
}
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。