Column width issue
Created originally on Bitbucket by ikovrigin (Igor Kovrigin)
Sample create workbook and set column width to 22.
Notice in excel column width is always lower on 0.7109375 than in openpyxl Same issue on read and write. So if you load file and save. Width in saved file will be same as in template file.
#!python from openpyxl import Workbook wb = Workbook() ws = wb.get_active_sheet() ws['A1'] = 'test' ws.column_dimensions["A"].width = 22 wb.save(filename = 'test_book.xlsx')