hi, the specifications for my application call that the input file be in excel only in the format i previously mentioned. now if the approach you mention has to be used then the part of converting has to be done automatically. this i found to be too complex.
an alternative to that was to use MS access databases. but again it is the problem of automating the conversion that is proving difficult regards and best vivek On 6/16/05, ronggui <[EMAIL PROTECTED]> wrote: > why not save the file as csv file(using the MS excel application) and use the > read.csv function in foreign library? > > On Thu, 16 Jun 2005 15:51:22 +0530 > Vivek Subramanian <[EMAIL PROTECTED]> wrote: > > > hi, > > > > i am using the RODBC package to read excel files using > > odbcConnectExcel and susequently sqlFetch to read the contents of the > > file. > > > > the file that i use is just a matrix of numbers thats all. no headers > > and column names. what happens is that the sqlFetch is not reading my > > first row of numbers. > > i have tried different combinations of colnames and rownames logical > > values but that first row is not being read into my data frame. > > > > i can manually set the first row to blanks in my worksheet, but since > > this is part of larger code where a user specifies a file to use this > > method is a little clumsy. > > > > i would be grateful if you help me get around this problem. > > > > regards, > > vivek > > > > ______________________________________________ > > 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 > ______________________________________________ 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