Skip to Main Content
Extending Excel with Python and R
book

Extending Excel with Python and R

by Steven Sanderson, David Kun
April 2024
Beginner to intermediate content levelBeginner to intermediate
344 pages
7h 56m
English
Packt Publishing
Content preview from Extending Excel with Python and R

4

Automating Further – Task Scheduling and Email

Sometimes, we can spend countless hours tediously creating, formatting, and emailing Excel spreadsheets. Well, fret no more! With the power of programming, specifically R or Python, you can effortlessly automate these mundane tasks and reclaim your precious time.

Imagine this: you have a list of sales data that needs to be organized into a professional-looking spreadsheet and sent to multiple recipients via email. Instead of slogging through manual data entry and formatting, you can leverage the prowess of R or Python to simplify your workflow.

In R, you can use the amazing taskscheduleR package to schedule tasks and run your script automatically at specified times. With this, you can set up a ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Visualization with Python and JavaScript, 2nd Edition

Data Visualization with Python and JavaScript, 2nd Edition

Kyran Dale
Python for Excel

Python for Excel

Felix Zumstein

Publisher Resources

ISBN: 9781804610695Supplemental Content