Excel vs Python: when spreadsheets are best for small, interactive analysis and sharing—and when Python wins for larger datasets, automation, and advanced analytics (plus Jupyter & key libraries).
Computing – MS Office
The Best Libraries and Tools for Development of MS Office Add-ins in 2020
Top libraries and tools for building MS Office add-ins in 2020—Add-In Express, Excel-DNA, Outlook Redemption—plus tooling like Advanced Installer and Visual Studio.
PostSharp and Excel-DNA
Use PostSharp AOP with Excel-DNA to keep Excel add-in UDFs clean: method decorators enforce the 255-char formula limit and auto-resize function results.
How to use Advanced Installer for an Excel-DNA Project
Step-by-step guide to ship an Excel-DNA XLL add-in with Advanced Installer: prerequisites, 32/64-bit handling, custom actions, registry setup, and auto-updates.