Asp.Net(C#)使用oleDbConnection 连接Excel的方法

using System.Data.OleDb;
using System.Data;

String sConnectionString = \"Provider=Microsoft.Jet.OLEDB.4.0;\" +
\"Data Source=c:/test.xls;\" +
\"Extended Properties=Excel 8.0;\";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
OleDbCommand objCmdSelect =new OleDbCommand(\"SELECT * FROM [sheet1]\", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
DataSet objDataset1 = new DataSet();
//将Excel中数据填充到数据集
objAdapter1.Fill(objDataset1, \"XLData\");
objConn.Close();

String sConnectionString = \"Provider=Microsoft.Jet.OLEDB.4.0;\" +
\"Data Source=c:/test.xls;\" +
\"Extended Properties=Excel 8.0;\";
OleDbConnection cn = new OleDbConnection(sConnectionString);
cn.Open();
DataTable tb = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
foreach (DataRow row in tb.Rows)
{
//遍历弹出各Sheet的名称
MessageBox.Show(row[\"TABLE_NAME\"]);
}

String sConnectionString = \"Provider=Microsoft.Jet.OLEDB.4.0;\" +
\"Data Source=c:/test.xls;\" +
\"Extended Properties=Excel 8.0;\";
OleDbConnection cn = new OleDbConnection(sConnectionString);
string sqlCreate = \"CREATE TABLE TestSheet ([ID] INTEGER,[Username] VarChar,[UserPwd] VarChar)\";
OleDbCommand cmd = new OleDbCommand(sqlCreate, cn);
//创建Excel文件：C:/test.xls
cn.Open();
//创建TestSheet工作表
cmd.ExecuteNonQuery();
//添加数据
cmd.CommandText = \"INSERT INTO TestSheet VALUES(1,\'elmer\',\'password\')\";
cmd.ExecuteNonQuery();
//关闭连接
cn.Close();