【请教】asp.net导出excel以至于OFFICE软件出异常!

由于excel格式比较复杂，所以用到了模板，每次导出的时候先把模板复制一份到一个新的目录下，然后进行填充，再下载。

C# code:

_Worksheet sheet1 = null;//sheet1

//判断是否复制成功：对模板进行复制，然后保存到一个新的目录下，再下载
string m_newPath = change(System.Configuration.ConfigurationManager.AppSettings["oldPath"] + "customer2.xls", filename);

if (string.IsNullOrEmpty(m_newPath))
{
return;
}

object missing = Missing.Value;

Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();

//打开新文件
myExcel.Application.Workbooks.Open(m_newPath, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);

//将Excel显示出来
myExcel.Visible = true;

//将列标题和实际内容选中
Microsoft.Office.Interop.Excel.Workbook myBook = myExcel.Workbooks[1];

sheet1 = (_Worksheet)myExcel.Worksheets[1];

sheet1.Cells[1, 1] = “”；
。。。。。。

myBook.Save();

myBook.Close(missing, missing, missing);

myExcel.Quit();

myExcel = null;

myBook = null;

sheet1 = null;