Kbase P23256: Unix data to Excel file as fast as possible with AppServer
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  16/10/2008 |
|
Status: Unverified
GOAL:
Unix data to Excel file as fast as possible with AppServer
GOAL:
With database on Unix what is the fastest way to get the data into an Excel spreadsheet from a user session using AppServer?
FIX:
Have one AppServer connecting to the database and gathering the data, running Asynchronously on the AppServer, pass this back to client which then runs another Asynch AppServer call on a Windows AppServer from the Event-Procedure of the call. Basic problem is that Excel resides on Windows so we have to run an AppServer there.
Other option may be to output the data from Unix as a flat file, copy it to Windows and then run Excel parsing code.