Python for Excel (O'Reilly, 2021)

This is the companion repository for the O'Reilly book Python for Excel.

All notebooks can be run in the cloud except ch09.ipynb (requires a local installation of Excel):

Name		Name	Last commit message	Last commit date
Latest commit History 12 Commits
ExistingSalesData		ExistingSalesData
NewSalesData		NewSalesData
AAPL.csv		AAPL.csv
AMZN.csv		AMZN.csv
GOOGL.csv		GOOGL.csv
LICENSE		LICENSE
MSFT.csv		MSFT.csv
README.md		README.md
appendixC.ipynb		appendixC.ipynb
array_calculations.xlsx		array_calculations.xlsx
big.xlsx		big.xlsx
ch02.ipynb		ch02.ipynb
ch03.ipynb		ch03.ipynb
ch04.ipynb		ch04.ipynb
ch05.ipynb		ch05.ipynb
ch06.ipynb		ch06.ipynb
ch07.ipynb		ch07.ipynb
ch08.ipynb		ch08.ipynb
ch09.ipynb		ch09.ipynb
ch11.ipynb		ch11.ipynb
ch12.ipynb		ch12.ipynb
course_participants.xlsx		course_participants.xlsx
currency_converter.xlsx		currency_converter.xlsx
debugging.py		debugging.py
excel.py		excel.py
macro.xlsm		macro.xlsm
parallel_openpyxl.py		parallel_openpyxl.py
parallel_pandas.py		parallel_pandas.py
parallel_xlrd.py		parallel_xlrd.py
pep8_sample.py		pep8_sample.py
requirements.txt		requirements.txt
sales_report_openpyxl.py		sales_report_openpyxl.py
sales_report_pandas.py		sales_report_pandas.py
sales_report_template.xlsx		sales_report_template.xlsx
sales_report_xlsxwriter.py		sales_report_xlsxwriter.py
sales_report_xlwings.py		sales_report_xlwings.py
stores.xls		stores.xls
stores.xlsb		stores.xlsb
stores.xlsx		stores.xlsx
temperature.py		temperature.py
vba.xlsm		vba.xlsm

Provide feedback