Write data into a specific workbook sheet
11,505
Solution 1
This will add a new named sheet to an existing Excel workbook without altering existing sheets:
# create data in R
a = 1:10
b = 31:40
c0 = data.frame(a=a,b=b)
# write data object 'c0' to existing Excel file
# 'Book1.xlsx' into a new sheet called 'Sheet1'
library(XLConnect)
writeWorksheetToFile(file = "C:/.../Book1.xlsx", data = c0, sheet = "Sheet1")
Note that if the workbook already has a Sheet1
then this function would silently overwrite it. So you'll need to make sure your sheet names are unique.
Solution 2
Try with xlsx package. You have the function write.xlsx() which allows you to specify a name sheet and you can complete an existing excel.
Author by
SilverSpoon
Updated on June 13, 2022Comments
-
SilverSpoon almost 2 years
I have a data frame e.g.
a=1:10 b=31:40 c=data.frame(a=a,b=b)
and I will need to write this data frame into a specific Excel sheet ("Sheet1").
I am using WriteXLS now but this function always overrides the entire excel file and thus deletes other sheets. How can I append to the sheet without overwriting previous entries?