Re: [R] XLConnect readWorksheet comma decimal sign

Hi, XLConnect can very well deal with missing values. By default, only blank cells (cells not containing any values) will be treated as missing values. Cells containing the text "NA" are not automatically treated as missing values as "NA" is a valid non-missing text string. If you want to treat th

Re: [R] xlsx file read in R

Hi Nico, please let me know the details of sessionInfo() in R. Also, what version of Java are you running? If you could post the output of "java -version" from the command line that would be great. Note that XLConnect requires at least Java 1.6. Best regards, Martin -- View this message in co

Re: [R] CreateThread failure since R 2.15.2 (32-bit)

I tried with Java 1.6.0_20 and 1.7.0_09. It actually doesn't matter what command I'm running with system. Any command will fail with the same error message. But for the example I posted, yes, I was using "ls" from Rtools. I found that I can only reproduce this with R 2.15.2+ 32-bit on Windows 32-

[R] CreateThread failure since R 2.15.2 (32-bit)

Dear R users & developers, I coming across the following issue since R 2.15.2 32-bit (running on Windows XP 32.bit; some output left out for conciseness): > setInternet2(TRUE) > require(rJava) > .jinit() > getCRANmirrors() > system("ls" , intern = TRUE) Error in system("ls", intern = TRUE) : Crea

Re: [R] Import/Export excel files to/from R, without changing the file type

XLConnect requires Java 1.6+ to be installed. You can get Java from http://www.java.com/getjava/ Best regards, Martin -- View this message in context: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717p4650766.html Sent from the R help ma

Re: [R] Import excel file

Hi Cyril, please let me know the following details: - sessionInfo() output from R - Version of XLConnect you are using - Version of rJava you are using - Version of Java you are using (complete output of "java -version" on the command line) - Value of the JAVA_HOME environment variable if it is se

Re: [R] rJava Out of Memory Error

Hi Matthew, The problem is that the underlying JVM is running with a fixed maximum heap size. When you load a workbook in XLConnect, an in-memory representation of that workbook is created (in Java by Apache POI). Reading and writing data additionally requires memory due to "communication" of your

Re: [R] Cannot create Java virtual machine (-1)

Hi Roger, note that since version 0.1-7 of XLConnect Java 1.6 is required - it won't work with Java 1.5. However, the problem you describe is another one. It's most likely related to your Java setup/configuration and therefore independent of XLConnect. You can verify this by running the following

Re: [R] Java problem - XLConnect/xlsx package

Hi Rainer, Looking at your sessionInfo() it looks like you are using 32-bit R on 64-bit Windows 7. My guess is that the installed JVM is 64-bit. This leads to an architecture clash between R and Java. It is important to make sure that the architectures of R and the JVM match, i.e. either both are

Re: [R] write.xls

Hi Spencer, it looks like you either don't have Java installed or the architectures of R and your JVM don't match, i.e. your running 64-bit R (as noted from your sessionInfo() output) but are using a 32-bit JVM. In any case installing 64-bit Java should resolve your issue. Hope that helps. Best

Re: [R] Can't read xlsx file into R. Seem, Seem to have XLConnect loaded.

Hi Mike, as others have already suggested, there might be a problem with quoting. Otherwise, did you already have a look at the package vignette ( http://cran.r-project.org/web/packages/XLConnect/vignettes/XLConnect.pdf http://cran.r-project.org/web/packages/XLConnect/vignettes/XLConnect.pdf ) tha

Re: [R] nice report generator?

Hi Michael, Hi all, an alternative for reading/writing tables from/to Excel is the package XLConnect. It is platform-independent and therefore runs under Windows, UNIX/Linux & Mac. It supports reading/writing worksheets as well as named ranges. In addition, for reporting purposes, there is support

Re: [R] XLConnect Error

Hi Daniel, you can get Java from http://www.java.com/en/download/manual.jsp?locale=en Simply download and follow the instructions. Hope that helps. Martin -- View this message in context: http://r.789695.n4.nabble.com/XLConnect-Error-tp3628528p3991681.html Sent from the R help mailing list arch

Re: [R] Reading Parts of Excel Files (within a sheet)

the readNamedRegion method to read only the defined range. Best regards, Martin Studer -- View this message in context: http://r.789695.n4.nabble.com/Reading-Parts-of-Excel-Files-within-a-sheet-tp3814447p3856138.html Sent from the R help mailing list archive at Nabble