org.apache.poi.ss.usermodel.Cell#getCellStyle

Source File: ExcelUtils.java From onetwo with Apache License 2.0

6 votes

public static void copyCellStyle(Cell source, Cell target){
	CellStyle style = source.getCellStyle();
	if(style!=null){
		//TODO:会影响性能, 可缓存。。。
		CellStyle newCellStyle = source.getRow().getSheet().getWorkbook().createCellStyle();
		newCellStyle.cloneStyleFrom(style);
		target.setCellStyle(style);
	}
	if(source.getCellComment()!=null){
		target.setCellComment(source.getCellComment());
	}
	if(source.getHyperlink()!=null){
		target.setHyperlink(source.getHyperlink());
	}
	target.setCellType(source.getCellType());
}

Source File: ExcelAdjacencyMatrixExtractor.java From wandora with GNU General Public License v3.0

6 votes

public boolean hasValue(Cell cell) {

        if(ADD_CELL_COLOR_AS_PLAYER || INTERPRET_COLOR_AS_VALID_CELL_VALUE) {
            CellStyle style = cell.getCellStyle();
            short color = style.getFillBackgroundColor();
            if(color != 0) {
                return true;
            }
        }
        
        String str = getCellValueAsString(cell);
        if(str == null) return false;
        if(INTERPRET_FALSE_AS_EMPTY_CELL && "false".equalsIgnoreCase(str)) return false;
        if(INTERPRET_ZERO_AS_EMPTY_CELL && "0".equalsIgnoreCase(str)) return false;
        if(INTERPRET_ZERO_LENGTH_STRING_AS_EMPTY_CELL && "".equalsIgnoreCase(str)) return false;
        
        return true;
    }

Source File: StylerHelper.java From easypoi with Apache License 2.0

6 votes

public void printStyles(Workbook wb) {
    if (DEFAULTS_CLASS_CSS == null) {
        DEFAULTS_CLASS_CSS = getDefaultsClassCss();
    }
    out.format(DEFAULTS_CLASS_CSS);
    Set<CellStyle> seen = new HashSet<CellStyle>();
    sheet = wb.getSheetAt(sheetNum);
    Iterator<Row> rows = sheet.rowIterator();
    while (rows.hasNext()) {
        Row row = rows.next();
        for (Cell cell : row) {
            CellStyle style = cell.getCellStyle();
            if (!seen.contains(style)) {
                printStyle(style);
                seen.add(style);
            }
        }
    }
}

Source File: StylerHelper.java From autopoi with Apache License 2.0

6 votes

public void printStyles(Workbook wb) {
	if (DEFAULTS_CLASS_CSS == null) {
		DEFAULTS_CLASS_CSS = getDefaultsClassCss();
	}
	out.format(DEFAULTS_CLASS_CSS);
	Set<CellStyle> seen = new HashSet<CellStyle>();
	sheet = wb.getSheetAt(sheetNum);
	Iterator<Row> rows = sheet.rowIterator();
	while (rows.hasNext()) {
		Row row = rows.next();
		for (Cell cell : row) {
			CellStyle style = cell.getCellStyle();
			if (!seen.contains(style)) {
				printStyle(style);
				seen.add(style);
			}
		}
	}
}

Source File: XsStyle.java From excel-io with MIT License

5 votes

@Override
public CellStyle attachTo(final Cell cell) {
    final CellStyle style = cell.getCellStyle();
    for (final Props<CellStyle> property : this.properties) {
        property.accept(style);
    }
    return style;
}

Source File: VerticalRecordsProcessor.java From xlsmapper with Apache License 2.0

5 votes

/**
 * セルの書式をコピーする。
 * <p>コピー先のセルの種類は、空セルとする。</p>
 * <p>結合情報も列方向の結合をコピーする。</p>
 *
 * @since 2.0
 * @param fromCell コピー元
 * @param toCell コピー先
 */
