Nice! On Tue, May 26, 2020 at 9:37 PM Ista Zahn <istaz...@gmail.com> wrote:
> How about > > read_excel_table <- function(x) { > readxl::read_excel( > x, > sheet=grep("tables", > excel_sheets(x), > ignore.case = TRUE, > value = TRUE), > .name_repair = fixColNames > ) > } > > lapply(SIS$FULL_FILEPATH, read_excel_table) > > > --Ista > > On Tue, May 26, 2020 at 11:05 PM Ravi Jeyaraman <rav...@gmail.com> wrote: > > > > I’ve already tried that and doesn’t work > > > > > > > > From: Erin Hodgess [mailto:erinm.hodg...@gmail.com] > > Sent: Tuesday, May 26, 2020 10:55 PM > > To: Ravi Jeyaraman <rav...@gmail.com> > > Cc: r-help@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 <rav...@gmail.com > <mailto:rav...@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@r-project.org <mailto:R-help@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.hodg...@gmail.com <mailto:erinm.hodg...@gmail.com> > > > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help@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.hodg...@gmail.com [[alternative HTML version deleted]] ______________________________________________ R-help@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.