-3

I searched a lot but could not get solution to it.Is there any way to get the tabs colour in excel using java.enter image description here

In the image u will find three tabs sheet1,sheet2,sheet3 in excel i want to get the color of three tabs using java.

Sai
  • 1
  • 2
  • What libraries are you using? – Joe C Jul 15 '18 at 18:21
  • Please explain in more details what you are doing / trying to do. Right now your question is too broad to give help. – Jorge Campos Jul 15 '18 at 18:41
  • I am using xssf and required libraries and Apache poi.I am trying to get the tabs colour in excel workbook based on the tab color I have to extract the data and copy in other sheet but am not able to get the tabs colour in excel. – Sai Jul 16 '18 at 03:21
  • Possible duplicate of [how to change the tab color of a worksheet with Apache Poi](https://stackoverflow.com/questions/2093777/how-to-change-the-tab-color-of-a-worksheet-with-apache-poi) – Atul Sharma Jul 17 '18 at 05:33
  • No it is not duplicate here i want to get the tab colour in the above mentioned link they are setting colour. I want to get the tab color here @ Atul Sharma – Sai Jul 21 '18 at 13:29

1 Answers1

0

If you are using the apache POI library.

You can use

HSSFColor.getIndexHash().get(myCell.getCellStyle().getFillBackgroundColor())

to get the color infomations of the cell.

Deatils of the apache POI getFillBackgroundColor methd

For more informations see stackoverflow topic maybe it is helpfull.

sven0379
  • 11
  • 4
  • I am not asking about cell.i am trying to get the tabs colour which are present in workbook – Sai Jul 16 '18 at 03:25