TscExcelExport 3.2
Component for Delphi 5,
6 & 7
June 2004
Stefan Cruysberghs
Lommel, Flanders, Belgium
http://www.scip.be
Description
This TscExcelExport component is an advanced, powerfull but easy component to export all records of a dataset from Delphi to MS Excel (97, 2000, XP or 2003). Many features are provided to change the layout, to add totals, to create groups, ...
Properties
All kinds of settings to change the layout of the worksheet
- 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, AVG)
- Create groups with given fields
- A lot of other options to customize the result
Events
- To define the backgroundcolor of each cel
- For exporting data without using a TDataset
Methods
- Export to Excel
- Save worksheet as XLS, HTM or CSV
- Show print preview
Component editor
- The component editor can be used to change some settings on an easy way.
Type library / COM
- This component uses the Office server components from the Borland COM type library (Excel97 or Excel2000).
- So MS Excel should be installed on the PC when using this component.
Copyrights and distribution
- All copyrights to this component are owned by the author Stefan Cruysberghs.
- This component is freeware for non-commercial use and may be freely distributed.
- The author doesn't give a warranty for error free running of this component.
- Registered users can count on it that bugs will be solved as soon as possible.
Registration
- If you like this component and/or you are using it in a commercial environment then you can register it.
- You will encourage the author to further develop and improve this TscExcelExport component.
- You will receive an email when new versions or upgrades are available and support will be provided by e-mail.
- The registration cost is €30 or 30 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.dpk (for Delphi5),
dclExcelExport6.dpk (for Delphi6) or
dclExcelExport7.dpk (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
- TscExcelExport_leesmij.htm : Dutch version of this file
- /Demo : Sample project to demonstrate features of
TscExcelExport component