How to "read" MS EXCEL Formula from a cell and output it as a text in another spreadsheet

[ykhondo]

Does anyone know if there is a tool in ALTERYX that can read MS Excel worksheet cells that have a "Used Range" with "Special Cells with Cell Type Formulas" and return its content as a string? I am trying to document a very large and complex MS EXCEL workbook and VBA code for that works only on the small ranges. When I attempt read formulas from a worksheet with 1000+ rows and 10 + columns there seems to be not enough memory to hold huge arrays values and VBA program "hangs"... I hope there is a solution in Alteryx for what I am trying to do, is there? Any suggestions would be greatly appreciated!

[binuacs · Accepted solution]

@ykhondo you can read the Excel formula as is and bring it back to Alteryx

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

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

[ykhondo]

I have seen these links, thank you for the reference. I am still working on figuring out which delimiters to use in order to read formulas content from EXCEL pages.