[CLOSED] HTMLFORMTYPE 2 sheet

August 01, 2018, 09:11 AM

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,

August 06, 2018, 10:58 AM

JACQUETL

Hello
nobody has an idea ? :-(

August 06, 2018, 12:20 PM

FP Mod Chuck

Jacquetl

Using table of contents will generate multiple sheets in a single xls spreadsheet.

August 06, 2018, 01:32 PM

Doug

JACQUETL,

Can't you use the standard WebFOCUS "ON TABLE SET STYLE *" ... "ENDSTYLE" and then "ON TABLE PCHOLD AS ENTETES FORMAT XLSX"?

August 07, 2018, 02:39 AM

JACQUETL

Hi

@doug : I did not find any other way to make an excel formatting inside the same fields of a same cell