Interface: SheetOptions

Options for Sheets getter function

Properties

headers?

optional headers: number

How many rows are header rows. If not specified, Google Sheets will guess from the header and body type.

Remarks

If all your columns are string data, the spreadsheet might have difficulty determining which rows are header rows without this parameter.

See

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

Defined in

src/parser/spreadsheet.ts:23

---

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