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

[Gabor Grothendieck]

On Fri, Aug 12, 2011 at 3:15 AM, christiaan pauw <cjpauw at gmail.com> 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