Multiple Sheets in Excel

punyag1 over 7 years ago

I want to create multiple sheets in excel based on days in a month and it should generate a new excel file when month changes.
Please let me know if you know the solution.
Thanks in Advance !

Discussion posts and replies are publicly visible

Parents

0 sethulakshmis over 7 years ago

@punyag, also please make sure that you leave Document_to_overwrite parameter empty in this case and only Base_template is mapped with the previous generated document. This is why because, having the pv in Document_to_ovewrite actually wipes off the data from the worksheet that is already generated and populates the data in the new sheet configured during next iteration.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sethulakshmis over 7 years ago

@punyag, also please make sure that you leave Document_to_overwrite parameter empty in this case and only Base_template is mapped with the previous generated document. This is why because, having the pv in Document_to_ovewrite actually wipes off the data from the worksheet that is already generated and populates the data in the new sheet configured during next iteration.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data