data, R, automation, excel, reporting Data Extraction from Outlook Attachments using R When excel files get delivered through e-mail attachments, how can we extract the data and consolidate into a single table? Here I present an automated process to extract the attachments from Outlook emails and consolidate them using R. I use the 'RDCOMClient' package (https://github.com/omegahat/RDCOMClient or https:
data, R, automation, excel, reporting Data manipulation in an Excel File with Hyperlinks using R If data manipulation is carried out in R, why not creating the hyperlinks in R as well? Excel files use hyperlinks to navigate to external content, such as, urls or file paths to some other files. Excel uses 'HYPERLINK()' function for this purpose. Below I present (a) how to
