Adding an Excel file filter

There are two default filters for Excel: Default Excel filter, and Default Excel 2007 filter. The steps for adding both filters are the same. In the example below, a Default Excel filter will be added.

 

To add an Excel file filter:

  1. Follow steps 1 and 2 from Viewing default file filters.
    The Formats dialog box appears. The default filters appear in the Available Formats box.

  2. Select Format Type as Default Excel Filter.
    The Excel Filter options appear.


     

  3. Click Setup.
    The Choose Excel File... dialog box appears.


     

  4. Select an Excel file and click Open.
    The Excel Column Selection Wizard  appears.


     

  5. Read the instructions carefully and click Next.
    The Select Wizard type page appears.


     

  6. Select the wizard type. You have two options:

Simple wizard

To run the Simple 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.
     

    Number

    Use

     

    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 Finish.
    The configuration and sample file path appears in the Formats options box as shown in the screenshot below.


     

  4. Select the Translate Sheet Names checkbox to include sheet names as translatable text. Selected by default.

  5. Select Translate Comments to clear it, and not include comments as translatable text. Selected by default.

  6. Select the Translate hidden rows and columns checkbox to include rows and columns hidden in the Excel file as translatable text.

  7. Select Translate hidden sheets to include hidden Excel sheets.

  8. Select the Translate cell with formulas checkbox to include cells with notes and formulas as translatable text.

  9. Select Translate Data Validation comment to clear it, and not include columns in the Excel sheet used to record comments validating the data, for example, columns recording vaccination data by date applied and dosage. Selected by default.

  10. Select the Treat numbers stored in text format as real numbers checkbox to include numbers as translatable text. Selected by default.

  11. Select Translate Drop-down list contents to include the drop-down list contents in the translation. Selected by default.

  12. Select Translate cell order by column to extract cells by columns, instead of by rows.

  1. Click Apply and 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.

Advanced wizard

To run the Advanced wizard:

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

  2. The Preview page appears.



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

    Number

    Use

     

    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.

  5. Select the starting row number. The content extract begins with this row number, and ends at the selected end row number.

  6. Select the end row number. The content extract ends with this row number, having begun at the selected end row number.

    The corresponding Column name appears in the Target column as shown in the example.

  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.

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



     

  1. Click Apply and 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.