This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes  cell.getCellStyle().getFillBackgroundColor() doesn't return proper value for xlsx sheets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark " cell.getCellStyle().getFillBackgroundColor() doesn Watch " cell.getCellStyle().getFillBackgroundColor() doesn New topic
Author

cell.getCellStyle().getFillBackgroundColor() doesn't return proper value for xlsx sheets

Sujoy Choudhury
Ranch Hand

Joined: Sep 17, 2008
Posts: 136

Hi There,
I am facing this weird problem where the "cell.getCellStyle().getFillBackgroundColor()" doesn't return proper background color.
I am using the latest 3.8 version of POI.

I have a xlsx file and on a cell I have Yellow background and it returns 64.
For someother cell when the background color is Blue it returns the same 64.

No matter what background color you have it is always returning 64.

Thanks and Regards,
~Sujoy
aman hindustani
Ranch Hand

Joined: Jun 15, 2006
Posts: 57
My self is also facing the same issue. Any updates/solution for this issue.
aman hindustani
Ranch Hand

Joined: Jun 15, 2006
Posts: 57
Got the solution for this we need use cell.getCellStyle().getFillForegroundColor() in the place of cell.getCellStyle().getFillBackgroundColor()
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: cell.getCellStyle().getFillBackgroundColor() doesn't return proper value for xlsx sheets