在ASP.NET访问Excel文件
using System.Data;
using System.Data.OleDb;
private DataSet GetExcel(string strFilePath, string strSheetName)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
string strSQL = "select * from [" + strSheetName + "$]";
OleDbCommand comm = new OleDbCommand(strSQL, conn);
OleDbDataAdapter da = new OleDbDataAdapter(comm);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
conn.Close();
}