Posts

Showing posts with the label readxl

Opening/reading an excel file in r

Image
Clash Royale CLAN TAG #URR8PPP Opening/reading an excel file in r I am having trouble opening/reading excel files that I download from the website of the Australian Bureau of Statistics using readxl. I've downloaded Table 12 from the website but when I go to read the sheets of the workbook in r I get an error message: r library(readxl) excel_sheets(path = "C:/Users/Name/Documents/downloaded_file.xls") "Error in xls_sheets(path) : Failed to open C:/Users/Name/Documents/downloaded_file.xls". In previous versions of readxl I have had no trouble reading these files into r but I've recently updated my readxl version, after a hiatus of several months, and now it doesn't work. readxl r I have tried to download the file using the download.file function taking care to set mode = wb but that makes no difference to being able to access the data in the workbook either. download.file mode = wb Grateful for any pointers. The file is...