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 -
|