similar to: How to title the excel chart and axis using 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 <-

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

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, How can I attach chart/plot to a excel file? I would like to create a plot in R eg. plot(1) and save it into a Excel file, eg. test.xls in a same working directory. Regrads, -J

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

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

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 All. I'd like to programm a 4 dimensional chart in R. Acctually I wanted to solve that problem in Excel cause I had the data there. Here is a link of my actual problem description (there are some chart pictures as well).... http://www.mrexcel.com/board2/viewtopic.php?t=187336&highlight=stacked+column because I still couldn't solve that problem I came to R. The chart should be

Hey at all I''ve a question about excel chart: i want to export some data into excel and generate a chart with different styles. unfortunately, the generated chart is in fullscreeen-mode. how can i set the size by generating the chart? does anybody know a page where i can find some information about excel charts? thanks a lot! Pascal -- Posted via http://www.ruby-forum.com/.

Hi, I have a series of data (about 80,000 pairs of x,y). Plotting it shows a great chart. However, R has randomly chosen about 6 labels for my x axis. Now, clearly I can't show them all, but would like some control over the granularity of what is displayed. I can't find anything in the documentation about controlling the axis data labels. Is there a way? Alternately, is there a

Hello Nabble users, A question about having two y axes on a chart. I'm trying to show on the left (first) y axis a measure used in an experiment; the x axis shows the experiment number, that has been sorted in a specific manner -- i.e. not Experiments 1,2,3,n, but could be Experiment 6,1,18,n; the right (second) y axis shows an experimental variable. The idea of the chart is to show how

Hello All, I am trying to format a box plot chart for a report so it matches other charts I have created in other software programs. My problem is that I need to rotate the values on the Y axis by 45 degrees, I have tried to use the srt parameter but with no luck? Does anybody have any suggestions? Regards, Daniel My syntax is as follows:

Attached is a histogram chart with a break on y-axis which my friend made for me using phot shop. Do anyone know how to make such a break using R? Thanks in advance. (See attached file: 2007 age distribution.doc) Hongsheng (Hank) Liao, Ph.D. Lab Manager Center for Quantitative Fisheries Ecology 800 West 46th Street Old Dominion University Norfolk, Virginia 23508 Phone:757.683.4571

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 All! I have a question regarding the package RDCOMClient. I want to start an Excel file with R and it works flawlessly except the fact, that Add-Ins are not loaded. Can someone please explain me how to load one? Does it work with ex$AddIns$Invoke? Greetings, David [[alternative HTML version deleted]]