62,047
社区成员
发帖
与我相关
我的任务
分享
Microsoft.Office.Interop.Excel.Application app = null;
Excel.Workbook workbook = null;
Excel.Worksheet worksheet = null;
protected object missing = Missing.Value;
try
{
String templatePath = "你的xls文件地址";
//创建一个Application对象并使其可见
app = new Excel.ApplicationClass();
app.Visible = true;
//打开模板文件,得到WorkBook对象
workbook = app.Workbooks.Open(templatePath, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing);
//得到WorkSheet对象
worksheet = (Excel.Worksheet)workbook.Sheets[1];
for (int i = 1; i <= 50; i++)
{
//在这里对每一个格子进行填充
worksheet.Cells[i, 4] = 2;
}
//打印预览
worksheet.PrintPreview(missing);
}
finally
{
//垃圾收集
workbook.Close(false, missing, missing);
app.Workbooks.Close();
app.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(app);
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
app = null;
worksheet = null;
workbook = null;
//强行销毁
GC.Collect();
}