Package org.apache.poi.hssf.usermodel

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

47
48
49
50
51
52
53
54
55
56
57
58
  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
108
109
110
111
112
113
114
115
116
117
118
119
120
   * @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
135
136
137
138
139
140
141
142
143
144
145
        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
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
            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
584
585
586
587
588
589
590
591
592
593
594
595
        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
118
119
120
121
122
123
124
125
126
127
128
        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
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
            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
TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFDataFormat

  • cn.baiweigang.qtaf.toolkit.dbunit.data.excel.XlsDataSetWriter
  • com.canoo.ant.table.ExcelPropertyTable
  • er.excel.EGSimpleTableParser
  • evolaris.framework.sys.business.CSVFile
  • org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPStyle
  • org.apache.poi.hssf.record.FormatRecord
  • org.apache.poi.hssf.record.formula.functions.TestTime
  • org.apache.poi.hssf.usermodel.examples.InCellLists
  • org.apache.poi.ss.formula.functions.TestTime
  • org.dbunit.dataset.excel.XlsDataSetWriter
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.