Re: [R] number of Excel worksheets

2012-05-08 Thread Gabor Grothendieck
On Mon, May 7, 2012 at 8:54 PM, Santosh wrote: > Hello experts!! > I apologize for posting SPlus related query here..badly in need of relevant > info.. > > I usually use R (and your advice/tips) for my daily work. Was wondering if > there is an equivalent of "sheetCount" of the package "gdata" ava

Re: [R] number of Excel worksheets

2012-05-07 Thread William Dunlap
re wdunlap tibco.com > -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On > Behalf > Of Santosh > Sent: Monday, May 07, 2012 5:54 PM > To: r-help@r-project.org > Subject: Re: [R] number of Excel worksheets > > Hell

Re: [R] number of Excel worksheets

2012-05-07 Thread Santosh
Hello experts!! I apologize for posting SPlus related query here..badly in need of relevant info.. I usually use R (and your advice/tips) for my daily work. Was wondering if there is an equivalent of "sheetCount" of the package "gdata" avaailable in Splus 8.2? I would like to get the total number

Re: [R] number of Excel worksheets

2010-02-05 Thread Kevin Wright
Sorry, I thought the code was clear, but probably not. As far as I know, the "gdata" package requires perl. My read.xls function requires RODBC. If you don't have perl, my function works well, but if you have perl, the gdata package can do a better job of reading mixed-type (character/numeric)

Re: [R] number of Excel worksheets

2010-02-05 Thread Gabor Grothendieck
Yes. Get it from here: http://www.activestate.com/activeperl/ On Fri, Feb 5, 2010 at 10:10 AM, Gábor Pozsgai wrote: > Thank you both. > Gabor, do I need perl to be installed onj my computer to use those functions? > > Gabor > > 2010/2/5 Kevin Wright : >> I have a function to read xls files that

Re: [R] number of Excel worksheets

2010-02-05 Thread Steve_Friedman
Re: [R] number of Excel worksheets 02/05/2010 09:41 AM

Re: [R] number of Excel worksheets

2010-02-05 Thread Gábor Pozsgai
Thank you both. Gabor, do I need perl to be installed onj my computer to use those functions? Gabor 2010/2/5 Kevin Wright : > I have a function to read xls files that tells me the name of the available > sheets.  See below. > > Kevin Wright > > > read.xls = function (file, sheet, condition) > { >

Re: [R] number of Excel worksheets

2010-02-05 Thread Kevin Wright
I have a function to read xls files that tells me the name of the available sheets. See below. Kevin Wright read.xls = function (file, sheet, condition) { if (missing(file)) stop("No file specified.") if (!file.exists(file)) stop("File ", file, " does not exist in direct

Re: [R] number of Excel worksheets

2010-02-05 Thread Gabor Grothendieck
See ?sheetCount and ?sheetNames in the gdata package. On Fri, Feb 5, 2010 at 9:13 AM, Gábor Pozsgai wrote: > Dear All, > > I would like to count or list the names of the existing worksheets > within an .xls file. Any hints? > > Thaks, > > Gabor > > -- > Pozsgai Gábor > www.coleoptera.hu > www.pho

[R] number of Excel worksheets

2010-02-05 Thread Gábor Pozsgai
Dear All, I would like to count or list the names of the existing worksheets within an .xls file. Any hints? Thaks, Gabor -- Pozsgai Gábor www.coleoptera.hu www.photogabor.com __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinf