Stack Overflow
Stack Overflow

Questions tagged [rdcomclient]

This package provides dynamic (i.e. non-compiled) access to COM objects from within R. It allows R to act as a COM client and invoke methods and access properties in any COM object that implements the IDispatch interface.

This package provides dynamic (i.e. non-compiled) access to COM objects from within R. It allows R to act as a COM client and invoke methods and access properties in any COM object that implements the IDispatch interface. This allows us to access and control applications such as Excel, Word, Power Point, Web browsers, etc.

Information from: http://www.omegahat.org/RDCOMClient/

127 questions
1
vote
1 answer

Send formatted HTML table created using rmarkdown over Outlook from R

I have the following well formatted table created using rmarkdown and saved as table.rmd file. library(RDCOMClient) kable(mtcars[1:5, 1:6]) %>% kable_styling(bootstrap_options = c("striped", "hover", "condensed"), full_width = T,…
Geet
  • 2,515
  • 2
  • 19
  • 42
1
vote
0 answers

RCOMClient is not available for R Version 3.6.1

I've been using RDCOMClient to automatically retrieve an email attachment and move it to a specific folder location. However since I updated my version of R to 3.6.1 this package is no longer available. Does anyone know if there is a workaround…
dapm
  • 25
  • 3
1
vote
0 answers

Can checkErrorInfo messages via RDCOMClient by suppressed?

In my application, the user supplies a function name, and I attempt to call it over two different COM interfaces. The logic is pretty simple: Attempt the first interface If that doesn't work attempt the second interface If that doesn't work,…
Kyle Ward
  • 889
  • 1
  • 8
  • 18
1
vote
1 answer

RDCOMClient + Outlook email search using date interval in R

I am trying to search outlook mail giving date as parameter in search. right now I am searching full mailbox then filtering on the basis of received date but problem is by this way it is reading all mail each time. I want a solution where I can…
Dinesh Mandal
  • 23
  • 3
1
vote
0 answers

Embedding flextable in outlook with rdcomclient

I am facing the following issue: I created a beautiful flextable from a dataframe in R, which I would like to send via email. I use htmltools_value to get the HTML code of the flextable. Now I am able to embed this as htmlbody in my email which…
SRO
  • 11
  • 2
1
vote
1 answer

Downloading attachment from Outlook into R

Following Greg Thatcher's answer (accepted answer) to How to retrieve Outlook inbox emails using R RDCOMClient?, I wrote some code to search through my inbox and find an email report I receive everyday. The code begins with -…
phil_t
  • 851
  • 2
  • 7
  • 17
1
vote
1 answer

UTF-8 encoding for issue with RDCOMClient

I'm trying to create emails with R using the package RDCOMClient. The emails basically consist of HTML text encoded in UTF-8 (and also some images). The problem that I'm having is that while the HTML encodes all the special characters I need…
Tom Bombadil
  • 183
  • 4
1
vote
0 answers

Add Macro to Excel file from R

I am using RDCOMClient package in R. I am able to run existing Macro in Excel Workbook from R. Is there a simple way to add Macro to Excel Workbook, when Macro is written in simple ".txt" file? So far I have: library(RDCOMClient) xlApp <-…
JacobJacox
  • 917
  • 5
  • 14
1
vote
2 answers

Retrieving data from my e-mail on outlook with R

I've been trying to retrieve some of my e-mails in order to have them as data in R. In case it is needed, it is on a Microsoft Exchange Server. require(RDCOMClient) folderName = 'ElastAlerts' #creating the outlook object OutApp <-…
Francisco Javier Jara Ávila
  • 45
  • 1
  • 8
1
vote
0 answers

How to fetch data in R by executing command in excel?

I have to fetch data from Reuters and they provide an excel plugin for that. The problem is that my excel is crashing if I try to fetch too many variables at the same time. I was wondering whether I can do it from R via some excel connection. In…
Nikhil Vidhani
  • 709
  • 5
  • 11
1
vote
1 answer

Export tables from Accessdb with R (RDCOMClient)

I want to export Tables from an Access database to .txt-files. Here is my Code: library(RDCOMClient) #Path of txt File destPath = 'C:\\Path\\to\\Hello.txt' #Path of AccessDB strDbName = "C:\\MyPath\\AccessDB.accdb" #launche Access App oApp =…
sneakyErich
  • 66
  • 7
1
vote
2 answers

RDCOMClient and Outlook: Booking a meeting

I am trying to book a recurring meeting in Outlook via a script in R which I will batch to run every week. We are not allowed to book recurring meetings at the moment since rooms are at a premium. I have used RDCOMClient to send automated emails so…
DW1
  • 41
  • 7
1
vote
1 answer

RDCOMclient renaming an Excel Worksheet

I'm having trouble renaming worksheets with the package RDCOMClient and I'm not sure what's going wrong. The code below will print out the name of the active worksheet, so the reference is working. print(wb$ActiveSheet()[["Name"]]) But when I try…
SpottieO
  • 11
  • 4
1
vote
1 answer

Set content type UTF-8 using RDCOMClient

I'm having trouble getting my email's body text in UTF-8. My markdown report is ok, and the script works when running from RStudio - i.e body text is in UTF-8. My problem is that when I run the script from command line my email message is encoded…
ErrantBard
  • 1,421
  • 1
  • 21
  • 40
1
vote
1 answer

RDCOMClient package: How to read data from a query

I am currently on the issue to connect to a Cube with R using .COM objects, to then gathering data from the Cube via mdx-queries. As in my previous question described (see link below), I can now connect to the cube with the help of the RDCOMClient…
Lodrik
  • 629
  • 9
  • 19
1 2 3
…
8 9