cxExportSchedulerToXLSX(string,TcxCustomScheduler,Boolean,Boolean,string,TDateTime,TDateTime,string,TObject) Method

Exports user events from a scheduler control to a file in Office Open XML spreadsheet format (XLSX).

Declaration

delphi

procedure cxExportSchedulerToXLSX(const AFileName: string; AScheduler: TcxCustomScheduler; AsTable: Boolean = False; AShowDialog: Boolean = False; const AHeader: string = 'Event %d'; const AStart: TDateTime = NullDate; const AFinish: TDateTime = NullDate; const AFileExt: string = 'xlsx'; AHandler: TObject = nil);

Parameters

Name	Type	Description
AFileName	string

The full path to the resulting XLSX file. You can omit the file name extension because it is automatically updated from the AFileExt parameter value.

| | AScheduler | TcxCustomScheduler |

The source scheduler control.

| | AsTable | Boolean |

Optional. If True, content of user events is exported as a table. If False, user events are exported as cards.

| | AShowDialog | Boolean |

Optional. If True, the data export procedure ignores the AStart and AFinish parameter values and invokes the Set Date Range dialog that allows a user to specify the time period before the data export operation starts. If False, the data export operation starts without user interaction.

| | AHeader | string |

Optional. Specifies the card header. The data export procedure ignores this parameter if the AsTable parameter value is False.

| | AStart | TDateTime |

Optional. Specifies the beginning of the export time period that limits exported user events. If the AStart parameter is omitted, the data export procedure uses the first date displayed in the Date Navigator. The AStart parameter value or the first date in the Date Navigator is ignored if the AShowDialog parameter value is True.

| | AFinish | TDateTime |

Optional. Specifies the end of the export time period that limits exported user events. If the AFinish parameter is omitted, the data export procedure uses the last date displayed in the Date Navigator. The AFinish parameter value or the last date in the Date Navigator is ignored if the AShowDialog parameter value is True.

| | AFileExt | string |

Optional. Specifies the file name extension for the resulting XLSX file. This parameter value always replaces the file name extension passed as a part of the AFileName parameter value.

| | AHandler | TObject |

Optional. Specifies a handler object that should implement the IcxExportBeforeSave and/or IcxExportProgress interfaces to allow you to perform specific actions before an export operation and track its progress. Refer to the following topic for detailed information on how to create and use handler objects: How to: Track Data Export Progress.