LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 06:02 PM.

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"