Read formula from Excel

[parthshukla]

Is there a way to load an excel file and then read the formula that is in Excel into Alteryx?

[alexnajm]

Looks like there may be a way! Solved: Alteryx Excel Import, Is there a way to bring thro... - Alteryx Community

[Bren_Spill]

@parthshukla 

Solved: View Underlying Excel Formulas - Alteryx Community

[Qiu]

@AkimasaKajitani 
I think you posted something to resolve the similar issue.
Maybe you can share? 😁

[AkimasaKajitani]

Hi @parthshukla ,

If you want to read xlsx type file, please change the file type to zip and unzip it. And then, read the xml file, you can get the formulas.

For example, after unzipped, you can get the xml files below.

 

Move to the xl\worksheets folder, you can find the sheet files, for example sheet1.xml.

Please load it and parse, you can get the formulas.

 

[parthshukla]

What would i do if my excel file doesn't have XML Data? so i can't save it as .xml