2016/07/03

C#.Net create Excel file


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