getActiveSheet(); $string = ' Ye&ar '; $trimString = trim($string); $sheet->getCell('A1')->setValue($string); $sheet->getCell('A2')->setValueExplicit($string, DataType::TYPE_INLINE); $sheet->getCell('B1')->setValue($trimString); $sheet->getCell('B2')->setValueExplicit($trimString, DataType::TYPE_INLINE); $writer = new XlsxWriter($spreadsheet); $writer->createStyleDictionaries(); $writerStyle = new XlsxWriter\Style($writer); $data = $writerStyle->writeStyles($spreadsheet); self::assertStringContainsString( 'writeWorkbook($spreadsheet); self::assertStringContainsString( 'createStringTable(); $writerStringTable = new XlsxWriter\StringTable($writer); $data = $writerStringTable->writeStringTable($stringTable); self::assertStringContainsString( ' Ye&ar ', $data ); self::assertStringContainsString( 'Ye&ar', $data ); $writerWorksheet = new XlsxWriter\Worksheet($writer); $data = $writerWorksheet->writeWorksheet($sheet, []); self::assertStringContainsString( ' Ye&ar ', $data ); self::assertStringContainsString( 'Ye&ar', $data ); $spreadsheet->disconnectWorksheets(); } public function testTable(): void { $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->fromArray( [ ['MyCol', 'Colonne2', 'Colonne3'], [10, 20], [2], [3], [4], ], null, 'B1', true ); $table = new Table('B1:D5', 'Tableau1'); $sheet->addTable($table); $writer = new XlsxWriter($spreadsheet); $writerTable = new XlsxWriter\Table($writer); $data = $writerTable->writeTable($table, 1); self::assertStringContainsString( 'disconnectWorksheets(); } }