c#导出excel保存为什么会保存在两个地方

Question

代码如何下；为什么每一次导出保存时都弹出一个保存对话框呀Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();                Microsoft.Office.Interop.Excel.Workbook wb=null ;                Microsoft.Office.Interop.Excel.Sheets sh=null ;                excel.Application.Workbooks.Add(true);                excel.Cells[1,1] = "第一行第一列";                excel.Cells[1,2] = "第一行第二列";                excel.Cells[2,1] = "第二行第一列";                excel.Cells[2,2] = "第二行第二列";                excel.Cells[3,1] = "第三行第一列";                excel.Cells[3,2] = "第三行第二列";                excel.Visible = false;                excel.DisplayAlerts = false;                excel.AlertBeforeOverwriting = false ;                excel.Save(@"C:\121.xlsx");                excel.Quit();

Answer 1

把你的 excel.Save(@"C:\121.xlsx");替换 excel.ActiveWorkbook.SaveCopyAs(@"C:\121.xlsx");

Answer 2

把你的 excel.Save(@"C:\121.xlsx");替换成我的 excel.ActiveWorkbook.SaveAs(@"C:\121.xlsx");