Multiple Sheets in Excel

@punyag, AFAIK there is no possibility to create new excel sheet after month changes..

@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

@punyag, added to above comments - please make sure to pass the excel template during the first iteration & save the generated document in a pv or save it according to your feasibility in the Appian Environment and from then onwards pass the pv or saved generated document to the input parameter "baseExcelTemplate" (of the smart service) and hence you will see the document gets appended new sheets every day. The process model should be a utility if you want to save the document in a pv and configure the Data Management settings accordingly. If you are not interested in utility model, then you may need to find the earlier generated document either by name or by saving the document id in database during first iteration.

@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.

Yep, @sethulakshmi - thanks for adding this point.
@punyag, Make a note of the above point as well.

Thanks for your inputs @sethu & @ poornah