C#实现数据到Excel的高效导出

Excel生成类  ExcelRW.cs

 
C#代码

   1. using System;  
   2. using System.Data;  
   3. using System.Configuration;  
   4. using System.Web;  
   5. using System.Web.Security;  
   6. using System.Web.UI;  
   7. using System.Web.UI.WebControls;  
   8. using System.Web.UI.WebControls.WebParts;  
   9. using System.Web.UI.HtmlControls;  
  10. using Microsoft.Office.Interop.Excel;  
  11. using System.Collections;  
  12. using System.Diagnostics;  
  13.   
  14. /// <summary>  
  15. /// Summary description for ExcelRW  
  16. /// </summary>  
  17. public static class ExcelRW  
  18. {  
  19.   
  20.   
  21.     public static void ExcelSave(Hashtable ht)  
  22.     {  
  23.   
  24.         Application excel = new Application();//引用Excel对象  
  25.   

  26.         Workbooks oBooks;  
  27.         Workbook oBook;  
  28.         Sheets oSheets;  
  29.         Worksheet oSheet;  
  30.         Range oCells;  
  31.         string sFile = ht["excelName"] as string;  
  32.         //excel.Save("ddd.xls");  
  33.         ArrayList alSheet = ht["sheetNameList"] as ArrayList;  
  34.         Workbook wb = excel.Workbooks.Add(true);//引用Excel工作簿  
  35.         excel.Visible = false;//使Excel可视  
  36.         oBooks = excel.Workbooks;  
  37.         oBook = oBooks.get_Item(1);  
  38.         oSheets = oBook.Worksheets;  
  39.         oSheet = (Worksheet)oSheets.get_Item(oSheets.Count);  
  40.         foreach (Hashtable htOneSheel in alSheet)  
  41.         {  
  42.   
  43.   
  44.             oSheet = (Worksheet)oSheets.get_Item(oSheets.Count);  
  45.   
  46.             ArrayList ColNameList = htOneSheel["ColName"] as ArrayList;  
  47.             //命名该sheet  
  48.             oSheet.Name = htOneSheel["sheetName"] as string;  
  49.             System.Data.DataTable dtable = htOneSheel["dataRows"] as System.Data.DataTable;  
  50.             Range column = ((Range)oSheet.Cells[1, 1]).EntireColumn;  
  51.             column.ColumnWidth = 10;  
  52.             int iRow = 1;  
  53.             foreach (DataRow dr in dtable.Rows)  
  54.             {  
  55.                 int icel = 1;