[R] read.xls problem

From: Knut Krueger <rh_at_family-krueger.com>
Date: Wed, 27 Jun 2007 21:15:22 +0200


Hi to all,
I have a strange problem
There was a Excel file with 5 sheets
I deleted sheet 2 and 4.
as all the times before I tried to read the sheets with data1<- read.xls(excelfile_2,sheet=1, as.is = TRUE ,verbose=FALSE, perl="C:/perl/bin/perl.exe")
data2<- read.xls(excelfile_2,sheet=2, as.is = TRUE ,verbose=FALSE, perl="C:/perl/bin/perl.exe")
data3<- read.xls(excelfile_2,sheet=3, as.is = TRUE ,verbose=FALSE, perl="C:/perl/bin/perl.exe")

but only the folloing code reads the sheets well data1<- read.xls(excelfile_2,sheet=1, as.is = TRUE ,verbose=FALSE, perl="C:/perl/bin/perl.exe")
data3<- read.xls(excelfile_2,sheet=3, as.is = TRUE ,verbose=FALSE, perl="C:/perl/bin/perl.exe")
data5<- read.xls(excelfile_2,sheet=5, as.is = TRUE ,verbose=FALSE, perl="C:/perl/bin/perl.exe")

Does anybody know whether this is normal?  I never had this problem before. And if it is normal I wonder about how to find the sheet numbers

Regards Knut



R-help_at_stat.math.ethz.ch 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. Received on Wed 27 Jun 2007 - 19:24:03 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 27 Jun 2007 - 19:32:25 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.