composer require phpoffice/phpspreadsheet
<?php
//Before
require_once 'PHPExcel.php';
//After
require_once 'vendor/autoload.php';
<?php
//After
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
<?php
//Before
$phpexcel = new PHPExcel();
$sheet1 = $phpexcel->getActiveSheet()->setTitle("基本資料");
$phpexcel->setActiveSheetIndex(0);
$objWriter->save("php://output");
//After
$spreadsheet = new Spreadsheet();
$sheet1 = $spreadsheet->getActiveSheet()->setTitle("基本資料");
$spreadsheet->setActiveSheetIndex(0);
$objWriter->save("php://output");
<?php
//Before
header('Content-Type:application/vnd.ms-excel');
header('Content-Disposition:attachment;filename=人員基本資料.xlsx');
header('Cache-Control:max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($phpexcel,'Xlsx');
//After
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename=人員基本資料.xlsx');
header('Cache-Control: max-age=0');
$objWriter = IOFactory::createWriter($spreadsheet, 'Xlsx');
<?php
//After
header('Content-Type: application/vnd.oasis.opendocument.spreadsheet');
header('Content-Disposition:attachment;filename=人員基本資料.ods');
header('Cache-Control:max-age=0');
$objWriter = IOFactory::createWriter($spreadsheet,'Ods');
[toc]
Jun 27, 2025建立要被掛載的資料夾
May 14, 2025假設有一張資料表(pay_table)如下:pay_datetic_nomoneycnt2019-05-15T300104$46,440112019-05-15I300132$57312019-05-15I300129/T400265$107,196392019-05-17I300128$10,9292 若要依pay_date欄位做分組序號,可以用ROW_NUMBER() OVER(PARTITION BY 群組依據欄位 ORDER BY 排序依據欄位 DESC)來實現SELECT (ROW_NUMBER() OVER(PARTITION BY pay_date ORDER BY tic_no DESC)) group_sn, pay_date, tic_no, money, cnt FROM pay_table 成果如下:group_snpay_datetic_nomoneycnt12019-05-15T300104$46,4401122019-05-15I300132$573132019-05-15I300129/T400265$107,1963912019-05-17I300128$10,9292 應用情境:資料分組後取前三筆資料 [參照]假設有以下資料表(表名為temp_table)商品品牌業績鞋NIKE1234000鞋愛迪達132200鞋雜牌223400鞋PUMA43532手機HTC32423手機IPHONE423手機三星23413手機NOKIA14344 解法select 商品,品牌,業績,排名 from ( select T100.* ,row_number() over (partition by 商品 order by 業績 desc ) 排名 from temp_table T100
Apr 25, 2025一開始掃描會先下載弱點資料庫
Apr 9, 2025or
By clicking below, you agree to our terms of service.
New to HackMD? Sign up