Excel.ApplicationClass myApp;
Excel.Workbook myBook;
Excel.Worksheet mySheet;
string tableName = "mp_ZZFY";
string FilePath = Server.MapPath(tableName); //模板文件路径
myApp = null;
myBook = null;
mySheet = null;
object oMissiong = System.Reflection.Missing.Value;
myApp = new Excel.ApplicationClass();
myApp.Visible = false;
myApp.Workbooks.Open(FilePath, oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong);
myBook=myApp.Workbooks[1];
mySheet=(Excel.Worksheet)myBook.ActiveSheet;
#region 一个萝卜一个坑
mySheet.Cells[i,j] = DataTable中的数据;
.......
#endregion
myBook.Save();
myBook.Close(true,FilePath,true);
//myApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(mySheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myApp);
GC.Collect();
#endregion
Response.Redirect(FilePath);
