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

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

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

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

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

[r] Export data from R to Excel

Examples related to r

Examples related to excel

Examples related to r-faq