class Axlsx::PivotTable

Worksheet#add_pivot_table is the recommended way to create tables for your worksheets.


Creates a new PivotTable object


  • ref (String)

    The reference to where the pivot table lives like 'G4:L17'.

  • range (String)

    The reference to the pivot table data like 'A1:D31'.

  • sheet (Worksheet)

    The sheet containing the table data.

  • options (Hash) (defaults to: {})

    a customizable set of options

Options Hash (options):

  • name (Cell, String)
  • style (TableStyle)


  • (_self)

Yield Parameters:

  • _self (Axlsx::PivotTable)

    the object that the method was called on

The cache_definition for this pivot table

The columns

The data

References for header cells

The values in the header cells collection

The header cells for the pivot table

The number of cells in the header_cells collection

The index of a given value in the header cells

The index of this chart in the workbooks charts collection

The name of the table.

The pages

The part name for this table

The range where the data for this pivot table lives.

The reference to the table data

The relationships for this pivot table.

The relationship part name of this pivot table

The rows

The name of the sheet.

Serializes the object


  • str (String) (defaults to: '')

PivotTable is referenced in 0 repositories