<?php

require_once _DIR_ . "/vendor/autoload.php";

use PhpOffice\PhpSpreadsheet\Spreadsheet;

use PhpOffice\PhpSpreadsheet\IOFactory;

use PhpOffice\PhpSpreadsheet\Style\Alignment; // Import the Alignment class

$spreadsheet = new Spreadsheet();

$sheet = $spreadsheet->getActiveSheet();

$sheet->getColumnDimension('A')->setWidth(12);

$sheet->getColumnDimension('B')->setWidth(12);

$sheet->getColumnDimension('C')->setWidth(12);

// Set value and alignment for numeric cell

$sheet->setCellValue("A1", 1234567);

$sheet->getStyle('A1')->getAlignment()->setHorizontal(Alignment::HORIZONTAL_LEFT); // Force left alignment

// Set value for string cells (default is usually left-aligned)

$sheet->setCellValue("B1", 'ABCDEFG');

$sheet->setCellValue("C1", 'QWERTY');

header('Content-Type: application/pdf');

header('Content-Disposition: attachment;filename="test.pdf"');

header('Cache-Control: max-age=0');

$objwriter = IOFactory::createWriter($spreadsheet, 'Mpdf');

$objwriter->save("php://output");