[CLOSED] HTMLFORMTYPE 2 sheet

Hi,

Is it possible to generate 2 sheet on same Xls File whith HTMLFORMTYPE=XLS ?

I use HTMLFORMTYPE=XLS because i have css with custom format, if i try without HTMTABLE and with OPEN/CLOSE css format don't work

My exemple :

  
 
SET PAGE=NOLEAD
SET GRID=OFF
-RUN
 
 
-* Les Colonnes en cellules A
DEFINE FILE SYSTABLE
GRAS_L2/A80 = 'libellé bla bla ';
GRAS_L3/A80 = 'Transparence ';
END
TABLE FILE SYSTABLE
SUM
TYPE NOPRINT
-*ON TABLE SUBHEAD
HEADING
"Quelles sont les exigences bla bla"
"<GRAS_L2 – bla bla bla."
"<GRAS_L3 – bla bla bla bla bla."
ON TABLE SET HTMLCSS ON
ON TABLE HOLD AS ENTETE001 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, CLASS=Entete,$
TYPE=HEADING, LINE=2, CLASS=bordure,$
TYPE=HEADING, LINE=2, OBJECT=FIELD, STYLE = BOLD,$
TYPE=HEADING, LINE=3, OBJECT=FIELD, STYLE = BOLD,$
TYPE=HEADING, LINE=3, CLASS=bordure,$
ENDSTYLE
END
-*
-*
-*
-* Les Colonnes en cellules B
DEFINE FILE SYSTABLE
GRAS_L2/A80 = 'Limitation blablabla ';
GRAS_L3/A80 = 'Transparence ';
LF/A4  = '<BR>' ;
LIGNE3/A1000 = 'Dans le cadre bla bla bla : ' | LF
| '- choix1 ;' | LF
| '- choix2' | LF
| '- Choix3.';
END
TABLE FILE SYSTABLE
SUM
TYPE NOPRINT
-*ON TABLE SUBHEAD
HEADING
"Gestion des données blabla
"Dans le cadre bla bla."
"<LIGNE3"
ON TABLE SET HTMLCSS ON
ON TABLE HOLD AS ENTETE002 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, CLASS=Entete,$
TYPE=HEADING, LINE=2, CLASS=bordure,$
TYPE=HEADING, LINE=4, OBJECT=FIELD, STYLE = BOLD, $
TYPE=REPORT, LINEBREAK = LF,$
ENDSTYLE
END
 
 
SET HTMLFORMTYPE=XLS
 
-HTMLFORM BEGIN
<html>
<style type="text/css">
.bordure {
        border-width:1px;
        border-style:solid;
        border-color:#999999;
		border-collapse:collapse;
        border-spacing:0px;
		border-width:1px;
        border-style:solid;
        border-color:#000000;
		}
 
.Entete {
        border-width:1px;
        border-style:solid;
        border-color:#999999;
        background-color:#bcb5b5;
		border-collapse:collapse;
        border-spacing:0px;
		border-width:1px;
        border-style:solid;
        border-color:#000000;
		Font-Weight: Bold;
		text-align: center;
		}
TABLE {
width:850px;
}
th{
width:50%;
}
</style>
<TABLE>
<TR>
<th>!IBI.FIL.ENTETE001;</th>
<th>!IBI.FIL.ENTETE002;</th>
</TR>
</TABLE>
</html>
-HTMLFORM END

This message has been edited. Last edited by: FP Mod Chuck,

Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH

Posts: 92 | Location: France | Registered: July 08, 2009