CODEWITHSUNDEEP
pythonxlwt
TimothyAWiseman
TimothyAWiseman

Reputation: 14873

Python XLWT adjusting column widths

I am enormously impressed with the ease of use of XLWT, but there is one thing I have not figured out how to do. I am trying to adjust certain rows to the minimum width they would need to display all characters (in other words, what excel would do if you double clicked on the divider between cells).

I know how to adjust the column widths to a predetermined amount, but I am not certain how to determine the minimum width needed to display everything.

Upvotes: 18

Views: 17674

Answers (1)

Manfre
Manfre

Reputation: 1245

Width is 1/256 the width of the zero character for the default font. A good enough approximation is:

def get_width(num_characters):
    return int((1+num_characters) * 256)

Upvotes: 30

Related Questions