Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if (isset($_POST["all"])) {
- $id = $_POST["all"];
- } else {
- $id = "";
- }
- use PhpOffice\PhpSpreadsheet\Helper\Sample;
- use PhpOffice\PhpSpreadsheet\IOFactory;
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- $helper = new Sample();
- if ($helper->isCli()) {
- $helper->log('This example should only be run from a Web Browser' . PHP_EOL);
- return;
- }
- // Create new Spreadsheet object
- $spreadsheet = new Spreadsheet();
- // Set document properties
- $spreadsheet->getProperties()->setCreator('Maarten Balliauw')
- ->setLastModifiedBy('Maarten Balliauw')
- ->setTitle('Office 2007 XLSX Test Document')
- ->setSubject('Office 2007 XLSX Test Document')
- ->setDescription('Test document for Office 2007 XLSX, generated using PHP classes.')
- ->setKeywords('office 2007 openxml php')
- ->setCategory('Test result file');
- // Add some data
- // ( 略 )
- // Rename worksheet
- $spreadsheet->getActiveSheet()->setTitle('Simple');
- // Set active sheet index to the first sheet, so Excel opens this as the first sheet
- $spreadsheet->setActiveSheetIndex(0);
- // Redirect output to a client’s web browser (Xlsx)
- header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
- header('Content-Disposition: attachment; filename="搜尋匯出-' . $time . '.xlsx"');
- header('Cache-Control: max-age=0');
- $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
- $writer->save('php://output');
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement