Introduction
Overview of Python Packages for Excel
pandas
openpyxl
xlsxwriter
xlrd
xlwt
xlutils
pyexcel
Installing the Python Packages for Excel
Preparing Your Spreadsheet and Data
Performing Quality Check
Best Practices for Spreadsheet Data
Preparing Your Workspace
Importing Your Excel Files and Loading Your Data Using pandas
Writing Data, Formatting Information, and Modifying Charts in Excel
Using openpyxl
Using xlsxwriter
Using xlwt
Using pyexcel
Reading and Formatting Data from Older Excel Files
Using openpyxl
Using xlrd
Using pyexcel
Implementing Final Check of Your Data
Calling Python Functions from Excel
Create User Defined Functions with Python and Excel
Troubleshooting
Summary and Conclusion |