R Excel Out | david beaumont | 2016-09-06 12:35 |
Status: Closed | ||
Thank you Jon and Karl, I tried Karl's suggestion and recieved the following errors: When I tried: require(xlsx) write.xlsx(labkey.data, "${fileout:myExcelFile.xlsx}") I get: Error executing command javax.script.ScriptException: javax.script.ScriptException: An error occurred when running the script 'script.R', exit code: 1). Loading required package: xlsx Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'rJava', details: call: fun(libname, pkgname) error: JAVA_HOME cannot be determined from the Registry In addition: Warning messages: 1: package 'xlsx' was built under R version 3.2.3 2: package 'rJava' was built under R version 3.2.3 Failed with error: 'package 'rJava' could not be loaded' Error: could not find function "write.xlsx" Execution halted then tried: require(xlsx) require(rJava) write.xlsx(labkey.data, "${fileout:myExcelFile.xlsx}") and got: Error executing command javax.script.ScriptException: javax.script.ScriptException: An error occurred when running the script 'script.R', exit code: 1). Loading required package: xlsx Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'rJava', details: call: fun(libname, pkgname) error: JAVA_HOME cannot be determined from the Registry In addition: Warning messages: 1: package 'xlsx' was built under R version 3.2.3 2: package 'rJava' was built under R version 3.2.3 Failed with error: 'package 'rJava' could not be loaded' Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'rJava', details: call: fun(libname, pkgname) error: JAVA_HOME cannot be determined from the Registry In addition: Warning message: package 'rJava' was built under R version 3.2.3 Error: could not find function "write.xlsx" Execution halted David |
||