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 <jdug...@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]]
______________________________________________
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.
