Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Read values from a text box present in Excel.

KirtiAgarwal
5 - Atom

I have an input excel file which has data present in a textbox, How should I read these values.  

 

KirtiAgarwal_0-1595510592481.png
Need 

 

2 REPLIES 2
kelly_gilbert
13 - Pulsar

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.

  1. Select your file in the Connect a File or Database box.
  2. Change the File Format to Zip
  3. Click the ... next to File in Archive, which will display a list of the files within the .xlsx. Select Drawings. kelly_gilbert_0-1595551355475.png  
  4. In Parse Selected File as, choose XML. Un-check all of the boxes except Return Outer XMLkelly_gilbert_1-1595551440034.png

  5. At some point, the File Format may get flipped back to .xlsx, and you'll get an error. Just change it back to Zip.
  6. Next, use the XML Parse tool to parse out the child fields you want. You could also parse using regex or string functions, if those are more comfortable to you.The text within a shape is usually in a <t> element.

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! 

KirtiAgarwal
5 - Atom

Hi Kelly, Thanks for the response.

This worked perfectly 🙂

Labels