Create merge cells from table definition
Hi, Joel.
Any update about this stuff???
thanks
On 24 sep, 19:06, Joel wrote:
You are going about this the wrong way. *To open up an internet explorer in
VBA and read the table into excel. *Much easier. *If you post your html file
at code TheCodeCage.com or give me a URL to the webpage I can do it very
simply.
"netdaviso" wrote:
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.- Ocultar texto de la cita -
- Mostrar texto de la cita -
|