Microsoft Excel documents (XLS and XLT)

Use this dialog to control how Microsoft Excel worksheets (.xls and .xlt files) are imported into memoQ.

 
MemoQ excel filter config dialog Microsoft Excel documents (XLS and XLT)

Invoking

In the Translations pane of Project home, click Add document as… below the document list, and in the Open dialog, locate and select a Microsoft Excel file (with the .xls or .xltextension).

Options

Direction of linearization area:

This area enables you to choose the direction of import – you can decide if you want to translate the Microsoft® Excel® document by rows or columns and from first to last or vice versa. The four tables below illustrate these four options.

1

2

 

2

1

 

1

4

 

4

1

3

4

 

4

3

 

2

5

 

5

2

5

6

 

6

5

 

3

6

 

6

3

Left-to-right and top-down

 

Right-to-left and top-down

 

Top-down and left-to-right

 

Top-down and right-to-left

Non-translatable data ranges area:

This area enables you select any number of cells, rows or columns in Microsoft® Excel®, which will not be imported. Use this tool to mark all cells, rows or columns that do not need to be translated. The idea behind excluding data ranges instead of specifying what data ranges to translate is that you never forget about translating anything.

· Select ranges: Click this button to start Microsoft® Excel® and to open the Mark selected ranges dialog to mark non-translatable cells, rows or columns in Microsoft® Excel® directly. Any ranges you select using the Mark selected ranges dialog will be recorded as Microsoft® Excel® codes in the Non-translatable data ranges pane.

These codes have the following structure:

 
{name of worksheet}!{top left cell}:{bottom right cell}

See the screenshot below.

MemoQ excel filter config dialog excluce Microsoft Excel documents (XLS and XLT)

· Remove selected: Click this button to remove a selected range from the Non-translatable data ranges pane.
· Remove all: Click this button to remove all ranges from the Non-translatable data ranges pane.
 

Comment options area:

This area enables you decide if you want to import certain parts of the Microsoft® Excel® file as comments into memoQ:

· Do not use commenting: Select this radio button to skip importing comments. This is the default setting.
· Use a general comment rule, comment for cell A1 should be: Select this radio button to define a simple rule to be applied to all cells in the document. Customize the code in the input field on the right to specify the required general comment rule relative to cell A1. The input field is shaded in red if the code you enter is not valid.
· Use advanced commenting: Select this radio button, and click the button labeled Comment options to invoke the Advanced comment options dialog where you can specify comprehensive requirements for the import of comments.
 

If a certain range of your Microsoft® Excel® file (a column, for example) is imported as comments and you do not want to have the range imported for translation, which is often the case, mark this area as non-translatable (see above).
 

Additional options area:

· Insert sheet labels at the beginning of the document: Check this check box to import the names of the different worksheets of the translation document as the first segments.
· Include cells containing formulas: Check this check box to import formulas for translation. This is useful if you need to localize formulas in Microsoft® Excel® files.
· Import context IDs: Select this radio button, and click the button labeled Context options to invoke the Advanced context options dialog where you can specify comprehensive requirements for the import of context IDs.

Microsoft Excel documents (XLS and XLT)