Multiple Sheets in Excel

punyag1 over 8 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 krishnaprasadd1 over 8 years ago

@punyag, if you are using any Smart Service like Export Cdt to Excel there is field called Document_name_to_create and sheet_number. In that place pass a pv parameter so that parameter value changes accordingly. For Example to create a new document after month changes I took a pv parameter with value month(today()).

please let me know if this help u
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 krishnaprasadd1 over 8 years ago

@punyag, if you are using any Smart Service like Export Cdt to Excel there is field called Document_name_to_create and sheet_number. In that place pass a pv parameter so that parameter value changes accordingly. For Example to create a new document after month changes I took a pv parameter with value month(today()).

please let me know if this help u
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data