This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android 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()
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: cell.getCellStyle().getFillBackgroundColor() doesn't return proper value for xlsx sheets
 
Similar Threads
cell renderer trouble
css background color question
wants to display Cell color in a table based on source value
Is there a way to show an image in a JTable as a thumbnail?
make uneditable cell a different color