Read and write Excel from R using the openxlsx package. No infuriating Java dependencies. Easy to work with. Best Excel translator I know of.

read write excel from R.R

# Example use of the openxlsx package

require(openxlsx) # For writing output in excel for collaborators

df1 <- data.frame(aa = letters[3:12], bb = 21:30, stringsAsFactors = FALSE)
df2 <- data.frame(cc = rnorm(20, 5, 1), dd = runif(20, 1, 5))

## Write the data to a new excel file
wb <- openxlsx::createWorkbook()
addWorksheet(wb, 'Wksheet name')
addWorksheet(wb, 'Another worksheet name')

class(df1$aa) <- 'text'   # Ususally not necessary, the function does a good job of auto-recognizing
writeDataTable(wb = wb, sheet = 'Wksheet name', x = df1)
writeDataTable(wb = wb, sheet = 'Another worksheet name', x = df2)
saveWorkbook(wb = wb, file = './blahblah.xlsx', overwrite = TRUE)