private static HSSFCellStyle aligned(HSSFCellStyle style, short align) { style.setAlignment(align); return style; }
private static HSSFCellStyle aligned(HSSFCellStyle style, short align) { style.setAlignment(align); return style; }
private void createDefaultDataCellStyle() { dataCellStyle = workbook.createCellStyle(); dataCellStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT); } }
private static HSSFCellStyle createCustomStyle(HSSFFont fontStyle, Short... alignment) { HSSFCellStyle style = wb1.createCellStyle(); style.setFont(fontStyle); if (alignment.length > 0) { style.setAlignment(alignment[0]); } return style; }
private HSSFCellStyle createStyle(final HSSFWorkbook workbook, boolean isFirst, short align) { HSSFCellStyle style = workbook.createCellStyle(); if (isFirst) { style.setBorderTop(HSSFCellStyle.BORDER_THIN); } if (align == RIGHT) { style.setAlignment(RIGHT); style.setDataFormat(dataFormat.getFormat("[HH]:MM:SS")); } return style; }
style.setAlignment(HorizontalAlignment.LEFT); }else if(align.equals(Alignment.center)){ style.setAlignment(HorizontalAlignment.CENTER); }else if(align.equals(Alignment.right)){ style.setAlignment(HorizontalAlignment.RIGHT);
private HSSFCellStyle createStyle(final HSSFWorkbook workbook, boolean isFirst, short align, short color) { HSSFCellStyle style = workbook.createCellStyle(); if (isFirst) { style.setBorderTop(HSSFCellStyle.BORDER_THIN); } if (color != WHITE) { style.setFillForegroundColor(color); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); } if (align == RIGHT) { style.setAlignment(RIGHT); } return style; }
private void whiteDataStyle(HSSFSheet sheet) { HSSFCellStyle style = sheet.getWorkbook().createCellStyle(); style.setBorderTop(HSSFCellStyle.BORDER_THIN); style.setBorderLeft(HSSFCellStyle.BORDER_THIN); style.setBorderRight(HSSFCellStyle.BORDER_THIN); style.setBorderBottom(HSSFCellStyle.BORDER_THIN); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFont(fontNormal); styles.put(I_WhiteDataStyle, style); }
/** * Instantiates a new Poi cell style. * * @param workBook the work book */ public PoiCellStyle(PoiWorkBook workBook) { this.stringCs = this.getDefaultExcelCellStyle(workBook); this.numberCs = this.getDefaultExcelCellStyle(workBook); this.numberCs.setDataFormat(HSSFDataFormat.getBuiltinFormat("#,##0")); this.numberCs.setAlignment(HorizontalAlignment.RIGHT); this.dateCs = this.getDefaultExcelCellStyle(workBook); this.dateCs.setDataFormat(DATE_FORMAT_VALUE); }
private void headerStyle2Red(HSSFSheet sheet) { HSSFCellStyle style = sheet.getWorkbook().createCellStyle(); style.setBorderTop(HSSFCellStyle.BORDER_MEDIUM); style.setBorderLeft(HSSFCellStyle.BORDER_MEDIUM); style.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); style.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFont(fontSmallRed); styles.put(I_HeaderStyle2Red, style); }
private void headerStyle2(HSSFSheet sheet) { HSSFCellStyle style = sheet.getWorkbook().createCellStyle(); style.setBorderTop(HSSFCellStyle.BORDER_MEDIUM); style.setBorderLeft(HSSFCellStyle.BORDER_MEDIUM); style.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); style.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFont(fontSmall); styles.put(I_HeaderStyle2, style); }
private void initWhiteDataStyleSmall(HSSFSheet sheet) { HSSFCellStyle style = sheet.getWorkbook().createCellStyle(); style.setBorderTop(HSSFCellStyle.BORDER_THIN); style.setBorderLeft(HSSFCellStyle.BORDER_THIN); style.setBorderRight(HSSFCellStyle.BORDER_THIN); style.setBorderBottom(HSSFCellStyle.BORDER_THIN); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFont(fontSmall); styles.put(I_WhiteDataStyleSmall, style); }
private void whiteDataStyleRed(HSSFSheet sheet) { HSSFCellStyle style = sheet.getWorkbook().createCellStyle(); style.setBorderTop(HSSFCellStyle.BORDER_THIN); style.setBorderLeft(HSSFCellStyle.BORDER_THIN); style.setBorderRight(HSSFCellStyle.BORDER_THIN); style.setBorderBottom(HSSFCellStyle.BORDER_THIN); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFont(fontRed); styles.put(I_WhiteDataStyleRed, style); }
private static HSSFCellStyle createTilteStyle(HSSFWorkbook wb) { HSSFFont bold = wb.createFont(); bold.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); HSSFCellStyle style = wb.createCellStyle(); style.setFont(bold); style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setWrapText(true); return style; }
private HSSFCellStyle getDefaultExcelCellStyle(PoiWorkBook daouWorkBook) { HSSFWorkbook wb = daouWorkBook.getWorkBook(); HSSFCellStyle cs = wb.createCellStyle(); cs.setAlignment(HorizontalAlignment.CENTER); cs.setVerticalAlignment(VerticalAlignment.CENTER); cs.setBorderTop(BorderStyle.THIN); cs.setBorderRight(BorderStyle.THIN); cs.setBorderLeft(BorderStyle.THIN); cs.setBorderBottom(BorderStyle.THIN); return cs; }
private void whiteDataStyleEnd(HSSFSheet sheet) { HSSFCellStyle style = sheet.getWorkbook().createCellStyle(); style.setBorderTop(HSSFCellStyle.BORDER_THIN); style.setBorderLeft(HSSFCellStyle.BORDER_THIN); style.setBorderRight(HSSFCellStyle.BORDER_THIN); style.setBorderBottom(HSSFCellStyle.BORDER_THIN); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFont(fontNormal); style.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); styles.put(I_WhiteDataStyleEnd, style); }
private void greyDataStyleRed(HSSFSheet sheet) { HSSFCellStyle style = sheet.getWorkbook().createCellStyle(); style.setBorderTop(HSSFCellStyle.BORDER_THIN); style.setBorderLeft(HSSFCellStyle.BORDER_THIN); style.setBorderRight(HSSFCellStyle.BORDER_THIN); style.setBorderBottom(HSSFCellStyle.BORDER_THIN); style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFont(fontRed); styles.put(I_GreyDataStyleRed, style); }
public HSSFCellStyle style() { Font font = worksheet.getWorkbook().createFont(); font.setBoldweight(Font.BOLDWEIGHT_BOLD); font.setFontHeight((short) TITLE_FONT_HEIGHT); HSSFCellStyle cellStyle = worksheet.getWorkbook().createCellStyle(); cellStyle.setAlignment(alignment); cellStyle.setWrapText(true); cellStyle.setFont(font); return cellStyle; } }
private void greyDataStyle(HSSFSheet sheet) { HSSFCellStyle style = sheet.getWorkbook().createCellStyle(); style.setBorderTop(HSSFCellStyle.BORDER_THIN); style.setBorderLeft(HSSFCellStyle.BORDER_THIN); style.setBorderRight(HSSFCellStyle.BORDER_THIN); style.setBorderBottom(HSSFCellStyle.BORDER_THIN); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); style.setFont(fontNormal); styles.put(I_GreyDataStyle, style); }
private void changeoverDataStyle(HSSFSheet sheet) { HSSFCellStyle style = sheet.getWorkbook().createCellStyle(); style.setBorderTop(HSSFCellStyle.BORDER_THIN); style.setBorderLeft(HSSFCellStyle.BORDER_THIN); style.setBorderRight(HSSFCellStyle.BORDER_THIN); style.setBorderBottom(HSSFCellStyle.BORDER_THIN); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFont(fontNormal); style.setFillForegroundColor(HSSFColor.PALE_BLUE.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); styles.put(I_ChangeoverDataStyle, style); }