Data Extraction from Outlook Attachments using RWhen 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 RD...Nov 11, 2021·4 min read
Data manipulation in an Excel File with Hyperlinks using RIf 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. Bel...Oct 12, 2019·3 min read
