TscExcelExport 2.91
Component for Delphi 5,
6 & 7
November 2002
Stefan Cruysberghs
Lommel, Flanders, Belgium
http://users.pandora.be/stefancr
(http://www.stefancr.yucom.be)
Description
Export all records of dataset to MS Excel (97, 2000 or XP).
Properties
Name of worksheet and file
Header texts
Begin row of header, titles (=fieldnames) and data (fieldvalues)
Width of columns or autofit
Font of header, titles, summary and data (Alignment, WrapText, Orientation)
Backgroundcolor and borders of header, titles, summary and data
Summaries for numeric or given fields (SUM, MIN, MAX)
Grouping fields and options
Events
Define backgroundcolor of each cel
Events for exporting data without using a TDataset
Methods
Exporting
Saving (XLS, HTM of CSV)
Print preview
Component editor
This component is free of charge.
The author doesn't give a warranty for error free running of this component and he doesn't give any support
See source code for history and more information about properties, methods and events.
If you like the component and you use it regularly, you can register it. You will encourage the author to further develop and improve TscExcelExport. You will receive an email when new versions or upgrades are available. Do realize that I have spent a lot of hours developing this software
The registration cost is €15 or 15 US$.
You can register yourself online on the website of Reg.Net (ID = 11696) : https://secure.reg.net/product.asp?ID=11696
Installation
Open the package dclExcelExport5.dpr (for Delphi5), dclExcelExport6.dpr (for Delphi6) or dclExcelExport7.dpr (for Delphi7). Compile and Install the package. The TscExcelExport component can be found in the tabsheet 'SC' of the component palette.
When you like to add the component to an existing package, add the unit scExcelExportReg.pas to a package. Make sure the DCP file dclOffice is added as required.
Files included
scExcelExport.pas : component
scExcelExportReg.pas : componenteditor and registration of component
scExcelExport.dcr : component icon
dclExcelExport5.dpk : Delphi5 package
dclExcelExport6.dpk : Delphi6 package
dclExcelExport7.dpk : Delphi7 package
TscExcelExport_readme.htm : this file
/Example : Sample project to demonstrate features of TscExcelExport component