NPOI excel导出快速构建

直接上代码，这个是一个在webFrom中的例子，要请求的页面是ashx

 public void ExportVisaFeeAll(HttpContext context)
        {
            try
            {
                string title ="签证费用表";

                string[] idArray = context.Request["idStr"].ToString().Split(',');
                DateTime startDate = DateTime.Parse(context.Request["startDate"]);
                DateTime endDate = DateTime.Parse(context.Request["endDate"]).AddDays(1);

                string unit = context.Request.QueryString["unit"];
                string groupname = context.Request.QueryString["groupname"];
                string countryname = context.Request.QueryString["countryname"];
                string Member = context.Request.QueryString["Member"];
                string LetterNumbers = context.Request.QueryString["LetterNumbers"];
                List<VisaFeeMain> visaFees = new OilDigital.CGGL.Web.VisaApply.VisaApplyProcess().GetVisaFeeByQueryString(startDate, endDate, unit, groupname, countryname, Member, LetterNumbers);
                for (int i = visaFees.Count-1; i >=0; i--)
                {
                    bool flag = true;
                    for (int j  = 0; j < idArray.Length; j++)
                    {
                        if (visaFees[i].Id.ToString() == idArray[j])
                        {
                            flag = false;
                            break;
                        }
                    }
                    if (flag)
                    {
                        visaFees.RemoveAt(i);
                    }
                }
                HSSFWorkbook wb = new HSSFWorkbook();//创建工作薄
                HSSFSheet sheet = (HSSFSheet)wb.CreateSheet(title); //创建工作表
                HSSFRow row_Title = (HSSFRow)sheet.CreateRow(0); //创建列头行
                row_Title.HeightInPoints = 19.5F; //设置列头行高
                string[] titleStr = { "批件文号", "申办国家(地区)", "总金额", "人员名单", "总人数", "备注", "创建时间", "创建人"};
                //设置列宽
                for (int i = 0; i < titleStr.Length; i++)
                {
                       sheet.SetColumnWidth(i, 20 * 256);

                }
                //设置列样式
                HSSFCellStyle cs_Title = (HSSFCellStyle)wb.CreateCellStyle(); //创建列头样式
                cs_Title.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; //水平居中
                cs_Title.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center; //垂直居中
                HSSFFont cs_Title_Font = (HSSFFont)wb.CreateFont(); //创建字体
                cs_Title_Font.FontHeightInPoints = 12; //字体大小
                cs_Title_Font.Boldweight = (short)FontBoldWeight.Bold;
                cs_Title.SetFont(cs_Title_Font); //将字体绑定到样式
                //填充列头内容
                for (int i = 0; i < titleStr.Length; i++)
                {
                    HSSFCell cell_Title = (HSSFCell)row_Title.CreateCell(i); //创建单元格
                    cell_Title.CellStyle = cs_Title; //将样式绑定到单元格
                    cell_Title.SetCellValue(titleStr[i]);
                }
                //设置单元格样式
                HSSFCellStyle cs_Content = (HSSFCellStyle)wb.CreateCellStyle(); //创建列头样式
                cs_Content.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; //水平居中
                cs_Content.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center; //垂直居中
                //填充单元格
                int r = 0;
                for (r = 0; r < visaFees.Count; r++)
                {
                    int i = r;
                    HSSFRow row = (HSSFRow)sheet.CreateRow(i + 1);
                    row.HeightInPoints = 16;
                    string[] arr = { visaFees[i].LetterNumbers.ToString(), visaFees[i].EmbassyNames, visaFees[i].Fee, visaFees[i].Names, visaFees[i].TotalAmount.ToString(), visaFees[i].Memo, visaFees[i].CreatedTime.ToString("yyyy-MM-dd"), visaFees[i].CreatedBy };
                    for (int j = 0; j < arr.Length; j++)
                    {
                        HSSFCell cell = (HSSFCell)row.CreateCell(j); //创建单元格
                        cell.CellStyle = cs_Content;
                            cell.SetCellValue(arr[j]);

                    }
                }
              

                HttpResponse httpResponse = HttpContext.Current.Response;
                httpResponse.Clear();
                httpResponse.Buffer = true;
                //httpResponse.Charset = Encoding.UTF8.BodyName;
                httpResponse.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("签证费用.xls"));
                httpResponse.ContentEncoding = System.Text.Encoding.UTF8;
                httpResponse.ContentType = "application/vnd.ms-excel; charset=UTF-8";
                wb.Write(httpResponse.OutputStream);
                httpResponse.End();
            }
            catch (Exception ex)
            {

                throw new Exception(ex.Message);
            }
        }