pyexcel - is there a way to get the column width?

80 Views Asked by At

I have an excel sheet that I can display via pyexcel.get_book like this:

    +------------------------+-------+---------------+--------------+-----------------------------------------------------------------+------------------------+----------+
    | Rec No.                | Title | Forenames     | Surname      | Address                                                         | Plaintiff Name         | Amount   |
    +------------------------+-------+---------------+--------------+-----------------------------------------------------------------+------------------------+----------+
    | 01                     | MR    | GUY PERSON    | FITZGERALD   | 69 BLAZEIT TERRACE, BAGEL ROAD, ST SAVIOUR, GERBILTONG, JE2 7TR | BANANA COMPANY LIMITED | 69420.69 |
    +------------------------+-------+---------------+--------------+-----------------------------------------------------------------+------------------------+----------+

Is there a way to determine the width of the column that pyexcel calculates to display the table above (address is longer than the rest for example)? Like a col.width?

I want to convert this table to an image that takes up the full width of a page. The columns are of different widths, which I would like to use.

0

There are 0 best solutions below