# GoogleSheetsAddTableRequest

Adds a native Google Sheets table to the worksheet.

Class 

`OfficeIMO.Excel.GoogleSheets`

**Namespace**

`OfficeIMO.Excel.GoogleSheets`

**Assembly**

`OfficeIMO.Excel.GoogleSheets`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

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

**Base**

`GoogleSheetsRequest`

**Modifiers**

sealed

Adds a native Google Sheets table to the worksheet.

## Inheritance

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

Filter members 

Show inherited

## Constructors

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

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

Creates an add-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:201](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L201)

Gets or sets the worksheet containing the table.

`public string TableName { get; set; }` [#](#property-tablename)

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

Gets or sets the native table name.

`public string A1Range { get; set; }` [#](#property-a1range)

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

Gets or sets the table range in A1 notation.

`public int StartRowIndex { get; set; }` [#](#property-startrowindex)

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

Gets or sets the inclusive zero-based first row.

`public int EndRowIndexExclusive { get; set; }` [#](#property-endrowindexexclusive)

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

Gets or sets the exclusive zero-based ending row.

`public int StartColumnIndex { get; set; }` [#](#property-startcolumnindex)

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

Gets or sets the inclusive zero-based first column.

`public int EndColumnIndexExclusive { get; set; }` [#](#property-endcolumnindexexclusive)

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

Gets or sets the exclusive zero-based ending column.

`public bool HasHeaderRow { get; set; }` [#](#property-hasheaderrow)

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

Gets or sets whether the first row contains headers.

`public bool TotalsRowShown { get; set; }` [#](#property-totalsrowshown)

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

Gets or sets whether the totals row is shown.

`public string? StyleName { get; set; }` [#](#property-stylename)

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

Gets or sets the source table-style name, when available.

`public string? HeaderColorArgb { get; set; }` [#](#property-headercolorargb)

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

Gets or sets the optional ARGB header color.

`public string? FirstBandColorArgb { get; set; }` [#](#property-firstbandcolorargb)

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

Gets or sets the optional ARGB first-band color.

`public string? SecondBandColorArgb { get; set; }` [#](#property-secondbandcolorargb)

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

Gets or sets the optional ARGB second-band color.

`public string? FooterColorArgb { get; set; }` [#](#property-footercolorargb)

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

Gets or sets the optional ARGB footer color.

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

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

Gets or sets target table-column metadata.

## 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:2B0C955DBEAE2B5C9CAE99C7D645095978B9068F8C21D0BB24E9A0761BCED481 -->
