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
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]]
I?ve already tried that and doesn?t work From: Erin Hodgess [mailto:erinm.hodgess at gmail.com] Sent: Tuesday, May 26, 2020 10:55 PM To: Ravi Jeyaraman <ravi76 at gmail.com> Cc: r-help at r-project.org Subject: Re: [R] 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 On Tue, May 26, 2020 at 8:21 PM Ravi Jeyaraman <ravi76 at gmail.com <mailto: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 <mailto: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 <mailto:erinm.hodgess at gmail.com> [[alternative HTML version deleted]]