View Code - 20260721

Hstack.php | 20260721_154033.php Initial Bulk Import

<?php

namespace PhpOffice\PhpSpreadsheet\Calculation\LookupRef;

use PhpOffice\PhpSpreadsheet\Calculation\Functions;
use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;

class Hstack
{
    /**
     * Excel function HSTACK.
     *
     * @return mixed[]|string
     */
    public static function hstack(mixed ...$inputData): array|string
    {
        $maxRow = 0;
        foreach ($inputData as $matrix) {
            if (!is_array($matrix)) {
                $count = 1;
            } else {
                $count = count($matrix);
            }
            $maxRow = max($maxRow, $count);
        }
        /** @var mixed[] $inputData */
        foreach ($inputData as &$matrix) {
            if (!is_array($matrix)) {
                $matrix = [$matrix];
            }
            $rows = count($matrix);
            $reset = reset($matrix);
            $columns = is_array($reset) ? count($reset) : 1;
            while ($maxRow > $rows) {
                $matrix[] = array_pad([], $columns, ExcelError::NA());
                ++$rows;
            }
        }

$transpose = array_map(null, ...$inputData); //* @phpstan-ignore-line
        $returnMatrix = [];
        foreach ($transpose as $array) {
            $returnMatrix[] = Functions::flattenArray($array);
        }

return $returnMatrix;
    }
}