Java Mailing List Archive

http://www.r-help.com/

Home » Home (12/2007) » R Help for Statistical Computing »

Re: [R] importing excel-file

Hans-Peter

2007-04-19

Replies:

2007/4/18, Alberto Monteiro <albmont@(protected)>:
> 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")

> This works in most cases.
          ~~~~~~~~~~~~
Huu? (the package is supposed to work in *all* cases...!). Do you use
the newest version (v1.3.1 or v1.3.2)? If there are any bugs/issues,
please report them to me and they - most likely - will get fixed.

--
Regards,
Hans-Peter
(author of xlsReadWrite)

______________________________________________
R-help@(protected)
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.
©2008 r-help.com - Jax Systems, LLC, U.S.A.