from-xls-converter question (bis)

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

from-xls-converter question (bis)

Martin Mohnhaupt
<corrected step 1 + 2 code>

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"/>
   
    <!-- Step 1 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>

    <!-- Step 2: Convert to XML -->
    <p:processor name="oxf:from-xls-converter">
        <p:input name="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
Reply | Threaded
Open this post in threaded view
|

Re: from-xls-converter question (bis)

Alessandro  Vernet
Administrator
Martin,

Has your spreadsheet been annotated with XPath expressions, as
described in "2.1. Preparing the Spreadsheet" on the page linked
below?

http://www.orbeon.com/ops/doc/processors-charts-spreadsheets

Alex

On 10/20/06, Martin Mohnhaupt <[hidden email]> wrote:

>
>  <corrected step 1 + 2 code>
>
>  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"/>
>
>      <!-- Step 1 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>
>
>      <!-- Step 2: Convert to XML -->
>      <p:processor name="oxf:from-xls-converter">
>          <p:input name="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
>
>
>

--
Blog (XML, Web apps, Open Source):
http://www.orbeon.com/blog/



--
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
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet