如何在没有消息的情况下保存/覆盖现有的Excel文件 [英] How to Save/Overwrite existing Excel file without message
本文介绍了如何在没有消息的情况下保存/覆盖现有的Excel文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要从视图列表中导出excel,我使用了这段代码
I need to export excel from viewlist, I used this code
Excel.Application app = new Excel.Application();
//app.Visible = true;
Excel.Workbook wb = app.Workbooks.Add(1);
Excel.Worksheet ws = (Excel.Worksheet)wb.Worksheets[1];
int i = 1;
int i2 = 1;
foreach (ListViewItem lvi in lvLogs.Items)
{
i = 1;
foreach (ListViewItem.ListViewSubItem lvs in lvi.SubItems)
{
ws.Cells[i2, i] = lvs.Text;
i++;
}
i2++;
}
wb.SaveAs(@"C:\1\myExcel.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
wb.Close(false, Type.Missing, Type.Missing);
app.Quit();
}
现在,我需要覆盖Excel文件而没有任何消息,并且需要每10分钟执行一次此操作.
Now I need to overwrite the excel file without any message and I need to do this action every 10 min.
推荐答案
尝试这个.
app.DisplayAlerts = false;
wb.SaveAs(@"C:\1\myExcel.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
workbook.Close();
app.Quit();
这篇关于如何在没有消息的情况下保存/覆盖现有的Excel文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文