# GoogleSheetsAddPivotTableRequest

Adds a supported pivot table at a destination cell.

Class 

`OfficeIMO.Excel.GoogleSheets`

**Namespace**

`OfficeIMO.Excel.GoogleSheets`

**Assembly**

`OfficeIMO.Excel.GoogleSheets`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[GoogleSheetsRequest.cs:339](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L339)

**Base**

`GoogleSheetsRequest`

**Modifiers**

sealed

Adds a supported pivot table at a destination cell.

## Inheritance

- [GoogleSheetsRequest](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsrequest/)
- GoogleSheetsAddPivotTableRequest

Filter members 

Show inherited

## Constructors

`public GoogleSheetsAddPivotTableRequest()` [#](#constructor-ctor)

[GoogleSheetsRequest.cs:339](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L339)

Creates a pivot-table request.

## Inherited Methods

`public virtual bool Equals(object? obj)` [#](#method-equals-object)

Inherited from object

Parameters

**obj object? required**

Returns

`bool`

`public virtual int GetHashCode()` [#](#method-gethashcode)

Inherited from object

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public virtual string? ToString()` [#](#method-tostring)

Inherited from object

Returns

`string?`

## Properties

`public string SheetName { get; set; }` [#](#property-sheetname)

[GoogleSheetsRequest.cs:339](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L339)

Gets or sets the worksheet receiving the pivot table.

`public int DestinationRowIndex { get; set; }` [#](#property-destinationrowindex)

[GoogleSheetsRequest.cs:341](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L341)

Gets or sets the zero-based destination row.

`public int DestinationColumnIndex { get; set; }` [#](#property-destinationcolumnindex)

[GoogleSheetsRequest.cs:343](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L343)

Gets or sets the zero-based destination column.

`public string SourceSheetName { get; set; }` [#](#property-sourcesheetname)

[GoogleSheetsRequest.cs:345](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L345)

Gets or sets the source-data worksheet.

`public string SourceA1Range { get; set; }` [#](#property-sourcea1range)

[GoogleSheetsRequest.cs:347](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L347)

Gets or sets the source-data range in A1 notation.

`public IReadOnlyList<GoogleSheetsPivotGroup> Rows { get; set; }` [#](#property-rows)

[GoogleSheetsRequest.cs:349](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L349)

Gets or sets source columns grouped as pivot rows.

`public IReadOnlyList<GoogleSheetsPivotGroup> Columns { get; set; }` [#](#property-columns)

[GoogleSheetsRequest.cs:351](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L351)

Gets or sets source columns grouped as pivot columns.

`public IReadOnlyList<GoogleSheetsPivotValue> Values { get; set; }` [#](#property-values)

[GoogleSheetsRequest.cs:353](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L353)

Gets or sets aggregated pivot values.

`public string ValueLayout { get; set; }` [#](#property-valuelayout)

[GoogleSheetsRequest.cs:355](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L355)

Gets or sets measure placement: HORIZONTAL for columns or VERTICAL for rows.

## Inherited Properties

`public string Kind { get; }` [#](#property-kind)

[GoogleSheetsRequest.cs:24](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L24)

Inherited from [GoogleSheetsRequest](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsrequest/)

<!-- PowerForge markdown artifact sha256:6EB5962C4985FF0E5C075DB7E794C0E6B76763411D16BCCC237A1EAC18FCB14B -->
