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.