Selecting Grid Data

Summary

  • AdapTable builds on the cell and row Selection in AG Grid by adding extra functionality including:
    • Full summary information of selected cells using multiple operations (including custom ones)
    • Methods in Grid API which allow cells and rows to be selected programatically
    • The Selected Data Report which exports data about currently selected cells
    • A Selection Changed Event which provides full details about the current selection

Cell and Row Selection is an important and well-supported run-time user feature in AG Grid.

Caution

  • Selection requires the correct Selection Options in AG Grid GridOptions
  • To select multipe cells with the mouse the range-selection AG Grid Module must be provided

AdapTable builds on the selection capabilities of AG Grid by providing these additional features:

  • Displaying (customisable) Cell Summary information of selected cells
  • Grid API functions enable run-time selection and highlighting of cells
  • Selected Cells Report is available to export selected data

Exporting Cell Selection

A common requirement is to select a range of cells or rows and export them from AG Grid to another location.

AdapTable wraps up the current cell and row selection in the Selected Cells System Report.

The Selected Cells (System) Report is available for export in 2 ways:

  • Export Selected Cells Menu Item in the Context Menu

    Caution

    Using the Context Menu item exports the Report to Excel only

  • Selecting the Report in the Export Toolbar, ToolPanel or Status Bar

    Note

    This will export the selected data to any available export destination

Selecting through API

The Grid API section of AdapTable API includes many helpful selection related functions, including:

  • selecting cell ranges using row indexes or primary keys (with timeouts)
  • selecting columns
  • unselecting cells or columns

Find Out More

See Selecting using API for more information and multiple demos

Selection Changed Event

AdapTable fires the Selection Changed Event whenever the cell or row selection in AG Grid changes.

This provides very detailed information of the new Grid selection.

Selected Cells Summaries

AdapTable's Cell Summary Module provides comprehensive information about the currently selected Cells.

This includes a number of Summary Operations provided by AdapTable (e.g. sum, count, average etc) and custom summary operations provided by developers.

Find Out More

See Summarising Selected Cells for full details

FAQ

Why am I unable to select a range of cells? Make sure that you have the CellSelection AG Grid Module registered Also ensure that you have the correct AG Grid Selection Options set.

PreviousTechnical ReferenceNextSelecting using API