private void copyCellStyle(final Cell fromCell, final Cell toCell) {

    final CellStyle style = fromCell.getCellStyle();
    toCell.setCellStyle(style);
    toCell.setCellType(CellType.BLANK);

    // 縦方向に結合されている場合、結合情報のコピーする。（XlsArrayColumns用）
    final Sheet sheet = fromCell.getSheet();
    final CellRangeAddress mergedRegion = POIUtils.getMergedRegion(sheet, fromCell.getRowIndex(), fromCell.getColumnIndex());
    final int mergedSize = POIUtils.getRowSize(mergedRegion);

    if(mergedSize >= 2) {
        CellRangeAddress newMergedRegion = POIUtils.getMergedRegion(sheet, toCell.getRowIndex(), toCell.getColumnIndex());
        if(newMergedRegion != null) {
            // 既に結合している場合 - 通常はありえない。
            return;
        }

        newMergedRegion = POIUtils.mergeCells(sheet,
                toCell.getColumnIndex(), mergedRegion.getFirstRow(), toCell.getColumnIndex(), mergedRegion.getLastRow());

        // 結合先のセルの書式も設定する
        for(int i=1; i < mergedSize; i++) {
            Cell mergedFromCell = POIUtils.getCell(sheet, fromCell.getColumnIndex(), toCell.getRowIndex()+i);

            Cell mergedToCell = POIUtils.getCell(sheet, toCell.getColumnIndex(), toCell.getRowIndex()+i);
            mergedToCell.setCellStyle(mergedFromCell.getCellStyle());
            mergedToCell.setCellType(CellType.BLANK);
        }
    }

}

Source File: Borders1ReportTest.java From birt with Eclipse Public License 1.0

5 votes

private void assertBorder( Sheet sheet, int row, int col, short bottom, short left, short right, short top ) {
	
	Cell cell = sheet.getRow(row).getCell(col);
	CellStyle style = cell.getCellStyle();
			
	assertSingleBorder( sheet, row, "bottom", bottom, style.getBorderBottom() );
	assertSingleBorder( sheet, row, "left", left,   style.getBorderLeft() );
	assertSingleBorder( sheet, row, "right", right,  style.getBorderRight() );
	assertSingleBorder( sheet, row, "top", top,    style.getBorderTop() );
}

Source File: Borders2ReportTest.java From birt with Eclipse Public License 1.0

5 votes

/**
 * Check that the borders for a given cell match the expected values.
 * This is complicated by the fact that POI will not always give a particular cell the borders that are seen in Excel
 * - neighbouring cells may override the values for the chosen cell.
 * I don't know how to tell which takes precedence, but the following works for the tests I've carried out.
 */
public static void assertBorder( Sheet sheet, int row, int col, short bottom, short left, short right, short top ) {
	
	Row curRow = sheet.getRow( row );
	Row prevRow = ( row > 0 ) ? sheet.getRow( row - 1 ) : null;
	Row nextRow = sheet.getRow( row + 1 );
	Cell cell = curRow.getCell(col);
	CellStyle style = cell.getCellStyle();
	
	Cell cellUp = ( prevRow == null ) ? null : prevRow.getCell( col );
	Cell cellDown = ( nextRow == null ) ? null : nextRow.getCell( col );
	Cell cellLeft = ( col == 0 ) ? null : curRow.getCell( col - 1 ); 
	Cell cellRight = curRow.getCell( col + 1 ); 
	
	CellStyle styleUp = ( cellUp == null ) ? null : cellUp.getCellStyle();
	CellStyle styleDown = ( cellDown == null ) ? null : cellDown.getCellStyle();
	CellStyle styleLeft = ( cellLeft == null ) ? null : cellLeft.getCellStyle();
	CellStyle styleRight = ( cellRight == null ) ? null : cellRight.getCellStyle();
	
	System.out.println( "style == " + style );
	System.out.println( "style == " + style );
	
	if( ( top != style.getBorderTop() ) && 
			( ( styleUp == null ) || ( top != styleUp.getBorderBottom() ) ) ) {
		assertEquals( top,    style.getBorderTop() );
	}
	if( ( bottom != style.getBorderBottom() ) && 
			( ( styleDown == null ) || ( bottom != styleDown.getBorderTop() ) ) ) {
		assertEquals( bottom, style.getBorderBottom() );
	}
	if( ( left != style.getBorderLeft() ) && 
			( ( styleLeft == null ) || ( left != styleLeft.getBorderRight() ) ) ) {
		assertEquals( left,   style.getBorderLeft() );
	}
	if( ( right != style.getBorderRight() ) && 
			( ( styleRight == null ) || ( right != styleRight.getBorderLeft() ) ) ) {
		assertEquals( right,  style.getBorderRight() );
	}
}

