Unable to set fill background color for certain cell using RGB value in apache POI

apache-poi background-color rgb xssf
Charlie Zeng picture Charlie Zeng · Dec 26, 2012 · Viewed 23.4k times · Source

I'm using XSSF in Apache POI to generate Xlsx file. I imported org.apache.poi.xssf.usermodel.XSSFColor. My purpose is to set fill background color to RGB(141,180,226) for certain cell. I tried using 

XSSFColor bg=getXSSFColor("8DB4E2");

to get the codes for the color first. Then use,

setFillBackgroundColor(bg)

to set the color. However, method getXSSFColor cannot be found. I don't know why and if there is other to achieve the same purpose.

Answer

Related questions

How can I read numeric strings in Excel cells as string (not numbers)?

I have excel file with such contents: A1: SomeString A2: 2 All fields are set to String format. When I read the file in java using POI, it tells that A2 is in numeric cell format. The problem is that the …

Read More
Apache POI Excel - how to configure columns to be expanded?

I am using Apache POI API to generate excel spreadsheet to output some data. The problem I am facing is when the spreadsheet is created and opened, columns are not expanded so that some long text like Date formatted text …

Read More
How do I set cell value to Date and apply default Excel date format?

I've been using Apache POI for some time to read existing Excel 2003 files programmatically. Now I have a new requirement to create entire .xls files in-memory (still using Apache POI) and then write them to a file at the end. …

Read More