Extending Excel with Python and R

Table of Contents

1. Reading Excel Spreadsheets
2. Writing Excel Spreadsheets
3. Executing VBA Code from R and Python
4. Automating Further (Email Notifications and More)
5. Formatting Your Excel sheet
6. Inserting ggplot2/matplotlib Graphs
7. Pivot Tables (tidyquant in R and with win32com and pypiwin32 in Python)/Summary Table {gt}
8. Exploratory Data Analysis with R and Python
9. Statistical Analysis: Linear and Logistic Regression
10. Time Series Analysis: Statistics, Plots, and Forecasting
11. Calling R/Python Locally from Excel Directly or via an API
12. Data Analysis and Visualization with R and Python for Excel Data – A Case Study