similar to: Java problem - XLConnect/xlsx package

Displaying 20 results from an estimated 200 matches similar to: "Java problem - XLConnect/xlsx package"

2011 Sep 05
1
help with installing tar.gz package
hi, i'd like to install the package "RGoogleDocs ". i downloaded to path "E:/R/R-2.13.0/library/RCurl_0.91-0.tar.gz" i run R from an usb-stick and can't get the install.packages() prompt to run correctly - can anyone help with this? thanks, kay > sessionInfo() R version 2.13.0 (2011-04-13) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1]
2010 Oct 22
1
RODBC: data base with decimal point ","
Dear R-users, I am working with R version 2.10.1 and package RODBC Version: 1.3-2 under windows. Say I have a table "testtable" (in an Access data base) with 3 columns and 1 row that looks like this: X Y Z 0012345 42 42,1 The columns are of these types: X - character, Y - Long Integer, Z - Decimal. I use RODBC to get these data into R: > library(RODBC) >
2008 Nov 06
3
Umlaut read from csv-file
Dear All! Reading character strings containing an "umlaut" from a csv-file I find a (to me) surprising behaviour in R 2.8.0, that I did not notice in R 2.7.2. A comparison by "==" results in FALSE, while grep does find the aggreement. See the example below. The crucial line is x=="div 1-2 Ver?nderungen", with the result [1] FALSE in R 2.8.0 but [1] TRUE in R
2008 Nov 07
1
Encoding() and strsplit()
Dear All, Encoding() goes beyond my understanding. See the example. I would expect from reading the help for Encoding() that strsplit preserves the encoding for each resulting element, but for simple letters it gets lost. Also it seems that an Encoding() cannot be declared for simple letters. They remain in any case "unknown". In paste() "latin1" seems to dominate
2008 Nov 09
1
attr.all.equal() and all.equal(attributes(), attributes())
Dear All! If I try to compare the attributes of two objects, I find a surprising behaviour of attr.all.equal(). With identical attributes I receive the answert NULL. If the attributes differ, the answer is as expecxted and differences are shown. all.equal(attributes(), attributes()) instead returns TRUE, if attributes are equal. See example: v <- 1:5 attr(v, 'testattribute')
2008 Dec 19
1
How to write a Surv object to a csv-file?
Dear All, trying to write a data.frame, containing Surv objects to a csv-file I get "Error in dimnames(X) <- list(dn[[1L]], unlist(collabs, use.names = FALSE)) : length of 'dimnames' [2] not equal to array extent". See example below. May be, I overlooked something, but I expected that also data.frames containing Surv objects may be written to csv files. Is there a
2009 Mar 19
1
How to keep attributes when dropping factor levels?
Dear All, to drop unused factor levels two ways are outlined in R-help. In both cases a label attribute is lost. The same happens, when using car:::recode. Is there a simple way to avoid losing attributes? Thanks, Heinz ## example ff <- factor(substring("statistics", 1:10, 1:10), levels=letters) attributes(ff)$label <- 'test label' attributes(ff)$label gg <- ff[,
2023 Apr 16
1
Package Caret
I have newly installed R, R-tools, RStudio, but still not working: library(caret)Lade n?tiges Paket: latticeError: Laden von Paket oder Namensraum f?r ?caret? in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): fehlgeschlagen Namensraum ?vctrs? 0.5.2 ist bereits geladen, aber >= 0.6.0 wird gefordert Error in createDataPartition(hypotezis_df$X, p = 0.75, list = FALSE, times
2023 Apr 16
1
Package Caret
So update the vctrs package to the latest version first before loading R-tools (or the caret package, specifically)? -- Bert On Sun, Apr 16, 2023 at 1:57?PM G?bor Malomsoki <gmalomsoki1980 at gmail.com> wrote: > > I have newly installed R, R-tools, RStudio, but still not working: > > library(caret)Lade n?tiges Paket: latticeError: Laden von Paket oder > Namensraum f?r
2023 Apr 16
2
Package Caret
Many thanks Bert, now is ok, i did not know that "Namensraum" should mean a package Am So., 16. Apr. 2023 um 23:44 Uhr schrieb Bert Gunter < bgunter.4567 at gmail.com>: > So update the vctrs package to the latest version first before loading > R-tools (or the caret package, specifically)? > > -- Bert > > On Sun, Apr 16, 2023 at 1:57?PM G?bor Malomsoki >
2012 May 09
4
Can't read xlsx file into R. Seem, Seem to have XLConnect loaded.
I have spent hours on R in Windows 7. Just installed 2 days ago so the R package should be current. Currently I am using the RGui (64-bit) for Windows. I can not read an Excel file into R from my computer. Have hours on this. Completely crazy!! I have the XLConnect package loaded. I think it is loaded because when I enter: > loadedNamespaces() [1] "base"
2008 Mar 06
3
xml-commons-jaxp-1.3-apis for Freemind?
I am working on installing Freemind (http://freemind.sourceforge.net/wiki/index.php/Main_Page) on my new notebook. And it is not working... I downloaded all the rpms and put them into my local repo, enabled the jpackages repos then, well here is what is happening: yum install freemind* jcalendar* jgoodies-forms* Loading "installonlyn" plugin Loading "priorities" plugin
2007 Sep 27
2
rJava and RJDBC
I am desperate for help. I am trying to get the RJDBC and rJava .5to work on both my windows xp and linux Redhat EL5 Server. On both I get a ava.lang.ClassNotFoundException when calling JDBC(). My example is require(RJDBC) classPath='C:\\libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar' driverClass=c("com.mysql.jdbc.Driver") drv <-
2008 Mar 19
1
R_ParseVector problem: it's cutting off after the decimal point
Dear all, my aim is to integrate R in an interactive visualisation software called Bulk Analyzer developed by VrVis (http://www.vrvis.at). the code: SEXP e, tmp; ParseStatus status; PROTECT(tmp = mkString("x <- c(1.234,-3.45)")); PrintValue(tmp); PROTECT(e = R_ParseVector(tmp, -1, &status, R_NilValue)); PrintValue(e); UNPROTECT(2); produces the following output: [1] "x
2011 May 30
0
Question of the XLConnect package
Hi Everybody I have started to learn how to use the XLConnect package and I think it is going to be very helpful to help me to operate between Excel users. Is there a function that can export a dataframe to a Excel sheet and automatically create a named region for every column (excluding the column heading) that correspond to the column name? If this is possible one can then also create formulae
2007 Mar 22
2
difftime / RBloomberg
hi, I've troubles with some difftime objects. e.g. ISOdate(2001, 4, 26) - ISOdate(2001, 2, 26) - 2 works, telling me "Time difference of 57 days". But when I'd like to add days, such as ISOdate(2001, 4, 26) - ISOdate(2001, 2, 26) + 2 the function gives me an error. Function "as.COMDate.chron" of the Rbloomberg package doesn't work for that reason. I'm
2011 Jan 28
0
Error using write.xlsx library(xlsx)
Dear Adrian, I would like to export a quite large matrix from R to Excel (40 columns, 257 597 rows). After 10 minutes of work, I get the following error message: Error in .jcall(row[[ir]], "Lorg/apache/poi/ss/usermodel/Cell;", "createCell", : Java Exception <no description because toString() failed> This is the code I used: write.xlsx(wvs19812008hm,
2010 Sep 06
1
Help on write.xlsx library(xlsx)
Hi Adrian, dat=data.frame(matrix(0,3,3)) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet1",append=F) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=F) The above code works and creates new worksheets. But if I want to append to an existing worksheet I seem to get an error.
2013 Apr 24
0
time from excel with XLConnect
When I read a time hh:mm:ss from a excel sheet with gdata read.xls it is as expected. When I read the time with readWorksheet I get 1899-12-31 00:20:00 UTC. I would prefer XLConnect because it does not nee perl installed but the data coming with XLConnect is not usable.
2013 Nov 19
1
XLConnect error - "not implemented yet"
When using XLConnect's readWorksheet, instead of it correctly reading string and numeric columns, I receive NA's with the following message: " Error when trying to evaluate cell A2 - not implemented yet" I do not know what this means. Can anyone please assist? -- __________________________ *Barry E. King, Ph.D.* Chief Modeler Qualex Consulting Services, Inc.