Warning messages:1: In read_fun(path = enc2native(normalizePath(path)), sheet_i = sheet, : Expect

当读取数据时，

d3 <- read_excel("salt.xlsx",sheet=12)

出现Warning messages:

1: In read_fun(path = enc2native(normalizePath(path)), sheet_i = sheet,  :  Expect numeric in D4 / R4C4: got a date

此时，可以加上 col_types = "text"

d3 <- read_excel("salt_spray.xlsx",sheet=12,col_types = "text")

即可解决。