Skip to main content

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

Exports user events from a scheduler control to a file in Microsoft Excel® binary format (XLS).

Declaration

procedure cxExportSchedulerToExcel(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 = 'xls'; AHandler: TObject = nil);

Parameters

Name Type Description
AFileName string

The full path to the resulting XLS 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 for the data export operation before it 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 XLS 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.

See Also