title: How to add header to a Dataframe (created from excel with ".parse") without overwriting the first Row in Excel
body: <p>I want to read multiple Excel-Files from multiple sheets and files. The biggest issue is just to add an header (because the original excel-Files don't have one) to a generated dataframe of a sheet, because all used methods still overwriting the values in line/row 1 (A1, B1 ...).</p>
  <p>Code at the moment:</p>
  <pre><code># before the path was declared 
  xl = pd.ExcelFile(file)
  
  # there is additional code above which reads all the files in a folder, selecting the relevant ones and open them
  sheetHeader = [&quot;A&quot;, &quot;B&quot;, &quot;C&quot;, &quot;D&quot;, &quot;E&quot;, &quot;F&quot;, &quot;G&quot;, &quot;H&quot;]
  
  # rotation through all excel-sheets starts 
  for sheetNames in xl.sheet_names:
       df_sheetExtraction = xl.parse(sheet_names = sheetNames, 
                                     header = 0, 
                                     names = sheetHeader)
  
       #example for asking at the specific cell value
       if df_sheetExtraction[&quot;B&quot;][1] == searchedValue:
             pass
       
  </code></pre>
  <p>The problem as an example (in list-form) ...</p>
  <p>Excel: <code>[[11, 12, 13, 14 ...],[21, 22, 23, 24 ...], [31, 32, 33, 34 ...] ...]</code></p>
  <p>Dataframe: <code>[[A, B, C, D ...], [21, 22, 23, 24 ...], [31, 32, 33, 34 ...] ...]</code></p>
  <p>instead of <code>[[A, B, C, D ...], [11, 12, 13, 14 ...] ...]</code></p>
  <p>I tried it without the <code>xl.parse(..., names = ...)</code> and add the columns afterwards <code>df_sheetExtraction.columns = sheetHeader </code> with the same result. Different usages in <code>xl.parse(..., header = ...)</code> won't affect the targeted result.</p>
  <p>Is there a way to avoid combining the dataframe with a separate &quot;header-dataframe&quot;?</p>
  <p>Thx for your help</p>