Displaying 2 results from an estimated 2 matches for "readnamedregion".
2011 Aug 12
1
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 an...
2011 Sep 15
2
Reading Parts of Excel Files (within a sheet)
Dear R Users,
I have to read data from many excel spreadsheets, all which have some
frustrating formatting (lots of titles, headers, etc.). I am trying
to work directly from source data and the number of the spreadsheets I
would have to go through make reformatting one by one a pain. I have
found lots of ways to read excel files, but my question is whether
there is a way to only read