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

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Fri 17 Jun 2005 - 13:01:18 EST

Antoher non-OBDC solution is to get the information from Excel using Microsoft COM objects. Look into

  1. the RDCOM package on CRAN, or
  2. the rcom package, rcom_1.0-1.zip, at: http://sunsite.univie.ac.at/rcom/download/ The rcom package has a mailing list at: http://mailman.csd.univie.ac.at/pipermail/rcom-l/

On 6/16/05, John Considine <vinum@iinet.net.au> wrote:
> 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@stat.math.ethz.ch
> > [mailto:r-help-bounces@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@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
> >
>
> ______________________________________________
> 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 Fri Jun 17 13:05:53 2005

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