需要控件datagridview (显示excel内容)
button(触发事件)
再窗体添加两行引用
using System.Data;
using System.Data.OleDb;
excel文件的路径为c:\\sample.xls
定义读取excel的方法:
public DataTable LoadDataFromExcel(string Path)
{
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();
string strExcel = "";
OleDbDataAdapter myCommand = null;
DataTable dt = null;
strExcel = "select * from [sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
dt = new DataTable();
myCommand.Fill(dt);
return dt;
}
在button1按钮添加代码
DataTable dt = LoadDataFromExcel("c:\\sample.xls");
dataGridView1.DataMember = "[Sheet1$]";
dataGridView1.DataSource = dt;
执行之后,按下按钮,就能够在datagridview上显示excel表单sheet1的内容,
当然有不完善的内容,以后再改进。