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
9 replies
Subscribers
4 subscribers
Views
3962 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Downlaod to excel
benh3891
over 7 years ago
Any suggestions for Exporting a multiple variable to an Excel Template.
I have been using the following:
forum.appian.com/.../Text_Doc_From_Template_Smart_Service.html
But my goal is for the multi-row query result to be printed to individual grid cells. It seems that joinarray, which the document suggests, prints the result to multiple lines but within the same grid cell.
Thank you
OriginalPostID-264357
Discussion posts and replies are publicly visible
Parents
0
Mike Schmitt
Certified Lead Developer
over 7 years ago
Ah, that's good news - if you want to generate a second sheet, i'm thinking what you'll need to do is save the document into a PV (in the "Output_document" output variable), then pass that saved document in for both "Excel_base_template" and "Document_to_overwrite" (and this time leave "Document_name_to_create" blank) - if i have that right, that should cause your generated sheet 2 to show stack with your generated sheet 1 -- but i'm less familiar with doing this, so you might need to just play around with it.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Mike Schmitt
Certified Lead Developer
over 7 years ago
Ah, that's good news - if you want to generate a second sheet, i'm thinking what you'll need to do is save the document into a PV (in the "Output_document" output variable), then pass that saved document in for both "Excel_base_template" and "Document_to_overwrite" (and this time leave "Document_name_to_create" blank) - if i have that right, that should cause your generated sheet 2 to show stack with your generated sheet 1 -- but i'm less familiar with doing this, so you might need to just play around with it.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data