PHP SpreadSheet can't find the function to auto size column width

Question

I simply want the columns to autosized. I am using php spreadsheet and I can't find how to do it. Any advise ? This is my code

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Projects First Year');
$sheet->setCellValue('B1', 'Grades');

$sheet->setCellValue('A2', 'PHP Project 2020');
$sheet->setCellValue('B2', $_SESSION['phpScore']);

https://stackoverflow.com/questions/12381875/autosize-spreadsheet-columns — Dezigo, Jun 04 '20 at 20:18
@Dezigo this is phpexcel not spreadsheet anyway thnx ..but i found it — ThunderBoy, Jun 04 '20 at 20:47

score 29 · Accepted Answer · answered Nov 01 '21 at 08:52

29

Don't use range(). It won't work when cells beyond Z. Use instead

foreach ($sheet->getColumnIterator() as $column) {
   $sheet->getColumnDimension($column->getColumnIndex())->setAutoSize(true);
}

answered Nov 01 '21 at 08:52

Tara

470
4
13

score 12 · Answer 2 · answered Jun 04 '20 at 20:48

For spreadsheet the answer is:

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\IOFactory;

  foreach (range('A','B') as $col) {
   $sheet->getColumnDimension($col)->setAutoSize(true);
}

score 5 · Answer 3 · answered Oct 05 '21 at 20:15

5

A slight modification that does not require you to know how many columns you have in your spreadsheet:

foreach (range('A', $sheet->getHighestColumn()) as $col) {
   $sheet->getColumnDimension($col)->setAutoSize(true);
}

answered Oct 05 '21 at 20:15

Wes

826
9
18

for some reason when highest column beyond than z, setAutosize(true) is not woking – Tara Nov 01 '21 at 08:40
That's right! I also found this out and should have corrected my comment! – Wes Nov 01 '21 at 14:54

PHP SpreadSheet can't find the function to auto size column width

3 Answers3

Linked