添加DLL文件:Microsoft.Office.Interop.Excel
Using:
using Excel = Microsoft.Office.Interop.Excel;
调用:
//Excel模板文件
string strFilePath = Application.StartupPath + "\\tiaomaout.xls";
if (!File.Exists(strFilePath))
throw new Exception("Excel条码模版不存在,无法导出");
//定义
Excel.Application xlApp = new Excel.Application();
if (xlApp == null)
throw new Exception("无法创建Excel对象,可能您的电脑未安装Excel");
xlApp.Visible = false;
xlApp.UserControl = true;
xlApp.DisplayAlerts = false;
Excel.Workbooks workbooks = xlApp.Workbooks;
Excel.Workbook workbook = workbooks.Add(strFilePath); //目标文件
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1];//取得sheet1