An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20121016/8f8d7265/attachment.pl>
Problems with xlsx and rjava
4 messages · Lopez, Dan, Rui Barradas, Ivan Calandra
Hello, I cannot answer directly to your question, but I had problems with package xlsx and for what I've seen on R-Help so had others. Maybe you are using the wrong architecture of R (32/64 bits). Package XLConnect is more flexible and a bit more complex, but it comes with a vignette that explains how to use it. Hope this helps, Rui Barradas Em 16-10-2012 18:57, Lopez, Dan escreveu:
Hi, I keep getting the below error regarding rJava which is required by package xlsx (I have used it in the past to directly import data from Excel 2010). I was on R version 2.15.0 when I was getting this error this morning. So I upgraded to 2.15.1 but still the same problem. I tried unstalling and reinstalling xlsx and even rJava directly from the source as indicated here: http://stackoverflow.com/questions/7019912/using-the-rjava-package-on-win7-64-bit-with-r Where it says: install rJava 0.9.2. rJava.dll is located in the file path indicated by the error message below. Not sure why it's now saying "The specified path is invalid" Does anyone now the fix to this problem?
library(xlsx)
Loading required package: xlsxjars Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'rJava', details: call: inDL(x, as.logical(local), as.logical(now), ...) error: unable to load shared object 'C:/R/R-2.15.1/library/rJava/libs/i386/rJava.dll': LoadLibrary failure: The specified path is invalid. Daniel Lopez Workforce Analyst HRIM - Workforce Analytics & Metrics Strategic Human Resources Management wf-analytics-metrics at lists.llnl.gov<mailto:wf-analytics-metrics at lists.llnl.gov> (925) 422-0814 [[alternative HTML version deleted]]
______________________________________________ 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.
I don't have any problem with xlsx/rJava: > library(xlsx) Le chargement a n?cessit? le package : xlsxjars Le chargement a n?cessit? le package : rJava > sessionInfo() R version 2.15.1 (2012-06-22) Platform: i386-apple-darwin9.8.0/i386 (32-bit) locale: [1] fr_FR.UTF-8/fr_FR.UTF-8/fr_FR.UTF-8/C/fr_FR.UTF-8/fr_FR.UTF-8 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] xlsx_0.5.0 xlsxjars_0.4.0 rJava_0.9-3 Is it then a Windows problem? Ivan -- Ivan CALANDRA Universit? de Bourgogne UMR CNRS/uB 6282 Biog?osciences 6 Boulevard Gabriel 21000 Dijon, FRANCE +33(0)3.80.39.63.06 ivan.calandra at u-bourgogne.fr http://biogeosciences.u-bourgogne.fr/calandra Le 16/10/12 20:16, Rui Barradas a ?crit :
Hello, I cannot answer directly to your question, but I had problems with package xlsx and for what I've seen on R-Help so had others. Maybe you are using the wrong architecture of R (32/64 bits). Package XLConnect is more flexible and a bit more complex, but it comes with a vignette that explains how to use it. Hope this helps, Rui Barradas Em 16-10-2012 18:57, Lopez, Dan escreveu:
Hi, I keep getting the below error regarding rJava which is required by package xlsx (I have used it in the past to directly import data from Excel 2010). I was on R version 2.15.0 when I was getting this error this morning. So I upgraded to 2.15.1 but still the same problem. I tried unstalling and reinstalling xlsx and even rJava directly from the source as indicated here: http://stackoverflow.com/questions/7019912/using-the-rjava-package-on-win7-64-bit-with-r Where it says: install rJava 0.9.2. rJava.dll is located in the file path indicated by the error message below. Not sure why it's now saying "The specified path is invalid" Does anyone now the fix to this problem?
library(xlsx)
Loading required package: xlsxjars
Loading required package: rJava
Error : .onLoad failed in loadNamespace() for 'rJava', details:
call: inDL(x, as.logical(local), as.logical(now), ...)
error: unable to load shared object
'C:/R/R-2.15.1/library/rJava/libs/i386/rJava.dll':
LoadLibrary failure: The specified path is invalid.
Daniel Lopez
Workforce Analyst
HRIM - Workforce Analytics & Metrics
Strategic Human Resources Management
wf-analytics-metrics at lists.llnl.gov<mailto:wf-analytics-metrics at lists.llnl.gov>
(925) 422-0814
[[alternative HTML version deleted]]
______________________________________________ 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.
______________________________________________ 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.
Hi Rui, I started using package gdata instead. But the day I need to write back to I .xlsx I will plan to use XLConnect. I started reading the vignette and it didn't sound too bad. I like it. Thanks. Dan -----Original Message----- From: Rui Barradas [mailto:ruipbarradas at sapo.pt] Sent: Tuesday, October 16, 2012 11:16 AM To: Lopez, Dan Cc: R help (r-help at r-project.org) Subject: Re: [R] Problems with xlsx and rjava Hello, I cannot answer directly to your question, but I had problems with package xlsx and for what I've seen on R-Help so had others. Maybe you are using the wrong architecture of R (32/64 bits). Package XLConnect is more flexible and a bit more complex, but it comes with a vignette that explains how to use it. Hope this helps, Rui Barradas Em 16-10-2012 18:57, Lopez, Dan escreveu:
Hi, I keep getting the below error regarding rJava which is required by package xlsx (I have used it in the past to directly import data from Excel 2010). I was on R version 2.15.0 when I was getting this error this morning. So I upgraded to 2.15.1 but still the same problem. I tried unstalling and reinstalling xlsx and even rJava directly from the source as indicated here: http://stackoverflow.com/questions/7019912/using-the-rjava-package-on-win7-64-bit-with-r Where it says: install rJava 0.9.2. rJava.dll is located in the file path indicated by the error message below. Not sure why it's now saying "The specified path is invalid" Does anyone now the fix to this problem?
library(xlsx)
Loading required package: xlsxjars Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'rJava', details: call: inDL(x, as.logical(local), as.logical(now), ...) error: unable to load shared object 'C:/R/R-2.15.1/library/rJava/libs/i386/rJava.dll': LoadLibrary failure: The specified path is invalid. Daniel Lopez Workforce Analyst HRIM - Workforce Analytics & Metrics Strategic Human Resources Management wf-analytics-metrics at lists.llnl.gov<mailto:wf-analytics-metrics at lists. llnl.gov> (925) 422-0814 [[alternative HTML version deleted]]
______________________________________________ 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.