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.

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.

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 -

I would like to have the file if possible. Put on codecage and give me
posting or post the complete html file as text here (or potion that wil open
on an internet explorer. Here is a small example. I need the header tag so
it is complete.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"

<head
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /
<titleGoogle Translate API</title
</head

<body


<form name="f" id="f" action="#" onsubmit="translate(); return false;"

<textarea name="foreign_text" id="foreign_text" rows="4"
cols="60"</textarea
<br /
<br /

<input type="submit" id="submit_button" value="Translate into English"
onfocus="this.blur();" /
<br /
<br /

<textarea name="translation" id="translation" rows="4" cols="60"
onfocus="this.select();" readonly="true"</textarea</form
<br /

<script type="text/javascript" src="http://www.google.com/jsapi"</script
<script type="text/javascript"
google.load("language", "1");
function translate() {var
originaltext=document.forms["f"].foreign_text.value;
google.language.translate(originaltext, "", "en", function(result) {
document.forms["f"].translation.value = (result.error)?("Error:
"+result.error.message):result.translation; }); }
</script

</body
</html




"David gonzalez" wrote:

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 -

Hi.
I don't know if this is what you need.

This is the xml file I use to parse first, and later create the header
in html


<?xml version="1.0" encoding="UTF-8"?
<header
<cabecera tipo="1"
<table id="11" cols="7"
<tr
<td align="center" styleClass="logo" colspan="2"
width="20%" titulo="logo" 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
</cabecera
</header

This is the code created in html (using firebug)
<table id="j_id80:dataTable01" class="iceDatTbl" cellspacing="0"
style="border-collapse: collapse;"
<thead
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol logo" colspan="2"
<img id="j_id80:dataTable01:htmlGraphicImage" class="iceGphImg"
height="53" width="54" title="Banco Datos" style="" src="/
bancodatos3-1/xmlhttp/images/logobd3.gif" alt="Banco Datos"/
</th
<th class="iceDatTblColGrpHdrCol LCAB" colspan="5"
<span id="j_id80:dataTable01:htmlOutputText_13" class="iceOutTxt
textoCabecera"Clasificación de Ganado Bovino</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LCAB" rowspan="3" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_31" class="iceOutTxt
textoCabecera"Municipios</span
</th
<th class="iceDatTblColGrpHdrCol LN" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_33" class="iceOutTxt
textoCabecera"Animales menores de 12 meses</span
</th
<th class="iceDatTblColGrpHdrCol LN" colspan="3"
<span id="j_id80:dataTable01:htmlOutputText_35" class="iceOutTxt
textoCabecera"Animales mayores de 12 meses</span
</th
<th class="iceDatTblColGrpHdrCol LN2" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_37" class="iceOutTxt
textoCabecera"Nº total ejemplares</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LN" rowspan="2"
<span id="j_id80:dataTable01:htmlOutputText_51" class="iceOutTxt
textoCabecera"MACHOS</span
</th
<th class="iceDatTblColGrpHdrCol LN" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_53" class="iceOutTxt
textoCabecera"HEMBRAS</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_71" class="iceOutTxt
textoCabecera"Que no se ordeñan</span
</th
<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_73" class="iceOutTxt
textoCabecera"Que se ordeñan</span
</th
</tr
</thead
</table


thanks


On 2 oct, 14:07, Joel wrote:
I would like to have the file if possible. *Put on codecage and give me
posting or post the complete html file as text here (or potion that wil open
on an internet explorer. *Here is a small example. *I need the header tag so
it is complete.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"

<head
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /
<titleGoogle Translate API</title
</head

<body

<form name="f" id="f" action="#" onsubmit="translate(); return false;"

<textarea name="foreign_text" id="foreign_text" rows="4"
cols="60"</textarea
<br /
<br /

<input type="submit" id="submit_button" value="Translate into English"
onfocus="this.blur();" /
<br /
<br /

<textarea name="translation" id="translation" rows="4" cols="60"
onfocus="this.select();" readonly="true"</textarea</form
<br /

<script type="text/javascript" src="http://www.google.com/jsapi"</script
<script type="text/javascript"
google.load("language", "1");
function translate() {var
originaltext=document.forms["f"].foreign_text.value;
google.language.translate(originaltext, "", "en", function(result) {
document.forms["f"].translation.value = (result.error)?("Error:
"+result.error.message):result.translation; }); }
</script

</body
</html



"David gonzalez" wrote:
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 -- Ocultar texto de la cita -

- Mostrar texto de la cita -

You are going in the wrong direction!!!!!


Go to window explorer an select the XML file. Then right click and select
Open with Excel. Excel will make the table automatically. You can't do that
with HTML. I tried an hour ago. I didn't know from the data if it was XML
or HTML.

Let me know if I should continue looking at this request.

"David González" wrote:

Hi.
I don't know if this is what you need.

This is the xml file I use to parse first, and later create the header
in html


<?xml version="1.0" encoding="UTF-8"?
<header
<cabecera tipo="1"
<table id="11" cols="7"
<tr
<td align="center" styleClass="logo" colspan="2"
width="20%" titulo="logo" 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
</cabecera
</header

This is the code created in html (using firebug)
<table id="j_id80:dataTable01" class="iceDatTbl" cellspacing="0"
style="border-collapse: collapse;"
<thead
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol logo" colspan="2"
<img id="j_id80:dataTable01:htmlGraphicImage" class="iceGphImg"
height="53" width="54" title="Banco Datos" style="" src="/
bancodatos3-1/xmlhttp/images/logobd3.gif" alt="Banco Datos"/
</th
<th class="iceDatTblColGrpHdrCol LCAB" colspan="5"
<span id="j_id80:dataTable01:htmlOutputText_13" class="iceOutTxt
textoCabecera"Clasificación de Ganado Bovino</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LCAB" rowspan="3" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_31" class="iceOutTxt
textoCabecera"Municipios</span
</th
<th class="iceDatTblColGrpHdrCol LN" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_33" class="iceOutTxt
textoCabecera"Animales menores de 12 meses</span
</th
<th class="iceDatTblColGrpHdrCol LN" colspan="3"
<span id="j_id80:dataTable01:htmlOutputText_35" class="iceOutTxt
textoCabecera"Animales mayores de 12 meses</span
</th
<th class="iceDatTblColGrpHdrCol LN2" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_37" class="iceOutTxt
textoCabecera"Nº total ejemplares</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LN" rowspan="2"
<span id="j_id80:dataTable01:htmlOutputText_51" class="iceOutTxt
textoCabecera"MACHOS</span
</th
<th class="iceDatTblColGrpHdrCol LN" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_53" class="iceOutTxt
textoCabecera"HEMBRAS</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_71" class="iceOutTxt
textoCabecera"Que no se ordeñan</span
</th
<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_73" class="iceOutTxt
textoCabecera"Que se ordeñan</span
</th
</tr
</thead
</table


thanks


On 2 oct, 14:07, Joel wrote:
I would like to have the file if possible. Put on codecage and give me
posting or post the complete html file as text here (or potion that wil open
on an internet explorer. Here is a small example. I need the header tag so
it is complete.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"

<head
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /
<titleGoogle Translate API</title
</head

<body

<form name="f" id="f" action="#" onsubmit="translate(); return false;"

<textarea name="foreign_text" id="foreign_text" rows="4"
cols="60"</textarea
<br /
<br /

<input type="submit" id="submit_button" value="Translate into English"
onfocus="this.blur();" /
<br /
<br /

<textarea name="translation" id="translation" rows="4" cols="60"
onfocus="this.select();" readonly="true"</textarea</form
<br /

<script type="text/javascript" src="http://www.google.com/jsapi"</script
<script type="text/javascript"
google.load("language", "1");
function translate() {var
originaltext=document.forms["f"].foreign_text.value;
google.language.translate(originaltext, "", "en", function(result) {
document.forms["f"].translation.value = (result.error)?("Error:
"+result.error.message):result.translation; }); }
</script

</body
</html



"David gonzalez" wrote:
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 -- Ocultar texto de la cita -

- Mostrar texto de la cita -

Hi,

no way, excel didn't open as you told me, I select excel but opens
with notepad.

Later I tried to open from excel program using open/as list xml and
the other 2 options, but it doesn't create the headers as I want. It
creates several formata but no grouping headers.

Maybe changing the structure of the xml file, or have you got
something similiar which works. I mean, an xml file you open as you
told me and creating the corrects grouping headers in excel. If so, I
would change my file to adapt to these requeriments.

thanks againg

On 2 oct, 15:01, Joel wrote:
You are going in the *wrong direction!!!!!

Go to window explorer an select the XML file. *Then right click and select
Open with Excel. *Excel will make the table automatically. *You can't do that
with HTML. *I tried an hour ago. *I didn't know from the data if it was XML
or HTML.

Let me know if I should continue looking at this request.



"David González" wrote:
Hi.
I don't know if this is what you need.

This is the xml file I use to parse first, and later create the header
in html

<?xml version="1.0" encoding="UTF-8"?
<header
* *<cabecera tipo="1"
* * * * * *<table id="11" cols="7"
* * * * * * * * * *<tr
* * * * * * * * * * * * * *<td align="center" styleClass="logo" colspan="2"
* * * * * * * * * * * * * * * * * *width="20%" titulo="logo" 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
* *</cabecera
</header

This is the code created in html (using firebug)
<table id="j_id80:dataTable01" class="iceDatTbl" cellspacing="0"
style="border-collapse: collapse;"
*<thead
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol logo" colspan="2"
<img id="j_id80:dataTable01:htmlGraphicImage" class="iceGphImg"
height="53" width="54" title="Banco Datos" style="" src="/
bancodatos3-1/xmlhttp/images/logobd3.gif" alt="Banco Datos"/
</th
*<th class="iceDatTblColGrpHdrCol LCAB" colspan="5"
<span id="j_id80:dataTable01:htmlOutputText_13" class="iceOutTxt
textoCabecera"Clasificación de Ganado Bovino</span
</th
</tr
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol LCAB" rowspan="3" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_31" class="iceOutTxt
textoCabecera"Municipios</span
</th
*<th class="iceDatTblColGrpHdrCol LN" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_33" class="iceOutTxt
textoCabecera"Animales menores de 12 meses</span
</th
*<th class="iceDatTblColGrpHdrCol LN" colspan="3"
<span id="j_id80:dataTable01:htmlOutputText_35" class="iceOutTxt
textoCabecera"Animales mayores de 12 meses</span
</th
*<th class="iceDatTblColGrpHdrCol LN2" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_37" class="iceOutTxt
textoCabecera"Nº total ejemplares</span
</th
</tr
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol LN" rowspan="2"
<span id="j_id80:dataTable01:htmlOutputText_51" class="iceOutTxt
textoCabecera"MACHOS</span
</th
*<th class="iceDatTblColGrpHdrCol LN" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_53" class="iceOutTxt
textoCabecera"HEMBRAS</span
</th
</tr
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_71" class="iceOutTxt
textoCabecera"Que no se ordeñan</span
</th
*<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_73" class="iceOutTxt
textoCabecera"Que se ordeñan</span
</th
</tr
</thead
</table

thanks

On 2 oct, 14:07, Joel wrote:
I would like to have the file if possible. *Put on codecage and give me
posting or post the complete html file as text here (or potion that wil open
on an internet explorer. *Here is a small example. *I need the header tag so
it is complete.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"

<head
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /
<titleGoogle Translate API</title
</head

<body

<form name="f" id="f" action="#" onsubmit="translate(); return false;"

<textarea name="foreign_text" id="foreign_text" rows="4"
cols="60"</textarea
<br /
<br /

<input type="submit" id="submit_button" value="Translate into English"
onfocus="this.blur();" /
<br /
<br /

<textarea name="translation" id="translation" rows="4" cols="60"
onfocus="this.select();" readonly="true"</textarea</form
<br /

<script type="text/javascript" src="http://www.google.com/jsapi"</script
<script type="text/javascript"
google.load("language", "1");
function translate() {var
originaltext=document.forms["f"].foreign_text.value;
google.language.translate(originaltext, "", "en", function(result) {
document.forms["f"].translation.value = (result.error)?("Error:
"+result.error.message):result.translation; }); }
</script

</body
</html

"David gonzalez" wrote:
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 -- Ocultar texto de la cita -

- Mostrar texto de la cita -- Ocultar texto de la cita -

- Mostrar texto de la cita -

Did you use "OPEN WITH" and then select Excel? This is working with excel
2003 with our XML files. We have simple XML with one table per XML. I
haven't tried this with multiple tables in the same XML file.


Maybe you should go in the other direction. Enter a table into excel and
save as XML. Then see the XML that excel produces. Use that as a template
for creating your files.

"David González" wrote:

Hi,

no way, excel didn't open as you told me, I select excel but opens
with notepad.

Later I tried to open from excel program using open/as list xml and
the other 2 options, but it doesn't create the headers as I want. It
creates several formata but no grouping headers.

Maybe changing the structure of the xml file, or have you got
something similiar which works. I mean, an xml file you open as you
told me and creating the corrects grouping headers in excel. If so, I
would change my file to adapt to these requeriments.

thanks againg

On 2 oct, 15:01, Joel wrote:
You are going in the wrong direction!!!!!

Go to window explorer an select the XML file. Then right click and select
Open with Excel. Excel will make the table automatically. You can't do that
with HTML. I tried an hour ago. I didn't know from the data if it was XML
or HTML.

Let me know if I should continue looking at this request.



"David González" wrote:
Hi.
I don't know if this is what you need.

This is the xml file I use to parse first, and later create the header
in html

<?xml version="1.0" encoding="UTF-8"?
<header
<cabecera tipo="1"
<table id="11" cols="7"
<tr
<td align="center" styleClass="logo" colspan="2"
width="20%" titulo="logo" 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
</cabecera
</header

This is the code created in html (using firebug)
<table id="j_id80:dataTable01" class="iceDatTbl" cellspacing="0"
style="border-collapse: collapse;"
<thead
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol logo" colspan="2"
<img id="j_id80:dataTable01:htmlGraphicImage" class="iceGphImg"
height="53" width="54" title="Banco Datos" style="" src="/
bancodatos3-1/xmlhttp/images/logobd3.gif" alt="Banco Datos"/
</th
<th class="iceDatTblColGrpHdrCol LCAB" colspan="5"
<span id="j_id80:dataTable01:htmlOutputText_13" class="iceOutTxt
textoCabecera"Clasificación de Ganado Bovino</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LCAB" rowspan="3" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_31" class="iceOutTxt
textoCabecera"Municipios</span
</th
<th class="iceDatTblColGrpHdrCol LN" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_33" class="iceOutTxt
textoCabecera"Animales menores de 12 meses</span
</th
<th class="iceDatTblColGrpHdrCol LN" colspan="3"
<span id="j_id80:dataTable01:htmlOutputText_35" class="iceOutTxt
textoCabecera"Animales mayores de 12 meses</span
</th
<th class="iceDatTblColGrpHdrCol LN2" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_37" class="iceOutTxt
textoCabecera"Nº total ejemplares</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LN" rowspan="2"
<span id="j_id80:dataTable01:htmlOutputText_51" class="iceOutTxt
textoCabecera"MACHOS</span
</th
<th class="iceDatTblColGrpHdrCol LN" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_53" class="iceOutTxt
textoCabecera"HEMBRAS</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_71" class="iceOutTxt
textoCabecera"Que no se ordeñan</span
</th
<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_73" class="iceOutTxt
textoCabecera"Que se ordeñan</span
</th
</tr
</thead
</table

thanks

On 2 oct, 14:07, Joel wrote:
I would like to have the file if possible. Put on codecage and give me
posting or post the complete html file as text here (or potion that wil open
on an internet explorer. Here is a small example. I need the header tag so
it is complete.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"

<head
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /
<titleGoogle Translate API</title
</head

<body

<form name="f" id="f" action="#" onsubmit="translate(); return false;"

<textarea name="foreign_text" id="foreign_text" rows="4"
cols="60"</textarea
<br /
<br /

<input type="submit" id="submit_button" value="Translate into English"
onfocus="this.blur();" /
<br /
<br /

<textarea name="translation" id="translation" rows="4" cols="60"
onfocus="this.select();" readonly="true"</textarea</form
<br /

<script type="text/javascript" src="http://www.google.com/jsapi"</script
<script type="text/javascript"
google.load("language", "1");
function translate() {var
originaltext=document.forms["f"].foreign_text.value;
google.language.translate(originaltext, "", "en", function(result) {
document.forms["f"].translation.value = (result.error)?("Error:
"+result.error.message):result.translation; }); }
</script

</body
</html

"David gonzalez" wrote:
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 -- Ocultar texto de la cita -

- Mostrar texto de la cita -- Ocultar texto de la cita -

- Mostrar texto de la cita -

Hi again,

yes I have tries as you told, but no way (excel 2003).

I have done what you told me about save as xml file. I'll try to go in
that way..


If I have any doubts I'll post again. Thanks for your advices.

Greetings


On 2 oct, 15:29, Joel wrote:
Did you use "OPEN WITH" and then select Excel? *This is working with excel
2003 with our XML files. *We have simple XML with one table per XML. *I
haven't tried this with multiple tables in the same XML file.

Maybe you should go in the other direction. *Enter a table into excel and
save as XML. *Then see the XML that excel produces. *Use that as a template
for creating your files."David González" wrote:
Hi,

no way, excel didn't open as you told me, I select excel but opens
with notepad.

Later I tried to open from excel program using open/as list xml and
the other 2 options, but it doesn't create the headers as I want. It
creates several formata but no grouping headers.

Maybe changing the structure of the xml file, or have you got
something similiar which works. I mean, an xml file you *open as you
told me and creating the corrects grouping headers in excel. If so, I
would change my file to adapt to these requeriments.

thanks againg

On 2 oct, 15:01, Joel wrote:
You are going in the *wrong direction!!!!!

Go to window explorer an select the XML file. *Then right click and select
Open with Excel. *Excel will make the table automatically. *You can't do that
with HTML. *I tried an hour ago. *I didn't know from the data if it was XML
or HTML.

Let me know if I should continue looking at this request.

"David González" wrote:
Hi.
I don't know if this is what you need.

This is the xml file I use to parse first, and later create the header
in html

<?xml version="1.0" encoding="UTF-8"?
<header
* *<cabecera tipo="1"
* * * * * *<table id="11" cols="7"
* * * * * * * * * *<tr
* * * * * * * * * * * * * *<td align="center" styleClass="logo" colspan="2"
* * * * * * * * * * * * * * * * * *width="20%" titulo="logo" 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
* *</cabecera
</header

This is the code created in html (using firebug)
<table id="j_id80:dataTable01" class="iceDatTbl" cellspacing="0"
style="border-collapse: collapse;"
*<thead
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol logo" colspan="2"
<img id="j_id80:dataTable01:htmlGraphicImage" class="iceGphImg"
height="53" width="54" title="Banco Datos" style="" src="/
bancodatos3-1/xmlhttp/images/logobd3.gif" alt="Banco Datos"/
</th
*<th class="iceDatTblColGrpHdrCol LCAB" colspan="5"
<span id="j_id80:dataTable01:htmlOutputText_13" class="iceOutTxt
textoCabecera"Clasificación de Ganado Bovino</span
</th
</tr
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol LCAB" rowspan="3" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_31" class="iceOutTxt
textoCabecera"Municipios</span
</th
*<th class="iceDatTblColGrpHdrCol LN" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_33" class="iceOutTxt
textoCabecera"Animales menores de 12 meses</span
</th
*<th class="iceDatTblColGrpHdrCol LN" colspan="3"
<span id="j_id80:dataTable01:htmlOutputText_35" class="iceOutTxt
textoCabecera"Animales mayores de 12 meses</span
</th
*<th class="iceDatTblColGrpHdrCol LN2" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_37" class="iceOutTxt
textoCabecera"Nº total ejemplares</span
</th
</tr
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol LN" rowspan="2"
<span id="j_id80:dataTable01:htmlOutputText_51" class="iceOutTxt
textoCabecera"MACHOS</span
</th
*<th class="iceDatTblColGrpHdrCol LN" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_53" class="iceOutTxt
textoCabecera"HEMBRAS</span
</th
</tr
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_71" class="iceOutTxt
textoCabecera"Que no se ordeñan</span
</th
*<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_73" class="iceOutTxt
textoCabecera"Que se ordeñan</span
</th
</tr
</thead
</table

thanks

On 2 oct, 14:07, Joel wrote:
I would like to have the file if possible. *Put on codecage and give me
posting or post the complete html file as text here (or potion that wil open
on an internet explorer. *Here is a small example. *I need the header tag so
it is complete.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"

<head
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /
<titleGoogle Translate API</title
</head

<body

<form name="f" id="f" action="#" onsubmit="translate(); return false;"

<textarea name="foreign_text" id="foreign_text" rows="4"
cols="60"</textarea
<br /
<br /

<input type="submit" id="submit_button" value="Translate into English"
onfocus="this.blur();" /
<br /
<br /

<textarea name="translation" id="translation" rows="4" cols="60"
onfocus="this.select();" readonly="true"</textarea</form
<br /

<script type="text/javascript" src="http://www.google.com/jsapi"</script
<script type="text/javascript"
google.load("language", "1");
function translate() {var
originaltext=document.forms["f"].foreign_text.value;
google.language.translate(originaltext, "", "en", function(result) {
document.forms["f"].translation.value = (result.error)?("Error:
"+result.error.message):result.translation; }); }
</script

</body
</html

"David gonzalez" wrote:
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 -- Ocultar texto de la cita -

- Mostrar texto de la cita -- Ocultar texto de la cita -

- Mostrar texto de la cita -

I just had time to try some more things. I took you XML file and called it
Test.XML. the opened with excel and it work fine. what may of happeded is
the extension got change on the file to Test.XML.Txt. Windows added the txt
extension without me knowing. I think that is why you are getting text.

Go to you window explorer and change this option.

Tools - Options - view - hide extension for known file types - unclick box

Then press Apoply to All folders

Then go back and fix the filename.

I hate this option because windows often adds a 2nd extension to a filename
and screw up which program opens a file.



"David González" wrote:

Hi again,

yes I have tries as you told, but no way (excel 2003).

I have done what you told me about save as xml file. I'll try to go in
that way..


If I have any doubts I'll post again. Thanks for your advices.

Greetings


On 2 oct, 15:29, Joel wrote:
Did you use "OPEN WITH" and then select Excel? This is working with excel
2003 with our XML files. We have simple XML with one table per XML. I
haven't tried this with multiple tables in the same XML file.

Maybe you should go in the other direction. Enter a table into excel and
save as XML. Then see the XML that excel produces. Use that as a template
for creating your files."David González" wrote:
Hi,

no way, excel didn't open as you told me, I select excel but opens
with notepad.

Later I tried to open from excel program using open/as list xml and
the other 2 options, but it doesn't create the headers as I want. It
creates several formata but no grouping headers.

Maybe changing the structure of the xml file, or have you got
something similiar which works. I mean, an xml file you open as you
told me and creating the corrects grouping headers in excel. If so, I
would change my file to adapt to these requeriments.

thanks againg

On 2 oct, 15:01, Joel wrote:
You are going in the wrong direction!!!!!

Go to window explorer an select the XML file. Then right click and select
Open with Excel. Excel will make the table automatically. You can't do that
with HTML. I tried an hour ago. I didn't know from the data if it was XML
or HTML.

Let me know if I should continue looking at this request.

"David González" wrote:
Hi.
I don't know if this is what you need.

This is the xml file I use to parse first, and later create the header
in html

<?xml version="1.0" encoding="UTF-8"?
<header
<cabecera tipo="1"
<table id="11" cols="7"
<tr
<td align="center" styleClass="logo" colspan="2"
width="20%" titulo="logo" 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
</cabecera
</header

This is the code created in html (using firebug)
<table id="j_id80:dataTable01" class="iceDatTbl" cellspacing="0"
style="border-collapse: collapse;"
<thead
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol logo" colspan="2"
<img id="j_id80:dataTable01:htmlGraphicImage" class="iceGphImg"
height="53" width="54" title="Banco Datos" style="" src="/
bancodatos3-1/xmlhttp/images/logobd3.gif" alt="Banco Datos"/
</th
<th class="iceDatTblColGrpHdrCol LCAB" colspan="5"
<span id="j_id80:dataTable01:htmlOutputText_13" class="iceOutTxt
textoCabecera"Clasificación de Ganado Bovino</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LCAB" rowspan="3" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_31" class="iceOutTxt
textoCabecera"Municipios</span
</th
<th class="iceDatTblColGrpHdrCol LN" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_33" class="iceOutTxt
textoCabecera"Animales menores de 12 meses</span
</th
<th class="iceDatTblColGrpHdrCol LN" colspan="3"
<span id="j_id80:dataTable01:htmlOutputText_35" class="iceOutTxt
textoCabecera"Animales mayores de 12 meses</span
</th
<th class="iceDatTblColGrpHdrCol LN2" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_37" class="iceOutTxt
textoCabecera"Nº total ejemplares</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LN" rowspan="2"
<span id="j_id80:dataTable01:htmlOutputText_51" class="iceOutTxt
textoCabecera"MACHOS</span
</th
<th class="iceDatTblColGrpHdrCol LN" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_53" class="iceOutTxt
textoCabecera"HEMBRAS</span
</th
</tr
<tr class="iceDatTblColGrpHdrRow"
<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_71" class="iceOutTxt
textoCabecera"Que no se ordeñan</span
</th
<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_73" class="iceOutTxt
textoCabecera"Que se ordeñan</span
</th
</tr
</thead
</table

thanks

On 2 oct, 14:07, Joel wrote:
I would like to have the file if possible. Put on codecage and give me
posting or post the complete html file as text here (or potion that wil open
on an internet explorer. Here is a small example. I need the header tag so
it is complete.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"

<head
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /
<titleGoogle Translate API</title
</head

<body

<form name="f" id="f" action="#" onsubmit="translate(); return false;"

<textarea name="foreign_text" id="foreign_text" rows="4"
cols="60"</textarea
<br /
<br /

<input type="submit" id="submit_button" value="Translate into English"
onfocus="this.blur();" /
<br /
<br /

<textarea name="translation" id="translation" rows="4" cols="60"
onfocus="this.select();" readonly="true"</textarea</form
<br /

<script type="text/javascript" src="http://www.google.com/jsapi"</script
<script type="text/javascript"
google.load("language", "1");
function translate() {var
originaltext=document.forms["f"].foreign_text.value;
google.language.translate(originaltext, "", "en", function(result) {
document.forms["f"].translation.value = (result.error)?("Error:
"+result.error.message):result.translation; }); }
</script

</body
</html

"David gonzalez" wrote:
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 -- Ocultar texto de la cita -

- Mostrar texto de la cita -- Ocultar texto de la cita -

- Mostrar texto de la cita -

Hi,
I have changed my O.S. (I was windows 7) and now I can open the xml,
but the format is not correct.

Finally I have created by hand the format in and excel sheet as I want
and I have generated the code that excel uses to create merge cells,
etc...

Its completly diferent. it define <row and number of columns, but It
does not have anything to see with my structure

Here is:

<?xml version="1.0"?
<?mso-application progid="Excel.Sheet"?
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40"
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"
<TitleBANCO DE DATOS: demografía.</Title
<LastAuthordavid</LastAuthor
<Created2009-10-02T17:01:21Z</Created
<Version11.9999</Version
</DocumentProperties
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"
<WindowHeight9015</WindowHeight
<WindowWidth14115</WindowWidth
<WindowTopX600</WindowTopX
<WindowTopY90</WindowTopY
<ProtectStructureFalse</ProtectStructure
<ProtectWindowsFalse</ProtectWindows
</ExcelWorkbook
<Styles
<Style ss:ID="Default" ss:Name="Normal"
<Alignment ss:Vertical="Bottom"/
<Borders/
<Font/
<Interior/
<NumberFormat/
<Protection/
</Style
<Style ss:ID="m75079444"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="m75079454"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="m75079464"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="m75079474"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="m75079484"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="m75079494"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="s21"
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="s24"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="s28"
<Borders
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="s32"
<Alignment ss:Vertical="Bottom" ss:WrapText="1"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="s34"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="s35"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="s37"
<Borders
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
<Style ss:ID="s40"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"
ss:WrapText="1"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/
</Borders
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/
</Style
</Styles
<Worksheet ss:Name="Agri01M"
<Names
<NamedRange ss:Name="ini" ss:RefersTo="=Agri01M!#REF!"/
</Names
<Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="8"
x:FullColumns="1"
x:FullRows="1" ss:StyleID="s21" ss:DefaultColumnWidth="60"
<Column ss:StyleID="s21" ss:Width="240"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="56.25"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="48"/
<Column ss:StyleID="s21" ss:Width="88.5"/
<Column ss:StyleID="s21" ss:Width="74.25"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="52.5"/
<Row
<Cell ss:MergeDown="1" ss:StyleID="m75079444"/
<Cell ss:MergeAcross="4" ss:MergeDown="1"
ss:StyleID="m75079454"<Data
ss:Type="String"Clasificación de Ganado Bovino</Data</Cell
<Cell ss:StyleID="s28"/
</Row
<Row
<Cell ss:Index="7" ss:StyleID="s32"/
</Row
<Row
<Cell ss:MergeDown="5" ss:StyleID="m75079464"<Data
ss:Type="String"Municipios</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"Animales</Data</
Cell
<Cell ss:MergeAcross="2" ss:MergeDown="3"
ss:StyleID="m75079474"<Data
ss:Type="String"Animales mayores de 12 meses</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"Nº</Data</Cell
<Cell ss:StyleID="s37"/
</Row
<Row
<Cell ss:Index="2" ss:StyleID="s34"/
<Cell ss:Index="6" ss:StyleID="s34"<Data ss:Type="String"total</
Data</Cell
<Cell ss:StyleID="s37"/
</Row
<Row
<Cell ss:Index="2" ss:StyleID="s34"/
<Cell ss:Index="6" ss:StyleID="s34"<Data
ss:Type="String"ejemplares</Data</Cell
<Cell ss:StyleID="s37"/
</Row
<Row
<Cell ss:Index="2" ss:StyleID="s34"/
<Cell ss:Index="6" ss:StyleID="s34"/
<Cell ss:StyleID="s37"/
</Row
<Row ss:AutoFitHeight="0"
<Cell ss:Index="2" ss:StyleID="s34"<Data ss:Type="String"menores
de</Data</Cell
<Cell ss:MergeDown="1" ss:StyleID="m75079484"<Data
ss:Type="String"MACHOS</Data</Cell
<Cell ss:MergeAcross="1" ss:StyleID="m75079494"<Data
ss:Type="String"HEMBRAS</Data</Cell
<Cell ss:StyleID="s34"/
<Cell ss:StyleID="s37"/
</Row
<Row
<Cell ss:Index="2" ss:StyleID="s35"<Data ss:Type="String"12
meses</Data</Cell
<Cell ss:Index="4" ss:StyleID="s40"<Data ss:Type="String"Que no
se ordeñan</Data</Cell
<Cell ss:StyleID="s40"<Data ss:Type="String"Que se ordeñan</
Data</Cell
<Cell ss:StyleID="s35"/
<Cell ss:StyleID="s37"/
</Row
</Table
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"
<PageSetup
<Header x:Margin="0"/
<Footer x:Margin="0"/
<PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
x:Right="0.78740157499999996" x:Top="0.984251969"/
</PageSetup
<Selected/
<DoNotDisplayGridlines/
<Panes
<Pane
<Number3</Number
<RangeSelectionR1:R3</RangeSelection
</Pane
</Panes
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
</Workbook


On 2 oct, 23:58, Joel wrote:
I just had time to try some more things. *I took you XML file and called it
Test.XML. *the opened with excel and it work fine. *what may of happeded is
the extension got change on the file to Test.XML.Txt. *Windows added the txt
extension without me knowing. *I think that is why you are getting text..

Go to you window explorer and change this option.

Tools - Options - view - hide extension for known file types - unclick box

Then press Apoply to All folders

Then go back and fix the filename.

I hate this option because windows often adds a 2nd extension to a filename
and screw up which program opens a file.



"David González" wrote:
Hi again,

yes I have tries as you told, but no way (excel 2003).

I have done what you told me about save as xml file. I'll try to go in
that way..

If I have any doubts I'll post again. Thanks for your advices.

Greetings

On 2 oct, 15:29, Joel wrote:
Did you use "OPEN WITH" and then select Excel? *This is working with excel
2003 with our XML files. *We have simple XML with one table per XML.. *I
haven't tried this with multiple tables in the same XML file.

Maybe you should go in the other direction. *Enter a table into excel and
save as XML. *Then see the XML that excel produces. *Use that as a template
for creating your files."David González" wrote:
Hi,

no way, excel didn't open as you told me, I select excel but opens
with notepad.

Later I tried to open from excel program using open/as list xml and
the other 2 options, but it doesn't create the headers as I want. It
creates several formata but no grouping headers.

Maybe changing the structure of the xml file, or have you got
something similiar which works. I mean, an xml file you *open as you
told me and creating the corrects grouping headers in excel. If so, I
would change my file to adapt to these requeriments.

thanks againg

On 2 oct, 15:01, Joel wrote:
You are going in the *wrong direction!!!!!

Go to window explorer an select the XML file. *Then right click and select
Open with Excel. *Excel will make the table automatically. *You can't do that
with HTML. *I tried an hour ago. *I didn't know from the data if it was XML
or HTML.

Let me know if I should continue looking at this request.

"David González" wrote:
Hi.
I don't know if this is what you need.

This is the xml file I use to parse first, and later create the header
in html

<?xml version="1.0" encoding="UTF-8"?
<header
* *<cabecera tipo="1"
* * * * * *<table id="11" cols="7"
* * * * * * * * * *<tr
* * * * * * * * * * * * * *<td align="center" styleClass="logo" colspan="2"
* * * * * * * * * * * * * * * * * *width="20%" titulo="logo" 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
* *</cabecera
</header

This is the code created in html (using firebug)
<table id="j_id80:dataTable01" class="iceDatTbl" cellspacing="0"
style="border-collapse: collapse;"
*<thead
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol logo" colspan="2"
<img id="j_id80:dataTable01:htmlGraphicImage" class="iceGphImg"
height="53" width="54" title="Banco Datos" style="" src="/
bancodatos3-1/xmlhttp/images/logobd3.gif" alt="Banco Datos"/
</th
*<th class="iceDatTblColGrpHdrCol LCAB" colspan="5"
<span id="j_id80:dataTable01:htmlOutputText_13" class="iceOutTxt
textoCabecera"Clasificación de Ganado Bovino</span
</th
</tr
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol LCAB" rowspan="3" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_31" class="iceOutTxt
textoCabecera"Municipios</span
</th
*<th class="iceDatTblColGrpHdrCol LN" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_33" class="iceOutTxt
textoCabecera"Animales menores de 12 meses</span
</th
*<th class="iceDatTblColGrpHdrCol LN" colspan="3"
<span id="j_id80:dataTable01:htmlOutputText_35" class="iceOutTxt
textoCabecera"Animales mayores de 12 meses</span
</th
*<th class="iceDatTblColGrpHdrCol LN2" rowspan="3"
<span id="j_id80:dataTable01:htmlOutputText_37" class="iceOutTxt
textoCabecera"Nº total ejemplares</span
</th
</tr
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol LN" rowspan="2"
<span id="j_id80:dataTable01:htmlOutputText_51" class="iceOutTxt
textoCabecera"MACHOS</span
</th
*<th class="iceDatTblColGrpHdrCol LN" colspan="2"
<span id="j_id80:dataTable01:htmlOutputText_53" class="iceOutTxt
textoCabecera"HEMBRAS</span
</th
</tr
*<tr class="iceDatTblColGrpHdrRow"
*<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_71" class="iceOutTxt
textoCabecera"Que no se ordeñan</span
</th
*<th class="iceDatTblColGrpHdrCol LN"
<span id="j_id80:dataTable01:htmlOutputText_73" class="iceOutTxt
textoCabecera"Que se ordeñan</span
</th
</tr
</thead
</table

thanks

On 2 oct, 14:07, Joel wrote:
I would like to have the file if possible. *Put on codecage and give me
posting or post the complete html file as text here (or potion that wil open
on an internet explorer. *Here is a small example. *I need the header tag so
it is complete.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"

<head
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /
<titleGoogle Translate API</title
</head

<body

<form name="f" id="f" action="#" onsubmit="translate(); return false;"

<textarea name="foreign_text" id="foreign_text" rows="4"
cols="60"</textarea
<br /
<br /

<input type="submit" id="submit_button" value="Translate into English"
onfocus="this.blur();" /
<br /
<br /

<textarea name="translation" id="translation" rows="4" cols="60"
onfocus="this.select();" readonly="true"</textarea</form
<br /

<script type="text/javascript" src="http://www.google.com/jsapi"</script
<script type="text/javascript"
google.load("language", "1");
function translate() {var
originaltext=document.forms["f"].foreign_text.value;
google.language.translate(originaltext, "", "en", function(result) {
document.forms["f"].translation.value = (result.error)?("Error:
"+result.error.message):result.translation; }); }
</script

</body
</html

"David gonzalez" wrote:
Hi, Joel.

Any update about this stuff???

thanks

On 24 sep, 19:06, Joel

...

leer más »- Ocultar texto de la cita -

- Mostrar texto de la cita -