Code
df <- read_excel(test_sheet("types.xls"), sheet = "logical_coercion",
col_types = c("logical", "text"))
Warning <simpleWarning>
Expecting logical in A14 / R14C1: got 'cabbage'
Expecting logical in A18 / R18C1: got a date
Code
df <- read_excel(test_sheet("types.xlsx"), sheet = "logical_coercion",
col_types = c("logical", "text"))
Warning <simpleWarning>
Expecting logical in A14 / R14C1: got 'cabbage'
Expecting logical in A18 / R18C1: got a date
Code
df <- read_excel(test_sheet("types.xls"), sheet = "date_coercion", col_types = "date")
Warning <simpleWarning>
Expecting date in A4 / R4C1: got boolean
Expecting date in A5 / R5C1: got 'cabbage'
Coercing numeric to date in A6 / R6C1
Coercing numeric to date in A7 / R7C1
Code
df <- read_excel(test_sheet("types.xlsx"), sheet = "date_coercion", col_types = "date")
Warning <simpleWarning>
Expecting date in A4 / R4C1: got boolean
Expecting date in A5 / R5C1: got 'cabbage'
Coercing numeric to date in A6 / R6C1
Coercing numeric to date in A7 / R7C1
Code
df <- read_excel(test_sheet("types.xls"), sheet = "numeric_coercion",
col_types = "numeric")
Warning <simpleWarning>
Coercing text to numeric in A3 / R3C1: '72'
Coercing boolean to numeric in A5 / R5C1
Expecting numeric in A6 / R6C1: got a date
Expecting numeric in A7 / R7C1: got 'cabbage'
Code
df <- read_excel(test_sheet("types.xlsx"), sheet = "numeric_coercion",
col_types = "numeric")
Warning <simpleWarning>
Coercing text to numeric in A3 / R3C1: '72'
Coercing boolean to numeric in A5 / R5C1
Expecting numeric in A6 / R6C1: got a date
Expecting numeric in A7 / R7C1: got 'cabbage'
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.