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
Replies
6 replies
Subscribers
5 subscribers
Views
1886 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
I am using "export to excel" smart service to load the process variabl
ramakg
A Score Level 1
over 8 years ago
I am using "export to excel" smart service to load the process variable data into the excel spread sheet. Uploading the data into the spread sheet sheets like sheet1,sheet2,sheet3,sheet4 by calling this smart service 4 times. I am not getting any errors but I am able to see only the last sheet data.
Any help ??
OriginalPostID-206400
OriginalPostID-206400
Discussion posts and replies are publicly visible
0
ramakg
A Score Level 1
over 8 years ago
or is it possible to merge into a single file after generate separate excel spreadsheets?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 8 years ago
You might need to do the following:
1. Populate the first sheet in the smart service
2. Add a second smart service to populate the rest of the sheets one at a time (using MNI for example with the option, launch instances one at a time) but making sure that "Document_to_Overwrite" points to the output of the first node from step #1.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ramakg
A Score Level 1
over 8 years ago
i am using the sub-process to populate sheets starting from initial sheet, and passing the same output document to the rest of the sub-process, still I am facing the same issue.
Any workaround?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 8 years ago
Are you seeing a new version of the document gets created every time? You should be able to see version numbers under /suite/designer -> Documents
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 8 years ago
I'm asking this because the code looks good to me. I am not the author but it seems that if you configure it correctly it'll create a new version of the document every time.
Are you sure you're running the sub-process one at a time?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ramakg
A Score Level 1
over 8 years ago
yes.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel