Skip to main content

Excel_Workbook.read

readquery headers limit skip_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.