getActiveSheet();
$sheet->setCellValue('B1', 'First Page');
$sheet->setCellValue('B2', 'Second Page');
$sheet->getPageSetup()->setPrintArea('B1:B2');
$sheet->setBreak('B1', Worksheet::BREAK_ROW);
$sheet->getColumnDimension('B')->setAutoSize(true);
$writer = new Xlsx($spreadsheet);
$writerWorksheet = new Xlsx\Worksheet($writer);
$data = $writerWorksheet->writeWorksheet($sheet, []);
self::assertStringContainsString('', $data);
$spreadsheet->disconnectWorksheets();
}
public function testRowsNoPrintArea(): void
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('B1', 'First Page');
$sheet->setCellValue('B2', 'Second Page');
$sheet->setBreak('B1', Worksheet::BREAK_ROW);
$sheet->getColumnDimension('B')->setAutoSize(true);
$writer = new Xlsx($spreadsheet);
$writerWorksheet = new Xlsx\Worksheet($writer);
$data = $writerWorksheet->writeWorksheet($sheet, []);
self::assertStringContainsString('', $data);
$spreadsheet->disconnectWorksheets();
}
public function testCols(): void
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('B1', 'First Page');
$sheet->setCellValue('C1', 'Second Page');
$sheet->getPageSetup()->setPrintArea('B1:C1');
$sheet->setBreak('C1', Worksheet::BREAK_COLUMN);
$sheet->getColumnDimension('B')->setAutoSize(true);
$sheet->getColumnDimension('C')->setAutoSize(true);
$writer = new Xlsx($spreadsheet);
$writerWorksheet = new Xlsx\Worksheet($writer);
$data = $writerWorksheet->writeWorksheet($sheet, []);
self::assertStringContainsString('', $data);
$spreadsheet->disconnectWorksheets();
}
public function testColsNoPrintArea(): void
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('B1', 'First Page');
$sheet->setCellValue('C1', 'Second Page');
$sheet->setBreak('C1', Worksheet::BREAK_COLUMN);
$sheet->getColumnDimension('B')->setAutoSize(true);
$sheet->getColumnDimension('C')->setAutoSize(true);
$writer = new Xlsx($spreadsheet);
$writerWorksheet = new Xlsx\Worksheet($writer);
$data = $writerWorksheet->writeWorksheet($sheet, []);
self::assertStringContainsString('', $data);
$spreadsheet->disconnectWorksheets();
}
}