62,046
社区成员
发帖
与我相关
我的任务
分享
//导入EXCEL
public void ImportExcel(string file)
{
//string file = "d:\\123.xls";
string excelStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file + ";Extended Properties=Excel 8.0;";
DataSet ds = new DataSet();
using (System.Data.OleDb.OleDbConnection cn = new OleDbConnection(excelStr))
{
using (OleDbDataAdapter dr = new OleDbDataAdapter("SELECT * FROM [sheet1$]", excelStr))
{
dr.Fill(ds);
}
}
}