Focal Point
Using HTMLFORMTYPE in WebFocus Code.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8691088422

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 B
Basically 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.


Alan.
WF 7.705/8.007
April 24, 2007, 11:04 AM
susannah
nitiv, 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 article
A 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.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID