PHPExcel auto size column width

by

If a column is set to AutoSize, PHPExcel attempts to calculate the column width based on the calculated value of the column (so on the result of any formulae), and any additional characters added by format masks such as thousand separators.

By default, this is an estimated width: a more accurate calculation method is available, based on using GD, which can also handle font style features such as bold and italic; but this is a much bigger overhead, so it is turned off by default. You can enable the more accurate calculation using

PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);

However, autosize doesn’t apply to all Writer formats… for example CSV. You don’t mention what writer you’re using.

But you also need to identify the columns to set dimensions:

foreach(range('B','G') as $columnID) {
    $objPHPExcel->getActiveSheet()->getColumnDimension($columnID)
        ->setAutoSize(true);
}

$objPHPExcel->getActiveSheet()->getColumnDimension() expects a column ID.

$objPHPExcel->getActiveSheet()->getColumnDimensions() will return an array of all the defined column dimension records; but unless a column dimension record has been explicitly created (perhaps by loading a template, or by manually calling getColumnDimension()) then it won’t exist (memory saving).

More Related Contents:

  1. PHPExcel — Color part of XLSX table
  2. Alternative for PHP_excel
  3. PHPExcel runs out of 256, 512 and also 1024MB of RAM
  4. How do I resize pngs with transparency in PHP?
  5. Merging two images with PHP
  6. Calculating image size ratio for resizing
  7. phpexcel to download
  8. Maximum size of a PHP session
  9. Resize/crop/pad a picture to a fixed size
  10. How to merge transparent PNG with image using PHP?
  11. How to fix memory getting exhausted with PHPExcel?
  12. PHPExcel download using ajax call
  13. Ignore empty cells PHPExcel
  14. How to use phpexcel to read data and insert into database?
  15. How to read large worksheets from large Excel files (27MB+) with PHPExcel?
  16. Get size of POST-request in PHP
  17. $_FILE upload large file gives error 1 even though upload_max_size is bigger than the file size
  18. Correct format for strings / numbers beginning with zero?
  19. phpexcel Allowed memory size of 134217728 bytes exhausted [duplicate]
  20. php – Should I call exit() after calling Location: header?
  21. How can I add a PHP page to WordPress?
  22. Laravel Check If Related Model Exists
  23. Sort and display directory list alphabetically using opendir() in php
  24. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  25. Submitting JSON data via JQuery ajax.post to PHP
  26. Ajax push system
  27. why is $_REQUEST empty
  28. How to set cron job URL for CodeIgniter?
  29. Error 1148 MySQL The used command is not allowed with this MySQL version
  30. Switch between multiple database in PDO

Leave a Comment