ASP.Net中如何用生成Excel文件？（C#版）

需要添加对Excel组件的引用
Excel.Application oExcel;
Excel.Workbook oBook;
Object oMissing = System.Reflection.Missing.Value;
oExcel = new Excel.Application();
oBook = oExcel.Workbooks.Add(oMissing);
oExcel.Visible =true;
for (int i=1;i<=4;i++)
{
oExcel.Cells[i,1]=i.ToString();
oExcel.Cells[i,2]="我们来看看";
oExcel.Cells[i,3]="'10000E0000001";
oExcel.Cells[i,4]="10000E0000001";
}
Sheets sheets = oBook.Worksheets;
_Worksheet worksheet = (_Worksheet) sheets.get_Item(1);

Range range1 = worksheet.get_Range("A3", "B4");
range1.Select ();
oExcel.ActiveWindow.FreezePanes=true; range1.EntireRow.Insert(null,null);
range1.EntireColumn.Font.Size =10;
worksheet.PageSetup.PrintGridlines=true;
oBook.Saved = true;
oExcel.UserControl = false;
worksheet.SaveAs("c:\\books.xls",oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing, oMissing, oMissing);
oExcel.Quit();
oMissing=null;
sheets=null;
range1=null;
worksheet=null;
oBook=null;
oExcel=null;
GC.Collect ();