Python for Excel
Felix Zumstein is the author and maintainer of xlwings, a popular open-source software for automating Excel with Python on Windows and macOS. He also arranges the xlwings meetups in London and New York to promote a wide range of innovative Excel solutions.
While Excel is still widely used in business, new Microsoft feedback forums are flooded with demands to integrate Python as an Excel scripting language. In fact, it is the most frequently requested feature. What makes this pairing so appealing? Felix Zumstein, the inventor of xlwings, a famous open source program for automating Excel with Python, demonstrates experienced Excel users how to combine these two worlds efficiently in this hands-on approach.
Excel has introduced a lot of new features in the last few years, but its automation language, VBA, has been stagnant for a long time. Python has already been adopted by many Excel power users for regular automation chores. Python for Excel will help you get started.
- Python can be used without substantial programming skills.
- Begin with current technologies like as Jupyter notebooks and Visual Studio code.
- Pandas can be used to obtain, clean, and analyze data, as well as to replace standard Excel calculations.
- Automate time-consuming operations such as Excel workbook consolidation and report generation.
- Create interactive Excel tools that leverage Python as a calculating engine with xlwings.
- Connect Excel to databases and CSV files, and use Python code to retrieve data from the internet.
- Replace VBA, Power Query, and Power Pivot with Python as a single tool.
Author: Felix Zumstein
Link to buy: https://www.amazon.com/Python-Excel-Environment-Automation-Analysis/dp/1492081000/
Ratings: 4.5 out of 5 stars (from 148 reviews)
Best Sellers Rank: #59,602 in Books
#2 in Microsoft VBA
#14 in Business Intelligence Tools
#16 in Spreadsheet Books
