[R] Is it possible to create highly customized report in *.xlsformat by using R/S+?
Whit Armstrong
whit at twinfieldscapital.com
Wed Jul 20 17:27:29 CEST 2005
I have a package which I use to create excel files from R.
I have not been able to produce a configure script general enough for me
to post it to cran, but I will send it to you if you like.
I use it for production jobs on our linux servers. You may have to
tinker a bit to get it to compile on windows.
Have a look at the examples below. If it suits your needs, I will send
it to you.
Cheers,
Whit
Here are the examples from the help page:
nc <- 4
nr <- 20
x <- matrix(rnorm(nc*nr),ncol=nc,nrow=nr)
rownames(x) <- rep(letters,length=nr)
colnames(x) <- rep(letters,length=nc)
# write a matrix
write.xls(x,"matrixFromR.xls","matrix")
write.xls(x,"matrixFromR.no.colnms.xls","matrix",writeColNms=FALSE)
write.xls(x,"matrix.no.rownms.xls","matrix",writeRowNms=FALSE)
write.xls(x,"matrix.no.nms.xls","matrix",writeColNms=FALSE,writeRowNms=F
ALSE)
# add some formats
write.xls(x,"matrixFromR_formatted.xls","matrix",formats=rep("0.0",nc))
write.xls(x,"matrixFromR_formatted2.xls","matrix",formats=rep(c("0.0","0
"),nc/2))
write.xls(x,"matrixFromR_formatted3.xls","matrix",formats=rep("#,##0.0;[
Red]#-##0.0;\"\"",nc))
write.xls(x[,1],"vectorFromR.xls","vector")
write.xls(x[,1],"vectorFromR.no.colnms.xls","vector",writeColNms=FALSE)
write.xls(x[,1],"vectorFromR.no.rownms.xls","vector",writeRowNms=FALSE)
write.xls(x[,1],"vectorFromR.no.nms.xls","vector",writeColNms=FALSE,writ
eRowNms=FALSE)
# char data test
y <- matrix(rep(letters,each=26),ncol=26)
rownames(y) <- rep(letters,length=26)
colnames(y) <- rep(letters,length=26)
write.xls(y,"char.data.xls","alphabet")
# logical data test
z <- matrix(as.logical(round(runif(nc*nr),0)),ncol=nc)
rownames(z) <- rep(letters,length=nr)
colnames(z) <- rep(letters,length=nc)
write.xls(z,"logical.data.xls","myLogic")
write.xls(z[,1],"logical.data.vector.xls","myLogicVector")
-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch
[mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Wensui Liu
Sent: Wednesday, July 20, 2005 10:56 AM
To: Greg Snow
Cc: r-help at stat.math.ethz.ch
Subject: Re: [R] Is it possible to create highly customized report in
*.xlsformat by using R/S+?
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 <greg.snow at ihc.com> 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
> greg.snow at ihc.com
> (801) 408-8111
>
> >>> Wensui Liu <liuwensui at gmail.com> 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 at 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 at 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
More information about the R-help
mailing list