Question

Excel Template Formulas

Forum|Forum|20 days ago
July 14, 2026
4 replies
0 views

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.

K

khushim2808

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.

The Approach: "Export To Excel (Template)" Smart Service

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

-Prepare the Template:

- Place substitution keys where you want Appian data to populate (e.g., ###customerName### or ###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###"}).
- Values (Any Type Array): Pass the matching Appian process variables or rule outputs to fill those keys.