//注意:这个方法在服务器上运行时,服务器必须安装Office //引用 using MyExcel=Microsoft.Office.Interop.Excel; using System.Reflection; public void DbExcel(string filepath,DataTable dt) { //打开excel模板 object missing =Missing.Value; MyExcel.Application excelApp=new Microsoft.Office.Interop.Excel.Application(); excelApp.Application.Workbooks.Open(filepath, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); //填充excel MyExcel._Worksheet sheet = (MyExcel._Worksheet)excelApp.Worksheets[1]; //填充 if (dt.Rows.Count > 0) { int colCount = dt.Columns.Count; object[,] dataArray = new object[dt.Rows.Count+1,colCount]; for (int i = 0; i < dt.Rows.Count; i++)