Source File: POIUtils.java From xlsmapper with Apache License 2.0

5 votes

/**
 * 結合を考慮してセルの罫線（右部）を取得する。
 *
 * @param cell セル
 * @return {@literal BorderStyle}
 * @throws IllegalArgumentException {@literal cell is null.}
 */
public static BorderStyle getBorderLeft(final Cell cell) {

    ArgUtils.notNull(cell, "cell");

    final Sheet sheet = cell.getSheet();
    CellRangeAddress mergedRegion = getMergedRegion(sheet, cell.getRowIndex(), cell.getColumnIndex());

    final Cell target;
    if(mergedRegion == null) {
        // 結合されていない場合
        target = cell;

    } else {
        if(mergedRegion.getFirstColumn() == cell.getColumnIndex()) {
            // 引数のCellが左部のセルの場合
            target = cell;
        } else {
            target = getCell(sheet, mergedRegion.getFirstColumn(), cell.getRowIndex());
        }

    }

    final CellStyle style = target.getCellStyle();
    if(style == null) {
        return BorderStyle.NONE;
    } else {
        return style.getBorderLeftEnum();
    }

}

Source File: FontsReportTest.java From birt with Eclipse Public License 1.0

5 votes

private void assertFontCell( Sheet sheet, int row, int col, String contents, String fontName, int fontHeight ) {
	
	Cell cell = sheet.getRow(row).getCell(col);
	CellStyle style = cell.getCellStyle();
	
	assertEquals( contents, cell.getStringCellValue());
	assertEquals( fontName, sheet.getWorkbook().getFontAt( style.getFontIndex() ).getFontName().replace("\"", "") );
	assertEquals( fontHeight, sheet.getWorkbook().getFontAt( style.getFontIndex() ).getFontHeightInPoints() );
}

Source File: StyleManagerUtils.java From birt with Eclipse Public License 1.0

5 votes

/**
 * Check whether a cell is empty and unformatted.
 * @param cell
 * The cell to consider.
 * @return
 * true is the cell is empty and has no style or has no background fill.
 */
public static boolean cellIsEmpty(Cell cell) {
	if( cell.getCellType() != Cell.CELL_TYPE_BLANK ) {
		return false;
	}
	CellStyle cellStyle = cell.getCellStyle();
	if( cellStyle == null ) {
		return true;
	}
	if( cellStyle.getFillPattern() == CellStyle.NO_FILL ) {
		return true;
	}
	return false;		
}

Source File: AbstractSheet.java From tools with Apache License 2.0

5 votes

/**
 * @param cell
 * @return
 */
@SuppressWarnings("deprecation")
private int getNumWrappedLines(Cell cell) {
	if (cell.getCellTypeEnum() == CellType.STRING) {
		String val = cell.getStringCellValue();
		if (val == null || val.isEmpty()) {
			return 1;
		}
		CellStyle style = cell.getCellStyle();
		if (style == null || !style.getWrapText()) {
			return 1;
		}
		Font font = sheet.getWorkbook().getFontAt(style.getFontIndex());
		AttributedString astr = new AttributedString(val);
		java.awt.Font awtFont = new java.awt.Font(font.getFontName(), 0, font.getFontHeightInPoints());
		float cellWidth = sheet.getColumnWidth(cell.getColumnIndex())/ 256F * 5.5F;
		astr.addAttribute(TextAttribute.FONT, awtFont);
		FontRenderContext context = new FontRenderContext(null, true, true);
		java.awt.font.LineBreakMeasurer measurer = new java.awt.font.LineBreakMeasurer(astr.getIterator(), context);
		int pos = 0;
		int numLines = 0;
		while (measurer.getPosition() < val.length()) {
			pos = measurer.nextOffset(cellWidth);
			numLines++;
			measurer.setPosition(pos);
		}
		return numLines;
	} else {	// Not a string type
		return 1;
	}
}

Source File: ExcelToHtmlServer.java From easypoi with Apache License 2.0

5 votes

