stringstrFileName=
Environment.CurrentDirectory+@"\template\template.tpl";
stringstrSaveFileName= Environment.CurrentDirectory+@"\excel\"+System.DateTime.Now.ToString().Replace(":","").Replace("-","").Replace("","")+@".xls";
Excel.ApplicationThisApplication=newExcel.ApplicationClass();
Excel.WorkbookThisWorkBook;
objectmissing=System.Reflection.Missing.Value;
try
{
//加载Excel模板文件
ThisWorkBook=ThisApplication.Workbooks.Open(strFileName,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);
Excel.WorksheetThisSheet=(Excel.Worksheet)ThisWorkBook.Sheets[1];
ThisSheet.Cells[7,1]=dtEnd.ToShortDateString();
progressBar.Value=30;
ThisApplication.Visible=false;
DataRowdr=dt.Rows[0];
for(inti=0;i<dt.Columns.Count;i++)
{
ThisSheet.Cells[7,i+2]=dr[i].ToString();
progressBar.Value+=1;
}
//更新数据后另存为新文件
ThisSheet.SaveAs(strSaveFileName,missing,missing,missing,missing,missing,missing,missing,missing);
}
catch{}
finally
{
ThisApplication.Quit();
ThisWorkBook=null;
ThisApplication=null;
//dt=null;
}
try
{//打开刚才生成的Excel文件
Excel.WorkbookNewWorkBook;
NewWorkBook=NewApplication.Workbooks.Open(strSaveFileName,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);
Excel.WorksheetNewSheet=(Excel.Worksheet)NewWorkBook.Sheets[1];
NewApplication.Visible=true;
//也可以使用System.Diagnostics.Process.Start(strSaveFileName);来打开新文件
}
stringstrSaveFileName= Environment.CurrentDirectory+@"\excel\"+System.DateTime.Now.ToString().Replace(":","").Replace("-","").Replace("","")+@".xls";
Excel.ApplicationThisApplication=newExcel.ApplicationClass();
Excel.WorkbookThisWorkBook;
objectmissing=System.Reflection.Missing.Value;
try
{
//加载Excel模板文件
ThisWorkBook=ThisApplication.Workbooks.Open(strFileName,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);
Excel.WorksheetThisSheet=(Excel.Worksheet)ThisWorkBook.Sheets[1];
ThisSheet.Cells[7,1]=dtEnd.ToShortDateString();
progressBar.Value=30;
ThisApplication.Visible=false;
DataRowdr=dt.Rows[0];
for(inti=0;i<dt.Columns.Count;i++)
{
ThisSheet.Cells[7,i+2]=dr[i].ToString();
progressBar.Value+=1;
}
//更新数据后另存为新文件
ThisSheet.SaveAs(strSaveFileName,missing,missing,missing,missing,missing,missing,missing,missing);
}
catch{}
finally
{
ThisApplication.Quit();
ThisWorkBook=null;
ThisApplication=null;
//dt=null;
}
try
{//打开刚才生成的Excel文件
Excel.WorkbookNewWorkBook;
NewWorkBook=NewApplication.Workbooks.Open(strSaveFileName,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);
Excel.WorksheetNewSheet=(Excel.Worksheet)NewWorkBook.Sheets[1];
NewApplication.Visible=true;
//也可以使用System.Diagnostics.Process.Start(strSaveFileName);来打开新文件
}