similar to: Problem with RCOM package

Hi,   I would like to make a program that reads excel files, and writes the cells of which contents is not a formula to another file. I don't think this is possible with RODBC, but it may be possible with rcom.     I read the documentation of the rcom package, but I was hoping somebody knows a good web resource for more eleborate info. I tried Googling, but alas (did you know rcom also is a

Hello all, I’m new here and this is actually my very first post. My name is Giannis and I am an undergraduate student. I am programming in Microsoft’s Visual Studio 2010 (VB.NET mostly) and I want to create a program for the research group I am in. I merely want to evaluate actions and use simple statistical things such as ks test (Kolmogorov-Smirnov), and some plots. The reason I need to call R

Hi All Apologies if this is not the correct mailing list for this question. I have installed RExcel and RCom from CRAN. R is indicating that I need an additional file/package "statconnDCOM" from rcom.univie.ac.at I have been trying to access this website over the last 2 days be it appears to be down. Does anyone know when this site is likely to be back up and/or know of an

David - information on calling R from within Mathematica can be found at the following link: http://www.mofeel.net/1164-comp-soft-sys-math-mathematica/13022.aspx HTH, Alan Kelly

> From: Thomas Baier > > > I am confused as to what I need and must do. > > > > Your message said > > ftp://cran.r-project.org/pub/R/src/contrib/Devel/rcom_0.97.tar.gz > > > > The DESCRIPTION file inside that download says > > Package: rcom > > Version: 0.95 > > Date: 2004-07-14 > > That's too bad. Sorry for that. > >

I have the problem with rcom 1.2.2 package. It does't work with R 2.2.0. Is there any opportunities to correct the work of this package? Thanks for your help. Yulia

Dear all, I use the package RCOM to manipulate Excel-Files (Windows). After opening the Excel-File and formatting the cells I want to save the file automatically without request. If I use y[["Save"]] <- TRUE it opens the saving dialog and I have to select the destination for saving. But I simply want to overwrite the existing file without any other workings. Thany your very much

Dear list, I'm trying to use R2wd package. I've installed the package and try wdGet(). However a error message came up. I'm presently using R 2.15.0 > wdGet() Error in if (wdapp[["Documents"]][["Count"]] == 0) wdapp[["Documents"]]$Add() : argument is of length zero Does anyone knows what this means? Thanks a lot. Andreia Leite -- View this

Hola tengo q hacer un trabajo, donde me piden q todas las salidas q haga sean en Power Point (graficos, tablas, etc). Para eso habia empezado a leer algo del paquete R2PPT, pero la verdad es q hay cosas q no entiendo de este paquete. Queria saber si alguien estuvo trabajando con el y obtuvo buenos resultados o si han usado otro paquete para hacerlo. Por ultimo una pregunta: desde Sweave se

I'm struggling with interpreting XML files created by ADODB as data.frames and I'm looking for advice (see attached example file). Note: This file contains a result set which comes from a rectangular data array. I've been trying to play with parameters to the xmlToDataFrame function in the XML package but I dont get it to extract the data frame. This is what the result should look

Hi List, Is there any way to pass on directly VBA variable content into a R variable? on windows XP & using R 2.12.0 I have installed RExcel addin (with associated D(COM)) >> It function fine when trying to pass Excel Range to R but I failed (sorry if it is only my own limitation, search till now unsuccessful) to find out how to pass directly VBA array into R Below an example -

Hello, I just discovered that I cannot close the Excel application and task manager shows numerous copies of Excel.exe I tried both x$Quit() # shown in the rcom archive and x$Exit() and Excel refuses to die. Thank you very much. S. "You can't kill me, I will not die" Mojo Nixon I also have a problem with saving. It produces a pop-up dialog and does not take my second

Hi list, I just installed the rcom package and tried to read/give out some values from/to Excel. Altogether it works great... but nevertheless I don't know how the syntax works or in other words: "Which command needs which parameters?" Is there somwhere a manual about this package with good examples? I've read the Package description... but there are not really good

Installation of rcom, statconnDCOM and RBloomberg Hi folks, Win7 64bit R version 2.11.1 (2010-05-31) Perform following steps to install rcom, statconnDCOM and RBloomberg 1) rcom installation login Win7 as administrator and start R > install.packages("rcom") --- Please select a CRAN mirror for use in this session --- also installing the dependency ?rscproxy? trying URL

This is not the right list for your question. Question on how to use R and R's libraries should be posted to R-help at stat.math.ethz.ch Patrick Zhang wrote: > Hello all, > > Trying to implement GARCH(1,1) with ASP.NET <http://asp.net/> and > VB.NET<http://vb.net/>. > It involves optimization of a three-variate function with some constraints. > Learned from

Hi, I am looking into a way to hook into the R coercion framework to allow me to convert table-like data stored within a COM object into a data.frame. Some of our COM objects have their own table-like data storage, and from R's point of view it's an object (EXTPTRSXP) decoarated with a sepcial symbol so we can easily identify it. COM_Table <- a_method_that_creates_the_object()

Hi, I have R 2.5.1 installed in my system and have installed rcom package 1.5-2.2 vesion. I don't see the following reference "RCOM 1.0 Type Library" in the VBA IDE. Please help. Also, after installing when I type comRegisterRegistry(), it return "NULL". Is that ok? Same with comRegisterServer(). Regards, Uma This e-mail may contain confidential and/or

Dear Sir, rcom is a great package of R. Yet it seems that there is some problem of Chinese character supporting. comGetPropery() always get the part of the Chinese character. Any suggestion would be appreciated. Thanks. Michael > library(rcom) Loading required package: rscproxy > txe<-comCreateObject("Excel.Application") > comSetProperty(txe,"Visible",TRUE);

Hi, I am installing Excel using package "RExcelInstaller". When I tried to run installRExcel() I got this error message: You don not have the R package rcom installed. The (D)COM server installed which will aloow you to use the background server in RExcel. Since rcom is not installed, foreground mode will be unavailable. You may continue with the installation, but in most

Hi community. I'm fairly new to R and have a basic question. When I try to install RExcel with the code: install.packages("RExcelInstaller", "rcom", "rsproxy") I get the message below: Warning in install.packages("RExcelInstaller", "rcom", "rsproxy") : 'lib = "rcom"' is not writable Error in