Treat formula as string and output it into the Excel

[Happylife2025]

Hi, I recently learnt that alteryx can treat excel formula as string and output it into the Excel using text input. The Excel will automatically detect the formula and start the calculation. My use case is - I have an excel template with different formulas embedded. I want to alteryx output to be written to the excel template. The challenge is the formulas in excel are different cell level/row level/column level calculations. So I want alteryx to automatically write the calculations to excel template and when clicked on the individual cells we can still see the formula. How can this be done using text input? Any help will be very much appreciated.

[KGT]

So, do you want the cell to show the formula but not calculate it? Just drop the "=" at the start, or put an apostrophe ( ' ) in front of it. Or in Excel, hit the option on your ribbon to show formulas.

I'm not sure I've understood what you are after there...

[Happylife2025]

I want the calculation as well as formula to show in excel.

[KGT]

I'm not sure I understand. Maybe I don't understand what's currently happening.

With your current method, you are outputting formulas, and then when you open the excel workbook they'll calculate and show the results, but if you click on the cell, it'll show the formulas. That's what you have now?

And then what do you want it to look like?

[Happylife2025]

@KGT , thanks for replying. I found out my solution by doing some research :-)

[dreldrel]

Not sure what you have found, but in the Python tool you could dynamically create the Excel formula, then you just put the Excel formula to your template via the output tool