PhpOffice\PhpSpreadsheetTests\Reader\Xls\PasswordTest

Complexity

Total Complexity

4

Size/Duplication

Total Lines	45
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	testCorrectPassword()	0	9	1
A	testDefaultPassword()	0	8	1
A	testUnsupportedEncryption()	0	10	1
A	testWrongPassword()	0	10	1

<?php

namespace PhpOffice\PhpSpreadsheetTests\Reader\Xls;

use PhpOffice\PhpSpreadsheet\Reader\Exception as ReaderException;
use PhpOffice\PhpSpreadsheet\Reader\Xls as XlsReader;
use PHPUnit\Framework\TestCase;

class PasswordTest extends TestCase
{
    public function testDefaultPassword(): void
    {
        $filename = 'tests/data/Reader/XLS/pwtest.xls';
        $reader = new XlsReader();
        $spreadsheet = $reader->load($filename);
        $sheet = $spreadsheet->getActiveSheet();
        self::assertSame('x', $sheet->getCell('A1')->getValue());
        $spreadsheet->disconnectWorksheets();
    }

    public function testWrongPassword(): void
    {
        $this->expectException(ReaderException::class);
        $this->expectExceptionMessage('Decryption password incorrect');
        $filename = 'tests/data/Reader/XLS/pwtest2.xls';
        $reader = new XlsReader();
        $spreadsheet = $reader->load($filename);
        $sheet = $spreadsheet->getActiveSheet();
        self::assertSame('test2', $sheet->getCell('A1')->getValue());
        $spreadsheet->disconnectWorksheets();
    }

    public function testCorrectPassword(): void
    {
        $filename = 'tests/data/Reader/XLS/pwtest2.xls';
        $reader = new XlsReader();
        $reader->setEncryptionPassword('pwtest2');
        $spreadsheet = $reader->load($filename);
        $sheet = $spreadsheet->getActiveSheet();
        self::assertSame('test2', $sheet->getCell('A1')->getValue());
        $spreadsheet->disconnectWorksheets();
    }

    public function testUnsupportedEncryption(): void
    {
        $this->expectException(ReaderException::class);
        $this->expectExceptionMessage('Unsupported encryption algorithm');
        $filename = 'tests/data/Reader/XLS/pwtest3.xls';
        $reader = new XlsReader();
        $spreadsheet = $reader->load($filename);
        $sheet = $spreadsheet->getActiveSheet();
        self::assertSame('test2', $sheet->getCell('A1')->getValue());
        $spreadsheet->disconnectWorksheets();
    }
}