110,555
社区成员
发帖
与我相关
我的任务
分享
private void btnGetExcel_Click(object sender, EventArgs e)
{
try
{
Excel.Worksheet oldSheet = (Excel.Worksheet)xBook.Sheets[11];
int k = 0;
for (int w = 11; w < 88; w++)
{
xSheet = (Excel.Worksheet)xBook.Sheets[w];
ExcelApp.AlertBeforeOverwriting = false;
xSheet.Copy(oldSheet, Missing.Value);
}
xBook.SaveAs(@"c:\bbb.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xBook.Close(false, Type.Missing, Type.Missing);
ExcelApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelApp);
xBook = null;
xSheet = null;
xRang = null;
GC.Collect();
MessageBox.Show("创建完成!");
}
catch(Exception ex)
{
xBook.Close(false, Type.Missing, Type.Missing);
ExcelApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelApp);
xBook = null;
xSheet = null;
xRang = null;
GC.Collect();
MessageBox.Show("创建失败!" + ex);
}
}