title: text to columns with comma delimiter using python
body: <p>how to divide a column in to two columns in an excel using a delimiter ', 'and name the header's  using python</p>
  
  <p>here is my code</p>
  
  <pre><code>import openpyxl
  
  
  w=openpyxl.load_workbook('DDdata.xlsx')
  active=w.active
  
  
  a=active.columns[1]
  for cellobj in a:
      s=cellobj.value
      fila=s.split(',')
  
      print(fila)
  </code></pre>
  
  <p>[Input file link][1]</p>
  
  <p>[outputfile][3]</p>