Use Excel column names or RC reference as default names in read_excel
mkoohafkan opened this issue · 1 comments
mkoohafkan commented
Reading in an excel range with col_names = FALSE
results in uninformative name creation messages:
d = read_excel(my_book, my_sheet, "A1:C6", col_names = FALSE)
#> New names:
#> • `` -> `...1`
#> • `` -> `...2`
#> • `` -> `...3`
Neither the message or the resulting names are helpful or clear. However, it should be simple to derive appropriate default names from the workbook columns and/or RC notation, both of which result in valid names:
- A1:C6 --> "A", "B", "C"
- R1C1:R6C3 --> "C1", "C2", "C3"
You could also generate default row names using this logic.