from-xls-converter question

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

from-xls-converter question

Martin Mohnhaupt
Dear group,

I am playing with OPS 3.5 M1 and the from-xls-converter. I am trying to convert an xls file (1 workbook + 1 sheet) to xml using the configuration shown below.

Step 1 (test.xls -> bin64) seems to work fine.
Step 2 (binary -> xml) just gives me this:

<workbook>
   <sheet></sheet>
</workbook>

When I add a sheet to my excel workbook, i get a second <sheet></sheet> tag pair. I wonder why I cannot see any of my data.

Can someone give me a hint ?

Best regards & Thanks!

-Martin

<p:config xmlns:p="http://www.orbeon.com/oxf/pipeline"
    xmlns:oxf="http://www.orbeon.com/oxf/processors">

    <p:param name="data" type="output"/>
   
    <!-- Make a binary -->
    <p:processor name="oxf:url-generator">
        <p:input name="config">
            <config>
                <url>test.xls</url>
                <content-type>binary/octet-stream</content-type>
                <force-content-type>true</force-content-type>
            </config>   
        </p:input>   
    <p:output name="data" id="xls-binary"/>
    </p:processor>

    <!-- Convert to XML -->
    <p:processor name="oxf:from-xls-converter">
        <p:input name="config">
            <config>
                <template>test.xls</template>
            </config>
        </p:input>
        <p:input name="data" href="#xls-binary"/>
        <p:output name="xml-data" ref="data"/>
    </p:processor>
</p:config>

-- 
Martin Mohnhaupt
Nice Data Systems
Rue de Lyon 42 - CH 1203 GENEVE
Tél: +41 (0) 22 344 11 39
Mob: +41 (0) 78 636 00 75
Email: [hidden email]
Web: http://www.nicedata.com
Skype: martin.mohnhaupt


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws