Is it possible to retain a formulas in a cell and displaying it in the output ?

[gavinloi]

Hi all,

I have a query that in my input data excel file there are certain cells with formulas and i would like to retain the formulas when in the output excel once alteryx has ran. 

Would that be possible ?

Thanks!

[apathetichell · Accepted solution]

yes. It involves exploring the .xml in the .xlsx file by bringing in the .xlsx file as a .zip file...

check out these threads:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-Excel-Import-Is-there-a-way-to...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Hi-everyone-Please-help-with-the-attac...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/comparing-column-headers-and-notes-in-...