xlwings zurich python user group meetup
DESCRIPTION
xlwings and ExcelPython offer an alternative to program Excel with Python instead of with VBA. xlwings offers the possibility to creat cross-platform spreadsheet toolsTRANSCRIPT
xlwings & ExcelPython Zurich Python User Group Meetup
4 September 2014 Felix Zumstein
8 Years in Banking
Startup (Feb 2014)
About Me
2
Goals
• Open-source (liberal license) • Portability/Deployment: Lightweight, no admin rights • Flexibility: regarding Versions, Architectures, IDEs, Python distros • Cross-platform
3
xlwings (Win & Mac) • Interactive Use • VBA Macro replacement
4
ExcelPython (Win only) • UDFs: User Defined Formulas • Ability to expose functions from existing libraries as array formulas (e.g. NumPy)
xlwings.org
5
ExcelPython: GitHub