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