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

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