aspose 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
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