View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David gonzalez David gonzalez is offline
external usenet poster
 
Posts: 2
Default 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 -