Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I merge cells within a formatted table? | Excel Discussion (Misc queries) | |||
Merge two cells with dates to create a date range | Excel Discussion (Misc queries) | |||
Using merge cells in worksheet for Pivot Table | Excel Discussion (Misc queries) | |||
merge cells in pviot table | Excel Discussion (Misc queries) | |||
Create Excel Grouping according to Merge Cells | Excel Worksheet Functions |