EMS logo

Products Navigation

Advanced Data Export .NET

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

Advanced Data Export .NET

On-line Documentation

QExportXLS.GetAggregateParams


 

public class GetAggregateParamsEventArgs : EventArgs

{

    // Methods

    public GetAggregateParamsEventArgs(int Sheet, int Col, XlsFormat Format, string FormatText, string Value);

 

    // Properties

    public int Col { get; }

    public XlsFormat Format { get; }

    public string FormatText { get; set; }

    public int Sheet { get; }

    public string Value { get; set; }

 

    // Fields

    private int _col;

    private XlsFormat _format;

    private string _formatText;

    private int _sheet;

    private string _value;

}

 

public delegate void GetAggregateParamsEvent(object Sender, GetAggregateParamsEventArgs e);

 

public event SqlManager.QExport.Delegates.GetAggregateParamsEvent GetAggregateParams

 

Description

The GetAggregateParams event takes place, when the parameters of the cell, containing aggregate function, are recieved. Depending on the column number (GetAggregateParamsEventArgs.Col), you can change the format (GetAggregateParamsEventArgs.Format) of the cell value (GetAggregateParamsEventArgs.Value), or, if the value is empty, set a string value to the cell, e.g.

 

 

See also:

QExportXLS

QExportXLS Properties

QExportXLS Methods

QExportXLS Events