Is it possible to create an Excel file with R? [closed]

Question

Closed. This question is seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.

Closed 3 years ago.

Improve this question

General question: is there an R package out there that creates an Excel file? Or saves data frames as excel files? Or is it only possible to write files that already exist in a specific directory? If it is possible to create new Excel files, is there also a possibility to create multiple Excel sheets in that file?

Thank you for answering!

library(writexl) : cran.r-project.org/web/packages/writexl/writexl.pdf — maydin
– maydin, Commented Dec 20, 2021 at 10:05
Or if you want to use formating and other features, package openxlsx — phiver
– phiver, Commented Dec 20, 2021 at 10:07

jpiversen · Accepted Answer · 2021-12-20 10:23:04Z

1

I believe the package openxlsx is the most popular package to do this.

Example:

library(openxlsx)
write.xlsx(iris, file = "writeXLSX1.xlsx")

And yes, you can also add multiple sheets. See a nice introduction here.

answered Dec 20, 2021 at 10:23

jpiversen

3,2421 gold badge11 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to create an Excel file with R? [closed]

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related