Interface: SheetOptions

Options for Sheets getter function

Properties

debug?

optional debug: boolean

Enable debugging logs

Default Value

false

Defined in

src/parser/spreadsheet.ts:34

---

fetchRequestInit?

optional fetchRequestInit: FetchRequestInit

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

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

"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