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 <jdugge1@yahoo.com>wrote:

> 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 investigating odbcConnectExcel
> but
> did not yet see such capability.
>
>
> Appreciate your help.
>
> Jeevan
>
>
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O

	[[alternative HTML version deleted]]

