Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
+1
person also asked this
people also asked this
Replies
6 replies
Subscribers
9 subscribers
Views
4151 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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 !
OriginalPostID-263134
Discussion posts and replies are publicly visible
Parents
0
Poorna Guduri
A Score Level 1
over 7 years ago
@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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Poorna Guduri
A Score Level 1
over 7 years ago
@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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data