我的ExcelElectron 表格总是导入到R中，列标题像"44983"，而不是我想要的d/m/y格式.我想在R中解决这个问题，而不是在Excel中. 我的框架被称为"backlog"，有95列，第一个是"Backlog 62 d+"，其余的列是像"44983"这样的日期，R已经将其注册为字符.
我try 了以下代码，但我的数据框看起来仍然是一样的--列标题没有更改为日期d/m/y格式.
backlog <- read_excel("./Weekly/Weekly_Cancer_62d_PTL_Tracker.xlsx",
sheet = "Provider Trends", range = "B24:CR44" %>% setNames(., c('Backlog 62d+', format(as.Date(as.numeric(names(.)[-1]), origin = '1899-12-30'), '%m/%d/%Y'))))
基于你的 comments ，我相信这就是你正在寻找的，只是做了一些改变:
vector_column_number <- colnames(backlog)[-1] # Names of your columns without the first one
list_columns_numeric <- lapply(vector_column_number , as.numeric) # Transformation of the list of character to a list of numeric (needed for as.Date)
list_columns_date <- lapply(list_columns_numeric , as.Date, origin = "1899-12-30") # Transformation of the numerical value to the date value
vector_columns_character <- lapply(list_columns_date , as.character) |> unlist() # Tranformation back to a vector of character
colnames(backlog) <- c(colnames(backlog)[1],vector_columns_character ) # Change the columns' names, keeping the first one and using the vector created before