title: Pandas datframe excel errors
body: <p>I've been debugging this script and continue to get the following error</p>
  <pre><code>'python3 report_generator_1_5_3.py
  </code></pre>
  <p>Opening spreadsheet from .\CVB Logix Firmware-Test Run-20210430.xls...</p>
  <p>Traceback (most recent call last):</p>
  <pre><code>File &quot;C:\Users\report_generator_1_5_3.py&quot;, line 542, in &lt;module&gt;
  main()
  File &quot;C:\Users\report_generator_1_5_3.py&quot;, line 506, in main
  [all_data,suite_list] = openSpreadsheet()
  File &quot;C:\Users\report_generator_1_5_3.py&quot;, line 102, in openSpreadsheet
  all_data = pd.read_excel(workbook_name, 1 ,usecols=['Name','Test Stand','Report Location', 'Output Location', 'Status',
  File'
  </code></pre>
  <p>Here is some of the code</p>
  <pre><code> def openSpreadsheet():
   93     '''Opens spreadsheet generated by qTest, reorders the columns 
   94     and sorts rows by test name'''
   96     #File name of today's regression results
   97     workbook_name = today.strftime('.\Regression\CVB Logix Firmware-Test Run-%Y%m%d.xls')
   98     print(f'Opening spreadsheet from {workbook_name}...\n')
   99 
  100     #Turns regression data into dataframe
  101     all_data = pd.read_excel(workbook_name, 1 ,usecols=['Name','Test Stand','Report Location', 'Output Lo    cation', 'Status',
  102                             'Link to Execution Artifacts', 'Test Case Id','Id', 'Test Case Version',
  103                             'Executed Start','Executed End','Execution State','Test 
  Suite', 'Test Cycle',     'Test Case Automation Metadata: Script Name'],index=False)'
  </code></pre>
  <p>Any assistance?</p>