tests/testthat/_snaps/sheets.md

In readxl: Read Excel Files

informative error when requesting non-existent sheet by name

Code
  read_excel(test_sheet("iris-excel-xlsx.xlsx"), sheet = "tulip")
Error <simpleError>
  Sheet 'tulip' not found

Code
  read_excel(test_sheet("iris-excel-xlsx.xlsx"), range = "tulip!A1:A1")
Error <simpleError>
  Sheet 'tulip' not found

informative error when requesting non-existent sheet by position

Code
  read_excel(test_sheet("iris-excel-xlsx.xlsx"), sheet = 2)
Error <simpleError>
  Can't retrieve sheet in position 2, only 1 sheet(s) found.

Code
  read_excel(test_sheet("iris-excel-xls.xls"), sheet = 2)
Error <simpleError>
  Can't retrieve sheet in position 2, only 1 sheet(s) found.

invalid sheet values caught

Code
  read_excel(test_sheet("iris-excel-xlsx.xlsx"), sheet = 0)
Error <simpleError>
  `sheet` must be positive

Code
  read_excel(test_sheet("iris-excel-xlsx.xlsx"), sheet = rep(1L, 2))
Error <simpleError>
  `sheet` must have length 1

double specification of sheet generates message and range wins

Code
  double <- read_excel(test_sheet("sheet-xml-lookup.xlsx"), sheet = "Asia",
  range = "Oceania!A1:A1")
Message <simpleMessage>
  Two values given for `sheet`. Using the `sheet` found in `range`:
  Oceania

readxl documentation built on July 9, 2023, 5:57 p.m.