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
Rodney
openxlsx can do this:
Read from an Excel file or Workbook object — read.xlsx • openxlsx (ycphs.github.io)
Many thanks, Martin.
I will give that a try.
Best regards
Rodney
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.