Skip to content

Instantly share code, notes, and snippets.

@silgon

silgon/read_xlsx_defined_name.py

Created November 17, 2020 14:40
Show Gist options
  • Save silgon/e0e64930810c933363c05ade3dd86e3a to your computer and use it in GitHub Desktop.
Save silgon/e0e64930810c933363c05ade3dd86e3a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
read_xlsx_defined_name.py
wb=openpyxl.load_workbook("doc.xlsx")
sheet, inrange=list(wb.defined_names["MYDEFINEDNAME"].destinations)[0]
[xy.value for xy in x] for x in wb[sheet][inrange]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment