from-xls processor

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

from-xls processor

hodack
Hi,

Is there a configurable way to transform an imported Excel sheet to xml
file by looping through each Excel sheet's row and generate a new xml
element for each row instead of having all cells in one element. If yes,
how (configure excel template, processor, ...) ?
I'm using OPS 3.5.1.

For instance, instead of having this xml instance :
<workbook>
<sheet>
<el>
    <a>a</a>
   <b>b</b>
   <a>a1</a>
</el>
</sheet>
</workbook>

have this :
<workbook>
<sheet>
<el>
    <a>a</a>
    <b>b</b>
</el>
<el>
    <a>a1</a>
</el>
</sheet>
</workbook>

Thanks.


--
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
OW2 mailing lists service home page: http://www.ow2.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: from-xls processor

Alessandro Vernet
Administrator
On Feb 18, 2008, at 8:46 AM, Kim-Vân Ho-Dac wrote:

> Is there a configurable way to transform an imported Excel sheet to  
> xml file by looping through each Excel sheet's row and generate a  
> new xml element for each row instead of having all cells in one  
> element. If yes, how (configure excel template, processor, ...) ?
> I'm using OPS 3.5.1.

No, I don't think there is a way to do this at this point. But note  
that the code of the Excel processors is kind of deprecated and is  
really up for grab. It would benefit from being improved by someone  
who is actually using the processors. The code is out there, so feel  
free to give it a shot, and let us know if you need help along the way.

Alex
--
Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise
Orbeon's Blog: http://www.orbeon.com/blog/
Personal Blog: http://avernet.blogspot.com/



--
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
OW2 mailing lists service home page: http://www.ow2.org/wws