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\\FELIPEPARRA\\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/CurvaLIBOR.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
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/
Hi Luis, Take a look at http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows for some ideas. HTH, Jorge On Tue, Feb 23, 2010 at 3:06 PM, Luis Felipe Parra <> wrote:> 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 > > ______________________________________________ > 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. > >[[alternative HTML version deleted]]