[R] read_excel() ignore case of worksheet name?
Ravi Jeyaraman
r@v|76 @end|ng |rom gm@||@com
Wed May 27 04:20:47 CEST 2020
Hello All, Is there any parameter to make read_excel() ignore the case-sensitiveness of the worksheet? I'm using the below to ready in multiple spreadsheets and it works perfectly fine if the worksheet is named 'Tables', but fails when it's named ' TABLES'. Any thoughts?
lapply(1:nrow(SIS), function(x) readxl::read_excel(SIS$FULL_FILEPATH[x], sheet='Tables', .name_repair = fixColNames))
Thanks in advance for your response.
Cheers
Ravi
--
This email has been checked for viruses by AVG.
https://www.avg.com
More information about the R-help
mailing list