title: openpyxl - adjust column width size
body: <p>I have following script which is converting a CSV file to an XLSX file, but my column size is very narrow. Each time I have to drag them with mouse to read data. Does anybody know how to set column width in <code>openpyxl</code>? </p>
  
  <p>Here is the code I am using.</p>
  
  <pre><code>#!/usr/bin/python2.6
  import csv
  from openpyxl import Workbook
  from openpyxl.cell import get_column_letter
  
  f = open('users_info_cvs.txt', "rU")
  
  csv.register_dialect('colons', delimiter=':')
  
  reader = csv.reader(f, dialect='colons')
  
  wb = Workbook()
  dest_filename = r"account_info.xlsx"
  
  ws = wb.worksheets[0]
  ws.title = "Users Account Information"
  
  for row_index, row in enumerate(reader):
      for column_index, cell in enumerate(row):
          column_letter = get_column_letter((column_index + 1))
          ws.cell('%s%s'%(column_letter, (row_index + 1))).value = cell
  
  wb.save(filename = dest_filename)
  </code></pre>