BorlandTalk.com

Joseph Alan Poirier · Guest

Is there a way to save database query information as a XL file and convert
it to a zip file before sending it to a customer?

Joseph Alan Poirier · Guest

Thanks, got the excel working this morning. I'll have to think more about
the zip. I may just want to send the xl file directly to the browser. Is
there a way to do that?

Joseph Alan Poirier · Guest

Thanks, broke from here with related ? on streams in post above?

Joseph Alan Poirier · Guest

Happy Holidays...

Next question see subject title:
MYSTREAM := EXCEL FILE

How can I set a stream = to the content of an excel file?
I tried...
MyApp := CreateOleObject('EXCEL.Application');
MyApp.SaveToStream(MyStream);
and it didn't work.
.... [Error] EBCOMMI.pas(421): Type not allowed in OLE Automation call

I thought this may have been outside the original subject so I posted it
separately :-)

Also, now I have two more related questions...
Excel appears to remain open in memory after creating and saving my file.
How do I set it to nothing as in VB scripting?

This process does not appear to run on a server that does not have Excel
loaded on it.
VB Script is now creating Excel and Word files using Active X to get around
this. Is there a workaround for Delphi that will allow the Excel file to be
created natively without requiring Excel to be loaded?

Joseph Alan Poirier · Guest

Is there a way to code create an actual Excel .XLS format file without using
OLE Automation?

PS. Thanks for the
MyApp := Null; //makes sense