similar to: Using mimR

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

I am getting several errors about Windows only packages when I use task views. Is this suppose to be a Windows-centric utility? Also, I am sure there must be a simple way to tell which packages are in a view, but I haven't found it. If there isn't, it would be nice to have. Paul Gilbert _______ install.views(c( "Multivariate", "Econometrics", "Finance",

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

Hello R-helpers! I am new to R, but having a rough time with the socketConnection function. I cannot seem to get bi-directional communication to work. I have tried loads of possible ways, based on the manual's examples, but the result is always one or the other process hanging. Could anyone give me a working example of R code that: - creates a socket, - listens for data , - reads the data, -

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

I added a linux server to the Active Directory domain, I realized that the samba-winbind package uses the smb.conf file, but I also need to use the same linux server with shares, if I install the samba package, this package use the smb.conf file. Is there a solution? Then i have problem with 2 services. Example systemctl services: smb.service winbind.service My system is Centos 7. --

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

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

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

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

Together with Enrique's running start and Prasad's work, we figured out how to get tick data and bulk data from Bloomberg into R. Here is a code snippet which builds on Enrique's. ---------------------------- require("RDCOMClient") blCon <<- try(blCon <- COMCreate("Bloomberg.Data.1"), silent=TRUE) # Always check the class of blCon before proceeding! #

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

> Rmetrics - New Version is available for R 1.9 !! > in R-binary and R-source form from the site "http://www.rmetrics.org", > and install the binary "zip" files in the usual way via the menu I'm confused - does the fact that you are only distributing ".zip" files means that (shudder) I need Microsoft Windows in order to run this? (I hunted on the

Hi Luiz... I think you just misunderstood the concept of Samba... You can indeed you samba to make both task... Just join your samba box to AD and be happy. 2017-04-17 13:26 GMT-03:00 Luiz Guilherme Nunes Fernandes via samba < samba at lists.samba.org>: > Well, i need join 1 server Linux in Active Directory, i need too, create > one domain in samba for shared printers with cups.

Full_Name: Claus Pastor Version: 2.9.2 OS: Windows XP Submission from: (NULL) (82.113.106.4) I use the following function to compute MutualInformation Matrix of factorial members of a dataframe. I use package minet for this: my.MI = function(test) { ## die Diagonale gibt die Entropien, Teile durch entropy von y und du erh?lst den Zusammenhang ## kenne X und sage daraus y voraus require(minet)

Dear all, I would like to use the apply or a similar function belonging to this family, but applying for each column (or row) but let say for each q columns. For example I would like to apply a function FUN for the first q columns of matrix X then for q+1:2*q and so on. If I do apply (X, 2, FUN) it applies for each column and not for every q columns. Is that possible with any similar function?

Second test after big upgrade.. -- http://www.PowerDNS.com Open source, database driven DNS Software http://netherlabs.nl Open and Closed source services

Hello I am using Duncan Lang's RDCOM Client package (available on omegahat.org) under R 1.7.0 and Windows XP Pro. Is this the right forum for questions about this package? In case it is, here is my question: Instances of COM objects do not seem to terminate as expected, but leave residual processes running. For example, if I try the simple example: E <-