[R] lm model exported from R to excel

John Kane
2015-05-06T15:33:37Z

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: dulcalma at bigpond.com
> Sent: Thu, 7 May 2015 00:32:48 +1000
> To: r-help at 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:lvest09 at 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 [dulcalma at 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: mackay at northnet.com.au
>
> -----Original Message-----
> From: R-help [mailto:r-help-bounces at 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 at 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 at 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.