[R] importing excel-file

Alberto Monteiro albmont at centroin.com.br
Thu Apr 19 13:17:53 CEST 2007


Hans-Peter wrote:
>
>> Method 2:
>> This method uses library xlsReadWrite. You must know the index
>> of the spreadsheet that you want to load:
>> plan6 <- read.xls(filename, sheet = 6, colClasses="double")
> 
> it works with the sheet name too! You can write:
> plan6 <- read.xls(filename, sheet = "sheet name", colClasses="double")
>
Ok, it works.
 
>> This works in most cases.
>                ~~~~~~~~~~~~
> Huu? (the package is supposed to work in *all* cases...!).
>
Yes, but I did not test *all* cases to make such a strong
assertion O:-)

> Do you use
> the newest version (v1.3.1 or v1.3.2)? 
>
No, I was using 1.1.1

> If there are any bugs/issues,
> please report them to me and they - most likely - will get fixed.
> 
Ok - I will do it.

Thanks.

Alberto Monteiro



More information about the R-help mailing list