search for: rdcomclient

Dear list members, I'm using R in connection with the RDCOMClient and Excel. The more I use the package, the more I'm fascinated of it. The possibilities of R can be brought together with the necessities of outputing my socio-economical research results in MS Office! But I have some special questions concering the use of RDCOMClient and perhaps you can help...

Hi, I'm trying to use the excel.link package to write data to excel spreadsheets. I've installed the RDCOMClient package as required but get the error: package 'RDCOMClient' is not installed for 'arch=x64' I'm on Rx64 2.13.0. I assume it means the RDCOMClient package does not work on the x64 version. I've tried to see if there does a x64 RDCOMClient package version exist but to no a...

Dear r-help, Both 'omega-devel@omegahat.org' and 'duncan@research.bell-labs.com' appear to be bouncing with 'user unknown' so trying r-help .... [ Btw, "mailing lists" link on omega page is returning "mailman CGI error". ] > > require("RDCOMClient") > Loading required package: RDCOMClient > Error in library(package, character.only = TRUE, logical = TRUE, > warn.conflicts = warn.conflicts, : > 'RDCOMClient' is not a valid package -- installed < 2.0.0? > > version > _ >...

Hi, I am trying to use the mimR Package. According to its help pages it needs the RDCOMClient package to run. When I try to evaluate a model I get > m.sat<-mim("..",data=gm.dat) Error in mim.cmd("clear; clear output") : couldn't find function "COMCreate" > m2.sat<-emfit(m.sat) Error in toMIM(mim$data) : Object "m.sat" not found &gt...

Hi, I?m using R package RDCOMClient (http://www.omegahat.org/RDCOMClient/) to retrieve data from MS Excel workbook. I?m using the code below to count the number of sheets in the workbook and then loop the data from sheets in to a list. ############# R code ################### library(gdata) library(RDCOMClient) xl <- COMCreate(&...

Hi R-users! I'm trying to create an easy Excel chart using the package RDCOMClient. The following example is working fine: #------------------------------------------------------------------- library(RDCOMClient) xlLocationAsObject <-2 xlXYScatterSmoothNoMarkers <- 73 ex <- COMCreate("Excel.Application") wb <- ex[["Workbooks"]]$Add() sh <- ex...

...'citation()' on how to cite R or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > ls() character(0) > > library(RDCOMClient) > data(quakes) > source("K:/R/RDCOMClient/examples/excelutils.R") > xls <- COMCreate("Excel.Application") > xls[["Visible"]] <- TRUE Crashes R! Any ideas? Thank you This message and any attachments are confidential. If you a...

Hello, Try example(names) in R 2.5.0 after library(RDCOMClient) and you get > example(names) names> # print the names attribute of the islands data set names> names(islands) Error in names(islands) : no applicable method for "names" > Is this normal? Any way round it??? Best regards, Costas ------------------...

I am trying to use the Windows COM interface under R 2.0, and have encountered the following difficulties: - the package RDCOMClient installs, loads and works under R 1.9.1, installs under R2.0, but does not load or work under R2.0 - the package SWinTypeLibs does not install or load under either R 1.9.1 or under R2.0 For the moment I am concentrating on the RDCOMClient package as it seems to be the most up-to-date one. My qu...

Hi, I'd like to ask a installation question. I want to install a source code through the following command, R CMD INSTALL RDCOMClient but get Error: unexpected symbol in "r cmd" Please let know if I miss anything. I my utils package loaded. Thanks, Richard [[alternative HTML version deleted]]

I wrote a procedure to create a spreadsheet using rdcomclient. It uses a function to do the writing and runs "correctly" in isolation. It gives errors, but it continues to completion. The error I receive is "Error: Member not found". If I place it inside a for loop the loop fails after the first iteration, once it reaches the error. Ha...

Hi R-Experts, I'm currently using R 2.4.0 in Windows XP. I'm trying to download data from Bloomberg using the package "RBloomberg", but it fails to install the three needed packages "zoo", "chron" and 'Rbloomberg". Moreover I am not able to find "RBloomberg" package as windows binary in CRAN site as only for MAC it's given. Please

I try to produce and modify shapes in a PowerPoint presentation but run into a difficulty setting a variable. library(RDCOMClient) # load RDCOMClient package library(SWinTypeLibs) # package SWinTypeLibs from Omegahat to access information about COM libraries ppt = COMCreate("PowerPoint.Application") # create a ppt COM ppt[["Visible"]] <- TRUE # set COM property visible to TRUE pres = p...

Hi all, We currently faced a problem about how to pass a matrix with different types to a COM function call thru the RDCOMClient asCOMArray(). As we all know that matrix in R can't hold of elements with different types. So we managed to create a matrix of lists: rates <- matrix( list("1y","2y","3y","4y","5y","7y","10y"...

Hello,   I'm trying to create an Excel chart using the package RDCOMClient. I am not able to title the excel chart and axis using RDCOMClient  "ChartTitle" and "Axis"?   Any suggestions or references is appreciated.   Thanks, uak. [[alternative HTML version deleted]]

...get this error message Error in if (wdapp[["Documents"]][["Count"]] == 0) wdapp[["Documents"]]$Add() : argument is of length zero I saw in a previous posting to r-help ( http://r.789695.n4.nabble.com/R2wd-error-in-wdGet-td4632737.html), someone asked if RDCOMClient was installed and working properly. So, I tried submitting this code install.packages("RDCOMClient", repos = "http://www.omegahat.org/R") And I got this warning message: package ?RDCOMClient? is not available (for R version 2.15.0) I also ran installstatconnDCOM()...

...our code is inside a function, wrap the code in point 1 and 2 on an on.exit() call to ensure that excel is properly closed each time. Hope this helps. Enrique ------------------------------ Date: Wed, 8 Jul 2009 16:06:57 +0300 From: Lauri Nikkinen <lauri.nikkinen at iki.fi> Subject: [R] RDCOMClient: how to close Excel process? To: r-help at stat.math.ethz.ch Message-ID: <ba8c09910907080606n29b8a537uac5ba1788376ff42 at mail.gmail.com> Content-Type: text/plain; charset=windows-1252 Hi, I?m using R package RDCOMClient (http://www.omegahat.org/RDCOMClient/) to retrieve data from MS Excel...

Hi Does anyone know of any R routines to send emails from R, under Windows? I thought about writing such a facility using the R(D)COM package to drive e.g. MS Outlook, but I don't want to reinvent the wheel. I have found a function Sys.mail in the library syskern, but this only works under Unix by shelling out a mail command. Thanks, David

Hi Does anyone know of any R routines to send emails from R, under Windows? I thought about writing such a facility using the R(D)COM package to drive e.g. MS Outlook, but I don't want to reinvent the wheel. I have found a function Sys.mail in the library syskern, but this only works under Unix by shelling out a mail command. Thanks, David

Hi List, I am trying to learn something about the exchange facilities between R and Windows Application with the RDCOMClient package from (http://www.omegahat.org/RDCOMClient/) and I have faced 2 problems: 1. I could not follow the link for the binary version of SWinTypeLibs package on the site, (as it has given me a restricted permission message), but I downloaded it by searching it on google (from http://www.omegahat....