[R] Re ading Excel 5.0 files with RODBC?

Hi, i'm trying to read some data from excel files but it seems that neither xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0). When i open the file in Excel and save it in a new format Excel 97 -2003 everything works fine. Is it possible to use ODBC connection to open old for

[R] Annotation rgl plot

Hi, i was wondering if there is a way to annotate rgl plot, after searching i haven't found anything suitable. I saw function text3d but was thinking more about text on the margin, so not interactive. Thanks -- View this message in context: http://www.nabble.com/Annotation-rgl-plot-tp22930428p

Re: [R] Re ading Excel 5.0 files with RODBC?

>If you have a version of Excel that will do all those things, then you >should be able to write a very short VBA macro that will do it. >Undoubtedly simpler than the route you are proposing. Thanks for reply David, i was thinking about going this route, the problem is i will have to do it o

Re: [R] Re ading Excel 5.0 files with RODBC?

Thanks for reply David, but the problem is that the place i get those files from saves them in the old Excel format (Excel 5.0), not Excel 97-2003, so neither of the packages (RODBC, xlsReadWrite) can read it. >Your question is a bit confusing. This is the current state of play >regarding read

Re: [R] Annotation rgl plot

Thanks for a great package Duncan, one of the most amazing things i saw for R platform. In the meanwhile i can do with you suggestion: par3d(ignoreExtent=TRUE); -- View this message in context: http://www.nabble.com/Annotation-rgl-plot-tp22930428p22945459.html Sent from the R help mailing list

Re: [R] Re ading Excel 5.0 files with RODBC?

DBC with no problems so the problem has to be with the way original xls files are created. Thanks a lot for all replies. Prof Brian Ripley wrote: > > On Wed, 8 Apr 2009, Yuri Volchik wrote: > >> >> Thanks for reply David, >> >> but the problem is that the place

[R] Numeric data calculated in bwplot

Hi, i was wondering if there is a way to extract statistic calculated by the function bwplot in numeric format, i.e. a list with values of borders mean etc. Going through the help i couldn't find it, and text of the function itself(bwplot) is very long. Thanks -- View this message in context:

[R] ftp directory

Hi, is it possible to get content of ftp directory similar to for local files? Directory is password protected. Thanks -- View this message in context: http://www.nabble.com/ftp-directory-tp18368309p18368309.html Sent from the R help mailing list archive at Nabble.com. _

[R] Rows assignment

Hi to all members, i encountered a weird problem when trying to assign subset of rows in a matrix. Simple example works fine: z<-matrix(NA,ncol=3,nrow=10) z[,1]<-1:10 y<-matrix(1:30,ncol=3,nrow=10) y[,1]<-5:14 z[z[,1]%in%y[,1],2]<-y[y[,1]%in%z[,1],2] z z[z[,1]%in%y[,1],]<-y[y[,1]%in%z[,1],] z W

[R] FW: R memory management

Hi, I'm using R to collect data for a number of exchanges through a socket connection and constantly running into memory problems even though task I believe is not that memory consuming. I guess there is a miscommunication between R and WinXP about freeing up memory. So this is the code: f

[R] Passing function to tapply as a string

Hi, Was wondering if it is possible to pass function name as a parameter, smth along this line param.to.pass<-c(1,'max','h') dd<-function(dfd, param=param.to.pass,...){ ttime.int <- format(ttime,fmt) data.frame( param[3] = tapply(dfd[,param[1]],ttime.int,param[3]), ...) }

Re: [R] Passing function to tapply as a string

Thanks, match.fun is what i was looking for :-) Or perhaps: myfun <- function(fname, ...)match.fun(fname)(...) On 07/03/2008, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Was wondering if it is possible to pass function name as a parameter -- View this message in context: http://w

[R] Methods dispatch and inheritance R.oo

Hi to all members, i have a question about class inheritance and methods using R.oo package: I have the following code and it doesn't work, guess i'm doing smth wrong and there is nothing in the help. library(R.oo) setConstructorS3("ClassA", function(A=15) { extend(Object(), "ClassA", .s

Re: [R] Methods dispatch and inheritance R.oo

Thanks for reply Henrik, seems obvious now. Can child class (B) access argument of the parent class, i.e. can i rewrite definition of the class B as setConstructorS3("ClassB", function() { extend(ClassA(), "ClassB", .size2 = A ); }) it didn't work for me, so guess i'm doing smth wrong an

[R] Getting a static copy of the object using R.oo

Hi to all, probably question is to Henrik Bengtsson but may be others can help as well. I have an object of "Class A" with fields which are being changed (updating) dynamically in a loop. I would like to keep all iterations of the object in a list, but when i'm trying to do it i get a reference t