Skip to main content

Excel_Workbook.read

readquery headers limit on_problems

Group: Input
Aliases: get, 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.