How to hide a sheet

FLX TMS FlexCel for VCL & FMX
1

Just a quick question
How to hide/show a sheet?
Thanks for your help

2

Just do something like:


xls.ActiveSheetByName := 'sheetIWantToHide';
xls.SheetVisible := TXlsSheetVisible.Hidden;
xls.ActiveSheetByName := 'SomeOtherSheet';



The options are hidden, visible and "very hidden". A "very hidden sheet is a sheet that can't be made visible from ExcelUI, you need a macro or a different tool to make it visible.