Examples of HSSFDataFormatter

org.apache.poi.hssf.usermodel.HSSFDataFormatter
HSSFDataFormatter contains methods for formatting the value stored in an HSSFCell. This can be useful for reports and GUI presentations when you need to display data exactly as it appears in Excel. Supported formats include currency, SSN, percentages, decimals, dates, phone numbers, zip codes, etc.
Internally, formats will be implemented using subclasses of {@link Format}such as {@link DecimalFormat} and {@link SimpleDateFormat}. Therefore the formats used by this class must obey the same pattern rules as these Format subclasses. This means that only legal number pattern characters ("0", "#", ".", "," etc.) may appear in number formats. Other characters can be inserted before or after the number pattern to form a prefix or suffix.

For example the Excel pattern "$#,##0.00 "USD"_);($#,##0.00 "USD")" will be correctly formatted as "$1,000.00 USD" or "($1,000.00 USD)". However the pattern "00-00-00" is incorrectly formatted by DecimalFormat as "000000--". For Excel formats that are not compatible with DecimalFormat, you can provide your own custom {@link Format} implementationvia HSSFDataFormatter.addFormat(String,Format). The following custom formats are already provided by this class:
```
 SSN "000-00-0000"
 Phone Number "(###) ###-####"
 Zip plus 4 "00000-0000"
 
 
```
If the Excel format pattern cannot be parsed successfully, then a default format will be used. The default number format will mimic the Excel General format: "#" for whole numbers and "#.##########" for decimal numbers. You can override the default format pattern with HSSFDataFormatter.setDefaultNumberFormat(Format). Note: the default format will only be used when a Format cannot be created from the cell's data format string. @author James May (james dot may at fmr dot com)

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

            if(HSSFDateUtil.isCellDateFormatted(cellData)){
              Date xlDtVal=cellData.getDateCellValue();
              cell.setCellValue(new HSSFRichTextString(CommonUtilities.getDateInddMMYYYYFormat(xlDtVal)));
              break;
            }else{
              HSSFDataFormatter format = new HSSFDataFormatter(); // copies the data in the same format
              cell.setCellValue(new HSSFRichTextString(format.formatCellValue(cellData)));
            }
            break;
          }
        }
      }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

//                        td.text(strValue);
                      }else{
                        HSSFCellStyle cellStyle = hssfCell.getCellStyle();
                        if(cellStyle!=null && cellStyle.getDataFormatString()!=null){
//                          String dataFmt = cellStyle.getDataFormatString();
                          strValue = new HSSFDataFormatter().formatRawCellContents(hssfCell.getNumericCellValue(), cellStyle.getDataFormat(), cellStyle.getDataFormatString());
                        }else{
                          strValue = String.valueOf(hssfCell.getNumericCellValue());
                        }
                      }
                    }else{
                      XSSFCell xssfCell = (XSSFCell)cell;
                      if(HSSFDateUtil.isCellDateFormatted(cell)){
                          String dateFmt = cell.getCellStyle().getDataFormatString();
                          /* strValue = new SimpleDateFormat(dateFmt).format(date); - won't work as 
                          Java fmt differs from Excel fmt. If Excel date format is mm/dd/yyyy, Java 
                          will always be 00 for date since "m" is minutes of the hour.*/
                          strValue = new CellDateFormatter(dateFmt).format(cell.getDateCellValue()); 
//                        td.text(strValue);
                      }else{
                        XSSFCellStyle cellStyle = xssfCell.getCellStyle();
                        if(cellStyle!=null && cellStyle.getDataFormatString()!=null){
//                           String dateFmt = cell.getCellStyle().getDataFormatString();
                              /* strValue = new SimpleDateFormat(dateFmt).format(date); - won't work as 
                              Java fmt differs from Excel fmt. If Excel date format is mm/dd/yyyy, Java 
                              will always be 00 for date since "m" is minutes of the hour.*/
                           strValue = new HSSFDataFormatter().formatRawCellContents(cell.getNumericCellValue(), cellStyle.getDataFormat(), cellStyle.getDataFormatString());
                        }else{
                            strValue = String.valueOf(xssfCell.getNumericCellValue()); 
                        }
//                        xssfCell.getCellStyle().getDataFormatString();
//                        td.text(String.valueOf(cell.getNumericCellValue()));

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

    style = wb.createCellStyle();
    HSSFDataFormat fmt = wb.createDataFormat();
    style.setDataFormat(fmt.getFormat("hh:mm:ss"));


    cell11 = sheet.createRow(0).createCell(0);
    form = new HSSFDataFormatter();


    evaluator = new HSSFFormulaEvaluator(wb);
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

  private boolean _includeHeadersFooters = true;


  public ExcelExtractor(HSSFWorkbook wb) {
    super(wb);
    _wb = wb;
    _formatter = new HSSFDataFormatter();
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

   * the given locale for the formats.
   */
  public FormatTrackingHSSFListener(
      HSSFListener childListener, Locale locale) {
    _childListener = childListener;
    _formatter = new HSSFDataFormatter(locale);
    _defaultFormat = NumberFormat.getInstance(locale);
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

   * the given locale for the formats.
   */
  public FormatTrackingHSSFListener(
      HSSFListener childListener, Locale locale) {
    _childListener = childListener;
    _formatter = new HSSFDataFormatter(locale);
    _defaultFormat = NumberFormat.getInstance(locale);
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

  private boolean _includeHeadersFooters = true;
  
  public ExcelExtractor(HSSFWorkbook wb) {
    super(wb);
    _wb = wb;
    _formatter = new HSSFDataFormatter();
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

  private boolean _includeHeadersFooters = true;
  
  public ExcelExtractor(HSSFWorkbook wb) {
    super(wb);
    _wb = wb;
    _formatter = new HSSFDataFormatter();
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

    style = wb.createCellStyle();
    HSSFDataFormat fmt = wb.createDataFormat();
    style.setDataFormat(fmt.getFormat("hh:mm:ss"));


    cell11 = sheet.createRow(0).createCell(0);
    form = new HSSFDataFormatter();


    evaluator = new HSSFFormulaEvaluator(wb);
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter

    style = wb.createCellStyle();
    HSSFDataFormat fmt = wb.createDataFormat();
    style.setDataFormat(fmt.getFormat("hh:mm:ss"));


    cell11 = sheet.createRow(0).createCell(0);
    form = new HSSFDataFormatter();


    evaluator = new HSSFFormulaEvaluator(wb);
  }

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.