Easy way to export multiple data.frame to multiple Excel worksheets

by

You can write to multiple sheets with the xlsx package. You just need to use a different sheetName for each data frame and you need to add append=TRUE:

library(xlsx)
write.xlsx(dataframe1, file="filename.xlsx", sheetName="sheet1", row.names=FALSE)
write.xlsx(dataframe2, file="filename.xlsx", sheetName="sheet2", append=TRUE, row.names=FALSE)

Another option, one that gives you more control over formatting and where the data frame is placed, is to do everything within R/xlsx code and then save the workbook at the end. For example:

wb = createWorkbook()

sheet = createSheet(wb, "Sheet 1")

addDataFrame(dataframe1, sheet=sheet, startColumn=1, row.names=FALSE)
addDataFrame(dataframe2, sheet=sheet, startColumn=10, row.names=FALSE)

sheet = createSheet(wb, "Sheet 2")

addDataFrame(dataframe3, sheet=sheet, startColumn=1, row.names=FALSE)

saveWorkbook(wb, "My_File.xlsx")

In case you might find it useful, here are some interesting helper functions that make it easier to add formatting, metadata, and other features to spreadsheets using xlsx:
http://www.sthda.com/english/wiki/r2excel-read-write-and-format-easily-excel-files-using-r-software

More Related Contents:

  1. Importing a big xlsx file into R?
  2. How can I generate a user password in R [closed]
  3. In R; I would like to do something in R rather than excel because excel can’t handle the calculation. In excel the calculation is: =A2+SUM($B$2:B2)
  4. How to plot intersecting ranges in Excel/R/Matlab [closed]
  5. How can I read multiple (excel) files into R? [duplicate]
  6. How to convert Excel date format to proper date in R
  7. Read all worksheets in an Excel workbook into an R list with data.frames
  8. Importing Excel files into R, xlsx or xls
  9. Export data from R to Excel
  10. melt / reshape in excel using VBA?
  11. Handling java.lang.OutOfMemoryError when writing to Excel from R
  12. Read Excel file from a URL using the readxl package
  13. Is there an R function to reshape this data from long to wide?
  14. Is it possible to get the number of rows in a CSV file without opening it?
  15. How do you read a password protected excel file into r?
  16. export data frames to Excel via xlsx with conditional formatting
  17. Using R to read out excel-colorinfo
  18. How do I modify an existing a sheet in an Excel Workbook using Openxlsx package in R?
  19. Convert an upper to lower triangle matrix in r [duplicate]
  20. Remove all of x axis labels in ggplot [duplicate]
  21. What’s the use of which?
  22. In R, how do I add a max by group? [duplicate]
  23. How to plot a Stacked and grouped bar chart in ggplot?
  24. Ordering in r plotly barchart
  25. Sort legend in ggplot2
  26. Leaflet Legend for Custom Markers in R
  27. Check if string contains ONLY NUMBERS or ONLY CHARACTERS (R)
  28. Empty factors in “by” data.table
  29. Custom legend with imported images
  30. What you can do with a data.frame that you can’t with a data.table?

Leave a Comment