Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Sujoy Choudhury
Ranch Hand
Posts: 136
Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
aman hindustani
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My self is also facing the same issue. Any updates/solution for this issue.
 
aman hindustani
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Got the solution for this we need use cell.getCellStyle().getFillForegroundColor() in the place of cell.getCellStyle().getFillBackgroundColor()
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic