<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 |
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 |
Free forum by Nabble | Edit this page |