TTMSFMXGridExcelExport Class

This component will export an exiisting TMSFMXGrid to Excel.

Syntax

TTMSFMXGridExcelExport = class(TComponent);

Name	Description
Create	Creates the component.

Name	Description
Destroy	Frees all memory assigned to this component and releases the resources.

Name	Description
Export	Overloaded Export(TFileName, string) Export(TExcelFile, TInsertInSheet) Export(TStream, TFileFormats, string)
ExportPdf	Overloaded ExportPdf(TFileName) ExportPdf(TStream) ExportPdf(TStream, TFlexCelPdfExport)
ExportHtml	Overloaded ExportHtml(TFileName, THtmlExportMode) ExportHtml(TFlexCelHtmlExport, string, THtmlExportMode)

Name	Description
Grid	The grid to export.
ExportOptions	Settings that affect how the grid will be exported.
LocationOptions	Settings that define where the grid will be exported in Excel.
DateFormat	Default Excel format for the cells that contain dates. This is a global setting, you can control the format in individual cells with OnExportCell
TimeFormat	Default Excel format for the cells that contain times. This is a global setting, you can control the format in individual cells with OnExportCell
ImageMargin	Adds a margin around the cell for images or checkboxes. If you set this to 0 images will go exactly to the edges of the cell.
Version	The version of this component.

Name	Description
OnExportCell	Occurs before exporting every cell, and allows you to customize what is written in it.
OnProgress	Provides a progress indication of how many cells have been exported.
OnExportComment	Occurs before exporting a comment, and allows you to customize the size of the popup note that will appear in Excel.