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.xu@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.
_________________________________________________________________
[[alternative HTML version deleted]]