Delphi Tutorial

This TscExcelExport component is an advanced, powerful but easy component to export all records of a dataset from Delphi to MS Excel (97, 2000, XP, 2003 or 2007). Many features are provided to change the layout, to add totals, to create groups, to set a filter, and more…

Features:

Properties:

All kinds of settings to modify the layout of the worksheet are provided.

• Name of worksheet and file
• Header and footer texts
• Begin row and column of header, footer, titles (=fieldnames) and data (fieldvalues)
• Width of columns or autofit
• Font of header, footer, titles, summary and data (Alignment, WrapText, Orientation, MergeCells)
• Backgroundcolor and borders of header, footer, titles, summary and data
• Summaries for numeric or given fields (SUM, MIN, MAX, AVG)
• Create groups with given fields
• AutoFilter for titles
• A lot of other options to customize the result
• Access to the Excel objects (ExcelApplication, ExcelWorkbook, ExcelWorksheet, …)

Events:

• To define the background color and font color, size, name and bold style of each cell
• For exporting data without using a TDataset

Methods:

• Export to Excel
• Save worksheet as XLSX (Open XML), XLS, HTML, XML or CSV
• Show print preview

Homepage: http://www.scip.be/
Download: http://www.scip.be/index.php?Page=DownloadExcelExport&Lang=EN
File Size: 1.1 MB
Delphi Version: Delphi 5 - Delphi 2007
Source: Included