load($file);
$writer = new HtmlWriter($spreadsheet);
$html = $writer->generateHtmlAll();
$html = (string) preg_replace('/\r?\n\s+/m', '', $html);
$spreadsheet->disconnectWorksheets();
$expectedArray = [
'table.sheet0 col.col0 { width:42pt }',
'table.sheet0 col.col1 { width:42pt }',
'table.sheet0 col.col2 { width:42pt }',
'table.sheet0 col.col3 { width:42pt }',
'table.sheet0 col.col4 { width:42pt }',
'| test |
',
'|
',
'|
',
];
foreach ($expectedArray as $expected) {
self::assertStringContainsString($expected, $html);
}
}
public static function testFromScratch(): void
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->getCell('A1')->setValue('test');
$sheet->mergeCells('A1:E3');
$sheet->getStyle('A1')->getFont()
->setBold(true)
->setSize(18);
$sheet->getStyle('A1')->getAlignment()
->setHorizontal(Alignment::HORIZONTAL_CENTER)
->setVertical(Alignment::VERTICAL_CENTER);
// Following not needed when reading Excel, only from scratch.
// columnDimension needed, rowDimension not needed
//$sheet->getRowDimension(3);
$sheet->getColumnDimension('E');
$writer = new HtmlWriter($spreadsheet);
$html = $writer->generateHtmlAll();
$html = (string) preg_replace('/\r?\n\s+/m', '', $html);
$spreadsheet->disconnectWorksheets();
$expectedArray = [
'',
'',
'',
'',
'',
'| test |
',
'|
',
'|
',
];
foreach ($expectedArray as $expected) {
self::assertStringContainsString($expected, $html);
}
}
}