Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2014
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. a=1:10
  2. b=31:40
  3. c=data.frame(a=a,b=b)
  4.  
  5. # create data in R
  6. a = 1:10
  7. b = 31:40
  8. c0 = data.frame(a=a,b=b)
  9.  
  10. # write data object 'c0' to existing Excel file
  11. # 'Book1.xlsx' into a new sheet called 'Sheet1'
  12. library(XLConnect)
  13. writeWorksheetToFile(file = "C:/.../Book1.xlsx", data = c0, sheet = "Sheet1")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement