Excel Named Ranges

Good evening
I am using the read_excel() function from the readxl package to successfully read my excel spreadsheet data. However, it does not appear to support Excel 'named' ranges; you have to specify an absolute range (e.g. B3:D7).
Can anyone point me to a similar package that does except 'named' ranges?

Many thanks

openxlsx can do this:
Read from an Excel file or Workbook object — read.xlsx • openxlsx (ycphs.github.io)

1 Like

Many thanks, Martin.
I will give that a try.

Best regards

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.