Skip to content
GitLab

Adding ability to set column widths for all columns or for columns in a certain sheet

Closed Administrator requested to merge github/fork/pathfindercb/master into master

Created by: pathfindercb

(Note: first time GitHub user and fairly new to PHP so let me know if this is the wrong way to handle this!)

I love the PHP_XLXSWriter class and it does everything I want except I need some custom column widths to make the resulting sheets more readable to my users.

I added two functions --

  • setColWidth() to change default width for all column in a sheet when initialized from the global default of 11.5 to some other value

  • setColWidths() to pass a sheet name and an array of column widths for that sheet.

These values are used in building the XML for the <col /col> when a sheet is initialized.

I included an example-colwidths.php to demonstrate the functionality and updated the ReadMe file.