Python xlwt – accessing existing cell content, auto-adjust column width

by

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 worksheet interface remains the same: this is a drop-in wrapper
    for auto-sizing columns.
    """
    def __init__(self, sheet):
        self.sheet = sheet
        self.widths = dict()

    def write(self, r, c, label="", *args, **kwargs):
        self.sheet.write(r, c, label, *args, **kwargs)
        width = arial10.fitwidth(label)
        if width > self.widths.get(c, 0):
            self.widths[c] = width
            self.sheet.col(c).width = width

    def __getattr__(self, attr):
        return getattr(self.sheet, attr)

All the magic is in John Yeung’s arial10 module. This has good widths for Arial 10, which is the default Excel font. If you want to write worksheets using other fonts, you’ll need to change the fitwidth function, ideally taking into account the style argument passed to FitSheetWrapper.write.

More Related Contents:

  1. Preserving styles using python’s xlrd,xlwt, and xlutils.copy
  2. writing to existing workbook using xlwt [closed]
  3. Insert row into Excel spreadsheet using openpyxl in Python
  4. Edit existing excel workbooks and sheets with xlrd and xlwt
  5. GroupBy results to dictionary of lists
  6. Create a .csv file with values from a Python list
  7. Pandas: Looking up the list of sheets in an excel file
  8. python xlrd unsupported format, or corrupt file.
  9. How to copy over an Excel sheet to another workbook in Python
  10. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  11. Get formula from Excel cell with python xlrd
  12. Error: Unsupported format, or corrupt file: Expected BOF record
  13. Convert date from excel in number format to date format python [duplicate]
  14. How to obtain sheet names from XLS files without loading the whole file?
  15. xlrd.biffh.XLRDError: Excel xlsx file; not supported [duplicate]
  16. Python Creating Dictionary from excel data
  17. Identifying Excel Sheet cell color code using XLRD package
  18. django excel xlwt
  19. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets
  20. Integers from excel files become floats?
  21. Understanding the “is” operator
  22. Dynamically evaluate an expression from a formula in Pandas
  23. How can I capitalize the first letter of each word in a string?
  24. List vs generator comprehension speed with join function [duplicate]
  25. Parse HTML table to Python list?
  26. Reading binary data from stdin
  27. Scikit Learn SVC decision_function and predict
  28. ValueError: Missing staticfiles manifest entry for ‘favicon.ico’
  29. Filtering a list based on a list of booleans
  30. How do I detect whether sys.stdout is attached to terminal or not? [duplicate]

Leave a Comment