Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

GoogleSheetsAddPivotTableRequest

OfficeIMO.Excel.GoogleSheets

Namespace
OfficeIMO.Excel.GoogleSheets
Assembly
OfficeIMO.Excel.GoogleSheets
Source revision
ba882f6b0d07 with working tree changes
Modifiers
sealed

Adds a supported pivot table at a destination cell.

Inheritance

Constructors

public GoogleSheetsAddPivotTableRequest() #

Creates a pivot-table request.

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.