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
Hi Livia, One way is to use the "delim.table" function in the prettyR package. See the examples, in particular the final one. The resulting TAB delimited file will usually import directly into Excel. Jim On Wed, May 6, 2015 at 7:36 PM, Livia Maria Vestergaard <lvest09 at student.sdu.dk> wrote:> 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.
Hi AFAIK result of lm model is a list so you cannot expect easy direct output to Excel. List of 12 $ coefficients : Named num 61.2 ..- attr(*, "names")= chr "cas" $ residuals : Named num [1:2] 0 0 ..- attr(*, "names")= chr [1:2] "1" "2" $ effects : Named num [1:2] -61.2 0 ..- attr(*, "names")= chr [1:2] "cas" "" $ rank : int 1 $ fitted.values: Named num [1:2] 0 61.2 ..- attr(*, "names")= chr [1:2] "1" "2" $ assign : int 1 $ qr :List of 5 ..$ qr : num [1:2, 1] -1 1 .. ..- attr(*, "dimnames")=List of 2 .. .. ..$ : chr [1:2] "1" "2" .. .. ..$ : chr "cas" .. ..- attr(*, "assign")= int 1 ..$ qraux: num 1 ..$ pivot: int 1 ...... You can output data frame or other matrix like object e.g. by write.table(tab, "clipboard", sep = "\t", row.names = F) and in Excel you can use ctrl V. So first you need to transform list or its part to be suitable for Excel. Cheers Petr> -----Original Message----- > From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Livia > Maria Vestergaard > Sent: Wednesday, May 06, 2015 11:37 AM > 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.________________________________ Tento e-mail a jak?koliv k n?mu p?ipojen? dokumenty jsou d?v?rn? a jsou ur?eny pouze jeho adres?t?m. Jestli?e jste obdr?el(a) tento e-mail omylem, informujte laskav? neprodlen? jeho odes?latele. Obsah tohoto emailu i s p??lohami a jeho kopie vyma?te ze sv?ho syst?mu. Nejste-li zam??len?m adres?tem tohoto emailu, nejste opr?vn?ni tento email jakkoliv u??vat, roz?i?ovat, kop?rovat ?i zve?ej?ovat. Odes?latel e-mailu neodpov?d? za eventu?ln? ?kodu zp?sobenou modifikacemi ?i zpo?d?n?m p?enosu e-mailu. V p??pad?, ?e je tento e-mail sou??st? obchodn?ho jedn?n?: - vyhrazuje si odes?latel pr?vo ukon?it kdykoliv jedn?n? o uzav?en? smlouvy, a to z jak?hokoliv d?vodu i bez uveden? d?vodu. - a obsahuje-li nab?dku, je adres?t opr?vn?n nab?dku bezodkladn? p?ijmout; Odes?latel tohoto e-mailu (nab?dky) vylu?uje p?ijet? nab?dky ze strany p??jemce s dodatkem ?i odchylkou. - trv? odes?latel na tom, ?e p??slu?n? smlouva je uzav?ena teprve v?slovn?m dosa?en?m shody na v?ech jej?ch n?le?itostech. - odes?latel tohoto emailu informuje, ?e nen? opr?vn?n uzav?rat za spole?nost ??dn? smlouvy s v?jimkou p??pad?, kdy k tomu byl p?semn? zmocn?n nebo p?semn? pov??en a takov? pov??en? nebo pln? moc byly adres?tovi tohoto emailu p??padn? osob?, kterou adres?t zastupuje, p?edlo?eny nebo jejich existence je adres?tovi ?i osob? j?m zastoupen? zn?m?. This e-mail and any documents attached to it may be confidential and are intended only for its intended recipients. If you received this e-mail by mistake, please immediately inform its sender. Delete the contents of this e-mail with all attachments and its copies from your system. If you are not the intended recipient of this e-mail, you are not authorized to use, disseminate, copy or disclose this e-mail in any manner. The sender of this e-mail shall not be liable for any possible damage caused by modifications of the e-mail or by delay with transfer of the email. In case that this e-mail forms part of business dealings: - the sender reserves the right to end negotiations about entering into a contract in any time, for any reason, and without stating any reasoning. - if the e-mail contains an offer, the recipient is entitled to immediately accept such offer; The sender of this e-mail (offer) excludes any acceptance of the offer on the part of the recipient containing any amendment or variation. - the sender insists on that the respective contract is concluded only upon an express mutual agreement on all its aspects. - the sender of this e-mail informs that he/she is not authorized to enter into any contracts on behalf of the company except for cases in which he/she is expressly authorized to do so in writing, and such authorization or power of attorney is submitted to the recipient or the person represented by the recipient, or the existence of such authorization is known to the recipient of the person represented by the recipient.
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.
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.
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.
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:jrkrideau at 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: 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.