Is it possible to sort tabs ?

[dubinfo]

Hello,

Is it possible to sort the tabs of my Excel workbook once it is generated?

PhpSpreadsheet Version : 1.18 Php 8.1 Laravel 8.75

Thank you in advance for your help.

David

[jr212]

Google found https://stackoverflow.com/questions/78478646/how-to-sort-worksheets-by-name-in-a-phpspreadsheet-workbook-without-disrupting-s

[oleibman]

        $titleArray = $spreadsheet->getSheetNames();
        sort($titleArray);
        $index = -1;
        foreach ($titleArray as $title) {
            ++$index;
            $spreadsheet->setIndexByName($title, $index);
        }

[oleibman]

Don't see a way to "mark as answer", but, 3+ months after the last message, no reason to think it isn't right. Closing discussion.