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

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 readNamedRegi

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

I haven't used it, but I believe the XLConnect package allows for control on a cell-by-cell basis. Check out the extensive example given here: http://www.r-bloggers.com/xlconnect-%E2%80%93-a-platform-independent-interface-to-excel/ Hope this helps, Michael Weylandt On Wed, Sep 14, 2011 at 8:43 P

[R] 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 foun