similar to: Questions to RDCOMClient

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

Fresh Download of the newest R for windows R : Copyright 2005, The R Foundation for Statistical Computing Version 2.2.1 (2005-12-20 r36812) ISBN 3-900051-07-0 R is free software and comes with ABSOLUTELY NO WARRANTY. You are welcome to redistribute it under certain conditions. Type 'license()' or 'licence()' for distribution details. Natural language support but

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

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

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

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

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

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

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(

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

I am having trouble using the R2wd package. The last time I used it successfully, I was running an earlier version of R and an earlier version of Word with an earlier Windows OS. I'm not sure which if any of these changes might be contributing to the problem. Right now I'm using R version 2.15.0 (2012-03-30) for Windows MS Word 2010 version 14.0.6112.5000 (32-bit)

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 R Users, Tried to install RBloomberg with R-2.12.0 and appears RDComclient has not been built for this version of R, so failed. I then tried to get RBloombergs' Java API version to work, but ran into problems with RJava which does not appear to exist for Windows. My platform is Windows XP SP3. Will RDcomclient be built for R-2.12.0 anytime soon ? Does a version of RBloomberh with a

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

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

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