asp.net µ¼³öExcel·½·¨»ã×Ü

µÚÒ»ÖÖ£ºÐèÒªÒýÓÃcom £ºmicrosoft.excel.11.0.
//Éú³ÉExcelÎļþµÄ´úÂë
protected void ExportExcel()
{
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wb = excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet); // ´´½¨¹¤×÷²¾
Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1]; // ´´½¨¹¤×÷Ò³
DataSet ds = GetData();
int iMaxRow = ds.Tables["rsData"].Rows.Count;
int iMaxCol = ds.Tables["rsData"].Columns.Count;
// ÉèÖøñʽ
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, iMaxCol]).Font.Name = "ºÚÌå";
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, iMaxCol]).Font.Bold = true;
ws.get_Range(ws.Cells[1, 1], ws.Cells[iMaxRow + 1, iMaxCol]).Borders.LineStyle = 1;
// ÉèÖñêÌâ
excel.Cells[1, 1] = "°à¼¶";
excel.Cells[1, 2] = "ѧºÅ";
excel.Cells[1, 3] = "ÐÕÃû";
excel.Cells[1, 4] = "ÐÔ±ð";
// Ìî³äÊý¾Ý
for (int iRow = 0; iRow < iMaxRow; iRow++)
{
for (int iCol = 0; iCol < iMaxCol; iCol++)
{
excel.Cells[iRow + 2, iCol + 1] = ds.Tables["rsData"].Rows[iRow][iCol].ToString();
}
}
// ±£´æExcel
excel.Save("ѧÉú»ù´¡ÐÅÏ¢");
// ´ò¿ªExcel
excel.Visible = true;
}
 µÚ¶þÖÖ£ºÀûÓà System.IO
public void CreateExcel(DataSet ds, string typeid, string FileName)
{
HttpResponse resp;
resp = Page.Response;
resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
resp.ContentType = "application/ms-excel";
resp.AddHeader("Content-Dispositi