xxxxxxxxxx
library(writexl)
sheets <- list("sheet1Name" = sheet1, "sheet2Name" = sheet2) #assume sheet1 and sheet2 are data frames
write_xlsx(sheets, "path/to/location")
xxxxxxxxxx
with pd.ExcelWriter("Data 2016.xlsx") as writer:
data.to_excel(writer, "Stock Prices")
correlations.to_excel(writer, "Correlations")
data.pct_change().mul(100).to_excel(writer, "Daily Changes")