How to convert .xlsx file in R to .xls

134 Views Asked by At

I have specific need- one of the uploads I need to do is allowed only in .xls file.

So I am reading input in R (input is in .xlsx) via following command:

library(rio);
Data= import("Table.xlsx",skip=1); 

Now this Data is a dataframe in R. I want to save this in .xls format. However, package rio does not allow it via following command:

export((Data),"Table.xls"); #This command fails as rio does not support .xls

So question is- how do I store (export) my .xlsx file as .xls?

Any new library that can do this task?

Any new library or libraries are fine

0

There are 0 best solutions below