title: existing Xlsx file delete specific Columns in python
body: <p>I am trying to remove a column from a xlsx file i have. </p>
  
  <p>What i tried to do and founded over the internet was to write down in specific cells in order to clean its values but couldn't find a faster way to remove the whole column.</p>
  
  <p>what i did was this but since i have 300 rows its going to be large...</p>
  
  <pre><code>import openpyxl
  xfile = openpyxl.load_workbook('excel.xlsx')
  
  sheet = xfile.get_sheet_by_name('Sheet1')
  sheet['B1'] = ''
  sheet['B2'] = ''
  sheet['B3'] = ''
  sheet['B4'] = ''
  sheet['B5'] = ''
  sheet['B6'] = ''
  
  xfile.save('output.xlsx')
  </code></pre>
  
  <p>Any ideas?</p>