similar to: R D COM Excel Add-Ins

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

Hallo all, I`ve read a lot of things in this forum about an Excel export via R. It is no problem to export my data frames via write.table or write.xls (xls or csv), but some things are not very convenient for me: I always have to adjust the column with to see all the numbers or the text and there is no frame between the cells. And I missing the possibility to make some headers bold or coloured.

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

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 >

Hello, I was building a R addin for Excel. I was able to build R.dll, export to Rdll.lib and wrap it in a Excel addin (.xll) format. Most basic functions work fine within Excel except functions that use LAPACK, e.g. eigen, solve etc. But if you use solve(..., LINPACK = T). That's fine. So apparently the problem is with loading the shared library ../modules/lapack.dll. I read one of the

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

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,

Hi, I have downloaded the "R-Com and I was able to run "Interactive Graphics Demo 2" in excel. However, I couldn't create my own boxplot. Whenever I tried to run any code, it always say" Error in loading DLL", even "=rput(A1,A2:A20)". Any idea about what's going wrong? A detailed explaination about how to use R-Excel tool would be greatly appreciated.

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

Dear All, I have attempted to install the R-Excel Interface with poor results. The version of R is 1.6.1, the version of R-Excel is 1.0, the version of COM is 0.99. All of these were downloaded Monday, 6 January 2003. R (version 1.6.1) is installed on the machine and appears to run correctly on its own. The computer is a Compaq Pentium 4 machine with 128 meg of RAM running Windows 2000 and

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)

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();

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

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

I wrote a R script say called computeCovarMatrix.R and i want to call and run this piece from Excel visual basic. does anyone know how to do that? thanks, KZ [[alternative HTML version deleted]]

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

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