程式碼:
private void CreateExcelFile() { EXCEL.Application app = new EXCEL.Application(); //隱藏Excel程式 app.visible = false; //建立工作簿 EXCEL.Workbook workbook = app.Workbooks.Add(EXCEL.XlWBATemplate.xlWBATWorksheet); //取得工作表 EXCEL.Worksheet sheet = (EXCEL.Worksheet)workbook.Worksheets[1]; //給予工作表名稱 sheet.Name = "sheet1"; //給予該欄位值 sheet.Cells[1, 1] = "Name"; sheet.Cells[1, 2] = "Age"; sheet.Cells[2, 1] = "Wang"; sheet.Cells[2, 2] = "18"; //儲存Excel sheet.SaveAs(path); //關閉工作簿 workbook.Close(); //關閉Excel程式 app.Quit(); }