Treat formula as string and output it into the Excel

Question

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.

dreldrel · Answer

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

Happylife2025 · Answer

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

KGT · Answer

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?