XLSX - Filter to read Column A as source and Colmn B as target

[Konstantinos Chatzitheodorou]

Is there any way to import an XLSX file that has in column A the source text and in column B the target text? For instance:

Name Nome
Home Casa
Book Libro

[Chase Tingley]

Yes, this can be done with the worksheet configurations feature.  I've attached a sample config that works for me with your example.

--
You received this message because you are subscribed to the Google Groups "okapi-devel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to okapi-devel...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/okapi-devel/e43db845-ceef-4355-8cb5-2ae0e9cc7c12n%40googlegroups.com.

[Konstantinos Chatzitheodorou]

Thank you for your reply and for sharing the config file.

I have tasted it, but it doesn't work. Here is the command I used:

/tikal.sh -x Book.xlsx -fc okf_o...@excelConfig.fprm

The output must have the values of column B in fr, given that the XLSX file I have is bilingual.

<group id="P132303AB-sg2" resname="2">
<trans-unit id="P147242AB-tu2" resname="Sheet1!B2" xml:space="preserve">
<source xml:lang="en">Home</source>
<target xml:lang="fr">Home</target>
</trans-unit>
</group>
<group id="P132303AB-sg3" resname="3">
<trans-unit id="P147242AB-tu3" resname="Sheet1!B3" xml:space="preserve">
<source xml:lang="en">Book</source>
<target xml:lang="fr">Book</target>
</trans-unit>
</group>
<group id="P132303AB-sg4" resname="4">
<trans-unit id="P147242AB-tu4" resname="Sheet1!B4" xml:space="preserve">
<source xml:lang="en">Help</source>
<target xml:lang="fr">Help</target>
</trans-unit>

[Denis A. Konovalyenko]

Hi Konstantinos,

Please try out setting extractExcelSourceAndTargetColumnsJoined.b=true

Thanks,

Denis

To view this discussion visit https://groups.google.com/d/msgid/okapi-devel/aa712c18-e5d2-43e0-bd7e-fa53439d4799n%40googlegroups.com.

[Konstantinos Chatzitheodorou]

Hi Denis

extractExcelSourceAndTargetColumnsJoined.b=true  worked!

Thanks a lot
Konstantinos