Write.xlsx2(x, file, sheetName = 'Sheet1', col.names = TRUE, # Semi-colon as separator and comma as decimal separator
ShowNA = TRUE, # If TRUE, NA are empty cells Row.names = TRUE, # Whether to include row names or notĪppend = FALSE, # Whether to append to an existing file SheetName = 'Sheet1', # Name of the sheetĬol.names = TRUE, # Whether to include column names or not Write.xlsx(x, # Data frame to be exported # Comma as separator and dot as decimal separator The most known package to export data frames or tables as Excel is xlsx, that provides the write.xlsx and write.xlsx2 functions.
Export data from R to Excel (XLS and XLSX)Įxporting data from R to Excel can be achieved with several packages.
