Retain formatting of target template when writing data to Excel

Mike over 11 years ago

The excel plug-in works great, allowing us to push data to excel for additional analysis. Has anyone found a way to retain formatting of the target template when writing data? We're looking for more polish in the presentation of data, and writing data removes the colors, fonts, etc. of the template. Thanks!...

Discussion posts and replies are publicly visible

Top Replies

ChristineH over 5 years ago in reply to Antonio Menolascina +1
Certified Lead Developer

One approach we have done is to have a second sheet that has formulas that pulls the data from the sheet that Appian wrote to. We have used macros, etc. Hope that helps...

Parents

0 shelzle over 11 years ago

Search for the term "xmlss". There are some posts from me and others discussing this. Create a Excel sheet, do some formatting and save it as xmlss. This file can be used as template.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 shelzle over 11 years ago

Search for the term "xmlss". There are some posts from me and others discussing this. Create a Excel sheet, do some formatting and save it as xmlss. This file can be used as template.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data