title: Reading multiple excel files into R using the map function
body: <p>I know there are similar questions to this but I haven't came across ones using the  map function from the <code>purrr</code> package. I am having a difficult time trying to read in some excel files(.xlsx) using <code>purrr::map()</code>. I would like each one to be it's own data frame. I tried the approach in this similar question: <a href="https://stackoverflow.com/questions/32888757/reading-multiple-excel-files-into-r-best-practice">How can I reading multiple (excel) files into R?</a>.</p>
  
  <p>However, I keep getting this error: </p>
  
  <blockquote>
    <p>Error: path does not exist: "tab3_DOfinal_HUClevel_assessment.xlsx"</p>
  </blockquote>
  
  <p>I know for sure I have the right path. Not sure why I am getting this error. I have about 9 excel spreadsheets that I want to read in.</p>
  
  <p><strong>Code I tried:</strong></p>
  
  <pre><code># load necessary package
  library(purrr)
  
  file.list &lt;- list.files(path="2016_Data_Tables",pattern='*.xlsx')
  file.list &lt;- setNames(file.list, file.list)
  
  # store all .xlsx files as individual data frames inside of one list
  df &lt;- map(file.list, read_xlsx)
  </code></pre>
  
  <p>The file name pattern goes as follows: </p>
  
  <pre><code>tab3_DOfinal_HUClevel_assessment.xlsx
  </code></pre>
  
  <p>The only thing that changes is the DOfinal part.</p>
  
  <p><strong>Some sample data:</strong></p>
  
  <pre><code>structure(list(ID = 1, WMA = 15, Number = "02040302020030-01", 
      HUC14 = "HUC02040302020030", Name = "Absecon Creek (AC Reserviors) (gage to SB)", 
      Region = "Atlantic Coast", NumofStations = "2", ListofStations = "01410455, R32", 
      ListofAssessment = "2, 2", HUCTier = "2", swqs = "PL, SE1", 
      TotalNumSamples5yrs = "NA", flgusgsprelim = "NA, 0", auassess = 2, 
      auassesstrout = -999, finalauassess = 2, finalauassesstrout = -999, 
      Changefrom2014 = "No Change-2", Changetroutfrom2014 = "No Change", 
      listHUC14assess5 = "NA", listHUC14assess3 = "NA", listHUC14assess2 = "01410455, R32", 
      His2014 = "Attaining", His2014trout = "-999", Notes = NA_character_, 
      OldStations2014 = "01410455", OldStationsAssess2014 = "2", 
      Error = NA_character_), .Names = c("ID", "WMA", "Number", 
  "HUC14", "Name", "Region", "NumofStations", "ListofStations", 
  "ListofAssessment", "HUCTier", "swqs", "TotalNumSamples5yrs", 
  "flgusgsprelim", "auassess", "auassesstrout", "finalauassess", 
  "finalauassesstrout", "Changefrom2014", "Changetroutfrom2014", 
  "listHUC14assess5", "listHUC14assess3", "listHUC14assess2", "His2014", 
  "His2014trout", "Notes", "OldStations2014", "OldStationsAssess2014", 
  "Error"), row.names = c(NA, -1L), class = c("tbl_df", "tbl", 
  "data.frame"))
  
  
  structure(list(WMA = 15, Number = "02040302020030-01", HUC14 = "HUC02040302020030", 
      Name = "Absecon Creek (AC Reserviors) (gage to SB)", Region = "Atlantic Coast", 
      NumofStations = "1", ListofStations = "01410455", ListofAssessment = "2", 
      MaxStaAssessment = "2", MinStaAssessment = "2", TotalNumSamples5yrs = "NA", 
      auassess = "2", ChangeFrom2014 = "No Change-2", liststaassess2 = "01410455", 
      liststaassess3 = "NA", liststaassess5 = "NA", Assessment2014 = "Attaining", 
      Comments = NA_character_), .Names = c("WMA", "Number", "HUC14", 
  "Name", "Region", "NumofStations", "ListofStations", "ListofAssessment", 
  "MaxStaAssessment", "MinStaAssessment", "TotalNumSamples5yrs", 
  "auassess", "ChangeFrom2014", "liststaassess2", "liststaassess3", 
  "liststaassess5", "Assessment2014", "Comments"), row.names = c(NA, 
  -1L), class = c("tbl_df", "tbl", "data.frame"))
  
  structure(list(WMA = 15, Number = "02040302020030-01", HUC14 = "HUC02040302020030", 
      Name = "Absecon Creek (AC Reserviors) (gage to SB)", Region = "Atlantic Coast", 
      NumofStations = "1", ListofStations = "R32", ListofAssessment = "3", 
      MaxStaAssessment = "3", MinStaAssessment = "3", TotalNumSamples5yrs = "9", 
      auassess = "3", ChangeFrom2014 = "No Change-3", liststaassess2 = "NA", 
      liststaassess3 = "R32", liststaassess5 = "NA", Assessment2014 = "N/A", 
      Comments = NA_character_), .Names = c("WMA", "Number", "HUC14", 
  "Name", "Region", "NumofStations", "ListofStations", "ListofAssessment", 
  "MaxStaAssessment", "MinStaAssessment", "TotalNumSamples5yrs", 
  "auassess", "ChangeFrom2014", "liststaassess2", "liststaassess3", 
  "liststaassess5", "Assessment2014", "Comments"), row.names = c(NA, 
  -1L), class = c("tbl_df", "tbl", "data.frame"))
  </code></pre>