Re: [R] Extract named regions from an Excel file using XLConnect?

[Gabor Grothendieck]

On Fri, Aug 12, 2011 at 3:15 AM, christiaan pauw  wrote:
> Hi Everybody
>
> In R, the XLConnect package can read and write named region to and from
> Excel. In order to read a named region with the readNamedRegion function you
> need to know it's name. You can check is a name exists with existsName, but
> you still have to know the name. Is there a way to actually get a list of
> the named regions in XLConnect sinilar to getRanges in the xlsx package.

See ?getDefinedNames

This lists various R packages that read and/or write Excel files:
http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=excel

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] Extract named regions from an Excel file using XLConnect?

[christiaan pauw]

Hi Everybody

In R, the XLConnect package can read and write named region to and from
Excel. In order to read a named region with the readNamedRegion function you
need to know it's name. You can check is a name exists with existsName, but
you still have to know the name. Is there a way to actually get a list of
the named regions in XLConnect sinilar to getRanges in the xlsx package.

On that point: what is the difference between XLConnect and xlsx and when
should you use which?

regards
Christiaan

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.