Question

C# 后台程序，用ADO.net 如何读取EXCEL中数据到DataSet

Data Source 中路径格式是D:/try01/123.xls , D:\try01\123.xls, 还是D:\\try01\\123.xls?

Answer 1

publicDataSet ImportExcel(string strFileName) //参数为文件路径+文件名。就是DataSource
{
if (strFileName != "")
{
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileName + ";Extended Properties=Excel 8.0";
string sql = "select * from [Sheet1$]";
OleDbDataAdapter da = newOleDbDataAdapter(sql, conn);
DataSet ds = newDataSet();
try
{
da.Fill(ds, "datatable");
}
catch
{

}
return ds;
}
else
{
return null;
}
}

Answer 2

D:\\try01\\123.xls