Can ExcelGen hide a sheet?

mbleron / ExcelGen

ExcelGen is an Oracle PL/SQL utility to create MS Excel files (.xlsx, .xlsb)

MIT License

43 stars 9 forks source link

Can ExcelGen hide a sheet? #54

Closed FrFeCN closed 2 months ago

FrFeCN commented 5 months ago

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?

mbleron commented 5 months ago

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).

FrFeCN commented 5 months ago

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

mbleron commented 2 months ago

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