检查出了错误,Excel版本问题,Exce连接字符串版本是office2003的 ,更改为Excel2007版本则正常导入。
string strConn =
"Provider=Microsoft.Ace.OleDb.12.0;" + "data source
=" + Server.MapPath("ExcelFiles/Mydata2007.xlsx") + ";
Extended Properties='Excel 12.0; HDR=Yes; IMEX=1'";
//此连接可以操作.xls与.xlsx文件 (支持Excel2003 和 Excel2007 的连接字符串)
使用OLEDB读取excel和csv文件
///
/// 使用OLEDB读取excel和csv文件
///
/// 文件所在目录地址
/// 文件名
///
public static DataSet ReadFile(string path, string name)
{
if (string.IsNullOrWhiteSpace(path) || string.IsNullOrWhiteSpace(name) || !File.Exists(path+name))
return null;
// 读取excel
string connstring = string.Empty;
string strSql = string.Empty;
if (name.EndsWith(".xls") || name.EndsWith(".xlsx"))
{
connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + name + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1';";
strSql = "select * from [sheet1$]";
}
// 读取csv文件
else if (name.EndsWith(".csv"))
{
connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='text;HDR=YES;FMT=Delimited';";
strSql = "select * from " + name;
}
else
{
return null;
}
DataSet ds = null;
OleDbConnection conn = null;
try
{
conn = new OleDbConnection(connstring);
conn.Open();
OleDbDataAdapter myCommand = null;
myCommand = new OleDbDataAdapter(strSql, connstring);
ds = new DataSet();
myCommand.Fill(ds, "table1");
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Close();
}
return ds;
}