Extract from Text Box in Excel

nadiahghzli

Hi community, anyone know how to extract text from shape in excel?

For example, here is the text box in Excel:

I would like Alteryx to read it as two rows:

placeholder

alteryx

I am planning to use macro because I am running for a few excel files with similar format, which one of the tabs that I need Alteryx to read consists of text box. Here is the example data and workflow. Thank you in advanced for your help !

Data.xlsx

Example_Text Box.yxzp

erickyaparevalo

Hi,

it was interesting solving this topic. Here you can fin attached the macro you have shared but with some modifications. Instead of reading the xml, I read as csv (plain text). This way we can parsing using "XML Parse" tool (twice). You can set up properly inside your workflow.

Let me know if this works for you!

Spoiler

 

ReadXLSX_Text Box.yxmc