Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > Create merge cells from table definition
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 1
Default 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.
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 9,101
Default Create merge cells from table definition
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.

Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.programming
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 -

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 9,101
Default Create merge cells from table definition
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 -


Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 3
Default Create merge cells from table definition
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 -

Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 9,101
Default Create merge cells from table definition
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 -


Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I merge cells within a formatted table? Helen Excel Discussion (Misc queries) 1 September 8th 09 03:47 PM
Merge two cells with dates to create a date range Need Letters in the Columns Excel Discussion (Misc queries) 9 January 28th 09 02:50 PM
Using merge cells in worksheet for Pivot Table Digno Excel Discussion (Misc queries) 1 July 5th 08 02:10 PM
merge cells in pviot table saraua Excel Discussion (Misc queries) 0 June 5th 08 11:47 PM
Create Excel Grouping according to Merge Cells Grouping Data Excel Worksheet Functions 0 July 25th 06 12:44 PM


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement