How to create hidden sheet? I mean create sheet, write data to it and make it hidden. Pentaho's Excel Writer rewrites data to Excel sheet but MS Excel Writer removes hidden status upon rewriting it.
My situation is that I have Excel workbook with
hidden sheet "DATA" and another sheet "PIVOT" that uses that data from sheet DATA and represents them in pivot form to my report (excel file) customers. I want to rewrite DATA sheet with new data but to keep DATA sheet it hidden. Upon each rewrite PDI leaves DATA sheet visible.
------------------------------
Stjepan Brbot
Marketing Analyst
HT
------------------------------