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
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
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
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)
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
02/05/2010 09:41
AM
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)
> {
>
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
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
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
10 matches
Mail list logo