¹ÈËÑIT·þÎñ   ¼¼ÊõÎÄÕÂ
Ê×Ò³ | ÌØ»ÝÌ×²Í | ÓòÃûÉêÇë | Ö÷»ú¿Õ¼ä | ÆóÒµGÓÊÏä | ÍøÕ¾½¨Éè | ÍøÕ¾ÍÆ¹ã | ÓʾÖϵͳ | ¹ÈËÑÈí¼þ | ¹ÈËÑÍÆ¹ã
ÌØ

±ð

ÍÆ

¼ö
  ÄúËùÔÚµÄλÖà |  Ïà¹Ø¼¼ÊõÎÄÕ ->  ASP/PHP/.NET/XML ->  ÕýÎÄ
²Ù×÷excelÎļþ³É¹¦ÊÍ·Åcom¶ÔÏóµÄ´úÂë
http://www.aguso.com¡¡2007-11-18 03:20:57¡¡¹ÈËÑIT·þÎñ
  GoogleÌṩµÄ¹ã¸æ

    Excel.Application app = new Excel.ApplicationClass();
    Excel.Workbooks  workbooks = app.Workbooks;
    Excel._Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
    Excel.Sheets sheets = workbook.Sheets;
    Excel._Worksheet worksheet = (Excel._Worksheet)sheets.get_Item(1);
    Excel.Range  range = worksheet.Cells;
   for (int i = 1; i <= ds.Tables[0].Columns.Count; i++)
   {
    range[1,i] = ds.Tables[0].Columns[i-1].ColumnName;
   }

   for(int n = 0 ; n < ds.Tables[0].Rows.Count; n++)
   {
    for(int m = 1; m <= ds.Tables[0].Columns.Count; m++)
    {
     range[n+2,m] = ds.Tables[0].Rows[n][m-1].ToString();
    }
   }
    
   if(System.IO.File.Exists("d:\excel.xls"))
   {
    System.IO.File.Delete("d:\excel.xls");
   }
    worksheet.SaveAs("d:\excel.xls",Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
    //app.Visible = true;
    
    System.Runtime.InteropServices.Marshal.ReleaseComObject(range);
    range = null;
    System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
   worksheet = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject(sheets);
   sheets = null;
   workbook.Close(false,Missing.Value,Missing.Value);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
   workbook = null;
   workbooks.Close();
   System.Runtime.InteropServices.Marshal.ReleaseComObject(workbooks);
   workbooks = null;
   app.Quit();
   System.Runtime.InteropServices.Marshal.ReleaseComObject(app);
   app = null;


±¾ÎĵØÖ·£ºhttp://www.newbooks.com.cn/info/21640.html
 
¡¾´òÓ¡¡¿ ¡¾¹Ø±Õ¡¿ 
  ·ÖÀàÐÅÏ¢
  ÈȵãÐÂÎÅ
2 ¶È¹ýÀ§ÄÑʱÆÚ 08ÄêµÚÈý¼¾Ó®Àû
2 Ï൱¶àµÄÆóÒµ¹ºÂòVistaÐí¿ÉÖ¤µ«»¹Ã»Ê¹ÓÃ
2 ºê»ùÔ¤¼ÆÍ¶Èë1.2ÒÚÃÀÔªÔÞÖú°ÂÔË»á
2 Vista IPv6¼¼ÊõÆØ°²È«Â©¶´£¬ÔâºÚ¿Í¹¥»÷
2 Ó¢ÌØ¶û08ÄêÊ׿îÈüÑïË«ºË1ÔÂÉÏÊÐ
2 ÐÂÎż¯ÍÅĬ¶à¿Ë½Ó°àÈ˸¡³öË®Ãæ
2 ÊýÂëÏà»ú°®¹úÕßΪÏû·ÑÕß½ÚÊ¡60ÒÚÔª
2 "Öйú×î¾ß¾ºÕùÁ¦º£ÍâÉÏÊй«Ë¾"£­¿ÕÖÐÍø
¶«·½Ã÷Öé
ÃÀͼ£º¶«·½Ã÷Öé
ÉÏÍøºÃ°ïÊÖ£¬ÏÂÔØ²»Öж¾µÄä¯ÀÀÆ÷
ÏÂÔØÉÏÍø²»Öж¾µÄä¯ÀÀÆ÷
 ¾«²ÊרÌâ
¡¤ÆóÒµÍøÕ¾½¨Éè ¡¤×¨ÒµÍøÕ¾½¨Éè
¡¤ÓòÃû×¢²á ¡¤ÖÐÎÄÓòÃû×¢²á
¡¤ÍøÕ¾¿Õ¼ä ¡¤ÐéÄâÖ÷»ú
¡¤ÆóÒµÓÊÏä ¡¤ÆóÒµGÓÊ
¡¤ÈçºÎ½¨ÉèÆóÒµÍøÕ¾ ¡¤ÕÒÉÌ»ú-ÓÃÒ×ËÑÍø
¡¤ÆóÒµÐÅÏ¢Ãâ·Ñ²éѯ ¡¤ÆóÒµ²úÆ·Ãâ·ÑÐû´«
¡¤×¢²áCNÓòÃûÖ»Ðè1Ôª ¡¤¹ú¼ÊÖÐÎÄÓòÃû×¢²á
¡¤Linux ÐéÄâÖ÷»ú ¡¤Windows ÐéÄâÖ÷»ú
¡¤ÉêÇëÃâ·ÑÓÊÏä ¡¤Ãâ·ÑÆóÒµGÓÊÏäÉêÇë
¸ñ¶·ÌìÍõ2000ÍþÁ¦¼ÓÇ¿°æ
ÓÎÏ·£º¸ñ¶·ÌìÍõ2000ÍþÁ¦¼ÓÇ¿°æ
ÉÏÍøºÃ°ïÊÖ£¬ÏÂÔØ²»Öж¾µÄä¯ÀÀÆ÷
ÈÃÄúµÄÍøÕ¾¿ªÊ¼»ñÈ¡ÊÕÈë
 ×îÐÂÎÄÕÂ
Ê×Ò³ | ¹ØÓÚÎÒÃÇ | ÁªÏµ·½Ê½ | ¹ÈËѶ¯Ì¬ | Ö§¸¶ÖÐÐÄ | ÓÑÇéÁ´½Ó | ¹¤×÷»ú»á | ÍøÕ¾µØÍ¼ | Òâ¼û·´À¡
© 2007 ¹ÈËÑ-IT·þÎñ