The OpenEdge Hive

Hi all,

I am expecting help for this. Working on web-based application. webspeed, agent, broker, ps:eScript bla bla bla...

Now will come to the problem. Excel oops.. is the problem now..

We can create excel sheet and can do the formatting using Progress code. No problem with this one.

But the problem here is instead of create com-handle, worksheets, workbooks we directly export to excel. I don't have enough idea on how it is working. Because when clicks on button (say "Excel") it is directly exporting to the excel sheet from web (here records are available in temp-table). When we click the excel button it calls a procedure "exportExcel"

*********************** exportExcel START *************************
PROCEDURE exportExcel :
/*------------------------------------------------------------------------------
Purpose: export to Excel
Version: 0.00
Created:
Notes:
------------------------------------------------------------------------------*/
glExport = TRUE.

processMarkup("xxxxxxxxxxxxxxxxxx.html":U).
RETURN.
END PROCEDURE.

************************ exportExcel END **************************

glExport is used in a function "getContentType"

********************** getContentTye START ************************
FUNCTION getContentType RETURNS CHARACTER
( /* parameter-definitions */ ) :
/*------------------------------------------------------------------------------
Purpose : Super Override
[If we are exporting the results we set the HTTP content type
to ms-excel. This will cause the web browser to start Excel
to display the results in.]
Parameters :

------------------------------------------------------------------------------*/

IF glExport THEN
RETURN "application/vnd.ms-excel":U.
ELSE
RETURN SUPER().

END FUNCTION.
********************** getContentTye END ************************

Now what I have to do it I need to set the excel page orientation to Landscape because default is portrait but user needs it to landscape.

Anyone can help me please????????????