NPOI 建立EXCEL

建立新的EXCEL
public void CreateExcelFile()
        {
            IWorkbook workbook = new XSSFWorkbook();
            XSSFSheet u_sheet = (XSSFSheet)workbook.CreateSheet("Sheet"); //建立一個工作表
//建立資料列
            IRow row = u_sheet.CreateRow(0);
// 创建单元格
             ICell cell = row .CreateCell(0);

//輸出EXCEL檔
            MemoryStream MS = new MemoryStream();
            workbook.Write(MS);
            Response.AddHeader("content-disposition", "attachment; filename=Emp.xlsx");
            Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            Response.BinaryWrite(MS.ToArray());
//釋放資源
            MS.Close();
            MS.Dispose();
            Response.Flush();
            Response.End();
        }