-
Book Overview & Buying
-
Table Of Contents
Python Automation Cookbook - Third Edition
By :
Though Excel has its own language to perform calculations, recent versions have included the possibility of using Python as an alternative.
This makes it possible to take advantage of our Python skills and apply them directly in Excel spreadsheets.
Unfortunately, running Python in Excel executes the results in the Microsoft Cloud, which requires a working Internet connection.
You need to have a working copy of Excel that has Python in Excel. Running Python in Excel is not available in all subscriptions – generally you need to have a Microsoft 365 Business or Enterprise account. More information is available here: https://techcommunity.microsoft.com/blog/excelblog/python-in-excel-%e2%80%93-available-now/4240212.
In this recipe, we will use the movies.xlsx file available on GitHub at https://github.com/PacktPublishing/Python-Automation-Cookbook-Third-Edition/blob/main/ch06/movies.xlsx. It contains the top ten movies from the list in http://www...