ICellStyle cellStyle = workbook.CreateCellStyle();          cellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("0.00%");          SumRow.CreateCell(17).CellStyle = cellStyle; 

SumRow.CreateCell(17).SetCellValue(Convert.ToDouble(sumExamineGrossRate)); 

/// <summary>

        /// 获取单元格样式

        /// </summary>

        /// <param name="hssfworkbook">Excel操作类</param>

        /// <param name="font">单元格字体</param>

        /// <param name="fillForegroundColor">图案的颜色</param>

        /// <param name="fillPattern">图案样式</param>

        /// <param name="fillBackgroundColor">单元格背景</param>

        /// <param name="ha">垂直对齐方式</param>

        /// <param name="va">垂直对齐方式</param>

        /// <returns></returns>

        public static ICellStyle GetCellStyle(HSSFWorkbook hssfworkbook, IFont font, HSSFColor fillForegroundColor, FillPatternType fillPattern, HSSFColor fillBackgroundColor, HorizontalAlignment ha, VerticalAlignment va)

        {

            ICellStyle cellstyle = hssfworkbook.CreateCellStyle();

            cellstyle.FillPattern = fillPattern;

            cellstyle.Alignment = ha;

            cellstyle.VerticalAlignment = va;

            if (fillForegroundColor != null)

            {

                cellstyle.FillForegroundColor = fillForegroundColor.GetIndex();

            }

            if (fillBackgroundColor != null)

            {

                cellstyle.FillBackgroundColor = fillBackgroundColor.GetIndex();

            }

    &