Thank you, Patricia, So basically, both of us did the same thing, but installRExcel() just worked in your case. Because I was installing (D)COM on my company's computer ( I have temporary admin right), do you think it may be due to that Excel won't allow the change caused by calling installRExcel()?
patricia garcía gonzález <kurtney...@hotmail.com> 10/02/2009 11:58 To Shitao Xu/db/db...@dbemea, <r-help@r-project.org> cc Subject RE: [R] need help with installRExcel() Hi , What I did was similar, install R, R(D)COM server an RExcelInstaller package. Then just write > installRExcel() in the console. And it works. Something you should know is that there is a specific mailing list for RCOM topic in here: http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l Regards patricia. > To: r-help@r-project.org > From: shitao...@db.com > Date: Tue, 10 Feb 2009 11:03:05 +0000 > Subject: [R] need help with installRExcel() > > Struggled a whole day, but still could not get DCOM working on my machine. > > What I did is: > > 1. Installed R 2.8.1 under folder "../R/R-2.8.1" > 2. Installed R_Scilab_DCOM3.0-1B5 under folder ".. \R\(D)COM Server" > 3. Installed packages: rscproxy_1.0-12, RExcelInstaller_3.0-10, > rcom_2.0-4... > 4. run the following commands: > library(rscproxy) > library(rcom) > comRegisterRegistry() > library(RExcelInstaller) > installRExcel() > > Problems: > 1) Got error message when I run "installRExcel()", which was > "The download site http://rcom.univie.ac.at seems to be currently > unreachable". > However, I can visit that website from IE-explorer directly. > > 2) If I run the basic test from (D)Com Sever, I got Runtime Error which > read "Program: ..\R\(D)COM~1\bin\STATCO~1.EXE abornal program > termination", and "Run-time error 462, the remote server machine does not > exist or is unavailable". Also, the DebugView generated the following > report: > > 00000000 0.00000000 [2416] ::Init() > 00000001 0.00032801 [2416] connector: R > 00000002 0.00036630 [2416] DLL: rscproxy.dll > 00000003 0.00040314 [2416] environment: R_HOME > 00000004 0.00043921 [2416] registry key: Software\R-core\R > 00000005 0.00047554 [2416] registry value: InstallPath > 00000006 0.00051146 [2416] version key: > 00000007 0.00054723 [2416] version value: > 00000008 0.00058359 [2416] binary dir: bin > 00000009 0.00062370 [2416] connector: Rold > 00000010 0.00066010 [2416] DLL: rproxy.dll > 00000011 0.00069640 [2416] environment: R_HOME > 00000012 0.00073309 [2416] registry key: Software\R-core\R > 00000013 0.00076879 [2416] registry value: InstallPath > 00000014 0.00080503 [2416] version key: > 00000015 0.00084128 [2416] version value: > 00000016 0.00087704 [2416] binary dir: bin > 00000017 0.00091685 [2416] connector: SciLab > 00000018 0.00095268 [2416] DLL: sciproxy.dll > 00000019 0.00098887 [2416] environment: SCILAB_HOME > 00000020 0.00102560 [2416] registry key: Software\Scilab\%s > 00000021 0.00106183 [2416] registry value: SCIPATH > 00000022 0.00109763 [2416] version key: Software\Scilab > 00000023 0.00113390 [2416] version value: LASTINSTALL > 00000024 0.00116993 [2416] binary dir: bin > 00000025 0.00124627 [2416] sc_proxy_find_connector: 00860FD0/R > (current R) > 00000026 0.00128378 [2416] sc_proxy_find_connector: found "R > 00000027 0.00133204 [2416] looking up registry key at > "HKCU\Software\R-core\R\InstallPath" > 00000028 0.00139897 [2416] looking up registry key at > "HKLM\Software\R-core\R\InstallPath" > 00000029 0.00154388 [2416] > SetEnvironmentVariable("R_HOME","C:\Documents and > Settings\xushita\R\R-2.8.1") > 00000030 0.00161946 [2416] > SetEnvironmentVariable("PATH","C:\progra~1\oracle\product\10.2.0\bin;C:\Program > Files\blp\API\dde\;C:\Program Files\blp\API\;C:\Program > Files\TimeScape\Program;C:\Program > Files\Reuters\Common\Login;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program > Files\sybase\OLEDB\;C:\Program Files\sybase\odbc;C:\Program > Files\sybase\ocs-12_5\dll;C:\Program > Files\sybase\OCS-12_5\lib3p;C:\Program > Files\sybase\ocs-12_5\bin;C:\Program > Files\oracle\product\9.2.0.1\bin;C:\Program > Files\oracle\product\9.2.0.1\jre\1.1.8\bin;C:\Program > Files\oracle\product\9.2.0.1\jre\1.1.8\bin;C:\Program > Files\GED_Technology\Excel\RiskServer;C:\Program > Files\sybase\ado.net\dll;C:\Program Files\sybase\oledb;C:\Program > Files\sybase\odbc;C:\Program Files\sybase\ocs-12_5\dll;C:\Program > Files\sybase\ocs-12_5\bin;C:\Program Files\Xenomorph\Xenomorph > System\Utilities\;C:\Program Files\Xenomorph\Xenomorph > System\Program\;C:\Program Files\notes;C:\Program > Files\oracle\product\9.2.0.1\jre\1.1.8\bin;c:\Documents and Settings\All > Users\GED_Technology\Excel\RiskServer;C:\program files\notes\;C:\Program > Files\blp\API\dde;C:\Program > Files\blp\API;C:\PROGRA~1\Sybase\ADO.NET\dll;C:\PROGRA~1\Sybase\DataAccess\ODBC\dll;C:\PROGRA~1\Sybase\OCS-12_5\bin;C:\PROGRA~1\Sybase\OCS-12_5\lib3p;C:\PROGRA~1\Sybase\OCS-12_5\dll;C:\PROGRA~1\Sybase\DataAccess\OLEDB\dll;C:\PROGRA~1\Sybase\OLEDB;C:\PROGRA~1\Sybase\ODBC;C:\Program > Files\MATLAB\R2008a\bin;H:\matlab\bin;H:\matlab\bin\win32;C:\Program > Files\MATLAB\R2008a\bin\win32;C:\Program > Files\oracle\product\9.2.0.1\jre\1.1.8\bin;C:\Documents and > Settings\xushita\R\R-2.8.1\bin") > > I appreciate any help! > > > > > --- > > > > Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate and regulatory disclosures. > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. Actualízate, descubre el nuevo Windows Live Messenger. ¡Descárgatelo ya! --- This e-mail may contain confidential and/or privileged i...{{dropped:11}}
______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
