title: Reading multiple Excel files (with multiple sheets) in a directory in R
body: <p>I have multiple .xlsx files that I would like to read and combine into one file. However, each of the files contain two sheets so I would like to have one file that is all sheet 1 and then 1 file is all sheet 2.</p>
  <p>I have used code like this before to read multiple files but it doesn't take into account different sheets.</p>
  <pre><code>files = list.files(path = &quot;../input_data/&quot;, 
                           pattern = &quot;*.xlsx&quot;, 
                           full.names = T)
    
  combined_data = sapply(files, read_excel, simplify = F) %&gt;% 
      rbind.fill()
  </code></pre>
  <p>I had tried adding the <code>sheet</code> parameter to the <code>read_excel</code> function but that didn't work. Any ideas? Thanks!</p>