110,533
社区成员
发帖
与我相关
我的任务
分享
Microsoft.Office.Interop.Excel.Application mExcelObj = new Microsoft.Office.Interop.Excel.Application();
//停用警告訊息
mExcelObj.DisplayAlerts = false;
Workbook theWorkbook = mExcelObj.Workbooks.Add(Type.Missing);
Sheets sheets = theWorkbook.Worksheets;
Worksheet ws = (Worksheet)sheets.get_Item(1);
ws.Name = "導出";//SheetName
for (int i = 0; i < 100000; i++)
{
ws.Cells[i + 1, 1] = i.ToString();
}
string filePath = "D:\\tempFile\\" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";
theWorkbook.SaveAs(filePath, XlFileFormat.xlWorkbookDefault, null, null, false, false,
XlSaveAsAccessMode.xlNoChange, null, null, null, null, null);
theWorkbook.Close();
mExcelObj.Quit();
MessageBox.Show("OK!");