Microsoft Excel workbooks are tricky to import because they contain much more than translatable text. Usually, only a small part of an Excel workbook is translatable.

There are many settings that help you select what to translate and what to ignore.

This window is for old-style Excel workbooks: Use it to import .xls and .xlt files.

To import multilingual tables: Use the Multilingual Excel filter instead. Use the Multilingual Excel filter, too, if the translation mustn't replace the source text but must go into another column.

How to get here

1.Start importing a legacy Excel workbook (an .xls or .xlt file).

2.In the Document import options window, select the Excel workbooks, and click Change filter and configuration.

3.The Document import settings window appears. From the Filter drop-down list, choose Microsoft Excel filter.

If you see a different window that the one below: Click the Import as XLSX radio button.

aspose_xls

What can you do?

First, memoQ converts the workbook in the XLSX format (the one used by Excel 2007 or later).

Under Select import type: Click Import as XLSX. Do not click Import through Office interop.

This works if Excel 2007 or later is installed on your computer. memoQ calls Excel to save the workbook in the newest format.

If Excel 2007 or later isn't installed: Check the Aspose check box. In this case, memoQ converts the workbook into the newest format on its own. For that, memoQ uses a module called Aspose.

Set the order of cells as they are imported (Direction of linearization)

Import or ignore certain types of content

Line breaks in cells: New segment or inline tag?

Import or ignore cell ranges

Get the source text from one cell, and its context from another

Get the source text from one cell, and its comment from another

Deal with content that work in the newest Excel versions only

When you finish

To confirm the settings, and return to the Document import options window: Click OK.

To return the Document import options window, and not change the filter settings: Click Cancel.

If this is a cascading filter, you can change the settings of another filter in the chain: Click the name of the filter at the top of the window.

In the Document import options window: Click OK again to start importing the documents.