1.添加引用
“引用”右键:添加引用
COM选项卡选择Excel:
确定后,引用自动添加:
2.添加命名空间
using Microsoft.Office.Interop.Excel;
3.Excel数据调用处理类
public class ExcelDealing
{
//引用Excel Application类別
ApplicationClass myExcel = null;
//活页簿
Workbook wb = null;
//工作表
Worksheet ws = null;
Object missing = Missing.Value;
int rows; //行数
/// <summary>
/// 构造函数
/// </summary>
/// <param name="excelPath">Exce路径</param>
public ExcelDealing(string excelPath)
{
myExcel = new ApplicationClass();
//打开Excel数据源工作簿
this.wb = this.myExcel.Workbooks.Open(excelP