Part 1:The Basics – Reading and Writing Excel Files from R and Python

This introductory part lays the foundation for working with Excel files in both R and Python. The chapters cover essential tasks such as reading and writing Excel spreadsheets using popular libraries such as R and Python, enabling you to automate tasks and further enhance your Excel workflows using tools such as RDCOMClient, blastula, schedule, and smtplib for scheduling runs and sending emails.readxl, openxlsx, xlsx, pandas, and openpyxl. Additionally, you’ll learn how to execute VBA code.

This part has the following chapters:

• Chapter 1, Reading Excel Spreadsheets
• Chapter 2, Writing Excel Spreadsheets
• Chapter 3, Executing VBA Code from R and Python
• Chapter 4, Automating Further – Task Scheduling and Email