Displaying 1 result from an estimated 1 matches for "dmenezes".
Did you mean:
menezes
2011 Jun 14
3
Read in from multiple Excel wksheets
...part as a csv.
So far, I?ve tried using read.xlsx from the xlsx package. This works
fine for small test files ? e.g. suppose I?m trying to read from the
test_file workbook on my desktop. The following code extracts rows 1
and 2 from worksheet = ?johnny?.
setwd("C:\\Documents and Settings\\dmenezes\\Desktop")
info<-
read.xlsx("test_file.xlsx",sheetName="johnny",rowIndex=1:2,header=FALSE)
info
However, when I try to apply this to my real, large workbook, things
go wrong, with the following error message. Any ideas/workarounds?
Error in .jcall("RJavaTools&quo...