public List<string> GetExcel(string year, string month, string type, out string statusCode, out string errMsg)

           {

               statusCode = "";

               errMsg = "";

               List<string> response = new List<string>();

               string strFilePath = "";

               string strGuid = Guid.NewGuid().ToString();

               string FilePath = "\\BufFile\\OutFiles\\DownLoadFiles\\ExportExcel\\" + strGuid;

                //构建文件缓存目录

               strFilePath = System.IO.Directory.GetParent(System.IO.Directory.GetParent(System.AppDomain.CurrentDomain.BaseDirectory).FullName).FullName + FilePath;

              if (!System.IO.Directory.Exists(strFilePath))

              {

                  System.IO.Directory.CreateDirectory(strFilePath);

              }

              //文件命名

              string strFileName = strFilePath + "\\" + "XXXXXX.xls";

              string ret = FilePath + "\\" + "XXXXXX.xls";

              string uploadPath = System.IO.Directory.GetParent(System.IO.Directory.GetParent(System.AppDomain.CurrentDomain.BaseDirectory).FullName).FullName + "\\BufFile\\OutFiles\\UploadFiles\\";

              List<CompletionRateModel> data = GetCompletionRate(year, month, out statusCode, out errMsg);

              try

              {   //创建工作薄

                  HSSFWorkbook hssfWorkBook = new HSSFWorkbook();

                    //编辑文件信息，如文件所属公司、作者、创建日期等

                  DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();

                  dsi.Company = "ZondyCyber";

                  SummaryInformation si = PropertySetFactory.CreateSummaryInformation();

                  si.Author = "ZondyCyber";

                  si.LastAuthor = "ZondyCyber";

                  si.CreateDateTime = DateTime.Now;

                  hssfWorkBook.DocumentSummaryInformation = dsi;

                  hssfWorkBook.SummaryInformation = si;

                    //创建名为YYYYYY的表sheet

                  HSSFSheet hssfSheet = hssfWorkBook.CreateSheet("YYYYYY") as HSSFSheet;

                  //设置列宽

                  for (int c = ; c < ; c++)

                  {

                      hssfSheet.SetColumnWidth(c,  * );

                  }

                  //设置列头的单元格样式

                  HSSFCellStyle cellStyle = hssfWorkBook.CreateCellStyle() as HSSFCellStyle;

                  HSSFFont cellFont = hssfWorkBook.CreateFont() as HSSFFont;

                  cellFont.Boldweight = Convert.ToInt16(FontBoldWeight.Bold);

                  cellFont.FontName = "宋体";

                  cellFont.FontHeightInPoints = ;

                  cellStyle.Alignment = HorizontalAlignment.Center;

                  cellStyle.VerticalAlignment = VerticalAlignment.Center;

                  cellStyle.WrapText = true;

                  cellStyle.SetFont(cellFont);

                  cellStyle.BorderTop = cellStyle.BorderRight = cellStyle.BorderBottom = cellStyle.BorderLeft = BorderStyle.Thin;//BorderStyle.None

                  //左对齐样式

                  HSSFCellStyle leftCellStyle = hssfWorkBook.CreateCellStyle() as HSSFCellStyle;

                  leftCellStyle.CloneStyleFrom(cellStyle);

                  leftCellStyle.Alignment = HorizontalAlignment.Left;

                  //居中填充样式

                  HSSFCellStyle fillCellStyle = hssfWorkBook.CreateCellStyle() as HSSFCellStyle;

                  fillCellStyle.CloneStyleFrom(cellStyle);

                  fillCellStyle.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.Grey25Percent.Index;

                  //fillCellStyle.FillPattern = FillPattern.Diamonds;

                  //fillCellStyle.FillPattern = FillPattern.FineDots;

                  fillCellStyle.FillPattern = FillPattern.LeastDots;

                  fillCellStyle.FillBackgroundColor = NPOI.HSSF.Util.HSSFColor.Grey25Percent.Index;

                  //居中填充样式(无边框)

                  HSSFCellStyle fillCellStyle2 = hssfWorkBook.CreateCellStyle() as HSSFCellStyle;

                  fillCellStyle2.CloneStyleFrom(fillCellStyle);

                  //fillCellStyle2.FillPattern = FillPattern.NoFill;

                  fillCellStyle2.BorderTop = fillCellStyle2.BorderRight = fillCellStyle2.BorderBottom = fillCellStyle2.BorderLeft = BorderStyle.None;//BorderStyle.None

                  //值的样式

                  HSSFCellStyle valueStyle = hssfWorkBook.CreateCellStyle() as HSSFCellStyle;

                  HSSFFont valueFont = hssfWorkBook.CreateFont() as HSSFFont;

                  valueFont.FontName = "宋体";

                  valueFont.FontHeightInPoints = ;

                  valueStyle.BorderTop = valueStyle.BorderRight = valueStyle.BorderBottom = valueStyle.BorderLeft = BorderStyle.Thin;//BorderStyle.None

                  valueStyle.WrapText = true;

                  valueStyle.Alignment = HorizontalAlignment.Center;

                  valueStyle.VerticalAlignment = VerticalAlignment.Center;

                  valueStyle.SetFont(valueFont);

                  //值的样式（无边框）

                  HSSFCellStyle valueStyle2 = hssfWorkBook.CreateCellStyle() as HSSFCellStyle;

                  valueStyle2.CloneStyleFrom(valueStyle);

                  valueStyle2.BorderTop = valueStyle2.BorderRight = valueStyle2.BorderBottom = valueStyle2.BorderLeft = BorderStyle.None;//BorderStyle.None

                  //开始构建表格

                  int rowIndex = ;//记录用到第几行

                  //构建表题

                  String Title = "XXXXXX(" + type + ")统计     " + year + "年" + month + "月";

                  //创建表格的第一行的第一个单元格

                    hssfSheet.CreateRow().CreateCell().CellStyle = fillCellStyle;

                    //获取表格的第一行的第一个单元格，并为其赋值

                  hssfSheet.GetRow().GetCell().SetCellValue(Title);

                  //合并单元格

                    /*

                    * cellRangeAddress可以合并行或列，第一个参数是起始行号，第二个参数是终止行号，第三个参数是起始列号，第三个参数是终止列号

                    */

                  CellRangeAddress region = new CellRangeAddress(rowIndex, rowIndex + , , );

                  hssfSheet.AddMergedRegion(region);

                  hssfSheet.SetEnclosedBorderOfRegion(region, BorderStyle.Thin, NPOI.HSSF.Util.HSSFColor.Black.Index);

                  rowIndex = rowIndex + ; //

                  String Type = "部门";

                  //构建表头

                  hssfSheet.CreateRow(rowIndex).CreateCell().CellStyle = valueStyle;

                  hssfSheet.GetRow(rowIndex).GetCell().SetCellValue("序号");

                  /**

                    ** 构建表格的具体细节省略，无非是合并单元格，填充数据

                    **/

                 //表格构建完毕

                 FileStream file = new FileStream(strFileName, FileMode.Create);

                 hssfWorkBook.Write(file);

                 file.Close();

                 response.Add(ret);

             }