ÿØÿà JFIF ÿÛ „ ( %"1"%)+...383,7(-.-
![]() Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/luckymerchan/vendor/phpoffice/phpspreadsheet/samples/Basic/ |
<?php use PhpOffice\PhpSpreadsheet\Spreadsheet; require __DIR__ . '/../Header.php'; $spreadsheet = new Spreadsheet(); $helper->log('Create new Spreadsheet object'); $spreadsheet = new Spreadsheet(); // Set document properties $helper->log('Set document properties'); $spreadsheet->getProperties() ->setCreator('Maarten Balliauw') ->setLastModifiedBy('Maarten Balliauw') ->setTitle('PhpSpreadsheet Test Document') ->setSubject('PhpSpreadsheet Test Document') ->setDescription('Test document for PhpSpreadsheet, generated using PHP classes.') ->setKeywords('office PhpSpreadsheet php') ->setCategory('Test result file'); // Add some data $helper->log('Add some data'); $spreadsheet->setActiveSheetIndex(0) ->setCellValue('A1', 'Hello') ->setCellValue('B2', 'world!') ->setCellValue('C1', 'Hello') ->setCellValue('D2', 'world!'); // Miscellaneous glyphs, UTF-8 $spreadsheet->setActiveSheetIndex(0) ->setCellValue('A4', 'Miscellaneous glyphs') ->setCellValue('A5', 'éà èùâêîôûëïüÿäöüç'); $spreadsheet->getActiveSheet() ->setCellValue('A8', "Hello\nWorld"); $spreadsheet->getActiveSheet() ->getRowDimension(8) ->setRowHeight(-1); $spreadsheet->getActiveSheet() ->getStyle('A8') ->getAlignment() ->setWrapText(true); $value = "-ValueA\n-Value B\n-Value C"; $spreadsheet->getActiveSheet() ->setCellValue('A10', $value); $spreadsheet->getActiveSheet() ->getRowDimension(10) ->setRowHeight(-1); $spreadsheet->getActiveSheet() ->getStyle('A10') ->getAlignment() ->setWrapText(true); $spreadsheet->getActiveSheet() ->getStyle('A10') ->setQuotePrefix(true); // Rename worksheet $helper->log('Rename worksheet'); $spreadsheet->getActiveSheet() ->setTitle('Simple'); // Save $helper->write($spreadsheet, __FILE__);