服务器端如何读取客户端excel文件的内容？急急

[Bettyh]

要做个程序，将客户端excel文件中的内容读取到浏览器上，然后保存到数据库中。如何读取excel中的内容？

[seesea125]

先上传文件到服务器，然后读取excel

public class ExcelToTable
{
//把Excel数据读入DataTable
public static DataTable ExcelToDataTable(string strExcelFileName, string strSheetName)
{
//string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strExcelFileName + ";" + "Extended Properties=Excel8.0;HDR=Yes;IMEX=1;";
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strExcelFileName + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";

string strExcel = string.Format("select * from [{0}$]", strSheetName);
DataSet ds = new DataSet();

OleDbConnection conn = new OleDbConnection(strConn);
try
{
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, strConn);
adapter.Fill(ds, strSheetName);
conn.Close();
}
catch
{
throw;
}
finally
{
conn.Close();
}
return ds.Tables[strSheetName];
}
}

[mochencui]

好东西