• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 8 replies
  • Subscribers 4 subscribers
  • Views 5294 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

Export to Excel - Need to generate excel with multiple sheets and based on a template

arkaprobham
Hi All,

Our requirement is - We need to show link for Export to excel in tempo report.The generated excel should have multiple sheets and should be based on a template.

How can I achieve this using the link.

OriginalPostID-247417

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    @rrobins is right - create the file in the first node (with Sheet_number = 0 for the data inputs) and save the 'Output_document' in the data outputs as a pv. Then - in the next smart service node - start on Sheet_number = 1 and use the pv as the value for 'Document_to_overwrite' - saving the Output_document again as the pv...continue until you have all the tabs populated, overwriting the document (pv) each time.
Reply
  • 0
    Certified Senior Developer
    @rrobins is right - create the file in the first node (with Sheet_number = 0 for the data inputs) and save the 'Output_document' in the data outputs as a pv. Then - in the next smart service node - start on Sheet_number = 1 and use the pv as the value for 'Document_to_overwrite' - saving the Output_document again as the pv...continue until you have all the tabs populated, overwriting the document (pv) each time.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.