getActiveSheet();
$sheet->getDefaultRowDimension()->setRowHeight(20);
$sheet->setCellValue('A1', 'hello there world 1');
$sheet->getStyle('A1')->getAlignment()->setWrapText(true);
$sheet->getRowDimension(1)->setCustomFormat(true);
$sheet->setCellValue('A2', 'hello there world 2');
$sheet->setCellValue('A4', 'hello there world 4');
$writer = new XlsxWriter($spreadsheet);
$writerWorksheet = new XlsxWriter\Worksheet($writer);
$data = $writerWorksheet->writeWorksheet($sheet, []);
self::assertStringContainsString(
'',
$data
);
self::assertStringContainsString(
'',
$data
);
self::assertStringContainsString(
'',
$data
);
self::assertStringContainsString(
'',
$data
);
$spreadsheet->disconnectWorksheets();
}
public function testWriteRowDimensionsNoCustom(): void
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->getDefaultRowDimension()->setRowHeight(20);
$sheet->setCellValue('A1', 'hello there world 1');
$sheet->getStyle('A1')->getAlignment()->setWrapText(true);
//$sheet->getRowDimension(1)->setCustomFormat(true);
$sheet->setCellValue('A2', 'hello there world 2');
$sheet->setCellValue('A4', 'hello there world 4');
$writer = new XlsxWriter($spreadsheet);
$writerWorksheet = new XlsxWriter\Worksheet($writer);
$data = $writerWorksheet->writeWorksheet($sheet, []);
self::assertStringContainsString(
'',
$data
);
self::assertStringContainsString(
'',
$data
);
self::assertStringContainsString(
'',
$data
);
self::assertStringContainsString(
'',
$data
);
$spreadsheet->disconnectWorksheets();
}
public function testWriteAndReadRowDimension(): void
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->getDefaultRowDimension()->setRowHeight(20);
$sheet->setCellValue('A1', 'hello there world 1');
$sheet->getStyle('A1')->getAlignment()->setWrapText(true);
$sheet->getRowDimension(1)->setCustomFormat(true);
$sheet->setCellValue('A2', 'hello there world 2');
$sheet->setCellValue('A4', 'hello there world 4');
$reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xlsx');
$spreadsheet->disconnectWorksheets();
$rsheet = $reloadedSpreadsheet->getActiveSheet();
$rwriter = new XlsxWriter($reloadedSpreadsheet);
$rwriterWorksheet = new XlsxWriter\Worksheet($rwriter);
$data = $rwriterWorksheet->writeWorksheet($rsheet, []);
self::assertStringContainsString(
'',
$data
);
self::assertStringContainsString(
'',
$data
);
self::assertStringContainsString(
'',
$data
);
self::assertStringContainsString(
'',
$data
);
$reloadedSpreadsheet->disconnectWorksheets();
}
public function testBadOutlineLevel(): void
{
$this->expectException(PhpSpreadsheetException::class);
$this->expectExceptionMessage('Outline level must range between 0 and 7.');
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->getRowDimension(1)->setOutlineLevel(8);
}
}