private void printSheetContent(Sheet sheet) {
    //printColumnHeads(sheet);
    MergedRegionHelper mergedRegionHelper = new MergedRegionHelper(sheet);
    CellValueHelper cellValueHelper = new CellValueHelper(wb, cssRandom);
    out.format("<tbody>%n");
    Iterator<Row> rows = sheet.rowIterator();
    int rowIndex = 1;
    while (rows.hasNext()) {
        Row row = rows.next();
        out.format("  <tr style='height:%spx;'>%n", row.getHeight() / 15);
        //out.format("    <td class='%s'>%d</td>%n", ROW_HEAD_CLASS, row.getRowNum() + 1);
        for (int i = firstColumn; i < endColumn; i++) {
            if (mergedRegionHelper.isNeedCreate(rowIndex, i)) {
                String content = "&nbsp;";
                CellStyle style = null;
                if (i >= row.getFirstCellNum() && i < row.getLastCellNum()) {
                    Cell cell = row.getCell(i);
                    if (cell != null) {
                        style = cell.getCellStyle();
                        content = cellValueHelper.getHtmlValue(cell);
                    }
                }
                if (mergedRegionHelper.isMergedRegion(rowIndex, i)) {
                    Integer[] rowAndColSpan = mergedRegionHelper.getRowAndColSpan(rowIndex, i);
                    out.format("    <td rowspan='%s' colspan='%s' class='%s' >%s</td>%n",
                        rowAndColSpan[0], rowAndColSpan[1], styleName(style), content);
                } else {
                    out.format("    <td class='%s'>%s</td>%n", styleName(style), content);
                }
            }

        }
        out.format("  </tr>%n");
        rowIndex++;
    }
    out.format("</tbody>%n");
}

Source File: POIUtils.java From xlsmapper with Apache License 2.0

5 votes

/**
 * 結合を考慮してセルの罫線（左部）を取得する。
 *
 * @param cell セル
 * @return {@literal BorderStyle}
 * @throws IllegalArgumentException {@literal cell is null.}
 */
public static BorderStyle getBorderRight(final Cell cell) {

    ArgUtils.notNull(cell, "cell");

    final Sheet sheet = cell.getSheet();
    CellRangeAddress mergedRegion = getMergedRegion(sheet, cell.getRowIndex(), cell.getColumnIndex());

    final Cell target;
    if(mergedRegion == null) {
        // 結合されていない場合
        target = cell;

    } else {
        if(mergedRegion.getLastColumn() == cell.getColumnIndex()) {
            // 引数のCellが右部のセルの場合
            target = cell;
        } else {
            target = getCell(sheet, mergedRegion.getLastColumn(), cell.getRowIndex());
        }

    }

    final CellStyle style = target.getCellStyle();
    if(style == null) {
        return BorderStyle.NONE;
    } else {
        return style.getBorderRightEnum();
    }

}

Source File: HorizontalRecordsProcessor.java From xlsmapper with Apache License 2.0

5 votes

/**
 * ネストしたレコードの親のセルを結合する
 * @param sheet シート
 * @param mergedSize 結合するセルのサイズ
 * @param valueCellPositions 結合する開始位置のセルのアドレス
 */
private void processSavingNestedMergedRecord(final Sheet sheet, final int mergedSize,
        final List<CellPosition> valueCellPositions) {

    if(mergedSize <= 1) {
        return;
    }

    // ネストした場合、上のセルのスタイルをコピーして、結合する
    for(CellPosition position : valueCellPositions) {
        Cell valueCell = POIUtils.getCell(sheet, position);
        if(valueCell == null) {
            continue;
        }

        final CellStyle style = valueCell.getCellStyle();

        // 結合するセルに対して、上のセルのスタイルをコピーする。
        // 行を挿入するときなどに必要になるため、スタイルを設定する。
        for(int i=1; i < mergedSize; i++) {
            Cell mergedCell = POIUtils.getCell(sheet, position.getColumn(), position.getRow() + i);
            mergedCell.setCellStyle(style);
            mergedCell.setCellType(CellType.BLANK);
        }

        final CellRangeAddress range = new CellRangeAddress(position.getRow(), position.getRow()+ mergedSize-1,
                position.getColumn(), position.getColumn());

        // 既に結合済みのセルがある場合、外す。
        for(int rowIdx=range.getFirstRow(); rowIdx <= range.getLastRow(); rowIdx++) {
            CellRangeAddress r = POIUtils.getMergedRegion(sheet, rowIdx, position.getColumn());
            if(r != null) {
                POIUtils.removeMergedRange(sheet, r);
            }
        }

        sheet.addMergedRegion(range);
    }

}

