单击“添加引用”对话框的“COM”选项卡,找到“Microsoft Excel 11 Object Library”,按“确定”。
注意:Microsoft Excel 11 Object Library中Excel 11 的版本与安装的OFFICE版本有关。
在编程之前还需要引入命名空间using Microsoft.Office.Interop.Excel;
注意:有的机器上需要用using Excel;我猜这也跟OFFICE版本有关(并未确定)
这样C#就可以正确识别Excel对象了。
//
下面示例为:从一个Excel文档中读取数据,然后将数据附加到另外一个Excel文档中去(关键代码)
Application excelApp = new ApplicationClass();
Excel.Workbook workbook = null ;
Excel.Worksheet worksheet = null ;
Excel.Range range = null ;
private List < Teacher > LoadAccpBenetExcel( string sourceFileName)
... {
List<Teacher> teachers = new List<Teacher>();
try
...{
workbook = excelApp.Workbooks.Open(sourceFileName
, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing
, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing
, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
catch (Exception e)
...{
MessageBox.Sho
Application excelApp = new ApplicationClass();
Excel.Workbook workbook = null ;
Excel.Worksheet worksheet = null ;
Excel.Range range = null ;
private List < Teacher > LoadAccpBenetExcel( string sourceFileName)
... {
List<Teacher> teachers = new List<Teacher>();
try
...{
workbook = excelApp.Workbooks.Open(sourceFileName
, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing
, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing
, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
catch (Exception e)
...{
MessageBox.Sho