Skip to content

Interface: SheetOptions ​

Options for Sheets getter function

Properties ​

debug? ​

optional debug: boolean

Enable debugging logs

Default Value ​

ts
false

Defined in ​

src/parser/spreadsheet.ts:34


fetchRequestInit? ​

optional fetchRequestInit: RequestInit

Fetch requests configuration

See ​

https://developer.mozilla.org/en-US/docs/Web/API/RequestInit

Defined in ​

src/parser/spreadsheet.ts:29


headers? ​

optional headers: number

How many rows are header rows.

Default Value ​

ts
1

Remarks ​

If has more than one row, the column name will be a combination of those rows.

See ​

https://developers.google.com/chart/interactive/docs/spreadsheets#queryurlformat

Defined in ​

src/parser/spreadsheet.ts:24


range? ​

optional range: string

Which part of the sheet to use.

Example ​

ts
"A1:B10" = A range from cell A1 through B10
"5:7" = Rows 5-7
"D:F" = Columns D-F

See ​

https://developers.google.com/chart/interactive/docs/spreadsheets#query-source-ranges

Defined in ​

src/parser/spreadsheet.ts:17

Released under the MIT License.