title: R: Importing different excel file and rename colums in a loop
body: <p>I am struggeling in writing a code to import different files (selecting and renaming columns) with a loop.</p>
  <p>In detail, I  am looking for an efficient way to create a loop that does the same as follows for several .xlsx files.</p>
  <pre><code>library(readxl)
  Data &lt;-read_excel('File.xlsx', sheet = &quot;results&quot;, range = cell_cols(&quot;B:D&quot;),
                     c(&quot;Col1&quot;, &quot;Col2&quot;, &quot;Col3&quot;))
  </code></pre>
  <p>I have done several attemps, but non of them worked; can anyone suggest a solution?</p>