C# 写入EXCEL 简单例子

using  System;
using  System.Collections.Generic;
using  System.ComponentModel;
using  System.Data;
using  System.Drawing;
using  System.Text;
using  System.Windows.Forms;
using  System.IO;
using  System.Reflection;
using  System.Diagnostics;


private   void  button1_Click( object  sender, System.EventArgs e)  
{  
string  filename = @" c:统计表.xls " ;  
FileInfo mode = new  FileInfo( " c:/模板.xls " );  
try   
{  
mode.CopyTo(filename, true );  
}  
catch (Exception ee)  
{  
MessageBox.Show(ee.Message);  
return ;  
}  
Excel.Application objApp  =   new  Excel.Application()  ;  
Excel.Workbooks workbooks  =  objApp.Workbooks;  
object  missing = Missing.Value;  
workbooks.Open(filename,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);  
Excel.Sheets objSheets  =  objApp.Worksheets;  
Excel._Worksheet objSheet;  
// 采用索引的方式规定写入Index张的工作表  
objSheet  =  (Excel._Worksheet)objSheets.get_Item( 1 );  
objSheet.Cells[ 3 , 5 ]  =   " 循环写入数据 " ;  

// 去掉保存的对话框，若肯定无重复的文件或需要提示，将下面两行注释即可  
objApp.DisplayAlerts  =   false ;  
objSheet.SaveAs(filename,missing,missing,missing,missing,missing,missing,missing,missing,missing);  
objApp.Workbooks.Close();  
// 退出依然会驻留进程,因此进行垃圾回收  
objApp.Quit();                          
System.GC.Collect();  
}  

 http://www.dgren.cn

东莞人——东莞生活网|东莞网址大全|东莞人论坛|东莞网站大全|东莞网站导航|东莞网址导航