高分求助:excel连接时报Unspecified error
conn.Open();的时候报Unspecified error
相关代码如下:
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + FilePath + ";" + "Extended Properties='Excel 8.0; HDR=Yes;MEX=1';";
OleDbConnection conn = new OleDbConnection(connectionString);
DataSet ds = new DataSet();
try
{
conn.Open();
string xlsSheetNames = GetXlsSheetNames(conn);
foreach (string sheetName in xlsSheetNames.Split(','))
{
string str = "SELECT * FROM [" + sheetName + "$]";
OleDbCommand cmd = new OleDbCommand(str, conn);
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, sheetName);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}