Thanks Jim that is my second best option but would hope to get xlsx working as it seems a more coveninet fit to xlsx files
Paolo On 15 November 2010 00:12, jim holtman <jholt...@gmail.com> wrote: > If you are running on WIndows, I would suggest that you use the RODBC > package and the "odbcConnectExcel2007" function. I have had > reasonable success with this. > > On Sun, Nov 14, 2010 at 3:23 PM, Paolo Rossi > <statmailingli...@googlemail.com> wrote: > > Hi all, > > > > I am trying to run the package xlsx to read Excel 2007 files and I am > > getting the error below. > > > >> library(xlsx) > > Loading required package: xlsxjars > > Loading required package: rJava > > Error : .onLoad failed in loadNamespace() for 'xlsxjars', details: > > call: .jinit() > > error: cannot obtain Class.getSimpleName method ID > > Error: package 'xlsxjars' could not be loaded > > > > By looking up this in the mailing list I have seen that it is an error > > related to the configuration of the path. > > I was also made aware that the path read into R gets truncated if it is > too > > long. To avoid any issue I have added the jre at the very beginning of > the > > path - see below > > > >> p = Sys.getenv("PATH") > >> strsplit(p,";") > > > > $PATH > > [1] "c:\\Program > > Files\\Java\\j2re1.4.2_06\\bin\\client\\" > > [2] "c:\\Program > > Files\\Java\\jre1.5.0_06\\bin\\client\\" > > [3] > > "c:\\oracle\\ora92\\bin\\" > > > > [4] > > "c:\\oracle\\ora92\\jre\\1.4.2\\bin\\" > > > > [5] > > "c:\\oracle\\ora92\\jre\\1.4.2\\bin\\client\\" > > > > [6] "c:\\program > > files\\oracle\\jre\\1.3.1\\bin\\" > > [7] > > "C:\\WINDOWS\\system32" > > > > [8] "C:\\WINDOWS" > > .... > > > > In the path variable the items have been pasted like this: > > c:\Program Files\Java\j2re1.4.2_06\bin\client\;c:\Program > > Files\Java\jre1.5.0_06\bin\client\; > > The issue still persists. > > > > Can you please help? > > > > Thanks > > > > Paolo > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > 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<http://www.r-project.org/posting-guide.html> > > and provide commented, minimal, self-contained, reproducible code. > > > > > > -- > Jim Holtman > Cincinnati, OH > +1 513 646 9390 > > What is the problem that you are trying to solve? > [[alternative HTML version deleted]] ______________________________________________ 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.