Displaying 20 results from an estimated 900 matches similar to: "Rcmdr, RODBC and XLConnect conflict cause R to crash"
2008 Jan 04
1
bug Rcmdr
Hello,
If I run the script : "a<-2 ; a<-a+5 ; a" whith the "submit" buton in
Rcmdr the result is 12 !!!
But if I run the script "a<-2 ; b<-a+5 ; b" there is no problem and the
result is 7.
I think there is a bug in the function "onSubmit".
Thanks,
[[alternative HTML version deleted]]
2011 Jun 27
3
XLConnect Error
Any 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
2013 Jan 21
13
Problema gWidgets & XLConnect
Hola.
Tengo una especie de "poltergeist"... a ver si alguien es capaz de echarme un cable.... sucede al usar los paquetes XLConnect (http://cran.r-project.org/web/packages/XLConnect/) y gWidgets (http://cran.r-project.org/web/packages/gWidgets/) simultáneamente en R 2.15.2 (de 32 bits bajo Windows 7) ... con la versión anterior (2.15.1), en las mismas condiciones, no pasa.
Caso 1:
#
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"
2013 Apr 23
1
Questions on function "readNamedRegionFromFile" in XLConnect pacakge
Hi,
I have two questions on the function "readNamedRegionFromFile" in
XLConnect pacakge.
1.
In the documentation,
# multiregion xlsx file from demoFiles subfolder of package XLConnect
demoExcelFile <- system.file("demoFiles/multiregion.xlsx",
package = "XLConnect")
# Load a single named region into a single data.frame.
df
2011 Aug 12
1
Extract named regions from an Excel file using XLConnect?
Hi Everybody
In R, the XLConnect package can read and write named region to and from
Excel. In order to read a named region with the readNamedRegion function you
need to know it's name. You can check is a name exists with existsName, but
you still have to know the name. Is there a way to actually get a list of
the named regions in XLConnect sinilar to getRanges in the xlsx package.
On that
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.
2017 Sep 23
2
"XLConnect" packages; Excel dates read incorrectly
Hi,
I tried to read xlsx files by "XLConnect" packages, but the dates are
one day earlier than it is supposed to be. I moved from California to
Taiwan (Eastern Asia), and it worked well in California, but not in Taiwan.
Even if I adjust my Mac time to California time zone, it gives the wrong
dates. I don't know which part of the setting (in RStudio or in my Mac?) I
should adjust.
2012 Aug 08
4
Saving Splitted Series to Excel via XLConnect
Dear R Discussion List,
I would like to save my data as a xlsx file. But at first
I need to split it and then save each series into a Excel
column. Please take a look at the following code:
dados <- data.frame(matrix(c("2012-01-01","2012-02-01",
"2012-03-01","2012-04-01","2012-05-01","2012-06-01",
2017 Aug 30
2
Converting character to numeric using the package "XLConnect"
Hello,
>From an Excel file imported into R where each cell contains characters, I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my code (the Excel file is attached):
rm(list=ls(all=TRUE))
library(XLConnect)
tab <-
2017 Sep 23
2
"XLConnect" packages; Excel dates read incorrectly
Jim,
I don't see how that link could be related to John's issue. Symptoms
related to your link involve discrepancies of four years whereas John is
seeing discrepancies of one day.
John,
I do not see any attached files.
Regards
On Sat, Sep 23, 2017 at 1:30 PM, Jim Lemon <drjimlemon at gmail.com> wrote:
> Hi John,
> It could be due to this:
>
>
2017 Aug 31
2
Converting character to numeric using the package "XLConnect"
Thanks very much for your answer.
I?m trying the function ?strtoi? but it fails to convert character to numeric after the command "set[index] <- strtoi(set[index])".
> strtoi(set[index]) ## This works: all values are numeric !!!
[1] 1 2 3 4 2 8 9 7
> set[index] <- strtoi(set[index])
> print(set[10,1]) ## Problem: must be numeric !!!!
[1] "1"
Thanks
2017 Aug 30
0
Converting character to numeric using the package "XLConnect"
> On Aug 30, 2017, at 12:24 PM, Nelly Reduan <nell.redu at hotmail.fr> wrote:
>
> Hello,
>
> From an Excel file imported into R where each cell contains characters, I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my
2017 Sep 23
0
"XLConnect" packages; Excel dates read incorrectly
Hi John,
It could be due to this:
https://support.microsoft.com/en-au/help/214330/differences-between-the-1900-and-the-1904-date-system-in-excel
Jim
On Sat, Sep 23, 2017 at 1:04 PM, John <miaojpm at gmail.com> wrote:
> Hi,
>
> I tried to read xlsx files by "XLConnect" packages, but the dates are
> one day earlier than it is supposed to be. I moved from California
2017 Sep 24
0
"XLConnect" packages; Excel dates read incorrectly
> On Sep 23, 2017, at 6:30 AM, Eric Berger <ericjberger at gmail.com> wrote:
>
> Jim,
> I don't see how that link could be related to John's issue. Symptoms
> related to your link involve discrepancies of four years whereas John is
> seeing discrepancies of one day.
>
The MS Excel starting point was off by one day. R does not repeat that error. MS claims that
2017 Aug 30
3
Converting character to numeric using the package "XLConnect"
The Excel file can be found from this link: https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh
[https://r1.res.office365.com/owa/prem/images/dc-xlsx_40.png]<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh>
File.xlsx<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh>
Partag? via OneDrive
Thanks very much for your help.
Nell
________________________________
De : David Winsemius
2014 Aug 01
1
Update R on a new Linux Mint Maya 13 + rJava and XLConnect
Folks,
I was able to get R installed using:
apt-get install r-base-core
R version 2.14.1 (2011-12-22)
Copyright (C) 2011 The R Foundation for Statistical Computing
ISBN 3-900051-07-0
Platform: i686-pc-linux-gnu (32-bit)
* What is the best way to upgrade to the latest version of R.
* What is the best way to install rJava and XLConnect.
Thanks for your time,
Best,
KW
PS. I know some of you
2012 May 25
1
Java problem - XLConnect/xlsx package
Hi,
I hope you guys can help me, I already posted this question on
stackoverflow but did not get any help (which worked). And I need to solve
this problem as quick as possible:
In our firm we migrated to windows 7 (64-bit) and also updated the java
packages (1.6.0_24) and also R (to 2.15). Then I tried to install my
packages which i use daily and one of em is the xlsx package.
But if I load the
2017 Aug 30
0
Converting character to numeric using the package "XLConnect"
Hi Nelly,
Are you trying to convert hexadecimal to decimal?
nrdf
Setting Value
1 Parameters a
2 Parameters b
3 Parameters c
4 Parameters d
5 Parameters e
6 Parameters 2
7 Parameters 8
8 Parameters 9
9 Parameters 7
10 1 a
11 2 b
12 3 c
13 4 d
strtoi(nrdf$Value,16)
[1] 10 11 12 13 14 2 8 9
2017 Sep 24
3
"XLConnect" packages; Excel dates read incorrectly
Hi,
Thank you for all your responses.
For Eric, The files are attached. (I believe it was also attached in my
first message)
For David, Could you send me the link regarding possible solutions or a
more comprehensive description of the problem?
Thanks,
John
2017-09-23 22:29 GMT-07:00 David Winsemius <dwinsemius at comcast.net>:
>
> > On Sep 23, 2017, at 6:30 AM,