帮忙看一下下面C#调用excel问题!
碼上道 2005-11-11 09:42:39 private void button1_Click(object sender, System.EventArgs e)
{
OpenFileDialog Dlg = new OpenFileDialog();
Dlg.Filter = "Excel文件|*.xls";
if(DialogResult.OK==Dlg.ShowDialog())
{
FileName=Dlg.FileName;
}
textBox1.Text=FileName;
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = FileName;Extended Properties=Excel 8.0" ;
OleDbConnection Conn=new OleDbConnection(strCon);
Conn.Open ( ) ;
// OleDbCommand strCom=new OleDbCommand();
// strCom.Connection=Conn;
// strCom.CommandText="SELECT * FROM [Sheet1$] ";
string strCom="SELECT * FROM [Sheet1$]";
OleDbDataAdapter da= new OleDbDataAdapter(strCom,Conn);
DataSet dataSet=new DataSet();
da.Fill(dataSet,"[Sheet1$]");
dataGrid1.DataMember="[Sheet1$]" ;
dataGrid1.DataSource=dataSet;
}