When setting up a file format configuration for Microsoft Excel, there are many options to choose from to ensure extraction is successful. This page will explain the most common options for Excel files.
The following file extensions are supported when setting up file format configurations for Microsoft Excel: .xls, .xlt, .xlsx, .xlsm, .xltx, .xltm, .xlsb.
Please click on a section to see specific information regarding a configuration option:
General Tab
| Configuration Option | Description |
|---|---|
| Mono or Multilingual Content | The default configuration for Excel files is configured to translate monolingual files. This option to create a custom configuration with specific extraction rules for monolingual content or to translate multilingual files. A custom configuration is necessary to translate multilingual Excel files. |
| Columns | Configure specific columns to extract from the Excel file and choose to exclude hidden columns from the translation. |
| Rows | Configure what row the translation will start on and choose to exclude hidden rows from the translation. |
| Sheets | Configure specific sheets to be translated and choose to exclude hidden sheets from the translation. |
| Other Content | Extract or exclude document properties, headers, footers, sheet names, and user comments from the translation. |
| Text Segmentation | Enable/Disable SRX rules for text segmentation and choose to spilt or not split text at line breaks. |
Do Not Translate
| Configuration Option | Description |
|---|---|
| Colors | Choose specific text colors to exclude from the translation such as rede, blue, or green. **Please note that the chosen color in the configuration must precisely match the text color in the Word source file for the text to be excluded from the translation. |
| Segments | Enter certain texts or regular expressions for Wordbee Translator to locate and either exclude from or extract as part of the translation. Any text that does not match entered texts or patterns is automatically considered by the system to be translatable. |
| Words or Terms | Enter single words, terms or segment portions to exclude from the translation. Any text captured by regular expressions are converted to markup to avoid modification. If no description is entered, than the original text will appear when the translator hovers over the markup in the target file. |
Whitespaces & Symbols
| Configuration Option | Description |
|---|---|
| Do Not Show Leading and Trailing Whitespaces | |
| Convert Sequences of Multiple Whitespaces Into Markup | |
| Do Not Show Leading and Trailing Characters that are Neither Letters nor Digits | |
| Convert Words Containing Neither Letters nor Digits Into Markup |
Reduce Markup
| Configuration Option | Description |
|---|---|
| Remove Irrelevent Font or Style Changes | |
| Visually Reduce Markup in Translation Editor |
Embedded Files
| Configuration Option | Description |
|---|---|
| Extract Embedded Excel Files | |
| Extract Embedded PowerPoint Files | |
| Extract Embedded Word Files |