Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@wmcraver

wmcraver/WriteXLS.R

Last active November 10, 2016 23:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wmcraver/a4ffb718f3499cda2884857bf6ac3eb4 to your computer and use it in GitHub Desktop.
Save wmcraver/a4ffb718f3499cda2884857bf6ac3eb4 to your computer and use it in GitHub Desktop.
Download ZIP
Write multiple data frames to multiple sheets in one spreadsheet
Raw
WriteXLS.R
library(WriteXLS)
# renderedExperience, marketingChannel, allMetrics are data frames
sheetList <-list("Rendered Experience" = renderedExperience, "Marketing Channel" = marketingChannel, "Key Metrics" = allMetrics)
WriteXLS(
x = sheetList,
ExcelFileName = "RenderedExperience-MarketingChannel.xlsx",
SheetNames = names(sheetList),
FreezeRow = 1,
BoldHeaderRow = T,
AdjWidth = T
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment