Working with Excel Filters (xml File) Thread poster: Max Hezel
|
|---|
Hi everyone,
I would like to use Wordfast Pro to translate an Excel file, where the source language (English) is in Column A and the target language (e.g. Spanish) should be written to Column B.
I saw in the Wordfast Wiki that this can be done using an XML configuration file, but I'm having trouble setting it up correctly.
Has anyone here successfully done this and would be willing to share their XML configuration or explain how to set it up?
T... See more Hi everyone,
I would like to use Wordfast Pro to translate an Excel file, where the source language (English) is in Column A and the target language (e.g. Spanish) should be written to Column B.
I saw in the Wordfast Wiki that this can be done using an XML configuration file, but I'm having trouble setting it up correctly.
Has anyone here successfully done this and would be willing to share their XML configuration or explain how to set it up?
Thanks in advance! ▲ Collapse
| | | |
The process in Wordfast Pro is quite involved. It used to be straightforward in Wordfast Pro 3, and they were the first to have this feature, long before memoQ and Trados. No idea why they made it so hard to use in later versions of Wordfast Pro.
In any case, I have had better luck using the free and open-soure Okapi Rainbow. Here are the instructions, in case you would like to try: <... See more The process in Wordfast Pro is quite involved. It used to be straightforward in Wordfast Pro 3, and they were the first to have this feature, long before memoQ and Trados. No idea why they made it so hard to use in later versions of Wordfast Pro.
In any case, I have had better luck using the free and open-soure Okapi Rainbow. Here are the instructions, in case you would like to try: https://okapiframework.org/wiki/index.php/OpenXML_Filter#Excel_Options ▲ Collapse
| | | |
Thank you very much for your message.
Is there any documentation or a step-by-step guide for doing this in Wordfast Pro?
Unfortunately, I haven’t been able to find anything clear so far.
| | | |
|
|
|
|
Yes I found the wiki page with the instruction. But the xml-Code does not work As i want it.
Do you see the fault? (Deleted ">" to copy code)
?xml version="1.0" encoding="UTF-8" standalone="no"?>
!-- Update in AP 2.8.0 -->
!-- Configuration for Excel filter (ConvertXLS) -->
configuration>
regexp> !-- Use regular expression to mark up content as placeables --> /regexp>
translate_sheet_names>false /translate_sheet_name... See more Yes I found the wiki page with the instruction. But the xml-Code does not work As i want it.
Do you see the fault? (Deleted ">" to copy code)
?xml version="1.0" encoding="UTF-8" standalone="no"?>
!-- Update in AP 2.8.0 -->
!-- Configuration for Excel filter (ConvertXLS) -->
configuration>
regexp> !-- Use regular expression to mark up content as placeables --> /regexp>
translate_sheet_names>false /translate_sheet_names>
translate_formula_cells>false /translate_formula_cells>
translate_hidden_cells>false /translate_hidden_cells>
translate_hidden_sheets>false /translate_hidden_sheets>
translate_cell_comments>false /translate_cell_comments>
translate_data_validation_comments>true /translate_data_validation_comments>
number_extraction_on_text_cells>true /number_extraction_on_text_cells>
translate_drop_down_lists>true /translate_drop_down_lists>
extract_cell_order_by_column>true /extract_cell_order_by_column>
extract_soft_return_strategy>break /extract_soft_return_strategy>
!-- worksheet configuration can be placed here -->
sheets xml:space="preserve">
columns>
!-- When columns> is not specified, everything in the sheet gets extracted. Use either sourceColumnRange> or column> to specify column(s) for extraction. -->
sourceColumnRange>
!-- When You use this element target columns are the same as source columns. Use "-" to define column range, for example: 3-15. Use ";" to define more than one column range, for example: 3-15;18;20-24 -->
/sourceColumnRange>
column>
sourceColumn>
!-- Specify source column for extraction. First column starts at 0 -->
A
/sourceColumn>
targetColumn>
!-- Specify target column to store translation. Can be the same as source column. -->
B
/targetColumn>
lengthRestrictionColumn>
!-- Specify column with numbers that should represent translation length restriction (it is not mandatory to setup this) -->
/lengthRestrictionColumn>
/column>
/columns>
/sheets>
/configuration>
[Edited at 2025-05-19 10:30 GMT]
[Edited at 2025-05-19 10:30 GMT]
[Edited at 2025-05-19 10:37 GMT] ▲ Collapse
| | | |
| Change A and B to 0 and 1 | May 20 |
Well, it says the first column is 0 and you have entered “A” instead.
| | | |
| Result is the same | May 21 |
Yes, this was a test on my side. Also when I take "0" and "1" the result is the same.
I also wait for support from Wordfast team.
| | | |
| What did they say? | May 22 |
What did Wordfast say? Did you contact the hotline?
| | |
|
|
|
I just wrote an email to them. I do not have any hotline number.
But since one week no answer.
| | | |
| Not a real line, not really hot | May 24 |
Their 'hotline' is just a contact form on their website. And since it takes them more than one week to reply, I guess it's not very 'hot', either.
| | | |
Login to reply/comment 
Translation news related to Wordfast
