PhpOffice\PhpSpreadsheetTests\Worksheet\ToArrayTest

Complexity

Total Complexity

3

Size/Duplication

Total Lines	83
Duplicated Lines	0 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	testMaxCol()	0	11	1
A	testDollarSign()	0	13	1
A	testToArray()	0	53	1

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Worksheet;

use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PHPUnit\Framework\TestCase;

class ToArrayTest extends TestCase
{
    public static function testToArray(): void
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $inputArray = [
            ['a', 'b', null, 'd', 'e'],
            [],
            [null, null, null, null, 'f'],
            [],
            [1, 0, null, 4],
        ];

        $sheet->fromArray($inputArray, null, 'A1', true);

        $expected1 = [
            ['a', 'b', null, 'd', 'e'],
            [null, null, null, null, null],
            [null, null, null, null, 'f'],
            [null, null, null, null, null],
            [1, 0, null, 4, null],
        ];
        $result1 = $sheet->toArray(null, false, false, false, false);
        self::assertSame($expected1, $result1);

        $expected2 = [
            1 => ['A' => 'a', 'B' => 'b', 'C' => null, 'D' => 'd', 'E' => 'e'],
            2 => ['A' => null, 'B' => null, 'C' => null, 'D' => null, 'E' => null],
            3 => ['A' => null, 'B' => null, 'C' => null, 'D' => null, 'E' => 'f'],
            4 => ['A' => null, 'B' => null, 'C' => null, 'D' => null, 'E' => null],
            5 => ['A' => 1, 'B' => 0, 'C' => null, 'D' => 4, 'E' => null],
        ];
        $result2 = $sheet->toArray(null, false, false, true, false);
        self::assertSame($expected2, $result2);

        $expected3 = [
            [null, null, null, null],
            [null, null, null, 'f'],
            [null, null, null, null],
            [0, null, 4, null],
        ];
        $result3 = $sheet->rangeToArray('B2:E5', null, false, false, false, false);
        self::assertSame($expected3, $result3);

        $expected4 = [
            2 => ['B' => null, 'C' => null, 'D' => null, 'E' => null],
            3 => ['B' => null, 'C' => null, 'D' => null, 'E' => 'f'],
            4 => ['B' => null, 'C' => null, 'D' => null, 'E' => null],
            5 => ['B' => 0, 'C' => null, 'D' => 4, 'E' => null],
        ];
        $result4 = $sheet->rangeToArray('B2:E5', null, false, false, true, false);
        self::assertSame($expected4, $result4);

        $spreadsheet->disconnectWorksheets();
    }

    public static function testMaxCol(): void
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->getCell('A1')->setValue('start');
        $sheet->getCell('XFD1')->setValue('end');
        $array = $sheet->toArray(null, false, false, false, false);
        self::assertCount(1, $array);
        self::assertCount(16384, $array[0]);
        self::assertSame('start', $array[0][0]);
        self::assertSame('end', $array[0][16383]);
    }

    public static function testDollarSign(): void
    {
        $filename = 'tests/data/Reader/XLSX/issue.4242.xlsx';
        $reader = new Xlsx();
        $spreadsheet = $reader->load($filename);
        $sheet = $spreadsheet->getActiveSheet();

        $expected = [
            ['General', '$0', 'Value is $100', '200 number - $200 value', null],
            ['Text', '$0', 'Value is $100', '200 number - $200 value', null],
        ];
        $result = $sheet->toArray();
        self::assertSame($expected, $result);
    }
}