public void OperateExcel(ListView list, string text)
{
SaveFileDialog S = new SaveFileDialog();
S.Filter = "Excel files(*.xls)|*.xls";
S.RestoreDirectory = true;
S.CheckFileExists = false;
S.OverwritePrompt = false;
DialogResult dr=S.ShowDialog();
if (dr==DialogResult.Cancel)
{
return;
}
Interop.Excel.Application app = new Interop.Excel.Application();
try
{
if (app == null)
{
return;
}
app.Visible = false;
Workbooks workbooks = app.Workbooks;
_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
Sheets sheets = workbook.Worksheets;
_Worksheet worksheet = (_Worksheet)sheets.get_Item(1);
if (worksheet == null)
{
return;
}
app.Visible = false;
app.Cells[1, 4] = text;
for (int x = 1; x <= list.Columns.Count; x++)
{
app.Rows.Cells[2, x] = list.Columns[x - 1].Text;
}
for (int i = 3; i <= list.Items.Count + 2; i++)
{
for (int j = 1; j <= list.Columns.Count; j++)
{
app.Rows.Cells[i, j] = list.Items[i - 3].SubItems[j - 1].Text;
}
}
//保存
workbook.SaveCopyAs(S.FileName);
workbook.Saved = true;
MessageBox.Show("保存成功!", "振勇提示!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
Sdyy_Change.Log.WriteLog(ex.ToString());
MessageBox.Show("保存失败,请重试!", "振勇提示!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
//关闭Excel工作空间
app.UserControl = false;
app.Quit();
}
}
但是很慢` 点了保存以后会卡
还有就是导完了以后进程里面会有一个 excel进程
如果用System.Diagnostics.Process的Kill方法杀掉进程的话那么如果我开着一个excel正在办公然后用软件导出`
那么也就杀掉了`而且如果里面的东西没有保存就会丢失
