We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

.xlsx as .zip files to access the .xml ---- the writing quagmire...

apathetichell
20 - Arcturus

o.k so short of a python/R workaround has anyone been able to write to the inner .xml files that make up an .xlsx file after reading in the .xml files as a .zip?

1 REPLY 1
apathetichell
20 - Arcturus

@danilangany ideas on this one? I can see that a .zip file is fileformat 57 and when trying to write I get - Record #1: Tool #2: Zip format does not support writing and when I try to write to fileformat 37 (xml) I get:

  Record #1: Tool #2: DataWrap2XML does not support writing

 

this leaves me able to see the .xml inside the .xlsx file but not to make changes (like say resize a post-render absurdly large column) dynamically.

 

 

 

Labels
Top Solution Authors