private void button1_Click(object sender, System.EventArgs e)
{//读取EXCEL文件内容
try
{
string strConnection="";
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=MyExcel.xls;"+
"Extended Properties=Excel 8.0;";
this.oleDbConnection1.ConnectionString=strConnection;
this.oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM MySheetName";
this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
this.oleDbDataAdapter1.Fill(this.dataSet1);
this.dataGrid1.DataSource=this.dataSet1;
if(!this.dataGrid1.IsExpanded(0))
this.dataGrid1.Expand(0);
}
catch(Exception Err)
{
MessageBox.Show("读取EXCEL文件出现错误:"+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}
private void Form1_Closed(object sender, System.EventArgs e)
{//关闭程序
//如果打开了连接,则关闭它
if(this.oleDbConnection1.State==ConnectionState.Open)
{
this.oleDbConnection1.Close();
}
}