Python xlwt – accessing existing cell content, auto-adjust column width
I just implemented a wrapper class that tracks the widths of items as you enter them. It seems to work pretty well. import arial10 class FitSheetWrapper(object): “””Try to fit columns to max size of any entry. To use, wrap this around a worksheet returned from the workbook’s add_sheet method, like follows: sheet = FitSheetWrapper(book.add_sheet(sheet_name)) The … Read more