Export data from R to Excel

by

Another option is the openxlsx-package. It doesn’t depend on java and can read, edit and write Excel-files. From the description from the package:

openxlsx simplifies the the process of writing and styling Excel xlsx files from R and removes the dependency on Java

Example usage:

library(openxlsx)

# read data from an Excel file or Workbook object into a data.frame
df <- read.xlsx('name-of-your-excel-file.xlsx')

# for writing a data.frame or list of data.frames to an xlsx file
write.xlsx(df, 'name-of-your-excel-file.xlsx')

Besides these two basic functions, the openxlsx-package has a host of other functions for manipulating Excel-files.

For example, with the writeDataTable-function you can create formatted tables in an Excel-file.

More Related Contents:

  1. How to plot intersecting ranges in Excel/R/Matlab [closed]
  2. How to reshape data from long to wide format
  3. Grouping functions (tapply, by, aggregate) and the *apply family
  4. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  5. Select the row with the maximum value in each group
  6. How to create a consecutive group number
  7. Finding ALL duplicate rows, including “elements with smaller subscripts”
  8. Error in if/while (condition) {: missing Value where TRUE/FALSE needed
  9. Change R default library path using .libPaths in Rprofile.site fails to work
  10. Why can’t R’s ifelse statements return vectors?
  11. Sample random rows in dataframe
  12. Extracting specific columns from a data frame
  13. Subset / filter rows in a data frame based on a condition in a column
  14. Why do R objects not print in a function or a “for” loop?
  15. Converting year and month (“yyyy-mm” format) to a date?
  16. Fitting a density curve to a histogram in R
  17. A comprehensive survey of the types of things in R; ‘mode’ and ‘class’ and ‘typeof’ are insufficient
  18. What does %>% function mean in R?
  19. How do I install a package that has been archived from CRAN?
  20. as.Date with dates in format m/d/y in R
  21. Convert integer to class Date
  22. How to unload a package without restarting R
  23. as.Date returning NA while converting from ‘ddmmmyyyy’
  24. How to load packages in R automatically?
  25. How to search for “R” materials? [closed]
  26. Convert a dataframe to a vector (by rows)
  27. What is the difference between = and == in R?
  28. Should I use a data.frame or a matrix?
  29. Variable name restrictions in R
  30. How do you read a password protected excel file into r?

Leave a Comment