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

How do I get a list of all named ranges from an Excel workbook in 2018.2?

SuzanneMc
6 - Meteoroid

Looking to see if anyone has figured out how to get a list of all named ranges like you can get and import the list of all sheet names?

 

 

2 REPLIES 2
jasperlch
12 - Quasar

Hi, this could be achieved by Inputting the excel file as zip file. Then open the workflow.xml inside:

 

Capture1.PNG

neilmcg
7 - Meteor

I have used the solution presented across many files (using the xl/workbook.xml) to find named ranges in Excel files. I just ran into an .XLSM (I've successfully used this approach on XLSMs prior to this) where instead of getting a return of the named ranges, I get a list of sheet names instead (from xl/wookbook.xml). I'd really appreciate some help here. Any idea why I'm getting back sheet names (useless to me) instead of named ranges? I cannot attach the source file as it's confidential.

 

Thanks

Labels