We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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