{"id":901,"date":"2016-02-01T04:10:45","date_gmt":"2016-02-01T11:10:45","guid":{"rendered":"http:\/\/homepages.uc.edu\/~yaozo\/wordpress\/?p=901"},"modified":"2022-11-22T05:14:25","modified_gmt":"2022-11-22T05:14:25","slug":"rjava-in-rstudio-windows-and-library-xlsx","status":"publish","type":"post","link":"https:\/\/zhuoyao.net\/index.php\/2016\/02\/01\/rjava-in-rstudio-windows-and-library-xlsx\/","title":{"rendered":"rJava in RStudio, Windows, and library xlsx"},"content":{"rendered":"
\n
\n

This post is intended for users attempting to use the XLSX package in the Windows version of RStudio. I am using RStudio 0.98, R 3.1.2, Java 1.8.31 (all 64-bit).<\/p>\n

I’m assuming you have R and RStudio installed, and have attempted to use the xlsx package in order to import data from the Microsoft Excel format. When I attempted to load this package, I get an error like this:<\/p>\n

> library(\"xlsx\", lib.loc=\"~\/R\/win-library\/3.1\")\nLoading required package: rJava\nError : .onLoad failed in loadNamespace() for 'rJava', details:\n  call: inDL(x, as.logical(local), as.logical(now), ...)\n  error: unable to load shared object 'C:\/Users\/Charles\/Documents\/R\/win-library\/3.1\/rJava\/libs\/x64\/rJava.dll':\n  LoadLibrary failure:  The specified module could not be found.\n\nError: package \u2018rJava\u2019 could not be loaded<\/pre>\n
First; make sure you have the 64-bit edition of Java installed. This solved the issue on my girlfriends computer, but not mine.<\/p>\n
This nearly useless error message is due to the fact the system can’t locate jvm.dll. My solution was to append “;C:\\Program Files\\Java\\jre1.8.0_31\\bin;C:\\Program Files\\Java\\jre1.8.0_31\\bin\\server” to my path variable. You *may* need to adjust that path if you’re using a different version of Java, but I’ll leave finding that to you (and if you don’t have Java installed, try that first).<\/p>\n
\nTHESE INSTRUCTIONS ARE FOR 64-BIT VERSION OF ALL SOFTWARE<\/h3>\n
Adding to the PATH variable<\/h2>\n
Open the “System” panel by hitting the windows key and pause|break at the same time (or right clicking on my computer->properties in Windows 7, or right clicking on the windows icon at the bottom left->system in Windows 8), then open “Advanced System Settings”<\/p>\n
\"System<\/p>\n
In the System Properties window, go to the Advanced Tab, then click the “Environment Variables” button<\/p>\n
\"Advanced<\/p>\n
Search for the “Path” variable in the lower panel, the click edit<\/p>\n
\"Edit<\/p>\n
And finally, append “;C:\\Program Files\\Java\\jre1.8.0_31\\bin;C:\\Program Files\\Java\\jre1.8.0_31\\bin\\server” to the path and click OK<\/p>\n
\"Append<\/p>\n
And finally, relaunch RStudio. You should now be able to load the packages!<\/p>\n<\/div>\n<\/div>\n
\n
Tags<\/strong> : r<\/a> rstudio<\/a> windows<\/a><\/p>\n
Short url<\/strong> : http:\/\/logrit.com\/weblog\/18\/<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
This post is intended for users attempting to use the XLSX package in the Windows version of RStudio. I am using RStudio 0.98, R 3.1.2,… <\/p>\n","protected":false},"author":1,"featured_media":958,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-901","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-r"],"_links":{"self":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/comments?post=901"}],"version-history":[{"count":1,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/901\/revisions"}],"predecessor-version":[{"id":959,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/901\/revisions\/959"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/media\/958"}],"wp:attachment":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/media?parent=901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/categories?post=901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/tags?post=901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}