spreadsheet->disconnectWorksheets(); unset($this->spreadsheet); } public function testDefault(): void { $this->spreadsheet = new Spreadsheet(); $sheet = $this->spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 1); $writer = new HtmlWriter($this->spreadsheet); self::assertSame(PHP_EOL, $writer->getLineEnding()); $html = $writer->generateHtmlAll(); $count = substr_count($html, PHP_EOL); self::assertSame($this->expectedLines, $count); } public function testUnix(): void { $this->spreadsheet = new Spreadsheet(); $sheet = $this->spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 1); $writer = new HtmlWriter($this->spreadsheet); $writer->setLineEnding("\n"); $html = $writer->generateHtmlAll(); $count = substr_count($html, "\n"); self::assertSame($this->expectedLines, $count); $count = substr_count($html, "\r"); self::assertSame(0, $count); } public function testWindows(): void { $this->spreadsheet = new Spreadsheet(); $sheet = $this->spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 1); $writer = new HtmlWriter($this->spreadsheet); $writer->setLineEnding("\r\n"); $html = $writer->generateHtmlAll(); $count = substr_count($html, "\n"); self::assertSame($this->expectedLines, $count); $count = substr_count($html, "\r"); self::assertSame($this->expectedLines, $count); $count = substr_count($html, "\r\n"); self::assertSame($this->expectedLines, $count); } public function testInvalidLineEnding(): void { $this->expectException(WriterException::class); $this->expectExceptionMessage('Line ending must be'); $this->spreadsheet = new Spreadsheet(); $sheet = $this->spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 1); $writer = new HtmlWriter($this->spreadsheet); $writer->setLineEnding("\r"); } }