community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Reading Embedded excel doc within word doc

Does anyone know how to read an excel doc embedded within a  word doc?

 

I also need to read info on word doc, the best way I've seen to do this is to convert to .txt and read as .csv but that does not give me any useable info on the embedded excel doc other than the name without file format. 

 

Would appreciate any ideas or workarounds anyone can think of !!! 

 

 

Alteryx Certified Partner

Hi @ereyna1010 ,

 

Fun challenge!

 

Here's one approach. I'm making the assumption that you are working with an xlsx file embedded in a docx file.

 

1) Change the file extension from .docx to .zip (a docx is just a fancy zip file). You could create a batch file to do this and run it via the CMD tool, perhaps passing through the filename from a Directory tool.

 

2) Connect to the zip file using an Input tool.

 

3) Select the embedded Excel file from the Extract File menu.

 

I've attached the sample document I created to solve this.

 

Mqb9Ok3RtO

 

-----

If I've answered your question please consider marking this solution as accepted. Thank you!

Will try this and let you know how it goes. 

For some reason the embedded excel doc is not showing up in the zip file as a separate  document.   

 

Think it may be since the doc is embedded as a linked doc (see image below.)

 

 

tempsnip.png

Labels