At the expense of extra bandwidth. I also like latex + booktabs; hate word I format the table header and footer in latex with extra vertical space between lines and type; output looks more like latex than being cramped from xtable. Thanks anyway to xtable creators -- would be lost without it
Duncan -----Original Message----- From: John Kane [mailto:jrkrid...@inbox.com] Sent: Thursday, 7 May 2015 01:34 To: Duncan Mackay; R Subject: Re: [R] lm model exported from R to excel And for those of us who know close to nothing about HTML I found just now that under a basic print.xtable commmand we get those horrible HMTL borders that in Apache OpenOffice seemed impossible to remove safely. No idea about Word--I have not used it in years. I did find that adding html.table.attributes = "border = 0" gets rid of the borders. So So something like print.xtable(modtable, type = "html", html.table.attributes = "border = 0", file = "modtable .html") seems to give a reasonable result in AOO. At least I managed to do some half-decent formatting with it. Meanwhile, back to LaTeX where the output looks beautiful. I like booktabs :) John Kane Kingston ON Canada > -----Original Message----- > From: dulca...@bigpond.com > Sent: Thu, 7 May 2015 00:32:48 +1000 > To: r-help@r-project.org > Subject: Re: [R] lm model exported from R to excel > > If you know some basic html language you can jazz up the table headings > to > your liking by writing that before the xtable statement. > It save having to muck around in Microsoft to fix it. > If you are going to do a lot of it - a little study of html basics can go > far. > > I was changing the headings to what I wanted using html (although not all > the tables were lm summaries) before the major upgrade a year or so ago > Now things are better. > > Even a title and comments in html for yourself if not available in xtable > are helpful. I have not used xtable and html since the upgrade as I use > latex > > Duncan > > -----Original Message----- > From: Livia Maria Vestergaard [mailto:lves...@student.sdu.dk] > Sent: Wednesday, 6 May 2015 22:37 > To: Duncan Mackay; R > Subject: SV: [R] lm model exported from R to excel > > Hi Duncan > Thank you so much - it worked :) > > Best > > Livia > ________________________________________ > Fra: Duncan Mackay [dulca...@bigpond.com] > Sendt: 6. maj 2015 14:26 > Til: R; Livia Maria Vestergaard > Emne: RE: [R] lm model exported from R to excel > > Hi Livia > > There are several html packages that ?could also do it > > Heres a way with xtable > > library(xtable) > y = rnorm(100) > x= rnorm(100)+rnorm(100) > mod <- lm(y ~x) > > # latex example easy view > xtable(mod) > > # html > file.create("lm.htm") > ff <- file("lm.htm", "a+") > fchars <- print(xtable(mod),type = "html") > writeLines(paste(fchars, sep = ""), ff) > close(ff) > > You can then bring this into Microsoft as an html file > > You may need to fill in some of the arguments in xtable to get the right > border format etc > > If you are doing many you can make a function to do things > > Duncan > > Duncan Mackay > Department of Agronomy and Soil Science > University of New England > Armidale NSW 2351 > Email: home: mac...@northnet.com.au > > -----Original Message----- > From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Livia > Maria > Vestergaard > Sent: Wednesday, 6 May 2015 19:37 > To: r-help > Subject: [R] lm model exported from R to excel > > Hi all > I all. I am wondering whether anybody know how to export an output of an > lm > model from R to excel in order to have excel recognize the table that > comes > and divide the numbers in the table into columns and rows? > I really hope it is possible? :) > > Best Livia > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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 -- To UNSUBSCRIBE and more, see > 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. ____________________________________________________________ Can't remember your password? Do you need a strong and secure password? Use Password manager! It stores your passwords & protects your account. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.