Code
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();
}
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();
}