Excel Template Transform Suite

Data Mapping Problem

When importing data into Kingdee EAS Cloud, Kingdee AI Suite, or similar systems, source Excel files often use different column names, value formats, fixed fields, or concatenated fields than the target import template. Manual column copying is error-prone, and the rules are hard to reuse for the next batch of files. The Excel Template Transform Suite turns the “source data → target template” cleanup process into configurable mapping rules so similar import tasks can be executed consistently.

How the Transform Works

The suite coordinates two sub-skills: ett-template-config for creating, inspecting, and adjusting template mappings, and ett-data-transform for running single-file or batch conversions. The core script scripts/ett_transform.py is included, and conversion relies on openpyxl and pandas. On first use, it confirms a workspace directory such as ~/ett-workspace/, where assets/ stores mapping JSON files and output/ stores converted results.

It supports several mapping types:
- direct: copy a source column value;
- fixed: insert a constant value;
- value_map: translate source values through a lookup table;
- conditional: choose a value based on conditions;
- concat: join multiple fields;
- lookup: search an external Excel file;
- sequence: increment values by row;
- formula: calculate expressions.

Presets cover two common paths: Kingdee Cloud Enterprise → EAS Cloud with 9 business objects, and Data Cleanup → Kingdee AI Suite with 74 configurations. Accounting subjects, customers, suppliers, departments, vouchers, asset cards, and other templates can be reused directly, or inspected under presets/ and adapted into new mappings.

Usage Boundaries

This suite fits scenarios where source fields and target fields can be described explicitly, especially import tasks with stable template structures. If the target system also requires complex validation, permissions, or business-rule judgment, the final file still needs human review. When using a preset, prepare the matching target Excel template by exporting it from the Kingdee system or creating a blank template according to the import format.