Source File: HorizontalRecordsProcessor.java From xlsmapper with Apache License 2.0

5 votes

/**
 * セルの書式をコピーする。
 * <p>コピー先のセルの種類は、空セルとする。</p>
 * <p>結合情報も列方向の結合をコピーする。</p>
 *
 * @since 2.0
 * @param fromCell コピー元
 * @param toCell コピー先
 */
private void copyCellStyle(final Cell fromCell, final Cell toCell) {

    final CellStyle style = fromCell.getCellStyle();
    toCell.setCellStyle(style);
    toCell.setCellType(CellType.BLANK);

    // 横方向に結合されている場合、結合情報のコピーする。（XlsArrayColumns用）
    final Sheet sheet = fromCell.getSheet();
    final CellRangeAddress mergedRegion = POIUtils.getMergedRegion(sheet, fromCell.getRowIndex(), fromCell.getColumnIndex());
    final int mergedSize = POIUtils.getColumnSize(mergedRegion);

    if(POIUtils.getColumnSize(mergedRegion) >= 2) {
        CellRangeAddress newMergedRegion = POIUtils.getMergedRegion(sheet, toCell.getRowIndex(), toCell.getColumnIndex());
        if(newMergedRegion != null) {
            // 既に結合している場合 - 通常はありえない。
            return;
        }

        newMergedRegion = POIUtils.mergeCells(sheet,
                mergedRegion.getFirstColumn(), toCell.getRowIndex(), mergedRegion.getLastColumn(), toCell.getRowIndex());

        // 結合先のセルの書式も設定する
        // 中間のセルの設定
        for(int i=1; i < mergedSize; i++) {
            Cell mergedFromCell = POIUtils.getCell(sheet, toCell.getColumnIndex()+i, fromCell.getRowIndex());

            Cell mergedToCell = POIUtils.getCell(sheet, toCell.getColumnIndex()+i, toCell.getRowIndex());
            mergedToCell.setCellStyle(mergedFromCell.getCellStyle());
            mergedToCell.setCellType(CellType.BLANK);
        }

    }

}

Source File: ExcelToHtmlServer.java From autopoi with Apache License 2.0

5 votes

private void printSheetContent(Sheet sheet) {
	// printColumnHeads(sheet);
	MergedRegionHelper mergedRegionHelper = new MergedRegionHelper(sheet);
	CellValueHelper cellValueHelper = new CellValueHelper(wb, cssRandom);
	out.format("<tbody>%n");
	Iterator<Row> rows = sheet.rowIterator();
	int rowIndex = 1;
	while (rows.hasNext()) {
		Row row = rows.next();
		out.format("  <tr style='height:%spx;'>%n", row.getHeight() / 15);
		// out.format("    <td class='%s'>%d</td>%n", ROW_HEAD_CLASS,
		// row.getRowNum() + 1);
		for (int i = firstColumn; i < endColumn; i++) {
			if (mergedRegionHelper.isNeedCreate(rowIndex, i)) {
				String content = "&nbsp;";
				CellStyle style = null;
				if (i >= row.getFirstCellNum() && i < row.getLastCellNum()) {
					Cell cell = row.getCell(i);
					if (cell != null) {
						style = cell.getCellStyle();
						content = cellValueHelper.getHtmlValue(cell);
					}
				}
				if (mergedRegionHelper.isMergedRegion(rowIndex, i)) {
					Integer[] rowAndColSpan = mergedRegionHelper.getRowAndColSpan(rowIndex, i);
					out.format("    <td rowspan='%s' colspan='%s' class='%s' >%s</td>%n", rowAndColSpan[0], rowAndColSpan[1], styleName(style), content);
				} else {
					out.format("    <td class='%s'>%s</td>%n", styleName(style), content);
				}
			}

		}
		out.format("  </tr>%n");
		rowIndex++;
	}
	out.format("</tbody>%n");
}

Source File: CellValueFormatter.java From CloverETL-Engine with GNU Lesser General Public License v2.1

4 votes

private String getFormattedNumberString(Cell cell) {
	CellStyle cellStyle = cell.getCellStyle();
	return formatRawCellContents(cell.getNumericCellValue(), cellStyle.getDataFormat(), cellStyle.getDataFormatString(), false);
}

Source File: ExcelWriter_StyleFormatTest.java From hop with Apache License 2.0

