technohaa.blogg.se

Summaries for numeric or given fields (SUM, MIN, MAX, AVG, COUNT)Ĭreate new worksheets are reuse existing filesĪccess to the Excel objects (ExcelApplication, ExcelWorkbook, ExcelWorksheet, …) The component works in Delphi 5, 6, 7, 2006, 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8 and now also 10 Seattle and 10.1 Berlin (32 and 64 bit) and it supports all Excel versions from 97 to 2016.Īll kinds of settings to modify the layout of the worksheet are provided.īegin row and column of header, footer, titles (=fieldnames) and data (fieldvalues)įont of header, footer, titles, summary and data (Alignment, WrapText, Orientation, MergeCells)īackgroundcolor and borders of header, footer, titles, summary and data

Many features are provided to change the layout, use conditional formatting, to add totals, to create groups, to set a filter. This TscExcelExport component is an advanced, powerful but easy to use component which enables you to export all records of a dataset from Borland/Codegear/Embarcadero Delphi to Microsoft Excel. TscExcelExport 4.28 | freeware for non-commercial use