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
5 subscribers
Views
3879 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
In the "Export CDT to Excel" smart service, you simply need to feed in your template file ("Excel_base_template"), your CDT Array PV ("Cdt"), a text list consisting of the case-sensitive CDT field names ("Cdt_fields_to_export"), the starting cell (in your case you'd pass in "B7"), sheet number (zero-indexed iirc, so pass in 0). Ignore "Cell_keys" and "Cell_values" at first as these are just used to fill specific fields (after you get it working for your CDT you'd fill these in to fill static fields such as project name as needed).
AFAIK the text from template will literally populate the cell(s) where you have the replacement key(s) no matter what, so no matter what you do, all the values you pass into B7, C7, etc, will populate in just those cells. I'd need to see a screenshot of your template to be sure - but tbh it's probably not worth your time as it'd be easier just to get the Export CDT one to work instead.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Mike Schmitt
Certified Lead Developer
over 7 years ago
In the "Export CDT to Excel" smart service, you simply need to feed in your template file ("Excel_base_template"), your CDT Array PV ("Cdt"), a text list consisting of the case-sensitive CDT field names ("Cdt_fields_to_export"), the starting cell (in your case you'd pass in "B7"), sheet number (zero-indexed iirc, so pass in 0). Ignore "Cell_keys" and "Cell_values" at first as these are just used to fill specific fields (after you get it working for your CDT you'd fill these in to fill static fields such as project name as needed).
AFAIK the text from template will literally populate the cell(s) where you have the replacement key(s) no matter what, so no matter what you do, all the values you pass into B7, C7, etc, will populate in just those cells. I'd need to see a screenshot of your template to be sure - but tbh it's probably not worth your time as it'd be easier just to get the Export CDT one to work instead.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data