c# - NPOI 设置不同的单元格格式

Question

我在每个单元格中设置不同的格式时遇到问题，我想将数字格式设置为千位分隔符和带有 3 位小数的千位分隔符，当数字不是整数时，这是我的代码，我认为问题看起来像是设置了每个单元格格式通过for循环中最后的格式设置

所以输出应该是这样的12345 -> 12345； 425 -> 425； 41,2 -> 41,2； 4578,25 -> 4 578,25

        short doubleFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat("#,##0.###");
        short intFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat("#,##0");
        for (i = 0; i <= unorderedSheet.LastRowNum; i++)
        {
            NPOI.SS.UserModel.IRow newRow = orderedSheet.CreateRow(i);
            NPOI.SS.UserModel.IRow oldRow = unorderedSheet.GetRow(i);
            if (oldRow != null)
            {
                foreach (ICell oldCell in oldRow.Cells)
                {
                    ICell newCell = newRow.CreateCell(mapping[n]);
                    switch (oldCell.CellType)
                    { 
                        case CellType.NUMERIC:
                            newCell.SetCellType(CellType.NUMERIC);
                            newCell.SetCellValue(oldCell.NumericCellValue);
                            if (numberHasDecimals(oldCell.NumericCellValue))
                            {
                                newCell.CellStyle.DataFormat = doubleFormat;
                            }
                            else
                            {
                                newCell.CellStyle.DataFormat = intFormat;                
                            }
                            break;
                        default:
                            newCell.SetCellValue(oldCell.ToString());
                            break;
                    }}}}

Answer 1

static ICellStyle _doubleCellStyle = null;
static ICellStyle _intCellStyle    = null;
static void SettingDifferentCellFormat( HSSFWorkbook hssfOutputWorkBook, ISheet orderedSheet, ISheet unorderedSheet ) {

   //short doubleFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat( "#,##0.###" );
   //short intFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat( "#,##0" );

   if ( _doubleCellStyle == null ) { 
      _doubleCellStyle = hssfOutputWorkBook.CreateCellStyle();
      _doubleCellStyle.DataFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat( "#,##0.###" );
   }

   if ( _intCellStyle == null ) { 
      _intCellStyle = hssfOutputWorkBook.CreateCellStyle();
      _intCellStyle.DataFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat( "#,##0" ); 
   }

   for ( int i = 0; i <= unorderedSheet.LastRowNum; i++ ) {

      NPOI.SS.UserModel.IRow newRow = orderedSheet.CreateRow( i );
      NPOI.SS.UserModel.IRow oldRow = unorderedSheet.GetRow( i );

      const int mapping_n_ = 0;

      if ( oldRow != null ) {
         foreach ( ICell oldCell in oldRow.Cells ) {

            ICell newCell = newRow.CreateCell( mapping_n_ );
            bool numberHasDecimals = true;

            switch ( oldCell.CellType ) {

               case CellType.NUMERIC:

                  newCell.SetCellType( CellType.NUMERIC );
                  newCell.SetCellValue( oldCell.NumericCellValue );

                  if ( numberHasDecimals ) {
                     //newCell.CellStyle.DataFormat = doubleFormat;
                     newCell.CellStyle = _doubleCellStyle;
                  } else {
                     //newCell.CellStyle.DataFormat = intFormat;
                     newCell.CellStyle = _intCellStyle;
                  }
                  break;
               default:
                  newCell.SetCellValue( oldCell.ToString() );
                  break;
            }
         }
      }
   }

}//SettingDifferentCellFormat