Skip to content

OpenXML Filter: allow the extraction of only explicitly specified worksheets

This can be implemented via the explicitly specified worksheet configurations.

Example document - worksheets.xlsx

Sheet1 content: image

Sheet2 content: image

Sheet3 content: image

Parameters:

worksheetConfigurations.0.namePattern=Sheet1
worksheetConfigurations.number.i=1

Expected extraction:

<group id="P76C545-sg1" resname="Sheet1">
<group id="P132303AB-sg1" resname="1">
<group id="P147242AB-tu1_ssf1" resname="sub-filter:Sheet1!A1">
<trans-unit id="P147242AB-tu1_sf1_tu1" resname="Sheet1!A1_1">
<source xml:lang="en">S1</source>
<target xml:lang="fr"></target>
</trans-unit>
</group>
</group>
</group>
<group id="P76C545-sg2" resname="Sheet2">
<group id="P13311B2C-sg1" resname="1">
</group>
</group>
<group id="P76C545-sg3" resname="Sheet3">
<group id="P133F32AD-sg1" resname="1">
</group>
</group>