实验4.4

转载于:https://www.cnblogs.com/p201821440010/p/10894259.html

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. Many features are provided to change the layout, use conditional formatting, to add totals, to create groups, to set a filter, ... 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. 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, COUNT) AutoFilter for titles Create groups with given fields Create new worksheets are reuse existing files 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/writing data without using a TDataset Methods Export to Excel Save worksheet as XLSX (Open XML), XLS, HTML, XML or CSV Show print preview Component editor The component editor can be used to change some settings on an easy way. Live templates Live templates for all Delphi versions since 2006 (ExcelExportUse and ExcelExportCreate)
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值