Can ExcelGen hide a sheet?

Open FrFeCN opened this issue 2 years ago • 2 comments

Sometimes it is necessary to add a sheet to excel to store basic data, but it is not necessary to display it. Can this feature be supported?

Mar 27 '24 06:03 FrFeCN

Yes I can add that quite easily. Should have done it a long time ago to be honest, but I felt there was no need for it until I introduce a way to actually access that hidden data, e.g. via defined names or formulas (upcoming features).

Mar 27 '24 09:03 mbleron

Looking forward to your update and thank you for the powerful features of ExcelGen.

Apr 02 '24 04:04 FrFeCN

Done in v4.0. See for example addSheet function.

Jun 27 '24 10:06 mbleron