similar to: Help with package RDCOMClient

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("Excel.Application") sh <-

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 me solving them: 1. Problems

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 >

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 <-

Hi, This may be due to several reasons. That I can think about: 1) Ensure you close *all* possibly open workbooks: nBooks <- xl[["Workbooks"]]$Count(); for (i in seq_len(nBooks)) xl[["Workbooks"]]$item(i)$Close(SaveChanges=FALSE); 2) The excel application reference does not seem to be really released until the garbage collector runs. So this may help: xl$Quit();

hi, I use R - 2.15(32bit), and want to make a code to clear a console. Actually, I used to run following code to do that but after update the version of R from 2.14 to 2.15, it doesn't work. cls <- function (t) { require(RDCOMClient) wsh <- COMCreate("Wscript.Shell") wsh$SendKeys("\f") invisible(wsh) } cls() or cls <-

Has anyone managed to get this working? Here's what I did: I got the binary build for R2.0.1 from the Omegahat download page, and made a small change to the registerClassID function ( to make it use the right path to RDCOMServer.dll). Then I tried to replicate the simple TTest example from the same web site. The COM class definition and registration worked fine for me. To test this, I

Dear R-help, There seems to be a web page I am unable to download using RCurl. I don't understand why it won't download: > library(RCurl) > my.url <- "http://www.nytimes.com/2009/01/07/technology/business-computing/07program.html?_r=2" > getURL(my.url) [1] "" Other web pages are ok to download but this is the first time I have been unable to download a

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. Has anyone had experience with this

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

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

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,

Hello, everyone! I have a problem with RBloomberg and this is not the usual "no administrator rights" problem. I have R 2.7.2, RBloomberg 0.1-10, RDCOMclient 0.92-0 RDCOMClient, chron, zoo, stats: these packages load OK. Then, trying to connect, I get following error message: conn <- blpConnect(show.days="week", na.action="previous.days",

Dear all, I would like to import a range of cells (e.g. F10:K234) from an Excel worksheet to R. I have looked for documentation on RODBC and RDCOMClient but I was not able to find enough information to solve my problem and all the examples I have seen were dealing with an entire worksheet, not a range of cells. Thanks, Jean-Noel Jean-Noel Candau INRA - Unit? de Recherches Foresti?res

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 ---------------------------------- Costas Vorlow

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]]

Dear list member, I am using the packages RDCOMClient and SWinTypeLibs and try to import a COM object (created in Delphi) in R that is of type 'early binding' instead of late 'late binding'. Is there a possibility to do this in R? Currently, the following returns an error message: l1 = LoadTypeLib("c:\\Programme\\INVESCO\\QaCalendar\\Calendar.dll")

Hello together, i have a list of numbers, like this one A B C 1.1 1.2 1.3 i export this list into an excel file and want now color these numbers according to her value. I want every color under 1,25 is red, and every color over 1,25 is green. How can i do this with "RDCOMClient" ? I know how to colour a complete row, like this task: U3R <- sh$Range(zellen_blue) U3RF <-

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