(Showing Draft Content)

XlsxFormatItemEventArgs Class

XlsxFormatItemEventArgs Class

Represents arguments of the IFlexGridXlsxOptions.formatItem callback.




cancel: boolean

Gets or sets a value that indicates whether the event should be canceled.


cell: HTMLElement

If IFlexGridXlsxOptions.includeStyles is set to true then contains a reference to the element that represents the formatted grid cell; otherwise, a null value.


col: number

Gets the index of the column affected by this event.

To get the Column object, use the getColumn method.


data: any

Gets or sets the data associated with the event.


panel: GridPanel

Gets the GridPanel affected by this event.


range: CellRange

Gets the CellRange affected by this event.


row: number

Gets the index of the row affected by this event.

To get the Row object, use the getRow method.


xlsxCell: mXlsx.IWorkbookCell

Contains an exporting cell representation. Initially it contains a default cell representation created by FlexGrid export, and can be modified by the event handler to customize its final content. For example, the xlsxCell.value property can be updated to modify a cell content, xlsxCell.style to modify cell's style, and so on.

Static empty

empty: EventArgs

Provides a value to use with events that do not have event data.



  • getColumn(binding?: boolean): Column
  • Gets the Column affected by this event.

    To get the column index, use the col property.


    • Optional binding: boolean

      Whether to get the column by index or by binding. This parameter only makes a difference in grids that have multiple rows per data item (like the MultiRow grid).

    Returns Column


  • getFormattedCell(): HTMLElement
  • Returns a cell with a custom formatting applied (formatItem event, cell templates). This method is useful when export of custom formatting is disabled (IFlexGridXlsxOptions.includeStyles=false), but you need to export a custom content and/or style for a certain cells.

    Returns HTMLElement


  • getRow(): Row