It has been tested with Dutch and some English Office versions. Embarcadero Delphi 10.3 Rio & Community Edition. Microsoft Excel should be installed on the PC when using this component. The available libraries are Excel97, Excel2000, ExcelXP and Excel2010. By using compiler directives (in unit scExcelExportConfig.inc) you can override the default type library. This ExcelExport component uses the Office server components from the Embarcadero COM type library to implement OLE automation with Excel. Live templates for all Delphi versions since 2006 (ExcelExportUse and ExcelExportCreate). The component editor can be used to change some settings on an easy way. Save worksheet as XLSX (Open XML), XLS, HTML, XML or CSV. For exporting/writing data without using a TDataset. To define the background color and font color, size, name and bold style of each cell. Access to the Excel objects (ExcelApplication, ExcelWorkbook, ExcelWorksheet, …). Create new worksheets are reuse existing files. Summaries for numeric or given fields (SUM, MIN, MAX, AVG, COUNT). 
Backgroundcolor and borders of header, footer, titles, summary and data.
Font of header, footer, titles, summary and data (Alignment, VerticalAlignment, WrapText, Orientation, MergeCells). Begin row and column of header, footer, titles (=fieldnames) and data (fieldvalues). The component works in Delphi 5, 6, 7, 2006, 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio, 10.4 Sydney and 11 Alexandria and it supports all Excel versions from 97 to 2019.Īll kinds of settings to modify the layout of the worksheet are provided. This TscExcelExport component is an advanced, powerful but easy to use component which enables you to export all records of a dataset from Embarcadero Delphi to Microsoft Excel. Many features are provided to change the layout, use conditional formatting, to add totals, to create groups, to set a filter.
0 kommentar(er)
