asp.netDataTable导出Excel自定义列名的方法

　　using NPOI.HSSF.UserModel;
　　using NPOI.SS.UserModel;
　　using System.IO;

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using WSC.Framework;
using System.Data;
using WSC.Common;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using System.IO;
public partial class WorkManage_SMT_SMTMaintain : WSC.FramePage
{
 SQLHelper sql = new SQLHelper(ConfigurationManager.AppSettings["LocalConnectionString"].ToString());
 protected void Page_Load(object sender, EventArgs e)
 {
 if (!IsPostBack)
 {
 }
 }
 protected void btnReport_Click(object sender, EventArgs e)
 {
 string strSql = string.Format(@" select smtpicsmdl.model,smtmdl.submodel,pcbapn,PrdType,cycle,cast((12*3600/cycle) as int) as 'rate',onlineMan,offlineMan,reserve3,ptype_desc,minsqg,maxsqg from smtmdl left join smtpicsmdl on smtpicsmdl.submodel=smtmdl.submodel where pcbapn = '{0}' order by smtpicsmdl.model asc,smtpicsmdl.submodel asc,PrdType asc", this.txtMdmitem.Text.Trim());
 DataTable dt = sql.Query(strSql);
 string strFileName = "SMT机种信息" + DateTime.Now.ToString("yyyyMMddHHmmss");
 ExportExcel(dt, strFileName, "SMT机种信息");
 }
 /// 

 /// DataTable导出Excel
 /// 
 /// datatable数据源
 /// 文件名
 /// 工作簿名
 public void ExportExcel(DataTable dt, string strFileName, string strSheetName)
 {
 HSSFWorkbook book = new HSSFWorkbook();
 ISheet sheet = book.CreateSheet(strSheetName);
 
 IRow headerrow = sheet.CreateRow(0);
 ICellStyle style = book.CreateCellStyle();
 style.Alignment = HorizontalAlignment.Center;
 style.VerticalAlignment = VerticalAlignment.Center;
 
 HSSFRow dataRow = (HSSFRow)sheet.CreateRow(0);
 string strColumns = "主机种,子机种,5E料号,产线类型,CT（S）,rate/12H,线上人力,线外人力,总人力,面别,刮刀下限,刮刀上限";
 string[] strArry = strColumns.Split(',');
 for (int i = 0; i