Multiple Sheets in Excel

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