Subject: Re: Creating Excel Spreadsheets - Alternatives to OLE?
Like others have mentioned on the list, I highly recommend you take a look
at Formula1 (v3 shipped with Delphi3, look on the activex tab, v6 is most
recent).
I have built a system that creates executive summary reports from a
database, with the requirement that the final reports be published to the
company lan in Excel. I initially used Excel as you have, but found it was
extremely slow (never ran out of memory though). In fact, one large
spreadsheet took over 40 minutes to create in Excel, and takes less than 2
minutes with Formula1.
I don't know of any native spreadsheets for delphi, but you should be able
to use any activex components after importing it into Delphi.
good luck,
Bob M..
At 4/2/99 05:09 PM, Fleet Senseman, Jr. wrote:
>Greetings All,
>
>We're going to be generating a significant number of Excel spreadsheets via
>applications developed with Delphi 4. I've got no problems doing this as
>far
>as Delphi is concerned, the issues I've run into are all Excel memory leak
>related. (And man, are there a lot of those....) We need to to some
pretty
>extensive formatting and I can get about three worksheets generated and
then
>Excel pretty much has leaked all my memory away. There's a product called
>Spread 3 for VB that generates Excel files on its own, without requiring
>Excel (or suffering from related memory leaks). Anyone know of a similiar
>package for Delphi? I'm going to see if Spread can be used in Delphi but
>I'd
>rather use something native if possible.
>
>TIA
>Fleet Senseman
>fsenseman@fimc.com