Bug 63168

Summary:	Can't get the sheet's tab color of XLS file
Product:	POI	Reporter:	Rawutagouda <rawut321>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED LATER
Severity:	normal
Priority:	P2
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	All

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.

Comment 2 Dominik Stadler 2022-12-26 21:42:35 UTC

Sorry, but there is too little information provided to reproduce this without huge effort for reproducing it, so we are closing this for now, please reopen with an easier way to reproduce it if this is still a problem for you.