search for: xlconnectjar

All, I am trying to get the XLConnect package to work on one of my servers and I am getting an error that XLConnectJars cannot create the java virtual machine. The server is a 32-bit Windows Server 2003 machine with R 2.15.1. The version of Java installed on the server is J2SE Environment 5.0 update 8. I know this not the latest version of Java, and I will try to update it when I get exclusive access to the ser...

...method = method, : Intermediate file '/tmp/RtmpHRuknw/filefed757fcc67.csv' missing!In addition: Warning message:running command ''/usr/bin/perl' Con XLConnect -> Error : package ?rJava? was built before R 3.0.0: please re-install itERROR: lazy loading failed for package ?XLConnectJars?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/XLConnectJars?Warning in install.packages : installation of package ?XLConnectJars? had non-zero exit statusERROR: dependency ?XLConnectJars? is not available for package ?XLConnect?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-libr...

...9; missing!In addition: Warning message:running command ''/usr/bin/perl' >>>> >>>> Con XLConnect -> >>>> >>>> >>>> Error : package ?rJava? was built before R 3.0.0: please re-install itERROR: lazy loading failed for package ?XLConnectJars?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/XLConnectJars?Warning in install.packages : >>>> installation of package ?XLConnectJars? had non-zero exit statusERROR: dependency ?XLConnectJars? is not available for package ?XLConnect?* removing ?/home/miguelfg/R/x86_64-...

...9;/tmp/RtmpHRuknw/filefed757fcc67.csv' missing!In addition: Warning message:running command ''/usr/bin/perl' >> >> Con XLConnect -> >> >> >> Error : package ?rJava? was built before R 3.0.0: please re-install itERROR: lazy loading failed for package ?XLConnectJars?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/XLConnectJars?Warning in install.packages : >> installation of package ?XLConnectJars? had non-zero exit statusERROR: dependency ?XLConnectJars? is not available for package ?XLConnect?* removing ?/home/miguelfg/R/x86_64-pc-linux...

...uot;-Xmx1000m") ####### but it did not work. I wonder if I need to detach the packages before adding that line ######## detach("package:XLConnect", unload=TRUE) detach("package:xlsx", unload=TRUE) detach("package:xlsxjars", unload=TRUE) detach("package:XLConnectJars", unload=TRUE) detach("package:rJava", unload=TRUE) options(java.parameters = "-Xmx8000m") library(XLConnect) library(xlsx) ####### but it did not work. I am on a Mac, with very new OS and very new R version. R version 3.2.4 (2016-03-10) Platform: x86_64-apple-darwin...

Hi all, How can I set open files that contain values of Zero =0? These are valid values for the parameters I need to evaluate. I have tried CSV and tab formats. Trying XL Connect and/or XLConnectJars dies not seem to work to open Excel files so I am at a loss on how to get the data into a DF. Sample of data with 0 values: Filename Dur TBC Fmax Fmin Fmean Fc S1 Sc Pmc g8221843.13# 5.06 0 38.93 36.2 37.96 36.45 -34.08 192.69 6.8 g8221843.13# 0.41 5.29 38.83 36.04 38.83...

Hola, Pensé que esto iba a ser trivial en R, pero me estoy encontrado muchos con mi problema en internet, y que las soluciones ofrecidas no terminan de funcionar. Estoy intentando leer un fichero .xls en ubuntu con los siguientes paquetes y nada: require(RODBC) conn = odbcConnectExcel("madrid.xls") # open a connection to the Excel file sqlTables(conn)$TABLE_NAME # show all sheets df =

...y ideas of what is happening when I attempt to load XLConnect? I think I installed everything correctly. I posted what I get when I installed rJava as well as when I attempted to load rJava directly. Thanks in advance for any help you can give on this. library(XLConnect) Loading required package: XLConnectJars Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'rJava', details: call: fun(...) error: JAVA_HOME cannot be found from the Registry Error: package 'rJava' could not be loaded This is the mesage I get when I install rjava: Installing package(s) in...

...> loadedNamespaces() [1] "base" "datasets" "graphics" "grDevices" [5] "methods" "rJava" "stats" "tools" [9] "utils" "XLConnect" "XLConnectJars" XLConnect is listed. Does that mean it is loaded? > getwd() [1] "F:/RwkCB3/R OG SBCD 1205v01" > list.files() [1] "~$ R OG SBCD 1205 MH1.docx" "~WRL2121.tmp" [3] "01 R OG SBCD 1205 MH1 BU1.docx" "01 R OG SBCD 1205 MH1.do...

...he package XLConnect. Having used remove.packages to remove the ggplot2 and associated packages from the library, I installed XLConnect and it dependencies from CRAN from RStudio. Now the packages installed in "D:/Analyses/R LibDevel" were: "rJava", "XLConnect", "XLConnectJars". In this case executing library(XLConnect) cause the same response - "R Session aborted" with the information that "R encountered a fatal error". These are not packages that I maintain. However, I have packages (imageData and dae) that depend on ggplot2 and it seems tha...