openpyxl – adjust column width size

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

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 openpyxl?

Here is the code I am using.

#!/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)

👻 Read also: what is the best laptop for engineering students?

openpyxl - adjust column width size __del__: Questions

import time
time.sleep(5)   # Delays for 5 seconds. You can also use a float value.

import time
while True:
    print("This prints once a minute.")
    time.sleep(60) # Delay for 1 minute (60 seconds).

from time import sleep
sleep(0.1) # Time in seconds

openpyxl - adjust column width size __del__: Questions

We hope this article has helped you to resolve the problem. Apart from openpyxl – adjust column width size, check other __del__-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

• Italiano openpyxl – adjust column width size
• Deutsch openpyxl – adjust column width size
• Français openpyxl – adjust column width size
• Español openpyxl – adjust column width size
• Türk openpyxl – adjust column width size
• Русский openpyxl – adjust column width size
• Português openpyxl – adjust column width size
• Polski openpyxl – adjust column width size
• Nederlandse openpyxl – adjust column width size
• 中文 openpyxl – adjust column width size
• 한국어 openpyxl – adjust column width size
• 日本語 openpyxl – adjust column width size
• हिन्दी openpyxl – adjust column width size