I have an input excel file which has data present in a textbox, How should I read these values.
Need
Solved! Go to Solution.
One way to solve this would be parsing the worksheet's XML. A .xlsx file is basically a zip file of xml files, so we can read in the zip file with Alteryx, and then parse the XML.
You may need to perform some other cleanup/text parsing to get the data into the format you need, but this is one way to get the text out of the shape!
Hi Kelly, Thanks for the response.
This worked perfectly 🙂