title: Most efficient way to work with multiple excel sheets
body: <p>Currently, I'm working with Excel workbooks for > 15 sheets. I use the following sequence:</p>
  
  <pre><code>#libraries
  library(data.table)
  library(openxlsx)    
  
  #load excel file
      wb &lt;- loadWorkbook("Data.xlsx")
  
      #write sheets into a list of data frames
      name &lt;- names(wb)
      df &lt;- list()
      for (i in 1:length(name)){
  
        d &lt;- lapply(i, function(i) readWorkbook(wb, sheet = name[i], startRow = 1, colNames = TRUE, rowNames = FALSE, detectDates = TRUE, skipEmptyRows = TRUE, skipEmptyCols = TRUE, rows = NULL, cols = NULL, check.names = FALSE, namedRegion = NULL, na.strings = "NA", fillMergedCells = FALSE))
  
        df &lt;- append(df, d)
      }
  
  
  
      #assign names to columns
      names(df) &lt;- name
  
      #merge DFs into one list
      DT &lt;- rbindlist(df)
  </code></pre>
  
  <p>Now, I've been working mostly with very small data sets, so performance is not an issue. However, I was wondering if there's an easier way to perform this, in case I'm working with big data sets.</p>
  
  <p>Thanks a lot for your input already.</p>