Question

C#导入Excel的操作，最近一批文件 后缀都是XLS，并不是xls,每次导入 报错不是预期格式，请问怎么解决

public DataSet ExcelToDS(string Path,string SheetName)
{
string strConn = "Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + Path + ";Extended Properties='Excel 12.0; HDR=Yes; IMEX=1'";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbDataAdapter adp = new OleDbDataAdapter("Select * from ["+SheetName+"]", conn);
DataSet ds = new DataSet();
adp.Fill(ds);--------------------------这里报错
return ds;

}

Answer 1

把SheetName两边的[]去掉

Answer 2

string strConn = "Provider=Microsoft.Ace.OleDb.4.0;" + "data source=" + Path + ";Extended Properties='Excel 8.0; HDR=Yes; IMEX=1'";
试试