note

[For Environments Where Python is Prohibited] Why Use Excel for File Organization? A Macro for Bulk Renaming Invoices/PDFs and Automatically Generating Sorting Ledgers

Introduction: Why not just use Python or PowerShell for file organization? Hello, I'm def. I am an active IT professional working on internal IT infrastructure, business process improvement, and the ...

What to do with VBA when the person in charge has left and no one knows how it works?

When organizing internal systems and folders, there are files you almost always encounter.They are "Excel macros (VBA) where ...
GitHub

excel-automation

Automate real Microsoft Excel with AI via MCP Server or CLI — Power Query, DAX, VBA, PivotTables, charts, and 412 operations. Conversion from Excel to structured JSON (tables, shapes, charts) for ...
blog.csdn

可编程幻灯片引擎：用Python和OpenXML自动化生成PPTX

文章浏览阅读33次。本文介绍基于Python与OpenXML标准构建的可编程幻灯片生成引擎ppt-master，摒弃VBA和Office COM依赖，实现跨平台、高性能、可测试的.pptx文件自动化生成。核心能力包括声明式模板（YAML+占位符ID）、JSON Schema强类型数据校验、CSS-like样式系统、Excel驱动与Python绘图双模图表生成，并支持 ...