[R] Importing a file to r

[John Kane]

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.parra at quantil.com.co> wrote:

> From: Luis Felipe Parra <felipe.parra at quantil.com.co>
> Subject: [R] Importing a file to r
> To: r-help at 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 at 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/