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

initialize is referenced in 0 repositories