April 24, 2007, 03:07 AM
<hellonitiv>Using HTMLFORMTYPE in WebFocus Code.
When we are embedding HTML into webfocus,
the report output is on Browser.
Can we specify any command after (-HTMLFORM BEGIN), so that the output will come in Spreadsheet.
(Something like set formtype)
April 24, 2007, 04:10 AM
Alan BBasically no, as the mime type in the header will be html.
However, if you want to do something like create a csv file on the fly and have that displayed in Excel, then you can -WRITE the file out and use js in the -HTMLFORM to call that file.
April 24, 2007, 11:04 AM
susannahnitiv, please edit your profile signature so we know what platform and version you are on.
If you want to take an html table and turn it into a spreadsheet, and you are running a selfserv site ,
read this articleA lot of the HTML formatting within the HTMLFORM BEGIN and END tags can be made to come along with the export.
Otherwise, ON TABLE PCHOLD FORMAT EXL2K will put the output directlyinto excel without any of the htmlform style formatting.