When you are forced to use excel (but want to really use R and just give the result to others in excel), then there are a few options depending on what you are trying to do. We may be able to give better help if you can give a specific problem you are trying to solve.
Some Ideas: To quickly copy data from excel (highlight a region in excel and choose copy then:) mydata <- read.delim(file('clipboard')) to send a dataframe or matrix to excel: write.table(mydata, file('clipboard'), sep="\t") (now switch to excel, select a cell and choose paste). You can also look at the RODBC package for other ways to transfer information back and forth between R and excel. For more complicated output you may want to look at the R2HTML package or the LaTeX functions in Hmisc and other packages (then use a latex to rtf converter so you end users can read the output in word or copy it over to latex). Another place to look is:http://cran.us.r-project.org/contrib/extra/dcom/RSrv135.html This has examples of building functions in excel that will take the data from excel, analyze it in R, then bring the results back to excel. More detail on what you are trying to do would help us help you. Greg Snow, Ph.D. Statistical Data Center, LDS Hospital Intermountain Health Care [EMAIL PROTECTED] (801) 408-8111 >>> Wensui Liu <[EMAIL PROTECTED]> 07/20/05 08:55AM >>> I appreciate your reply and understand your point completely. But at times we can't change the rule, the only choice is to follow the rule. Most deliverables in my work are in excel format. On 7/20/05, Greg Snow <[EMAIL PROTECTED]> wrote: > See: > > http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html > and > http://www.stat.uiowa.edu/~jcryer/JSMTalk2001.pdf > > Greg Snow, Ph.D. > Statistical Data Center, LDS Hospital > Intermountain Health Care > [EMAIL PROTECTED] > (801) 408-8111 > > >>> Wensui Liu <[EMAIL PROTECTED]> 07/19/05 03:22PM >>> > I remember in one slide of Prof. Ripley's presentation overhead, he > said the most popular data analysis software is excel. > > So is there any resource or tutorial on this topic? > > Thank you so much! > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > > -- WenSui Liu, MS MA Senior Decision Support Analyst Division of Health Policy and Clinical Effectiveness Cincinnati Children Hospital Medical Center ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html