Re: [R] Excel files first row not being read

From: Vivek Subramanian <subramanian.vivek_at_gmail.com>
Date: Thu 16 Jun 2005 - 21:00:45 EST

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 <0034058@fudan.edu.cn> 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 <subramanian.vivek@gmail.com> 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 Received on Thu Jun 16 21:07:18 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:43 EST