4 votes

/**
 * Test applying Format and Style from cell (from a template) when writing fields
 *
 * @param fileType
 * @throws Exception
 */
private void testStyleFormat( String fileType ) throws Exception {
  setupTransformMock( fileType );
  createTransformMeta( fileType );
  createTransformData( fileType );
  transform.init();

  // We do not run pipeline or executing the whole transform
  // instead we just execute ExcelWriterData.writeNextLine() to write to Excel workbook object
  // Values are written in A2:D2 and A3:D3 rows
  List<Object[]> rows = createRowData();
  for ( int i = 0; i < rows.size(); i++ ) {
    transform.writeNextLine( rows.get( i ) );
  }

  // Custom styles are loaded from G1 cell
  Row xlsRow = transformData.sheet.getRow( 0 );
  Cell baseCell = xlsRow.getCell( 6 );
  CellStyle baseCellStyle = baseCell.getCellStyle();
  DataFormat format = transformData.wb.createDataFormat();

  // Check style of the exported values in A3:D3
  xlsRow = transformData.sheet.getRow( 2 );
  for ( int i = 0; i < transformData.inputRowMeta.size(); i++ ) {
    Cell cell = xlsRow.getCell( i );
    CellStyle cellStyle = cell.getCellStyle();

    if ( i > 0 ) {
      assertEquals( cellStyle.getBorderRight(), baseCellStyle.getBorderRight() );
      assertEquals( cellStyle.getFillPattern(), baseCellStyle.getFillPattern() );
    } else {
      // cell A2/A3 has no custom style
      assertFalse( cellStyle.getBorderRight() == baseCellStyle.getBorderRight() );
      assertFalse( cellStyle.getFillPattern() == baseCellStyle.getFillPattern() );
    }

    if ( i != 1 ) {
      assertEquals( format.getFormat( cellStyle.getDataFormat() ), "0.00000" );
    } else {
      // cell B2/B3 use different format from the custom style
      assertEquals( format.getFormat( cellStyle.getDataFormat() ), "##0,000.0" );
    }
  }
}

Source File: ExcelWriterTransform_StyleFormatTest.java From hop with Apache License 2.0

4 votes

/**
 * Test applying Format and Style from cell (from a template) when writing fields
 *
 * @param fileType
 * @throws Exception
 */
private void testStyleFormat( String fileType ) throws Exception {
  setupInputOutput( fileType );
  createTransformMeta( fileType );
  createTransformData( fileType );
  setupTransformMock( fileType );
  transform.init();

  // We do not run pipeline or executing the whole transform
  // instead we just execute ExcelWriterTransformData.writeNextLine() to write to Excel workbook object
  // Values are written in A2:D2 and A3:D3 rows
  List<Object[]> rows = createRowData();
  for ( int i = 0; i < rows.size(); i++ ) {
    transform.writeNextLine( rows.get( i ) );
  }

  // Custom styles are loaded from G1 cell
  Row xlsRow = data.sheet.getRow( 0 );
  Cell baseCell = xlsRow.getCell( 6 );
  CellStyle baseCellStyle = baseCell.getCellStyle();
  DataFormat format = data.wb.createDataFormat();

  // Check style of the exported values in A3:D3
  xlsRow = data.sheet.getRow( 2 );
  for ( int i = 0; i < data.inputRowMeta.size(); i++ ) {
    Cell cell = xlsRow.getCell( i );
    CellStyle cellStyle = cell.getCellStyle();

    if ( i > 0 ) {
      assertEquals( cellStyle.getBorderRight(), baseCellStyle.getBorderRight() );
      assertEquals( cellStyle.getFillPattern(), baseCellStyle.getFillPattern() );
    } else {
      // cell A2/A3 has no custom style
      assertFalse( cellStyle.getBorderRight() == baseCellStyle.getBorderRight() );
      assertFalse( cellStyle.getFillPattern() == baseCellStyle.getFillPattern() );
    }

    if ( i != 1 ) {
      assertEquals( format.getFormat( cellStyle.getDataFormat() ), "0.00000" );
    } else {
      // cell B2/B3 use different format from the custom style
      assertEquals( format.getFormat( cellStyle.getDataFormat() ), "##0,000.0" );
    }
  }
}

Java Code Examples for org.apache.poi.ss.usermodel.Cell#getCellStyle()