Re: [R] Transferring results from R to MS Word

2008-10-28 Thread Marc Schwartz
on 10/28/2008 10:23 AM [EMAIL PROTECTED] wrote: > John Kane wrote: > >> --- On Mon, 10/27/08, Tom Backer Johnsen <[EMAIL PROTECTED]> >> wrote: >> >>> From: Tom Backer Johnsen <[EMAIL PROTECTED]> Subject: Re: [R] >>> Transferring results f

Re: [R] Transferring results from R to MS Word

2008-10-28 Thread heimdal
John Kane wrote: > --- On Mon, 10/27/08, Tom Backer Johnsen <[EMAIL PROTECTED]> wrote: > > > From: Tom Backer Johnsen <[EMAIL PROTECTED]> > > Subject: Re: [R] Transferring results from R to MS Word > > To: "Greg Snow" <[EMAIL PROTECTE

Re: [R] Transferring results from R to MS Word

2008-10-28 Thread John Kane
--- On Mon, 10/27/08, Tom Backer Johnsen <[EMAIL PROTECTED]> wrote: > From: Tom Backer Johnsen <[EMAIL PROTECTED]> > Subject: Re: [R] Transferring results from R to MS Word > To: "Greg Snow" <[EMAIL PROTECTED]> > Cc: "[EMAIL PROTECTED]" <[EMAI

Re: [R] Transferring results from R to MS Word

2008-10-28 Thread Eric Lecoutre
Tom, Sorry to react only at tis point ; it makes months I didn"t read R-help, having unfortunalety to work for SAS. Though I am not anymore the maintainer of the package, I am the creator of it and may provide some insights. - There are a lot of HTML methods, effectively hidden (namespace) ; you

Re: [R] Transferring results from R to MS Word

2008-10-28 Thread Tom Backer Johnsen
Dieter Menne wrote: Tom Backer Johnsen psych.uib.no> writes: There are also some parts of the documentation that I do not understand. The list of functions includes things like HTML.lm, as far as I can see are invisible, both in respect to documentation and usage. This might be relic of a

Re: [R] Transferring results from R to MS Word

2008-10-28 Thread Dieter Menne
Tom Backer Johnsen psych.uib.no> writes: > There > are also some parts of the documentation that I do not understand. The > list of functions includes things like HTML.lm, as far as I can see are > invisible, both in respect to documentation and usage. This might be relic of a function writt

Re: [R] Transferring results from R to MS Word

2008-10-27 Thread Tom Backer Johnsen
Felipe Carrillo wrote: Are you still can't get the data into R? I sent you this -mail last week, did you read it? Yes I did read it, and I have installed the package and looked at the documentation. What I (after an admittently superficial inspection due to limited available time this weeke

Re: [R] Transferring results from R to MS Word

2008-10-27 Thread Tom Backer Johnsen
Greg Snow wrote: Another alternative (since you asked) is the RExcel project (http://rcom.univie.ac.at). I don't know if it will work better for your projects or not, but it may be worth a look. The basic idea is that it uses Excel as a front end and R as the background computational engine

Re: [R] Transferring results from R to MS Word

2008-10-27 Thread Tom Backer Johnsen
Greg Snow wrote: Any timing is of course your decision, but my observation (being one of my company's test cases for updating office) is that transitioning from MSWord 2003 to OpenOffice Writer will be less work/stress than transitioning from MSWord 2003 to MSWord 2007. That agrees with my o

Re: [R] Transferring results from R to MS Word

2008-10-27 Thread Liviu Andronic
On Mon, Oct 27, 2008 at 8:16 PM, Liviu Andronic <[EMAIL PROTECTED]> wrote: > On Mon, Oct 27, 2008 at 7:32 PM, Greg Snow <[EMAIL PROTECTED]> wrote: >> Another alternative (since you asked) is the RExcel project >> (http://rcom.univie.ac.at). >> > I didn't perform much search, but is there anything

Re: [R] Transferring results from R to MS Word

2008-10-27 Thread Liviu Andronic
Hello, On Mon, Oct 27, 2008 at 7:32 PM, Greg Snow <[EMAIL PROTECTED]> wrote: > Another alternative (since you asked) is the RExcel project > (http://rcom.univie.ac.at). > I didn't perform much search, but is there anything similar for OpenOffice or Gnumeric? Basically, is there a cross-platform R

Re: [R] Transferring results from R to MS Word

2008-10-27 Thread Greg Snow
To: [EMAIL PROTECTED] > Subject: Re: [R] Transferring results from R to MS Word > > To reply to myself, for anything that can be coerced into a table > (matrices, vectors) the best solution seems to to use the write.table > () > function to write a .csv file, which is easily opened with a &g

Re: [R] Transferring results from R to MS Word

2008-10-27 Thread Greg Snow
Ph.D. Statistical Data Center Intermountain Healthcare [EMAIL PROTECTED] 801.408.8111 > -Original Message- > From: Tom Backer Johnsen [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 25, 2008 1:00 AM > To: Greg Snow > Cc: [EMAIL PROTECTED] > Subject: Re: [R] Transferring re

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Frank E Harrell Jr
Tom Backer Johnsen wrote: Frank E Harrell Jr wrote: Tom Backer Johnsen wrote: Frank E Harrell Jr wrote: Tom Backer Johnsen wrote: Frank E Harrell Jr wrote: Tom Backer Johnsen wrote: I hadn't thought of the 'different random sample' approach. That's neat. Frank Yes, I am quite proud of

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Tom Backer Johnsen
Hans-Peter Suter wrote: what about: ?write.xls from my xlsReadWrite package? Sorry, I did not even think to look for something along the lines of what the name of the package suggests. I'll have a look at it! Tom __ R-help@r-project.org mailing l

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Ben Bolker
[apologies if I messed up the quoting] Tom Backer Johnsen psych.uib.no> writes: > > Frank E Harrell Jr wrote > > > > I hope you'll keep the community posted on that. If you ever have a > > need for a function in R for linux that makes e-mailing easy, I have one. > > Now, that is interesting

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Tom Backer Johnsen
Gabor Grothendieck wrote: I have sent an email to the maintainer about it. Thanks! Tom __ 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

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Gabor Grothendieck
I have sent an email to the maintainer about it. On Sun, Oct 26, 2008 at 10:51 AM, Tom Backer Johnsen <[EMAIL PROTECTED]> wrote: > Gabor Grothendieck wrote: >> >> Seems there is a bug in one of the HTML methods in that digits= >> either does not get passed or used in certain cases. It does seem >

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Tom Backer Johnsen
Gabor Grothendieck wrote: Seems there is a bug in one of the HTML methods in that digits= either does not get passed or used in certain cases. It does seem that the HTML.data.frame method is not affected so this would be a workaround: HTML2clip(as.data.frame(mean(attitude)), digits = 10) Ah.

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Tom Backer Johnsen
Frank E Harrell Jr wrote: Tom Backer Johnsen wrote: Frank E Harrell Jr wrote: Tom Backer Johnsen wrote: Frank E Harrell Jr wrote: Tom Backer Johnsen wrote: I hadn't thought of the 'different random sample' approach. That's neat. Frank Yes, I am quite proud of that. The program that doe

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Gabor Grothendieck
Seems there is a bug in one of the HTML methods in that digits= either does not get passed or used in certain cases. It does seem that the HTML.data.frame method is not affected so this would be a workaround: HTML2clip(as.data.frame(mean(attitude)), digits = 10) On Sun, Oct 26, 2008 at 9:58 AM,

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Marc Schwartz
on 10/26/2008 08:58 AM Tom Backer Johnsen wrote: > To reply to myself, for anything that can be coerced into a table > (matrices, vectors) the best solution seems to to use the write.table () > function to write a .csv file, which is easily opened with a spreadsheet. > > The alternative is to use

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Tom Backer Johnsen
To reply to myself, for anything that can be coerced into a table (matrices, vectors) the best solution seems to to use the write.table () function to write a .csv file, which is easily opened with a spreadsheet. The alternative is to use the HTML2clip () function (or the HTML function) in the

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Tom Backer Johnsen
Frank E Harrell Jr wrote: Tom Backer Johnsen wrote: Frank E Harrell Jr wrote: Tom Backer Johnsen wrote: I hadn't thought of the 'different random sample' approach. That's neat. Frank Yes, I am quite proud of that. The program that does the sampling and mailing is called "Distras". Is

Re: [R] Transferring results from R to MS Word

2008-10-26 Thread Tom Backer Johnsen
Liviu Andronic wrote: On Sat, Oct 25, 2008 at 9:05 PM, Tom Backer Johnsen <[EMAIL PROTECTED]> wrote: I am a new user of R. My problem is how to read excel data files. How can I read a file called stock in R. What statement I should use? It could help to start learning R with a GUI like Rcmdr. A

Re: [R] Transferring results from R to MS Word

2008-10-25 Thread Liviu Andronic
On Sat, Oct 25, 2008 at 9:05 PM, Tom Backer Johnsen <[EMAIL PROTECTED]> wrote: >> I am a new user of R. My problem is how to read excel data files. >> How can I read a file called stock in R. What statement I should use? > It could help to start learning R with a GUI like Rcmdr. Among other feature

Re: [R] Transferring results from R to MS Word

2008-10-25 Thread Tom Backer Johnsen
Jasim Al-Ajmi wrote: Dear Tom I am a new user of R. My problem is how to read excel data files. How can I read a file called stock in R. What statement I should use? Thanks for your help. Thye simplest is to save your file as a .CSV file. This is a "plain text" file where the elements are sepa

Re: [R] Transferring results from R to MS Word

2008-10-25 Thread Tom Backer Johnsen
: [EMAIL PROTECTED] Subject: [R] Transferring results from R to MS Word R-users At the moment I am teaching a course on the use of R for data analysis. Part of course requirements involves the transfer of results from R to something that resembles the APA (American Psychological Associations) type table

Re: [R] Transferring results from R to MS Word

2008-10-25 Thread Frank E Harrell Jr
L PROTECTED] Subject: [R] Transferring results from R to MS Word R-users At the moment I am teaching a course on the use of R for data analysis. Part of course requirements involves the transfer of results from R to something that resembles the APA (American Psychological Associations) type tables

Re: [R] Transferring results from R to MS Word

2008-10-25 Thread Tom Backer Johnsen
Backer Johnsen Sent: Friday, October 24, 2008 1:31 PM To: [EMAIL PROTECTED] Subject: [R] Transferring results from R to MS Word R-users At the moment I am teaching a course on the use of R for data analysis. Part of course requirements involves the transfer of results from R to something that res

Re: [R] Transferring results from R to MS Word

2008-10-24 Thread Greg Snow
-Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > project.org] On Behalf Of Tom Backer Johnsen > Sent: Friday, October 24, 2008 1:31 PM > To: [EMAIL PROTECTED] > Subject: [R] Transferring results from R to MS Word > > R-users > > At the moment I

Re: [R] Transferring results from R to MS Word

2008-10-24 Thread Gabor Grothendieck
Try using gsubfn from the gsubfn package: # test data based on builtin iris data set mod <- summary(lm(Sepal.Length ~., iris)) library(R2HTML); library(gsubfn) HTML(mod, file = textConnection("out", "w")) out2 <- gsubfn("[0-9]+[.][0-9]+", ~ round(as.numeric(x), 2), out) cat(paste(out2, "\n"), "\

[R] Transferring results from R to MS Word

2008-10-24 Thread Tom Backer Johnsen
R-users At the moment I am teaching a course on the use of R for data analysis. Part of course requirements involves the transfer of results from R to something that resembles the APA (American Psychological Associations) type tables to MS Word. Until now I have used the HTML function in the