PhpOffice\PhpSpreadsheetTests\Writer\Csv\HyperlinkTest

Complexity

Total Complexity

1

Size/Duplication

Total Lines	37
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	testVariableColumns()	0	35	1

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Writer\Csv;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Csv;
use PHPUnit\Framework\TestCase;

class HyperlinkTest extends TestCase
{
    public function testVariableColumns(): void
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setCellValue('A1', 3);
        $sheet->setCellValue('B1', 4);
        $sheet->setCellValue('C1', 5);
        $sheet->setCellValue('A2', 6);
        $sheet->setCellValue('B2', 'hyperlink');
        $sheet->getCell('B2')->getHyperlink()
            ->setUrl('http://www.example.com');
        $sheet->setCellValue('C2', 8);

        $fh = fopen('php://memory', 'r+b');
        self::assertNotFalse($fh);
        $writer = new Csv($spreadsheet);
        self::assertFalse($writer->getPreferHyperlinkToLabel());
        $writer->setEnclosureRequired(false)->setLineEnding("\n");
        $writer->save($fh);
        rewind($fh);
        self::assertSame(
            "3,4,5\n6,hyperlink,8\n",
            stream_get_contents($fh)
        );

        rewind($fh);
        $writer->setPreferHyperlinkToLabel(true);
        $writer->save($fh);
        rewind($fh);
        self::assertSame(
            "3,4,5\n6,http://www.example.com,8\n",
            stream_get_contents($fh)
        );
        fclose($fh);
        $spreadsheet->disconnectWorksheets();
    }
}