Code
read_excel(test_sheet("types.xlsx"), col_types = c("foo", "numeric", "text",
"bar"))
Error <simpleError>
Illegal column type: 'foo' [1], 'bar' [4]
Code
read_excel(test_sheet("types.xlsx"), col_types = rep_len(c("blank", "text"),
length.out = 5))
Message <simpleMessage>
`col_type = "blank"` deprecated. Use "skip" instead.
Output
# A tibble: 5 x 2
boolean numeric
<chr> <chr>
1 TRUE 1
2 FALSE 2
3 <NA> <NA>
4 TRUE 3
5 FALSE 6
Code
read_excel(test_sheet("types.xlsx"), col_types = character())
Error <simpleError>
length(col_types) > 0 is not TRUE
Code
read_excel(test_sheet("types.xlsx"), col_types = 1:3)
Error <simpleError>
is.character(col_types) is not TRUE
Code
read_excel(test_sheet("types.xlsx"), col_types = c(NA, "text", "numeric"))
Error <simpleError>
!anyNA(col_types) is not TRUE
Code
types <- read_excel(test_sheet("types.xlsx"), sheet = "guess_max", guess_max = 2)
Warning <simpleWarning>
Expecting numeric in A4 / R4C1: got 'ab'
Code
types <- read_excel(test_sheet("types.xls"), sheet = "guess_max", guess_max = 2)
Warning <simpleWarning>
Expecting numeric in A4 / R4C1: got 'ab'
Code
read_excel(test_sheet("iris-excel-xlsx.xlsx"), col_types = c("numeric", "text"))
Error <simpleError>
Sheet 1 has 5 columns, but `col_types` has length 2.
Code
read_excel(test_sheet("iris-excel-xls.xls"), col_types = c("numeric", "text"))
Error <simpleError>
Sheet 1 has 5 columns, but `col_types` has length 2.
Code
df <- read_xlsx(test_sheet("missing-values-xlsx.xlsx"), guess_max = 0)
Warning <simpleWarning>
Expecting logical in A2 / R2C1: got 'NA'
Expecting logical in B2 / R2C2: got 'NA'
Code
df <- read_xls(test_sheet("missing-values-xls.xls"), guess_max = 0)
Warning <simpleWarning>
Expecting logical in A2 / R2C1: got 'NA'
Expecting logical in B2 / R2C2: got 'NA'
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.