openstack-glossary-en

Fills empty English translation columns in multilingual Excel glossary files using OpenStack standard terminology.

Updated May 10, 2026
One-click install
npx skills add https://github.com/dadafinger/dadafinger-skills --skill openstack-glossary-en-dadafinger
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: openstack-glossary-en
Source: https://github.com/dadafinger/dadafinger-skills/tree/main/openstack-glossary-en
Command: npx skills add https://github.com/dadafinger/dadafinger-skills --skill openstack-glossary-en-dadafinger

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve? Manually translating hundreds of Korean glossary terms into English for multilingual product documentation is slow and inconsistent. This Skill automates filling the empty English column of an Excel (.xlsx) glossary using OpenStack standard terminology (e.g., 인스턴스 유형 → Flavor, 유동 IP → Floating IP), common UI terms, and role names, while never overwriting existing translations. ## Core Features & Use Cases - Automatic column detection: Locates the '한국어' header cell in the first rows of each sheet and treats the adjacent right column as the English target column. - Dictionary-based translation: Applies a built-in TRANSLATIONS dictionary covering OpenStack menu terms, common UI labels, and admin role names, copying font and alignment styles from the Korean cell. - Safe, non-destructive fills: Only empty English cells are filled; existing values are preserved, the VIOLA sheet is always excluded, and unregistered terms are reported for manual review instead of being guessed. - Use Case: You receive a product glossary workbook with Korean, English, and Japanese columns where the English column is partially empty. Run the script to fill all known terms, then review the printed list of unregistered terms and extend the dictionary as needed. ## Quick Start Ask the AI to fill the empty English column of your glossary Excel file with OpenStack standard translations using this skill, for example: "Fill in the empty English column of glossary.xlsx based on OpenStack terminology."

Frequently Asked Questions about openstack-glossary-en

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I fill an empty English column in an Excel glossary with Python?▼

Run the included translate.py script with the file path: python scripts/translate.py --file "glossary.xlsx". It reads the Korean column via openpyxl, looks up each term in a translation dictionary, and writes results only into empty English cells.

How does the script find the Korean and English columns in the sheet?▼

It scans the first rows of each sheet for a header cell whose value is '한국어' and treats the column immediately to its right as the English column. If no such header exists, the sheet is skipped and the user is asked to confirm the column positions.

Will the translation script overwrite existing English translations?▼

No. The script only writes to English cells that are empty; any cell that already contains a value is skipped. It also copies font and alignment from the adjacent Korean cell so new entries match the sheet's formatting.

What happens to Korean terms that are not in the translation dictionary?▼

Unregistered terms are left blank and printed in a 'dictionary unregistered' report after the run, grouped by sheet. You can add new mappings to the TRANSLATIONS dictionary in translate.py and rerun the script to fill them.

Can I translate only specific sheets of the Excel workbook?▼

Yes. Pass a comma-separated sheet list with the --sheets option, for example --sheets "CON EN,Product". The VIOLA sheet is always excluded regardless of options because it does not follow the Korean/English column structure.