Examples of HSSFDataFormat

org.apache.poi.hssf.usermodel.HSSFDataFormat
- 0x24 reserved for international and undocumented 0x25, "(#,##0_);(#,##0)"
0x26, "(#,##0_);[Red](#,##0)"
0x27, "(#,##0.00_);(#,##0.00)"
0x28, "(#,##0.00_);[Red](#,##0.00)"
0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"
0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"
0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"
0x2c, "_($*#,##0.00_);_($*(#,##0.00);_($*\"-\"??_);_(@_)"
0x2d, "mm:ss"
0x2e, "[h]:mm:ss"
0x2f, "mm:ss.0"
0x30, "##0.0E+0"
0x31, "@" - This is text format.
0x31 "text" - Alias for "@"
@author Andrew C. Oliver (acoliver at apache dot org) @author Shawn M. Laubach (slaubach at apache dot org)
org.zkoss.poi.hssf.usermodel.HSSFDataFormat

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


  public void setUp() {
    wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("new sheet");
    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.HSSFDataFormat

   * @return an XLS file in form of a byte array (to be streamed for download)
   */
  public byte[] toXLS(int headerRowCount, Short[] numberColumns, Short[] dateColumns) {
    HSSFWorkbook wb = new HSSFWorkbook();
      HSSFSheet s = wb.createSheet();
      HSSFDataFormat dataFormat = wb.createDataFormat();
      HSSFCellStyle dateStyle = wb.createCellStyle();
      dateStyle.setDataFormat(dataFormat.getFormat("dd.mm.yyyy"));
      int rownum = 0;
      for (Iterator<String[]> it = this.iterator(); it.hasNext(); rownum++) {
        HSSFRow r = s.createRow(rownum);
        String[] values = it.next();
        for (short columnnum = 0; columnnum<values.length; columnnum++) {

View Full Code Here

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

        workbook.write(out);
        out.flush();
    }
    
    protected static HSSFCellStyle createDateCellStyle(HSSFWorkbook workbook) {
        HSSFDataFormat format = workbook.createDataFormat();
        short dateFormatCode = format.getFormat(DATE_FORMAT_AS_NUMBER_DBUNIT);
        HSSFCellStyle dateCellStyle = workbook.createCellStyle();
        dateCellStyle.setDataFormat(dateFormatCode);
        return dateCellStyle;
    }

View Full Code Here

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

            logger.debug("setNumericCell(cell={}, value={}, workbook={}) - start", 
                new Object[] {cell, value, workbook} );


        cell.setCellValue( ((BigDecimal)value).doubleValue() );


        HSSFDataFormat df = workbook.createDataFormat();
        int scale = ((BigDecimal)value).scale();
        short format;
        if(scale <= 0){
            format = df.getFormat("####");
        }
        else {
            String zeros = createZeros(((BigDecimal)value).scale());
            format = df.getFormat("####." + zeros);
        }
        if(logger.isDebugEnabled())
            logger.debug("Using format '{}' for value '{}'.", String.valueOf(format), value);
        
        HSSFCellStyle cellStyleNumber = workbook.createCellStyle();

View Full Code Here

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

        takeClassValueForKey(dict, "alignment", cellStyle, CellStyle.class, null);
        takeClassValueForKey(dict, "verticalAlignment", cellStyle, CellStyle.class, null);
        
        String formatString = dictValueForKey(dict, "format", null);
        if(formatString != null) {
          HSSFDataFormat format = _workbook.createDataFormat();
          short formatId = format.getFormat(formatString);
          cellStyle.setDataFormat(formatId);
        }
        
        _styles.setObjectForKey(cellStyle, dict);
                if(log.isDebugEnabled()) {

View Full Code Here

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

        workbook.write(out);
        out.flush();
    }
    
    protected static HSSFCellStyle createDateCellStyle(HSSFWorkbook workbook) {
        HSSFDataFormat format = workbook.createDataFormat();
        short dateFormatCode = format.getFormat(DATE_FORMAT_AS_NUMBER_DBUNIT);
        HSSFCellStyle dateCellStyle = workbook.createCellStyle();
        dateCellStyle.setDataFormat(dateFormatCode);
        return dateCellStyle;
    }

View Full Code Here

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

            logger.debug("setNumericCell(cell={}, value={}, workbook={}) - start", 
                new Object[] {cell, value, workbook} );


        cell.setCellValue( ((BigDecimal)value).doubleValue() );


        HSSFDataFormat df = workbook.createDataFormat();
        int scale = ((BigDecimal)value).scale();
        short format;
        if(scale <= 0){
            format = df.getFormat("####");
        }
        else {
            String zeros = createZeros(((BigDecimal)value).scale());
            format = df.getFormat("####." + zeros);
        }
        if(logger.isDebugEnabled())
            logger.debug("Using format '{}' for value '{}'.", String.valueOf(format), value);
        
        HSSFCellStyle cellStyleNumber = workbook.createCellStyle();

View Full Code Here

Examples of org.zkoss.poi.hssf.usermodel.HSSFDataFormat

    return pi != null ? pi.getVerticalSplitPosition() : 0;
  }
  
  /*package*/ static void setDataFormat(Workbook book, CellStyle style, String formatString) {
    if (book instanceof HSSFWorkbook) {
      HSSFDataFormat df = ((HSSFWorkbook)book).createDataFormat();
      final short fmt = df.getFormat(formatString);
      style.setDataFormat(fmt);
    } else {
      XSSFDataFormat df = ((XSSFWorkbook)book).createDataFormat();
      final short fmt = df.getFormat(formatString);
      style.setDataFormat(fmt);
    }
  }

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.