[R] Excel files first row not being read

John Considine vinum at iinet.net.au
Thu Jun 16 13:51:45 CEST 2005


Hi Vivek,

I'm sure there must be an elegant way to interface R w ODBC connections, but
I find it simplest to create a macro in Access that exports the data (based
on a query or table) to a csv file, then use the R function read.csv() in
which you can specify header=FALSE if you wish. I've used the importData
function in S+, which can import directly from an access database, but the
two step process in R is quicker. Excel is pretty limiting if you have lots
of data.

JC Considine 

> -----Original Message-----
> From: r-help-bounces at stat.math.ethz.ch 
> [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Vivek 
> Subramanian
> Sent: Thursday, 16 June 2005 19:01
> To: ronggui; rhelp
> Subject: Re: [R] Excel files first row not being read
> 
> 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
> >
> 
> ______________________________________________
> 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