Create merge cells from table definition
Hi.
I have a definition of a table in html. I want to export using java
code and sax to excel, but I can get a way of doing Iterative.
let's say we have something like this:
<table id="11" cols="7"
<tr
<td align="center" styleClass="logo" colspan="2"
width="20%" media="/xmlhttp/images/logobd3.gif"
</td
<td styleClass="LCAB" align="center" colspan="5"
titulo="header.id_11.Titulo"
</td
</tr
<tr
<td styleClass="LCAB" rowspan="3" align="center"
colspan="2" titulo="header.id_11.row_1"
</td
<td styleClass="LN" rowspan="3" align="center"
titulo="header.id_11.row_2"
</td
<td styleClass="LN" colspan="3" align="center"
titulo="header.id_11.row_3"
</td
<td rowspan="3" align="center" styleClass="LN2"
titulo="header.id_11.row_4"
</td
</tr
<tr
<td styleClass="LN" rowspan="2" align="center"
titulo="header.id_11.row_5"
</td
<td styleClass="LN" colspan="2" align="center"
titulo="header.id_11.row_6"
</td
</tr
<tr
<td styleClass="LN" align="center"
titulo="header.id_11.row_7"
</td
<td styleClass="LN" align="center"
titulo="header.id_11.row_8"
</td
</tr
</table
as you can see this is the typical definition of a header in a word
document. I mean, if you translate into html a word document into html
you get something like this.
What I want to do is parse this document (as xml for instance) and
create this structure in an excel file using jxl or hssf or whatever
tool.
I want to do iteratively because I have several diferents headers.
I have tried to copy the macro in excel to copy from word to excel,
but I only I get activesheet.paste. So How works paste?,
I hope I have explained.
Maybe somebody have done somehting similar.
Thanks
PD: I can't attach the image with the result in excel.
|