Think Inside the Box(es) Excel-Hosted Dashboards With Python Graphics

on YouTube ↗11m

" summary

Shows a reproducible pattern: Python code runs from Excel cells, a macro exposes Excel width and Excel height variables, Python renders plots and writes static files which the macro save to Excel image and overlays precisely-sized images on the spreadsheet. Works with matplotlib and plotly, uses formula references to reuse code across cells, and targets local, offline sharing with static dashboards rather than interactive web apps. Code and Excel macros appear on GitHub.

AI-written summary · about

" chapters (6)

1. 0:00Introduction
2. 1:09Why Excel over other tools
3. 3:55Excel playground for Python graphics
4. 6:00Excel macro and Python integration
5. 7:29Real-world examples
6. 9:16Final demo and code walkthrough

" related talks

• 01h 25mAdvanced Excel Analytics: Python Integration WorkshopHewitt, Kitchen · PyData NYC 2024
• 58mProductivity Revolution in ExcelAvi Singh, Purna Duggirala · PASS BA Marathon 2015
• 24mHow to build a spreadsheet with PythonHarry Percival · EuroPython 2015
• 01h 01mExcel Charting TipsWayne Winston · PASS Business Analytics Conference 2013
• 01h 05mDynamic Presentation Using Excel CUBE FormulasBob Phillips · PASS Business Analytics Conference 2015
• 39mPython & Spreadsheets: 2017 EditionKojo Idrissa · DjangoCon US 2017
• 29mUsing Jupyter notebooks to develop and share interactive data displaysIoanna Ioannou, Maoyuan Liu · PyCon AU 2016 Science and Data Miniconf
• 41mDash: data exploration web apps in pure PythonChelsea Douglas · PyData DC 2018