程式搜集分享精靈

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using NPOI.HSSF;
using NPOI.HSSF.UserModel;
using NPOI.POIFS.FileSystem;

public partial class d14 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
HSSFWorkbook workbook = new HSSFWorkbook();
MemoryStream ms = new MemoryStream();
workbook.CreateSheet("試算表 SheetA");
workbook.CreateSheet("試算表 SheetB");
workbook.CreateSheet("試算表 SheetC");
workbook.Write(ms);
Response.AddHeader("Content-Disposition", String.Format("attachment;filename=EmptyWorkbook_1.xls"));
Response.BinaryWrite(ms.ToArray());
workbook = null;
ms.Close();
ms.Dispose();
}
}