TscExcelExport 2.8

Component for Delphi 5 & 6
April 2002

Stefan Cruysberghs
Lommel, Flanders, Belgium
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.

Installation

• Open the package dclExcelExport5.dpr (for Delphi5) or dclExcelExport6.dpr (for Delphi6). 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

• TscExcelExport_readme.htm : this file

• /Example : Sample project to demonstrate features of TscExcelExport component