PhpOffice\PhpSpreadsheetTests\Writer\Csv\HyperlinkTest::testVariableColumns()

Complexity

Conditions	1
Paths	1

Size

Total Lines	35
Code Lines	29

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    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();
    }