4

I am a beginner and am trying to simply insert an R data frame from RStudio into an existing Excel sheet without losing previous data in that sheet or overwriting the whole file, eg. insert new data frame (15 rows, 4 columns) in file "Reporting.xlsx" in Sheet "August" from row 16, column 1, so that the previous info is not lost ?

Thank you !

bateC
  • 41
  • 1
  • 2

2 Answers2

6

Something like this:

library(openxlsx)
library(dplyr)

# Get existing data and append new data
dat = readWorkbook("Reporting.xlsx", sheet="August")
dat = bind_rows(dat, new_data_frame)

# Write updated data frame to existing worksheet
wb = loadWorkbook("Reporting.xlsx")
writeData(wb, "August", dat)

# Save file (with new name for testing purposes)
saveWorkbook(wb, "Reporting_test.xlsx")

# To overwrite the pre-existing data file, you can do the following (commented out for safety)
#saveWorkbook(wb, "Reporting.xlsx", overwrite=TRUE)
eipi10
  • 91,525
  • 24
  • 209
  • 285
  • Thank you so much, it worked just like the way you described! Wish I could buy you a beer mate, have a good day ! – bateC Oct 26 '17 at 07:53
3

What I would suggest is importing the Excel file into R Studio, create a new data frame by merging the R data frame and Excel data frame, and then exporting the file.

jeron
  • 92
  • 10
  • Agreed. This seems like the most succinct approach. Use a write.xlsx or something equivalent. – skhan8 Oct 25 '17 at 17:09