How can you read the data from a named range in Excel into a pandas DataFrame?
Unfortunately, the canonical function pandas.read_excel() is designed to only read entire sheets within a workbook.
Reading an Excel named range into a pandas DataFrame
Viewed 13826
6 Answers
Here is the way I use openpyxl to copy a range in a [[]] :
wb = load_workbook(filename=xlPath)
ws, range= next(wb.defined_names["rangename"].destinations)
materials = [[cell.value for cell in row] for row in wb[ws][range]]
Well, it's been a while, but I would definitely recommend giving a shot to xlwings.
See also Xlwings take value from defined names .
Related