Output to Excel

L

laa

Member
I am working on a system that has a report that needs to be exported from WebSpeed to Excel. To accomplish this the following commands are used:

Output-Http-Header("Content-disposition","Attachment~; filename=MyReport.xls").
RUN OutputContentType in web-utilities-hdl("application/vnd.ms-excel").

At this point tab delimited data is output.

All of this works fine. The user is able to either open or save the Excel file that is created. Their complaint, though, is that the columns in the Excel file are not formatted. The user would like the columns to be autofit. They would also like the proper formats to be used for each column and there are even some column that they would like word wrapped.

Can this be easily done? Can this be done at all? I have used COM routines to create formatted Excel files from Progress, but never from WebSpeed.

Any suggestions.

Anne.
 
One thing I have used is to have the data output as an excel file type (as you are currently doing) but instead of delimited data, output it as a simple HTML format (<body><table><tr><td> et. etc </td></tr></table></body>) with formatting in tables. When this is opened in excel, the table will be converted from html to excel and include formatting, colors, alignment, bold, etc and formatted with the HTML tags.
 
You must log in or register to reply here.
Back
Top