Audit Evidence Form Generator

From Excel issue lists to Word evidence forms

Audit issue lists are often maintained in Excel, but the final deliverable is usually a Word evidence form. Manual copying can miss items, create inconsistent numbering, and produce messy pagination. @user_6256dea1/audit-evidence-form targets this workflow by grouping Excel records by issue title and filling a Word template that contains #1 and #2 placeholders.

Core workflow

• Grouping: reads data starting from row 2 and groups it by the issue-title column;
• Numbering: within each group, items are numbered using Chinese ordinal labels based on the classification column;
• Basis merging: consecutive identical regulatory or policy bases are merged into a single statement;
• Output: the first group fills the original template, while later groups copy the template and insert page breaks, then save 审计取证单_合并.docx.

Boundaries

The skill depends on a fixed column layout and template placeholders: serial number, issue title, classification, issue description, regulatory basis, and responsible department. If the Excel headers change or the Word template lacks #1 and #2, the result may not match expectations. It also requires Python 3.8+ with openpyxl, python-docx, and lxml.