Re: [R] Problems loading xlsx
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
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
> 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?
__
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.
Re: [R] Problems loading xlsx
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 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
> 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
> > 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.
Re: [R] Problems loading xlsx
On Nov 7, 2013, at 12:55 PM, Barrett Gady wrote: > does anyone know how to resolve Error: .onLoad failed in loadNamespace() for > ‘xlsxjars’ > > I can’t seem to get this package to load on my windows 7 install of R3.02 It appears that you did not install all the depndencies for package xlsx. http://cran.r-project.org/web/packages/xlsx/index.html -- David Winsemius Alameda, CA, USA __ 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.
