Advanced Wizard

  1. Follow steps 1 to 6 from Adding an Excel file filter.

  2. Select Simple Wizard and click Next.
    The Preview page appears.

    The content in the Preview page is selected for translation. The Preview page models an Excel file.




    Please choose number of preview rows drop down list

    select the number of rows to show on the preview page.

    Use headers check box

    use the column headers of the Excel sheet. If not selected, the column letter (A,B, C) appears in the next step.

    Table with the Excel sheet contents

    select the first row for translation. Rows above the selected row will not be translated.

  3. Click Next.
    The Selection page appears. If you have selected the Use header checkbox, the Excel sheet headers appear as column names, in the Column Name column. In the example below, the Excel sheet headers are Source Translation, Length Restriction, and Target. An example of the source Excel spreadsheet appears below.

  4. In the Translate column on the Selection page, select the columns for translation.

  1. Click Next.
    The Regular expression page appears.

  2. Enter a Regular Expression for the Excel analysis.
    Note: A regular expression provides a pattern to mark up any embedded HTML tags or variables in a column as tags.

  3. Click Finish.
    The configuration and sample file path appears in the Formats Options box as shown in the example below.

      1. Click Browse to browse to the excelConfig file. The default file is a sample to be edited for your configuration. To edit the file:

        1. Copy the sample excelConfig file to your preferred folder.

        2. Open the copy of the sample excelConfig file in your preferred text or XML editor.

        3. Edit the copied sample excelConfig file to set up the filter configuration. The file acts as a template for your preferred filter setup.
          Note: Remove or comment out any fields in XML that you are not using.

        4. Save the file.

      2. Select the path to the edited excelConfig file. An example is shown below.

      3. Click Apply.

      4. Click OK.
        An Excel file filter is set up.
        Note: You can now directly open Excel files using this filter. While opening files you must choose the correct filter, when prompted. You can also rename the filter using the Rename button.