Write tab with the same name as in 2.
Result Excel has 2 tabs from steps 1 and 2, and one hidden tab did not been visible after step 2 but visible after step 4.
thanks for the report! Unfortunately, we cannot reproduce (Mac and/or Windows) and maybe we need some clarification: Where do you observe the hidden tab? When you open the Excel file with Excel or with KNIME?
Thank you, @LukasS.
The hidden tabs are observed in Excel (actually file has 3 hidden tabs). Knime does not show them.
Knime open the file with upended sheet.
Hidden tab appears only after second upend / overwrite.
Ah, when there is a hidden tab (“hidden tab”) in the Excel file like so
and I append a new sheet (“KNIME tab”) with KNIME (excel file saved with the “KNIME tab” active), the hidden tab will be unhidden after appending/overwriting with KNIME:
Is that what you mean?
Note that this was particularly difficult to reproduce because it only happens when the tab that is overwritten by KNIME is saved selected in Excel - so it already might be a workaround for you to save the Excel file such that the tab-to-be-overwritten is not selected when saving.
I looks like KNIME is unhiding the tab for some reason - which is a Bug I just filed with the internal reference AP-18199.