While creating an Excel output file with multiple worksheets, only latest one is visible. What exactly could be done to retain previous worksheets along with latest worksheet ?
Hi,
To achieve the same, create another excel writer step, select use existing file and change the sheet name. Also add blocking step before writing into second excel writer mention the name of first writer.
Thanks for info. I will try.