Dustbiin

Create custom color for cell background by using java color class Create custom color- XSSFWorkbook workBook = new XSSFWorkbook (); IndexedColorMap colorMap = workbook.getStylesSource().getIndexedColors(); Font tableHeadOneFontStyle = workbook.createFont();  tableHeadOneFontStyle.setBold( true ); tableHeadOneFontStyle.setColor( IndexedColors.BLACK.getIndex() ); XSSFCellStyle tableHeaderOneColOneStyle = workbook.createCellStyle(); tableHeaderOneColOneStyle.setFont( tableHeadOneFontStyle ); tableHeaderOneColOneStyle.setFillForegroundColor( new XSSFColor( new java.awt.Color( 255, 231, 153 ), colorMap ) ); tableHeaderOneColOneStyle.setFillPattern( FillPatternType.SOLID_FOREGROUND ); tableHeaderOneColOneStyle = setLeftRightBorderColor( tableHeaderOneColOneStyle ); tableHeaderOneColOneStyle = alignCenter( tableHeaderOneColOneStyle );

Adding multiple sheets in excel file- Create new workbook first- XSSFWorkbook workBook = new XSSFWorkbook (); Add sheets in the workbook Sheet sheet1 = workbook.createSheet("Sheet name 1"); Sheet sheet2 = workbook.createSheet("Sheet name 2"); Sheet sheet3 = workbook.createSheet("Sheet name 3"); Sheet sheet4 = workbook.createSheet("Sheet name 4"); Sheet sheet5 = workbook.createSheet("Sheet name 5");     try (FileOutputStream outputStream = new FileOutputStream( "demo.xlsx" )) {     workbook.write( outputStream ); } finally {     workbook.close(); } Output -  Output with five sheet int excel file