string sql = "select * from [WS$]"; OleDbDataAdapter da = new OleDbDataAdapter(sql,cn); DataSet ds = new DataSet(); da.Fill(ds,"testTable"); this.DataGrid1.DataSource = ds.Tables["testTable"]; cn.Close(); } catch (Exception eee) { textBox1.Text=eee.ToString(); return; }出以下的错误: System.Data.OleDb.OleDbException: 找不到可安装的 ISAM。 at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at ExcelTest1.Form1.Excel_Click(Object sender, EventArgs e) in c:\documents and settings\administrator\my documents\visual studio projects\exceltest1\exceltest1\form1.cs:line 505 那位给解释一下,我对这个一点都不懂,或者提供一些相关资料也成,谢谢!:)
是不是把Excel文件当成数据库似的来操作?
这是不是连接字符串?我从别处找了段代码如下:
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
+"Data Source=D:\\Jan 2004 RSL SRIE.xls;"
+"Extended Properties=\"Excel 8.0\";";
try
{
OleDbConnection cn = new OleDbConnection(strConn);
cn.Open();
string sql = "select * from [WS$]";
OleDbDataAdapter da = new OleDbDataAdapter(sql,cn);
DataSet ds = new DataSet();
da.Fill(ds,"testTable");
this.DataGrid1.DataSource = ds.Tables["testTable"]; cn.Close();
}
catch (Exception eee)
{
textBox1.Text=eee.ToString();
return;
}出以下的错误:
System.Data.OleDb.OleDbException: 找不到可安装的 ISAM。
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at ExcelTest1.Form1.Excel_Click(Object sender, EventArgs e) in c:\documents and settings\administrator\my documents\visual studio projects\exceltest1\exceltest1\form1.cs:line 505
那位给解释一下,我对这个一点都不懂,或者提供一些相关资料也成,谢谢!:)