Advertisement
Guest User

Untitled

a guest
Sep 1st, 2015
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. a <- c(1, 2, 3, 4)
  2. b <- c(5, 6, 7, 8)
  3. c <- c(9, 10, 11, 12)
  4. d <- data.frame(a, b, c)
  5. d <- t(d)`
  6.  
  7. require(xlsx)
  8. require(XLConnect)
  9. SampleSetNumber <- 0 # 0 = First sample set, 1 = second...
  10. AppendData <- SampleSetNumber*3
  11. wb <- loadWorkbook("NewWorkbook.xlsx", create=T)
  12. createSheet(wb, name = "Data")
  13. writeWorksheet(wb, d, sheet="Data", header=F, startRow = AppendData+(2:4), startCol=1, rownames=NULL)
  14. saveWorkbook(wb, "NewWorkbook.xlsx")
  15.  
  16. SampleSetNumber <- 0 # Rows 2:4
  17. SampleSetNumber <- 1 # Rows 5:7... so on
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement