API Reference
Class
GoogleSheetsAddPivotTableRequest
Adds a supported pivot table at a destination cell.
Inheritance
- GoogleSheetsRequest
- GoogleSheetsAddPivotTableRequest
Constructors
public GoogleSheetsAddPivotTableRequest() #Creates a pivot-table request.
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
Properties
public String SheetName { get; set; } #Gets or sets the worksheet receiving the pivot table.
public Int32 DestinationRowIndex { get; set; } #Gets or sets the zero-based destination row.
public Int32 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.
Inherited Properties
public String Kind { get; } #Inherited from GoogleSheetsRequest