I am working with the R programming language.
I am trying to import a (multi sheet) “xlsb” file into R. Normally, I would have done this using the readxlsb library, e.g. How to open an .xlsb file in R? , but I can not install this library on my school/university computer.
I realized I can manually change the format from xlsb to xlsx, and then use the readxl::read_excel function to import this (How to import multiple xlsx sheets in R)
This got me thinking – using the system() command, is it possible to change the format of the xlsb file directly in R … and then use the readxl library in R to import?
For example, I know in R its possible to delete a file from the working directory:
a = data.frame(a = rnorm(100,100,100), b = rnorm(100,100,100))
write.csv(a, "Test.csv")
wd <- getwd()
file_path <- file.path(wd, "Test.csv")
file.remove(file_path)
Using R, it also possible to change the format of a file situated in the working directory?
Thanks!