[R] Reading Parts of Excel Files (within a sheet)

Martin Studer martin.remo.studer at gmail.com
Thu Sep 29 17:04:11 CEST 2011


Hi Peter,

the readWorksheet function of the XLConnect package seems to do what you are
looking for. It has arguments startRow, startCol, endRow & endCol.
Alternatively, you could define a named region in Excel that encompasses the
data that you are interested in. Then you can use the readNamedRegion method
to read only the defined range.

Best regards,
Martin Studer

--
View this message in context: http://r.789695.n4.nabble.com/Reading-Parts-of-Excel-Files-within-a-sheet-tp3814447p3856138.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list