Quote Translator

Problem addressed

Multilingual quotations, product catalogs, and price lists often need to be shared with customers in different languages. Rewriting documents with a generic translator can damage Excel formulas, merged cells, and conditional formatting, or break HTML CSS layout and Word table styles. This skill targets xlsx, html, and docx quotation files, replacing visible text only while preserving structure, formatting, and formulas, so translated versions stay closer to the original document.

How it works and limits

• Core capability: reads an existing file, identifies translatable text, and skips URLs, email addresses, and product codes; uses built-in translation without an external API; supports zh, en, es, hi, ar, fr, ru, pt, de, ja, and ko, and outputs the same file format.
• Processing path: Excel uses openpyxl to iterate cells while preserving styles and formulas; HTML uses BeautifulSoup to extract text nodes and keep structure intact, with Arabic optionally receiving dir="rtl"; Word uses python-docx to process paragraphs and tables while keeping fonts, colors, borders, and other styles.
• Notes: text inside images is not translated; complex structures such as nested tables and merged cells should be manually checked; industry terms should be defined in a custom glossary JSON for specific customers or products to reduce terminology drift.