[R] Import range of cells from Excel

Petr Pikal petr.pikal at precheza.cz
Tue Mar 2 14:02:30 CET 2004


Hi

What about to copy a range, paste it to notepad, save it as a *.txt 
file and read with read.delim().

Cheers
Petr

On 2 Mar 2004 at 10:10, Jean-Noel wrote:

> Dear all,
> I would like to import a range of cells (e.g. F10:K234) from an Excel
> worksheet to R. I have looked for documentation on RODBC and
> RDCOMClient but I was not able to find enough information to solve my
> problem and all the examples I have seen were dealing with an entire
> worksheet, not a range of cells. Thanks,
> 
> Jean-Noel
> 
> Jean-Noel Candau
> INRA - Unité de Recherches Forestičres Méditerranéennes
> Avenue A. Vivaldi
> 84000 AVIGNON
> Tel: (33) 4 90 13 59 22
> Fax: (33) 4 90 13 59 59
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html

Petr Pikal
petr.pikal at precheza.cz




More information about the R-help mailing list