PHPExcel 常用功能速查手冊：樣式、合併、圖片、超連結與邊框

PHPExcel 常用功能速查手冊：樣式、合併、圖片、超連結與邊框

本文整理 PHPExcel 開發中最高頻的操作片段，方便快速查閱與複製套用。

初始化與文件屬性

<?php
require_once 'PHPExcel.php';
$objPHPExcel = new PHPExcel();

$objPHPExcel->getProperties()
    ->setCreator('Sam.c')
    ->setLastModifiedBy('Sam.c Test')
    ->setTitle('Microsoft Office Excel Document')
    ->setSubject('Test')
    ->setDescription('Test')
    ->setKeywords('Test')
    ->setCategory('Test result file');

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle('phpexcel測試');

$objPHPExcel->getDefaultStyle()->getFont()->setName('宋體');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(10);
?>

輸出下載（Excel / PDF）

// Excel 2003 (.xls)
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="export.xls"');
$objWriter->save('php://output');

// PDF
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');
header('Content-Type: application/pdf');
header('Content-Disposition: attachment;filename="export.pdf"');
$objWriter->save('php://output');

常用單元格操作

插入圖片

$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('Logo');
$objDrawing->setPath('test.jpg');
$objDrawing->setWidth(400);
$objDrawing->setHeight(123);
$objDrawing->setCoordinates('J1');
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

設定超連結

$objPHPExcel->getActiveSheet()->setCellValue('H8', '燕南天');
$objPHPExcel->getActiveSheet()->getCell('H8')->getHyperlink()->setUrl('https://www.bkjia.com/');

邊框樣式

$style = [
    'borders' => [
        'outline' => [
            'style' => PHPExcel_Style_Border::BORDER_THIN,
            'color' => ['argb' => 'FF000000'],
        ],
    ],
];
$objPHPExcel->getActiveSheet()->getStyle('A4:E10')->applyFromArray($style);

新增工作表

$objPHPExcel->createSheet();
$objActSheet = $objPHPExcel->getSheet(1);
$objActSheet->setTitle('表2');

提醒： PHPExcel 已不再維護，建議新專案改用 PhpSpreadsheet，API 高度相容。