Bug 63168 - Can't get the sheet's tab color of XLS file
Summary: Can't get the sheet's tab color of XLS file
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2019-02-12 08:34 UTC by Rawutagouda
Modified: 2021-04-27 06:22 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Rawutagouda 2019-02-12 08:34:15 UTC
HI Team,

I have a scenario where I am supposed to read the sheet depending upon it's tab color.

example: I have to read the cell content of the sheet whose tab color is red.

I am able to fetch the tab color for XLSX(Using XSSFSheet) file but not able find anyway to fetch the same for XLS file(I have tried using HSSFSheet, it doesn't work out).

Can someone guide me on fetching the XLS sheet's tab color.

It's so critical, hoping for the quick response.

Thanks and regards
Rawutagouda Biradar
Comment 1 Dominik Stadler 2021-04-27 06:22:42 UTC
If this is still relevant then please provide a sample file and code-snippet to reproduce this.