asp.net 操作Excel 连接字符串

try {

System.Data.DataSet ds = new System.Data.DataSet();

//for 2007

//string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("1111.xlsx") + ";Extended Properties=\"Excel 12.0;HDR=YES\"";

//for 2003

var strConn = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0;", Server.MapPath("1111.xlsx"));

using (var oledbConn = new System.Data.OleDb.OleDbConnection(strConn))

{ oledbConn.Open();

var sheetName = oledbConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,

//检索excel的架构信息 new[] { null, null, null, "Table" });

var sheet = new string[sheetName.Rows.Count];

for (int i = 0, j = sheetName.Rows.Count; i < j; i++)

{ sheet[i] = sheetName.Rows[i]["TABLE_NAME"].ToString(); }

//这里您可以用一个for来查询每一个工作簿，

我这里只查询了第一个

var adapter = new System.Data.OleDb.OleDbDataAdapter(string.Format("select * from [{0}]", sheet[0]), oledbConn); adapter.Fill(ds); } }

catch (Exception ex) { Response.Write(ex); }