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
4149 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
0
bhanuprakashm
over 7 years ago
@punyag, AFAIK there is no possibility to create new excel sheet after month changes..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
krishnaprasadd1
over 7 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
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
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
0
Poorna Guduri
A Score Level 1
over 7 years ago
Yep, @sethulakshmi - thanks for adding this point.
@punyag, Make a note of the above point as well.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
bhanuprakashm
over 7 years ago
Thanks for your inputs @sethu & @ poornah
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel