Hi all. I was hoping someone knowledgeable about the poi HSSF API could help me with a problem I have.
I am creating an excel file, but I need to change the "background" for all my cells to be grey, so that everything except my data is greyed out. Easily in excel I'd do this by clicking 'Format > Style > Modify > Pattern' and then choosing whatever color (in this case grey, color index 15).
Is there a way to do this with HSSF? I've looked through the API but can't find any way of referencing all cells, or a HSSFSheet method to do this. The only way I can figure out to do this is to brute-force create each cell and set it to a predefined grey CellStyle which is ick.
Thanks in advance.
I am creating an excel file, but I need to change the "background" for all my cells to be grey, so that everything except my data is greyed out. Easily in excel I'd do this by clicking 'Format > Style > Modify > Pattern' and then choosing whatever color (in this case grey, color index 15).
Is there a way to do this with HSSF? I've looked through the API but can't find any way of referencing all cells, or a HSSFSheet method to do this. The only way I can figure out to do this is to brute-force create each cell and set it to a predefined grey CellStyle which is ick.
Thanks in advance.