Package org.apache.poi.ss.usermodel

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

45
46
47
48
49
50
51
52
53
54
55
        this.fill = fill;
    }

    @Override
    public void applyTo(org.apache.poi.ss.usermodel.Cell cell, Workbook workbook) {
        CellStyle style = newStyleBasedOn(cell).create(workbook);
        applyBorderTo(style);
        applyFillTo(style);
        applyAlignmentTo(style);
        applyDataFormatTo(style, workbook);
        applyFontTo(style, workbook);
View Full Code Here
67
68
69
70
71
72
73
74
75
76
        static Cell createCell(int row, int column, Date date) {
        Workbook workbook = new HSSFWorkbook();
        Sheet sheet = workbook.createSheet();
        Cell cell = sheet.createRow(row).createCell(column, CELL_TYPE_NUMERIC);
        cell.setCellValue(date);
        CellStyle style = workbook.createCellStyle();
        style.setDataFormat(workbook.getCreationHelper().createDataFormat().getFormat("m/d/yy h:mm"));
        cell.setCellStyle(style);
        return cell;
    }
View Full Code Here
31
32
33
34
35
36
37
38
39
        return new ClonedStyleFactory(source);
    }

    @Override
    public CellStyle create(Workbook workbook) {
        CellStyle style = workbook.createCellStyle();
        style.cloneStyleFrom(source.getCellStyle());
        return style;
    }
View Full Code Here
60
61
62
63
64
65
66
67
    public void testLoadStyles() throws Exception {
        XSSFWorkbook workbook = new XSSFWorkbook(new File(filename, "styles.xlsx").getAbsolutePath());
        Sheet sheet = workbook.getSheetAt(0);
        Row row = sheet.getRow(0);
        Cell cell = row.getCell((short) 0);
        CellStyle style = cell.getCellStyle();
        // assertNotNull(style);
    }
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
125
      cell.setCellValue(new Date());

      // we style the second cell as a date (and time).  It is important to
      // create a new cell style from the workbook otherwise you can end up
      // modifying the built in style and effecting not only this cell but other cells.
      CellStyle cellStyle = wb.createCellStyle();
      cellStyle.setDataFormat(createHelper.createDataFormat().getFormat("m/d/yy h:mm"));
      cell = row.createCell((short)1);
      cell.setCellValue(new Date());
      cell.setCellStyle(cellStyle);

      // Write the output to a file
View Full Code Here
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
    public void testCellFormatting() throws Exception {
      Workbook workbook = new XSSFWorkbook();
      Sheet sheet = workbook.createSheet();
      CreationHelper creationHelper = workbook.getCreationHelper();
     
      CellStyle cs = workbook.createCellStyle();
      assertNotNull(cs);
     
      assertNotNull(creationHelper);
      assertNotNull(creationHelper.createDataFormat());
     
      cs.setDataFormat(
          creationHelper.createDataFormat().getFormat("yyyy/mm/dd")
      );
      Cell cell = sheet.createRow(0).createCell((short)0);
      cell.setCellValue(new Date(654321));
     
View Full Code Here
262
263
264
265
266
267
268
269
270
    }

    // //////////////////////////////////////

    protected CellMarshaller newCellMarshaller(final Workbook wb) {
        final CellStyle dateCellStyle = createDateFormatCellStyle(wb);
        final CellMarshaller cellMarshaller = new CellMarshaller(bookmarkService, dateCellStyle);
        return cellMarshaller;
    }
View Full Code Here
272
273
274
275
276
277
278
279
280
    protected CellStyle createDateFormatCellStyle(final Workbook wb) {
        final CreationHelper createHelper = wb.getCreationHelper();
        final SimpleDateFormat dateInstance = (SimpleDateFormat) DateFormat.getDateInstance(DateFormat.MEDIUM);
        final String pattern = dateInstance.toPattern();
        short dateFormat = createHelper.createDataFormat().getFormat(pattern);
        final CellStyle dateCellStyle = wb.createCellStyle();
        dateCellStyle.setDataFormat(dateFormat);
        return dateCellStyle;
    }
View Full Code Here
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
        //create data format
        DataFormat df = workbook.createDataFormat();
        short sdf = df.getFormat(formatter.format());
       
        //set format
        CellStyle style = cell.getCellStyle();
        if (style == null) {
          style = workbook.createCellStyle();
        }
        style.setDataFormat(sdf);
       
      }
     
      if (result instanceof Date) {
       
View Full Code Here
374
375
376
377
378
379
380
381
382
383
384
385
     
            // Grab a copy of the old/new cell
            Cell newCell = newRow.createCell(oldCell.getColumnIndex());

            // Copy style from old cell and apply to new cell
            CellStyle newCellStyle = workbook.createCellStyle();
            newCellStyle.cloneStyleFrom(oldCell.getCellStyle());
            newCell.setCellStyle(newCellStyle);

            // If there is a cell comment, copy
            if (oldCell.getCellComment() != null) {
                newCell.setCellComment(oldCell.getCellComment());
View Full Code Here
TOP

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

  • accounts.web.ReportPoiController
  • accounts.web.ReportPoiControllerTest
  • bad.robot.excel.cell.DataFormat
  • bad.robot.excel.matchers.StubCell
  • bad.robot.excel.style.ClonedStyleFactory
  • bad.robot.excel.style.ReplaceExistingStyle
  • br.com.objectos.way.io.POICell
  • br.com.objectos.way.io.POIWorkbook
  • br.com.objectos.way.io.TableStyle
  • br.com.objectos.way.io.WayIO
    • 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.