Hi all,

I'm trying to figure out how to import Excel files into R. I'm running Mac
10.6, and so far I've tried the xlsx and gdata packages; both gave error
messages.

For the xlsx package, here is what I got:

> library(xlsx)
> project.source = "/Users/vicki/Desktop/R/test/kdReport.xls" #change the
path and file name here
> PIGF.elisa.dat = read.xlsx (file=project.source, 1, header=T)
Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl,
: java.lang.IllegalArgumentException: Your InputStream was neither an OLE2
stream, nor an OOXML stream

For the gdata package, it said that gtools was required; when gtools
package was attempted to load, this error message resulted:

Error in loadNamespace(i[[1L]], c(lib.loc, .libPaths())) :
there is no package called ‘gtools’
In addition: Warning message:
package ‘gdata’ was built under R version 2.15.1
Error: package/namespace load failed for ‘gdata’

Does anyone know how to resolve either of these error messages, or if there
are better packages to interact with Excel files in R on a Mac? Thanks so
much.

Sincerely,
Victoria Xiao

	[[alternative HTML version deleted]]

