# GoogleSheetsImportOptions

Options for importing a Google spreadsheet.

Class 

`OfficeIMO.Excel.GoogleSheets`

**Namespace**

`OfficeIMO.Excel.GoogleSheets`

**Assembly**

`OfficeIMO.Excel.GoogleSheets`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[GoogleSheetsImportOptions.cs:14](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L14)

**Modifiers**

sealed

Options for importing a Google spreadsheet.

## Inheritance

- object
- GoogleSheetsImportOptions

## Usage

Explore 3 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

### Accepted by parameters 3

- Method [ExcelGoogleSheetsExtensions.ImportGoogleSheetAsync](/api/excel-google-sheets/officeimo-excel-googlesheets-excelgooglesheetsextensions/#method-importgooglesheetasync-officeimo-googleworkspace-googleworkspacesession-string-officeimo-excel-googlesheets-googlesheetsimportoptions-threading-cancellationtoken) parameter `options`
- Method [GoogleSheetsImporter.ImportAsync](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsimporter/#method-importasync-string-officeimo-googleworkspace-googleworkspacesession-officeimo-excel-googlesheets-googlesheetsimportoptions-threading-cancellationtoken) parameter `options`
- Method [IGoogleSheetsImporter.ImportAsync](/api/excel-google-sheets/officeimo-excel-googlesheets-igooglesheetsimporter/#method-importasync-string-officeimo-googleworkspace-googleworkspacesession-officeimo-excel-googlesheets-googlesheetsimportoptions-threading-cancellationtoken) parameter `options`

Filter members 

Show inherited

## Constructors

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

[GoogleSheetsImportOptions.cs:14](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L14)

## 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 GoogleWorkspaceImportMode Mode { get; set; }` [#](#property-mode)

[GoogleSheetsImportOptions.cs:12](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L12)

Gets or sets Drive-export or native API import; defaults to Drive export.

`public IReadOnlyList<string> Ranges { get; set; }` [#](#property-ranges)

[GoogleSheetsImportOptions.cs:14](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L14)

Gets or sets optional A1 ranges for native import.

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

[GoogleSheetsImportOptions.cs:16](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L16)

Gets or sets an optional Sheets API field mask for native import.

`public ExcelLoadOptions LoadOptions { get; set; }` [#](#property-loadoptions)

[GoogleSheetsImportOptions.cs:18](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L18)

Gets or sets options used to load Drive-exported XLSX; defaults to read-write access.

`public IProgress<GoogleDriveTransferProgress>? Progress { get; set; }` [#](#property-progress)

[GoogleSheetsImportOptions.cs:22](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L22)

Gets or sets an optional observer for Drive-export transfer progress.

`public long MaxResponseBytes { get; set; }` [#](#property-maxresponsebytes)

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

Gets or sets the positive byte limit for Drive-exported XLSX or a native API response.

`public int MaxSheets { get; set; }` [#](#property-maxsheets)

[GoogleSheetsImportOptions.cs:26](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L26)

Gets or sets the positive maximum number of sheets projected by native import.

`public long MaxCells { get; set; }` [#](#property-maxcells)

[GoogleSheetsImportOptions.cs:32](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L32)

Maximum number of native cell values and row/column metadata entries that may be projected. Dimension metadata shares this budget because it can materialize row and column state even when the response contains no cell values.

`public long MaxDimensionGroupMembers { get; set; }` [#](#property-maxdimensiongroupmembers)

[GoogleSheetsImportOptions.cs:34](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L34)

Gets or sets the positive limit on native dimension-group members.

## Fields

`public const long DefaultMaxResponseBytes` [#](#field-defaultmaxresponsebytes)

[GoogleSheetsImportOptions.cs:10](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsImportOptions.cs#L10)

Default upper bound for Drive-exported XLSX or a native Sheets API response, in bytes.

Value: `134217728`

<!-- PowerForge markdown artifact sha256:8CC352A794C6B1E22A632D55C18CFD7FB577CC4FE2C33389F42CA162E9B70DC7 -->
