View Only

MS Excel Writer - write to hidden sheet

This thread has been viewed 3 times
  • 1.  MS Excel Writer - write to hidden sheet

    Posted 09-22-2022 15:56
    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