HotXLS Docs
Home Contents Overview

TGridToXLS component

Unit: lxGridToXLS
Component is intended for exporting TDBGrid to Excel,HTML or RTF file

说明

TGridToXLS 是把 TDBGrid 导出到 Excel 工作簿、HTML 或 RTF 文件的非可视化组件。也可以用 TGridToXLS 把多个 TDBGrid 导出到同一个工作簿。借助该组件，可以对任意导出的单元格应用条件格式

属性

DBGrid property
WorksheetName property
Worksheet property
Workbook property
HeaderFont property
DetailFont property
GroupFont property
HeaderColor property
DetailColor property
GroupColor property
RowsPerSheet property
StartRow property
StartCol property
HeaderBorderStyle property
DetailBorderStyle property
GroupBorderStyle property
HeaderBorderColor property
DetailBorderColor property
GroupBorderColor property
GroupFields property
ExportHeader property
OriginalHeaderFont property
OriginalHeaderColor property
OriginalDetailFont property
OriginalDetailColor property
SetColumnsWidth property
DisableFormat property
ClearGroupFields property

方法

SaveDBGridAs method
SaveAs method
ExportDBGrid method
Abort method

Events

AfterNewSheet event
AfterTitle event
AfterTitles event
AfterCell event
AfterRow event
AfterRows event
AfterExport event
AfterGroup event