Class
GoogleSheetsAddPivotTableRequest
OfficeIMO.Excel.GoogleSheets
Adds a supported pivot table at a destination cell.
Inheritance
- GoogleSheetsRequest
- GoogleSheetsAddPivotTableRequest
Constructors
Inherited Methods
Properties
public string SheetName { get; set; } #Gets or sets the worksheet receiving the pivot table.
public int DestinationRowIndex { get; set; } #Gets or sets the zero-based destination row.
public int DestinationColumnIndex { get; set; } #Gets or sets the zero-based destination column.
public string SourceSheetName { get; set; } #Gets or sets the source-data worksheet.
public string SourceA1Range { get; set; } #Gets or sets the source-data range in A1 notation.
public IReadOnlyList<GoogleSheetsPivotGroup> Rows { get; set; } #Gets or sets source columns grouped as pivot rows.
public IReadOnlyList<GoogleSheetsPivotGroup> Columns { get; set; } #Gets or sets source columns grouped as pivot columns.
public IReadOnlyList<GoogleSheetsPivotValue> Values { get; set; } #Gets or sets aggregated pivot values.
public string ValueLayout { get; set; } #Gets or sets measure placement: HORIZONTAL for columns or VERTICAL for rows.