Can’t Set Fill Color Apache POI Excel Workbook

by

Use foreground color instead of Background color. 

 errorOccured = true;
 XSSFCellStyle style = workbook.createCellStyle();
 style.setFillForegroundColor(IndexedColors.RED.getIndex());
 style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
 row.getCell(0).setCellStyle(style);

this will fill the cell background color with RED.

More Related Contents:

  1. How to print color in console using System.out.println?
  2. Convert RGB values to color name
  3. Code for changing the color of subtasks in Gantt Chart
  4. Apache POI error loading XSSFWorkbook class
  5. Docx to Pdf Converter in java
  6. Apache POI – FileInputStream works, File object fails (NullPointerException)
  7. how to convert rgb color to int in java
  8. Apache poi Excel line chart points
  9. How to set axis’ labels in a Line Chart using Apache Poi
  10. Removing a row from an Excel sheet with Apache POI HSSF
  11. Apache POI autoSizeColumn Resizes Incorrectly
  12. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  13. android color between two colors, based on percentage?
  14. How to get an Excel Blank Cell Value in Apache POI?
  15. Infinite background for game
  16. java swing background image
  17. How to slowly change object color from one to another?
  18. Apache POI Streaming (SXSSF) for Reading
  19. Get color of each pixel of an image using BufferedImages
  20. Exception when writing to the xlsx document several times using apache poi 3.7
  21. Android: Changing Background-Color of the Activity (Main View)
  22. Apache-POI sorting rows in excel
  23. Java POI : How to read Excel cell value and not the formula computing it?
  24. How to set background image in Java?
  25. Android BroadcastReceiver onReceive Update TextView in MainActivity
  26. apache POI java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipFile
  27. How can I change charts generated by apache poi to not use smoothed lines and show empty cells as gaps?
  28. Determine MS Excel file type with Apache POI
  29. Limitation while generating excel drop down list with Apache POI
  30. How to change the background color for JPanels with Nimbus Look and Feel?

Leave a Comment