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

11

Calling R/Python Locally from Excel Directly or via an API

In this chapter, we are going to discuss calling R and Python from within Excel. You may ask yourself why you would want to do that when there are many functions inside of Excel that one can use or, if so desired, can write with the VBA portion of the application. One reason why you might want to call R or Python from Excel is to leverage the power and flexibility of these programming languages for data analysis and visualization. Excel is a widely used spreadsheet application that can handle large datasets and perform basic calculations and functions. However, Excel has some limitations when it comes to more advanced or customized tasks, such as statistical modeling, machine learning, ...

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