namespace WebInfo
{
public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet realSheet = (HSSFSheet)workbook.CreateSheet("Sheet xls");
HSSFSheet hidden = (HSSFSheet)workbook.CreateSheet("hidden");
string[] pgName = GetDataStr();
for (int i = 0, length = pgName.Length; i < length; i++)
{
String name = pgName[i];
HSSFRow row = (HSSFRow)hidden.CreateRow(i);
HSSFCell cell = (HSSFCell)row.CreateCell(0); cell.SetCellValue(name); } IName namedCell = workbook.CreateName(); namedCell.NameName = "hidden"; namedCell.RefersToFormula = "hidden!$A$1:$A$" + pgName.Length; DVConstraint constraint = DVConstraint.CreateFormulaListConstraint("hidden"); CellRangeAddressList addressList = new CellRangeAddressList(0, 100, 0, 0); HSSFDataValidation validation = new HSSFDataValidation(addressList, constraint); workbook.SetSheetHidden(1, true); realSheet.AddValidationData(validation);
realSheet.SetColumnWidth(0, 8000);
//填充数据 //。。。。。。。。。。。。。
string savePath = this.MapPath("~/Temp/Default.xls"); using (FileStream file = new FileStream(savePath, FileMode.Create)) { workbook.Write(file); } string path = this.MapPath("~/Temp/Default.xls");
ExcelOutE(this, path); } private string[] GetDataStr() { List<string> DataList = new List<string>(); DataList.Add("ThinkCentre M及启天产品"); DataList.Add("笔记本昭阳"); DataList.Add("LCS 新技术孵化器"); DataList.Add("LCS ThinkPad CTO"); DataList.Add("ThinkPad"); DataList.Add("Think KAB"); DataList.Add("LCS ThinkStation CTO"); DataList.Add("ThinkStation"); DataList.Add("Options"); DataList.Add("服务器存储"); DataList.Add("高性能服务器"); DataList.Add("企业级存储-NAS"); DataList.Add("企业级存储-SAN"); DataList.Add("乐Pad"); DataList.Add("行业平板电脑"); DataList.Add("LCS 联想打印机"); DataList.Add("LCS 激光打印机耗材"); DataList.Add("大客户服务"); DataList.Add("LCS 移动存储"); DataList.Add("消费台式电脑"); DataList.Add("LCS 软件"); DataList.Add("LCS 信息服务"); DataList.Add("LCS 存储产品"); DataList.Add("LCS 外设喷墨打印机及耗材"); DataList.Add("LCS IT 1for1教育软件"); DataList.Add("信息安全产品"); DataList.Add("LCS IT 1FOR1"); DataList.Add("LCS 网络产品"); DataList.Add("PC Option"); DataList.Add("产品服务部"); DataList.Add("LCS 服务产品"); DataList.Add("LCS 高端服务器"); DataList.Add("IdeaCentre Option"); DataList.Add("数码维修备件"); DataList.Add("数码影音"); DataList.Add("LCS 存储卡"); DataList.Add("LCS 消费笔记本(旧)"); DataList.Add("商用台式电脑扬天产品"); DataList.Add("LCS BBPC"); DataList.Add("LCS 外设投影机"); DataList.Add("IdeaPad Option"); DataList.Add("LCS无线应用"); DataList.Add("笔记本电脑天逸旭日产品"); DataList.Add("LCS CDB配售业务"); DataList.Add("LCS 随身电脑"); DataList.Add("007产品"); DataList.Add("乐Phone"); DataList.Add("LCS QDI 中国区");
return DataList.ToArray(); }
private void ExcelOutE(Page Page, string fileName) { HttpResponse Response = Page.Response; HttpServerUtility Server = Page.Server;
string fn = Server.UrlDecode(fileName); FileStream fileStream = new FileStream(fn, FileMode.Open); long fileSize = fileStream.Length; fileStream.Close(); Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=Sheet1.xls"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType = "application/ms-excel"; Response.AddHeader("Content-Length", fileSize.ToString()); Page.EnableViewState = false; Response.WriteFile(fn); Response.Flush(); Response.End(); } }
原文：http://www.cnblogs.com/lijie20111015/p/3893051.html