When setting up a file format configuration for Microsoft Excel, there are many options to choose from to ensure extraction the translation is successful. This page will explain the most common options for Excel files.
...
The General Tab contains options for choosing what type of content will be translated and what portions of the Excel file will be extracted. For example, a custom configuration would be helpful if you desired desire to only extract certain columescolumns, rows, or sheets for monolingual content or when the translation will be for a multilingual content.
| Configuration Option | Description |
|---|---|
| Mono or Multilingual Content | The default Excel file format configuration is set up to translate monolingual content. This option may be used 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 These options may be used to configure specific columns to extract from the Excel file and choose for choosing to exclude hidden columns from the translation. |
| Rows | Configure These options may be used to configure what row the translation will start on and choose for choosing to exclude hidden rows from the translation. |
| Sheets | Configure These options may be used to cconfigure specific sheets to be translated and choose for choosing 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. By default, the system segments the document by cell, this means that if there are three sentences within a cell, they will be considered one segment. If SRX rules are enabled for text segmentation, the sentences will be segmented at each punctuation mark or line break (as defined by the SRX rules). A default set of SRX rules is defined for Excel files; however, these may be customized if needed. Additionally, the default or a customized set of SRX might have splitting text at line breaks disabled. In this instance, you can enable "Always Split Text at Line Breaks" to ensure this portion of segmentation is handled correctly. |
...
| Configuration Option | Description |
|---|---|
| Colors | Choose specific text colors to exclude from the translation such as redered, blue, or green. **Please note that the chosen color in the configuration must precisely match the text color in the Excel 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 the translation. Any text that does not match entered texts or patterns is automatically considered by the system to be translatable. Regular expressions may be entered in the system to protect entire segments or just terms with the file. These segments or terms will not be extracted for translation and be taken into account during the wordcount step. In the translation editor, they will appear as tags and can be used to protect parts of texts that should not be translated, but should still appear in the translated document. A good example, is entering terms or regular expressions to protect brand names or confidential content like software codes. |
| 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. |
...
The Embedded Files Tab provides options for extracted extracting other Office files that have been embedded into Microsoft Excel files. These options are disable disabled by default, but may be enabled to extract this type of content for translation.
...
| Tip |
|---|
| View our Mircosoft Excel file format Questions and Answers section to learn how to perform common file format customizationscustomisations. These examples are the most frequently answered by our support team. |