方法一:使用 Microsoft.Office.Interop.Excell类库
示例代码如下:
- public void openExcel(string file)
- {
- excel = new ExcelLib.ApplicationClass();
- excel.Application.Workbooks.Add(true);
- excel.Cells[1, 1] = "First Row First Column";
- excel.Cells[1, 2] = "First Row Second Column";
- excel.Cells[2, 1] = "Second Row First Column";
- excel.Cells[2, 2] = 200;
- DateTime time = DateTime.Now;
- excel.Cells[3,1] = time;
- excel.Visible = true;
- }
public void openExcel(string file)
{
excel = new ExcelLib.ApplicationClass();
excel.Application.Workbooks.Add(true);
excel.Cells[1, 1] = "First Row First Column";
excel.Cells[1, 2] = "First Row Second Column";
excel.Cells[2, 1] = "Second Row First Column";
excel.Cells[2, 2] = 200;
DateTime time = DateTime.Now;
excel.Cells[3,1] = time;
excel.Visible = true;
}
方法二:采用数据库连接的方式
示例代码如下:
- public void openExecl(string filepath)
- {
- string type = filepath.Substring(filepath.LastIndexOf(".") + 1);
- string connStr;
- if (type.Equals("xls", StringComparison.CurrentCultureIgnoreCase))
- {
- connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
- + filepath + ";Extended Properties=Excel 8.0";
- }
- else
- {
- connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
- + filepath +
- ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";";
- }
- OleDbConnection conn = new OleDbConnection(connStr);
- conn.Open();
- string sql = "select * from [Sheet1$A1:L93]";
- IDataAdapter dadp = new OleDbDataAdapter(sql, conn);
- DataSet ds = new DataSet();
- dadp.Fill(ds);
- dataGridView1.DataSource = ds.Tables[0];
- }