Focal Point
Excel output

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

June 24, 2008, 08:36 PM
Michael Simon
Excel output
We're finding out that WF doesn't save the output as a "XLS" file but in an XML format. I think it's an Open Office format can't be sure. Is there a way to export the "Excel" format? What would the output format code be? Is there a way for IBI to compress the XML format before sending it through the wire?


Have used WF 5.x, 7.x w/RC, BID, MR
WAS 5.x/6.x
AIX 5.3.0
June 24, 2008, 11:33 PM
dhagen
When your output format is "EXL2K", then the response is an XHT file. It's a fancy pants XML format for Office. If you change your output format to "EXCEL", then you would actually get an XLS file. However, you would lose a lot of the formatting options that you get with the EXL2K output.

There is a compression option between the WF Client and Server (via the client admin console), but I do not know what has to be done to implement properly (you should probably call NY on that one). Worse case scenario is you could implement your own compression routine using a Filter pattern to wrap the response object.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
June 25, 2008, 12:43 PM
Michael Simon
Thanks for the quick feedback.


Have used WF 5.x, 7.x w/RC, BID, MR
WAS 5.x/6.x
AIX 5.3.0