OpenXML Filter: XLSX: provide the extraction of source and target columns joined
There is a possibility to extract and then merge as usual the source and target cells as textual units with the source and target content. For instance,
a document with the next data in place
and a specific configuration options:
extractExcelSourceAndTargetColumnsJoined.b=true
worksheetConfigurations.number.i=1
worksheetConfigurations.0.namePattern=Sheet1
worksheetConfigurations.0.sourceColumns=A
worksheetConfigurations.0.targetColumns=B
The following extraction could be observed:
<group id="P76C545-sg1" resname="Sheet1">
<group id="P132303AB-sg1" resname="1">
<trans-unit id="P147242AB-tu1" resname="Sheet1!B1" xml:space="preserve">
<source xml:lang="en">Formatted text</source>
<target xml:lang="fr">B1</target>
</trans-unit>
</group>
<group id="P132303AB-sg2" resname="3">
<trans-unit id="P147242AB-tu2" resname="Sheet1!B3" xml:space="preserve">
<source xml:lang="en">Text</source>
<target xml:lang="fr">B3 <g id="1">formatted</g></target>
</trans-unit>
</group>
<group id="P132303AB-sg3" resname="4">
<trans-unit id="P147242AB-tu3" resname="Sheet1!B4" xml:space="preserve">
<source xml:lang="en">Text 2</source>
<target xml:lang="fr"></target>
</trans-unit>
</group>
</group>
The mentioned document source-and-target-joined.xlsx is attached for convenience.