christiaan pauw
2011-Aug-12 07:15 UTC
[R] Extract named regions from an Excel file using XLConnect?
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]]
Gabor Grothendieck
2011-Aug-12 11:53 UTC
[R] Extract named regions from an Excel file using XLConnect?
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