Message-ID: <CACxE24nFOyeY1bQ9HaWw8ZqJjoH3xviv7FiTV8NtsKKFx-Bjqw@mail.gmail.com>
Date: 2020-05-27T02:55:11Z
From: Erin Hodgess
Subject: read_excel() ignore case of worksheet name?
In-Reply-To: <002401d633cd$6f390b50$4dab21f0$@gmail.com>
Here?s a thought, please. Could you use the tolower function and make them
all lower case?
Thanks,
Erin
On Tue, May 26, 2020 at 8:21 PM Ravi Jeyaraman <ravi76 at gmail.com> wrote:
> 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]]