File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
wants to display Cell color in a table based on source value
make uneditable cell a different color
css background color question
Is there a way to show an image in a JTable as a thumbnail?
cell renderer trouble