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
Incoming search terms:
- tscexcelexport
- tscexcelexport delphi
- scExcelExport
- scexcelexport delphi
- tutorial tscexcelexport
- scexcelexport donload fre
- TcceExcelExport Delphi
- delphi xlsx write
- print preview EXCELL DELPHI
- letak tscexcelexport delphi