Board index » delphi » Using OLE servers to export to Excel

Gary Jones

Delphi Developer
Thu, 17 Apr 2003 18:42:52 GMT

Using OLE servers to export to Excel

Hi.

I use Delphi 5 and would like to save the contents of a Tdataset to a
new Excel worksheet.

I have trawled through Usenet and found several replies which seem to
offer an answer, but I've only found one Usenet post explicit enough for
me to get it to work, and the resulting application is very slow, taking
around half a minute to export about a thousand cells (a hundred rows
with ten columns).

Is there anyone out there who can offer an example of fast writing to an
Excel file?

--
Gary Jones <newsmas...@bohr.demon.co.uk>

 
MrBaseball3

Delphi Developer
Fri, 18 Apr 2003 22:45:40 GMT

Re:Using OLE servers to export to Excel


Have you taken a look at any of the Excel components on Torry's?
There are some free ones there that are extremely fast.
TExcel, I think is the one that I tried and had the most success with.
It uses Native Excel file formats, no OLE, so it would be fast.

http://torry.spang.org/db_msexcel.htm

Quote
> I use Delphi 5 and would like to save the contents of a Tdataset to a
> new Excel worksheet.

> I have trawled through Usenet and found several replies which seem to
> offer an answer, but I've only found one Usenet post explicit enough for
> me to get it to work, and the resulting application is very slow, taking
> around half a minute to export about a thousand cells (a hundred rows
> with ten columns).

> Is there anyone out there who can offer an example of fast writing to an
> Excel file?

OLBRICH ATTIL

Delphi Developer
Sat, 19 Apr 2003 03:49:02 GMT

Re:Using OLE servers to export to Excel


Gary Jones <newsmas...@bohr.demon.co.uk> az albbiakat rta a k?vetkez?
hrzenetben: 0f7+OAAs8$+5E...@bohr.demon.co.uk...

Quote

> Hi.

> I use Delphi 5 and would like to save the contents of a Tdataset to a
> new Excel worksheet.

> I have trawled through Usenet and found several replies which seem to
> offer an answer, but I've only found one Usenet post explicit enough for
> me to get it to work, and the resulting application is very slow, taking
> around half a minute to export about a thousand cells (a hundred rows
> with ten columns).

> Is there anyone out there who can offer an example of fast writing to an
> Excel file?

> --
> Gary Jones <newsmas...@bohr.demon.co.uk>

Try dde connection instead of using OLE, Im not sure, but it can be faster.
I use DDE dynamic data exchange in my applications.

Other Threads

1. Exporting to Excel using OLE when Excel is Editing Cell

2. Exporting data from Delphi datasets using the OLE Servers of Delphi 5

3. Problem using D5's Server Objects to Export Data To Excel

4. Using Excel & OLE servers

5. Help on exporting OLE Excel file

6. export to excel from SQL Server

7. Exporting to an Excel then Updating SQL Server

8. Exporting to an Excel then Updating SQL Server

9. Using SQL Export data to excel

10. Using Delphi To Export SQL Query Data TO Excel