方法一:使用 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 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];
}