Re: [R] read_excel() ignore case of worksheet name?

2020-05-27 Thread Ravi Jeyaraman
Ista, With few tweaks this worked beautifully. Thank you so much. -Original Message- From: Ista Zahn [mailto:istaz...@gmail.com] Sent: Tuesday, May 26, 2020 11:38 PM To: Ravi Jeyaraman Cc: Erin Hodgess ; r-help@r-project.org Subject: Re: [R] read_excel() ignore case of worksheet name

Re: [R] read_excel() ignore case of worksheet name?

2020-05-26 Thread Jim Lemon
27;s excellent solution that blew mine away. Maybe next time. Jim On Wed, May 27, 2020 at 1:05 PM Ravi Jeyaraman 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

Re: [R] read_excel() ignore case of worksheet name?

2020-05-26 Thread Ista Zahn
-Ista On Tue, May 26, 2020 at 11:05 PM Ravi Jeyaraman 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 > Cc: r-help@r-project.org > Subject: Re: [R]

Re: [R] read_excel() ignore case of worksheet name?

2020-05-26 Thread Erin Hodgess
gt; > > From: Erin Hodgess [mailto:erinm.hodg...@gmail.com] > > Sent: Tuesday, May 26, 2020 10:55 PM > > To: Ravi Jeyaraman > > Cc: r-help@r-project.org > > Subject: Re: [R] read_excel() ignore case of worksheet name? > > > > > > > > Here’s a thought

Re: [R] read_excel() ignore case of worksheet name?

2020-05-26 Thread Erin Hodgess
Jeyaraman > *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

Re: [R] read_excel() ignore case of worksheet name?

2020-05-26 Thread Ravi Jeyaraman
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 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

Re: [R] read_excel() ignore case of worksheet name?

2020-05-26 Thread Erin Hodgess
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 wrote: > Hello All, Is there any parameter to make read_excel() ignore the > case-sensitiveness of the worksheet? I'm using the below to read

[R] read_excel() ignore case of worksheet name?

2020-05-26 Thread Ravi Jeyaraman
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),