程式碼:
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();
}