Re: [R] Read Particular Cells within Excel

Try this: library(RDCOMClient) xl <- COMCreate("Excel.Application") wk <- xl$Workbooks()$Open("Book1.xlsx") do.call(cbind, wk$Sheets(1)$Range("B50:C55")$Value()) On Tue, Oct 12, 2010 at 9:17 PM, Jeevan Duggempudi wrote: > Hello all, > > I have a business user who generates monthly reports in M

Re: [R] Read Particular Cells within Excel

evan Duggempudi > Sent: Tuesday, October 12, 2010 6:17 PM > To: r-help@r-project.org > Subject: [R] Read Particular Cells within Excel > > Hello all, > > I have a business user who generates monthly reports in MS Excel in a > particular > format. The data I need is pres

[R] Read Particular Cells within Excel

Hello all, I have a business user who generates monthly reports in MS Excel in a particular format. The data I need is present in different portions of this excel file. Is there a way to read different cells from a particular excel worksheet? i.e., cells b50:d100 in the Inputs worksheet. I am