int numberCellStyles = workbook.getNumCellStyles();
public static <T extends CellStyle> T createCellStyle(Workbook workbook) { if (workbook instanceof HSSFWorkbook) { if (workbook.getNumCellStyles() == MAX_STYLES) { HSSFOptimiser.optimiseCellStyles((HSSFWorkbook) workbook); } @SuppressWarnings("unchecked") T style = (T) workbook.createCellStyle(); return style; } else { @SuppressWarnings("unchecked") T style = (T) workbook.createCellStyle(); return style; } }
final int predefinedStyles = workbook.getNumCellStyles(); for ( int i = 0; i < predefinedStyles; i++ ) { final XSSFCellStyle cellStyleAt = xssfWorkbook.getCellStyleAt( i ); final int predefinedStyles = workbook.getNumCellStyles(); for ( int i = 0; i < predefinedStyles; i++ ) { final CellStyle cellStyleAt = workbook.getCellStyleAt( i );
private void initWorkbookColors() { if (!(getWorkbook() instanceof HSSFWorkbook)) { return; } Workbook workbook = getWorkbook(); int numStyles = workbook.getNumCellStyles(); for (int i = 0; i < numStyles; i++) { CellStyle cellStyle = workbook.getCellStyleAt(i); wbColors.add(cellStyle.getFillForegroundColor()); wbColors.add(cellStyle.getFillBackgroundColor()); wbColors.add(cellStyle.getTopBorderColor()); wbColors.add(cellStyle.getBottomBorderColor()); wbColors.add(cellStyle.getLeftBorderColor()); wbColors.add(cellStyle.getRightBorderColor()); } int numFonts = workbook.getNumberOfFontsAsInt(); for (int i = 0; i < numFonts; i++) { Font font = workbook.getFontAt(i); wbColors.add(font.getColor()); } }
private CellStyle findWorkbookCellStyle(CellStyle cellStyle) { Workbook workbook = gridModel.getSheetSource().getWorkbookSource().getWorkbook(); int numCellStyles = workbook.getNumCellStyles(); for (int i = 0; i < numCellStyles; i++) { CellStyle cellStyleAt = workbook.getCellStyleAt((short) i); if (equalsStyle(cellStyleAt, cellStyle)) { return cellStyleAt; } } return null; }
short numberCellStyles = workbook.getNumCellStyles();
short numberCellStyles = workbook.getNumCellStyles();
short numberCellStyles = workbook.getNumCellStyles();
short numberCellStyles = workbook.getNumCellStyles();
Logger.getLogger(AccountExport.class.getName()).log(Level.INFO, "{0} cell styles were used", wb.getNumCellStyles());
Logger.getLogger(BudgetResultsExport.class.getName()).log(Level.INFO, "{0} cell styles were used", wb.getNumCellStyles());
int numberCellStyles = workbook.getNumCellStyles();