I've never tried reading in an Excel file. I usually just export the file as a
csv file and read it in using read.csv().
--- On Tue, 2/23/10, Luis Felipe Parra <felipe.pa...@quantil.com.co> wrote:
> From: Luis Felipe Parra <felipe.pa...@quantil.com.co>
> Subject: [R] Importing a file to r
> To: r-help@r-project.org
> Received: Tuesday, February 23, 2010, 3:06 PM
> Hello
>
> I am trying to import the attached file Curva LIBOR to R. I
> am trying to use
> the following commands and obtaining the following errors
>
> > res <- read.xlsx("C:\\Users\\FELIPE
> PARRA\\Documents\\Quantil\\Federacion\\Curva LIBOR.xlsx",
> 4)
> Error en .jcall(rowCells[[ic]], "I", "getColumnIndex") :
> RcallMethod: invalid object parameter
> > res <- read.xlsx("C:/Users/FELIPE
> PARRA/Documents/Quantil/Federacion/Curva
> LIBOR.xlsx", 4)
> Error en .jcall(rowCells[[ic]], "I", "getColumnIndex") :
> RcallMethod: invalid object parameter
>
> > res <- read.xlsx(file, sheetName="LIBORSWAP")
> Error en .jcall(rowCells[[ic]], "I", "getColumnIndex") :
> RcallMethod: invalid object parameter
>
> does anybody knows what does this error means? Or do you
> have nay idea what
> is a good way of importing big EXCEL files to R. Thank you
>
> Felipe Parra
>
> -----Inline Attachment Follows-----
>
> ______________________________________________
> R-help@r-project.org
> 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.
>
__________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr!
http://www.flickr.com/gift/
______________________________________________
R-help@r-project.org 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.
