openpyxl / openpyxl

96%

default: 96%

LAST BUILD ON BRANCH 3.2

branch: 3.2

CHANGE BRANCH

x

Reset

• 3.2
• 2.5
• 2.6
• 3.0
• 3.1
• DefRefErr
• Matthew-Davis/make-import-dependencies-clear-for-works-1572416714092
• Scott-Noyes/fix-grammar-and-spelling-errors-1574224174595
• Scott-Noyes/fix-some-grammar-and-spelling-1574230839774
• Tristan-Stenner/namedrangedoc
• bugfix/merge-cell-hyperlink
• default
• deletion-performance
• empty-sequence
• feature/formula-with-linefeed
• feature/write_numpy_to_cell
• fix-cfvo-type-error
• fix-mergedcell-hyperlink-read-only
• fix-reading-chart-with-no-series
• fix_disjoint_cellrange
• henningb/protectionrst-edited-online-with-bitbuck-1549543344364
• improve-error-msg
• issue-1321
• jemord/fix-incorrect-class-path-for-writeonlyce-1549810368558
• jlice/protectionrst-edited-online-with-bitbuck-1556983141575
• n23/fix-critical-typo-mitre-to-miter-causing-1544625603513
• snippet/authorsrst-edited-fixed-typo-1542062111491
• update-docs-py34

Add autofit() method for automatic column width adjustment

This commit introduces a new autofit() method in ColumnDimension that
automatically adjusts column widths based on cell content length.

Features:
- Uses public API: worksheet.cell(), min_row, max_row
- Configurable: min_width, max_width, width_factor parameters
- Robust: handles None values, multiline content (\n)
- Returns calculated width for debugging

Also includes:
- autofit_columns() helper method in Worksheet class
- Comprehensive test suite (13 new tests, all passing)
- Updated AUTHORS.rst with contributor

Performance: ~0.014s per column for 10k rows

This is a pragmatic approximation based on character count.
Excel's AutoFit uses complex calculations involving DPI, font metrics,
and rendering engine details that are not available to openpyxl.
This method provides a practical solution suitable for most use cases.