read_excel() ignore case of worksheet name?

Here?s a thought, please.  Could you use the tolower function and make them
all lower case?

Thanks,
Erin

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

______________________________________________
R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Erin Hodgess, PhD
mailto: erinm.hodgess at gmail.com

	[[alternative HTML version deleted]]

read_excel() ignore case of worksheet name?

Thread (9 messages)