Export data from R to Excel

Question

I am writing codes to export database from R into Excel  I have been trying others codes including   write table ALBERTA1   D  ALBERTA1 txt   sep   t   write csv ALBERTA1    ALBERTA1 csv   your filename in R   read csv  ALBERTA1 csv   your filename in R   read csv  ALBERTA1 csv   write csv df  file    ALBERTA1 csv   your filename in R   read csv  ALBERTA1 csv   write csv ALBERTA1   ALBERTA1 csv   write table ALBERTA1   clipboard   sep   t   write table ALBERTA1  ALBERTA1 txt   write table as matrix ALBERTA2   ALBERTA2 txt   write table as matrix vecm pred fcst Alberta Females  1     vecm pred fcst Alberta Females  1  txt   write table as matrix foo   foo txt   write xlsx ALBERTA2    ALBERTA2 xlsx   write table ALBERTA1   D  ALBERTA1 txt   sep   t      Other users of this forum advised me this   write csv2 ALBERTA1   ALBERTA1 csv   write table kt   D  kt txt   sep   t   row names FALSE      You can see on the pictures the outcome I have got from this codes above  But this numbers can t be used to make any further operations such as addition with other matrices    Has someone experienced this kind of problems

User · Answer

I have been trying out the different packages including the function:

install.packages ("prettyR") 

library (prettyR)

delimit.table (Corrvar,"Name the csv.csv") ## Corrvar is a name of an object from an output I had on scaled variables to run a regression.

However I tried this same code for an output from another analysis (occupancy models model selection output) and it did not work. And after many attempts and exploration I:

copied the output from R (Ctrl+c)
in Excel sheet I pasted it (Ctrl+V)
Select the first column where the data is
In the "Data" vignette, click on "Text to column"
Select Delimited option, click next
Tick space box in "Separator", click next
Click Finalize (End)

Your output now should be in a form you can manipulate easy in excel. So perhaps not the fanciest option but it does the trick if you just want to explore your data in another way.

PS. If the labels in excel are not the exact one it is because Im translating the lables from my spanish excel.

User · Answer

Recently used xlsx package  works well   library xlsx  write xlsx x  file  sheetName  Sheet1     where x is a data frame

User · Answer

The WriteXLS function from the WriteXLS package can write data to Excel   Alternatively  write xlsx from the xlsx package will also work

User · Answer

Here is a way to write data from a dataframe into an excel file by different IDs and into different tabs  sheets  by another ID associated to the first level id  Imagine you have a dataframe that has email address as one column for a number of different users  but each email has a number of  sub-ids  that have all the data  data  lt - tibble id   c 1 2 3 4 5 6 7 8 9   email address   c rep  aaa aaa com  3   rep  bbb bbb com   3   rep  ccc ccc com   3     So ids 1 2 3 would be associated with aaa aaa com  The following code splits the data by email and then puts 1 2 3 into different tabs  The important thing is to set append   True when writing the  xlsx file   temp dir  lt - tempdir    for i in unique data email address           data   gt        filter email address    i    gt        arrange id  - gt  subset data      for j in unique subset data id        write xlsx subset data   gt   filter id    j          file   str c temp dir  quot  your filename  quot   str extract i  pattern    quot   b A-Za-z0-         9    -   quot        Sys Date      xlsx           sheetName   as character j          append   TRUE           The regex gets the name from the email address and puts it into the file-name  Hope somebody finds this useful  I m sure there s more elegant ways of doing this but it works  Btw  here is a way to then send these individual files to the various email addresses in the data frame  Code goes into second loop  j    send mail from    quot sender sender com quot               to   i            subject   paste  quot Your report for quot   str extract i  pattern    quot   b A-Za-z0-9    -   quot     on   Sys Date               body    quot Your email body quot             authenticate   TRUE            smtp   list host name    quot XXX quot   port   XXX                        user name   Sys getenv  quot XXX quot    passwd   Sys getenv  quot XXX quot               attach files   str c temp dir   quot  your filename  quot   str extract i  pattern    quot   b A-Za-z0-9    -   quot        Sys Date      xlsx

User · Answer

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  lt - 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

User · Answer

writexl  without Java requirement      install packages  writexl   library writexl  tempfile  lt - write xlsx iris

[r] Export data from R to Excel

Examples related to r

Examples related to excel

Examples related to r-faq