Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.DataFormat

339
340
341
342
343
344
345
346
347
348
349
350
      } else if (val instanceof Double) {
        cell.setCellValue((Double) val);
      } else if (val instanceof Float) {
        cell.setCellValue((Float) val);
      } else if (val instanceof Date) {
        DataFormat format = wb.createDataFormat();
              style.setDataFormat(format.getFormat("yyyy-MM-dd"));
        cell.setCellValue((Date) val);
      } else {
        if (fieldType != Class.class){
          cell.setCellValue((String)fieldType.getMethod("setValue", Object.class).invoke(null, val));
        }else{
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    private CellStyle warningStyle;

    public ExcelCellStyles(Workbook wb) {
        CreationHelper helper = wb.getCreationHelper();
        DataFormat fmt = helper.createDataFormat();

        dateStyle = wb.createCellStyle();
        dateStyle.setDataFormat(fmt.getFormat("yyyy-mm-dd hh:mm:ss"));

        headerStyle = wb.createCellStyle();
        Font headerFont = wb.createFont();
        headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
        headerStyle.setFont(headerFont);
View Full Code Here
42
43
44
45
46
47
48
49
  }

  static void applyFormatTo(Cell cell, String string) {
    Workbook wb = workbookOf(cell);
    CellStyle style = cell.getCellStyle();
    DataFormat df = wb.createDataFormat();
    style.setDataFormat(df.getFormat(string));
  }
View Full Code Here
40
41
42
43
44
45
46
47
  public static WorkbookXlsBuilder newWorkbookXls() {
    return new WorkbookXlsBuilder();
  }

  static void applyFormatTo(Workbook wb, CellStyle style, String formatString) {
    DataFormat df = wb.createDataFormat();
    style.setDataFormat(df.getFormat(formatString));
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.usermodel.DataFormat

  • br.com.objectos.way.io.WayIO
  • br.com.starcode.trex.spreadsheet.PoiSheetParser
  • com.asakusafw.testdata.generator.excel.WorkbookInfo
  • com.asakusafw.testdriver.excel.WorkbookInfo
  • com.asakusafw.testtools.templategen.ExcelBookBuilder
  • com.dci.intellij.dbn.data.export.processor.ExcelDataExportProcessor$CellStyleCache
  • com.ebay.xcelite.styles.CellStyles
  • com.haulmont.yarg.formatters.impl.xls.hints.CustomCellStyleHint
  • com.thinkgem.jeesite.common.utils.excel.ExportExcel
  • no.ugland.utransprod.util.excel.CellStyle
    • 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.