Skip to main content

Google_Sheets_Workbook.read

readqueryheaderslimitskip_rowson_problems

Group: Input
Aliases: get, import, load, open, range, sheet, worksheet

Documentation

Read a range into a Table.

Arguments

  • query: sheet name, range name or address to read from the workbook.
  • headers: whether to use the first row as headers (default is Detect_Headers).
  • limit: the maximum number of rows to read. If set to Nothing, all rows will be returned.
  • skip_rows: the number of rows to skip before starting to read data. (Headers are taken after skipping).