How to extract information of underlying formulas and macros from excel in Alteryx?

[Kurohits]

Hi, 

Need urgent help from community members. 

I need to bring all the formulas and macros used in excel instead of rows and columns values. I tried this however Alteryx pulls the values not the underlying formulas? Is there any way to do this? If yes then can anyone help me on this please?

[FinnCharlton]

Hi @Kurohits , seems like it's possible but not too easy - it involves extracting the formulas for the XML of Excel files.

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

[Kurohits]

Hey @FinnCharlton 

I checked this link which you shard. However wondering should I ask for Zip/XML format from the client. I checke the attached solution but the file format is zip and parse selected file as CSV. Don't know how to convert excel to zip or xml?

[binuacs · Accepted solution]

@Kurohits connect your excel file in the input tool and make changes like below in the input tool. 

https://community.alteryx.com/t5/General-Discussions/Hyperlink/m-p/1188938#M9912