[R] exporting tables to word
Hello all, What is your preferred method to export tables (from ftable()) to Word? Do you just export to a text file and then copy/paste? Or perhaps via HTML output? Thanks, Allie __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] exporting tables to word
Hi Allie, My preferred method is by means of odfWeave. Odfweave generates a libreoffice file, which can directly be transferred to word. A second way is run R from within spss. Spss has a much better output than R, but you can use the output system of spss (by means of spsspivottable.Display()) Frans 2013/4/2 Alexander Shenkin ashen...@ufl.edu Hello all, What is your preferred method to export tables (from ftable()) to Word? Do you just export to a text file and then copy/paste? Or perhaps via HTML output? Thanks, Allie __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] exporting tables to word
Thanks Frans, odfTable seems not to like ftable objects. any thoughts? Error: chunk 1 (label = damageTable) Error in UseMethod(odfTable) : no applicable method for 'odfTable' applied to an object of class ftable thanks, allie On 4/2/2013 8:09 AM, Frans Marcelissen wrote: Hi Allie, My preferred method is by means of odfWeave. Odfweave generates a libreoffice file, which can directly be transferred to word. A second way is run R from within spss. Spss has a much better output than R, but you can use the output system of spss (by means of spsspivottable.Display()) Frans 2013/4/2 Alexander Shenkin ashen...@ufl.edu Hello all, What is your preferred method to export tables (from ftable()) to Word? Do you just export to a text file and then copy/paste? Or perhaps via HTML output? Thanks, Allie __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] exporting tables to word
Thanks Carlos, ftable has some internal routines, it seems, that allow it to print out a flat contigency table in a nice format. Converting to data.frame ends up messing up the display format, unfortunately. thanks, allie On 4/2/2013 12:41 PM, Carlos Valenzuela wrote: You may also want to consider the rtf package. It works okay. You would have to save your results as a dataframe and you would be able to write that object out to an .rtf (or even use an .doc extension, as I have seen it done). For example, library(rtf) # Your regression formula lmobj-lm(dv~iv1 + iv2 + iv3, data=dat) lmresults-as.data.frame(summary(lmobj)$coefficients) # Output location for .rtf file output-filepath/nameoffile.rtf # Specify the width, height, font size, etc and margins rtfdoc-RTF(output,width=8.5,height=11,font.size=10,omi=c(1,1,1,1)) addHeader(rtf,title=Title of Table, subtitle=Subtitle) addTable(rtfdoc, lmresults, font.size=10, row.names=T, NA.string=-) done(rtf) This is a very crude example so I would suggest looking at the help files associated with the rtf package to make any modifications, such as adding other regression results/tables. Thanks and hope this helps, Carlos On Tue, Apr 2, 2013 at 12:13 PM, Alexander Shenkin ashen...@ufl.edu wrote: Thanks Frans, odfTable seems not to like ftable objects. any thoughts? Error: chunk 1 (label = damageTable) Error in UseMethod(odfTable) : no applicable method for 'odfTable' applied to an object of class ftable thanks, allie On 4/2/2013 8:09 AM, Frans Marcelissen wrote: Hi Allie, My preferred method is by means of odfWeave. Odfweave generates a libreoffice file, which can directly be transferred to word. A second way is run R from within spss. Spss has a much better output than R, but you can use the output system of spss (by means of spsspivottable.Display()) Frans 2013/4/2 Alexander Shenkin ashen...@ufl.edu Hello all, What is your preferred method to export tables (from ftable()) to Word? Do you just export to a text file and then copy/paste? Or perhaps via HTML output? Thanks, Allie __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] exporting tables to word
On Tue, Apr 2, 2013 at 1:50 PM, Alexander Shenkin ashen...@ufl.edu wrote: Thanks Carlos, ftable has some internal routines, it seems, that allow it to print out a flat contigency table in a nice format. Converting to data.frame ends up messing up the display format, unfortunately. thanks, allie The metrumrg package has ftable2data.frame . __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] exporting tables to word
You may also want to consider the rtf package. It works okay. You would have to save your results as a dataframe and you would be able to write that object out to an .rtf (or even use an .doc extension, as I have seen it done). For example, library(rtf) # Your regression formula lmobj-lm(dv~iv1 + iv2 + iv3, data=dat) lmresults-as.data.frame(summary(lmobj)$coefficients) # Output location for .rtf file output-filepath/nameoffile.rtf # Specify the width, height, font size, etc and margins rtfdoc-RTF(output,width=8.5,height=11,font.size=10,omi=c(1,1,1,1)) addHeader(rtf,title=Title of Table, subtitle=Subtitle) addTable(rtfdoc, lmresults, font.size=10, row.names=T, NA.string=-) done(rtf) This is a very crude example so I would suggest looking at the help files associated with the rtf package to make any modifications, such as adding other regression results/tables. Thanks and hope this helps, Carlos On Tue, Apr 2, 2013 at 12:13 PM, Alexander Shenkin ashen...@ufl.edu wrote: Thanks Frans, odfTable seems not to like ftable objects. any thoughts? Error: chunk 1 (label = damageTable) Error in UseMethod(odfTable) : no applicable method for 'odfTable' applied to an object of class ftable thanks, allie On 4/2/2013 8:09 AM, Frans Marcelissen wrote: Hi Allie, My preferred method is by means of odfWeave. Odfweave generates a libreoffice file, which can directly be transferred to word. A second way is run R from within spss. Spss has a much better output than R, but you can use the output system of spss (by means of spsspivottable.Display()) Frans 2013/4/2 Alexander Shenkin ashen...@ufl.edu Hello all, What is your preferred method to export tables (from ftable()) to Word? Do you just export to a text file and then copy/paste? Or perhaps via HTML output? Thanks, Allie __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.