I'm looking for a way to generate an Excel file from a template in Appian while ensuring that all existing formulas in the template are preserved. Has anyone implemented this or knows of an approach?
Thanks in advance.
Discussion posts and replies are publicly visible
Yes, this is a standard requirement handled via the Appian AppMarket plug-ins. Native Appian smart services like Export Data Store Entity to Excel will overwrite or drop complex template formatting and formulas, so you need to use a plug-in that performs token replacement while leaving the rest of the spreadsheet structure intact.
The most reliable approach is using the Excel Tools plug-in.
Instead of building a spreadsheet from scratch, you upload your .xlsx file containing all pre-configured formulas, named ranges, charts, and styling to Appian as a document template. You then use the plug-in to inject data into specific target cells or markers without touching the formula blocks
.xlsx
-Prepare the Template:
Place substitution keys where you want Appian data to populate (e.g., ###customerName### or ###invoiceDate###).
###customerName###
###invoiceDate###
Add the Export To Excel (Template) smart service node to your process model.
Template (Document): Pass your uploaded Excel template document.
Keys (Text Array): Provide the exact text markers used in the template (e.g., {"###customerName###", "###invoiceDate###"}).
{"###customerName###", "###invoiceDate###"}
Values (Any Type Array): Pass the matching Appian process variables or rule outputs to fill those keys.