martinctc
10/12/2017 - 7:38 PM

Write data to Excel Sheet (openxlsx)

[Write to worksheet] Saves or overwrites a worksheet to an Excel Workbook in a form compatible with the pipe style - using the openxlsx package in #R.

write to worksheet.R
content_copyfile_download
write_to_ws <- function(data, workbook, worksheet){
  if (worksheet %in% names(workbook)) {
  writeData(workbook, worksheet, data)
  }
  else{
  addWorksheet(workbook, worksheet)
  writeData(workbook, worksheet, data)
  }
}

## Accompanying functions
#library(openxlsx)
#wb <- createWorkbook()
#saveWorkbook(wb,filename,overwrite=TRUE)