[R] Excel files first row not being read

[Vivek Subramanian]

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 at 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 at 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 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
>