php xlswriter怎樣設置邊框

在PHP中使用PHPExcel（現在已經被更名為PhpSpreadsheet）庫來操作Excel文件時，你可以使用以下方法為單元格或整個工作表設置邊框：

首先，確保已經安裝了PhpSpreadsheet庫。如果沒有安裝，可以使用Composer進行安裝：

composer require phpoffice/phpspreadsheet

接下來，創建一個簡單的PHP腳本來設置邊框：

<?php
// 引入PhpSpreadsheet庫
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Cell\DataType;

// 創建一個新的電子表格對象
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

// 設置單元格邊框
$styleArray = [
    'borders' => [
        'allborders' => [
            'style' => Border::BORDER_THIN,
            'color' => ['argb' => 'FF000000'],
        ],
    ],
];

// 應用樣式到單元格
$sheet->setCellValue('A1', 'Hello World !');
$sheet->getStyle('A1')->applyFromArray($styleArray);

// 設置整個工作表的邊框
$sheet->getSheetView()->setZoomScale(80);
$sheet->getSheetView()->setZoom(1);
$sheet->getSheetView()->setGridLines(true);
$sheet->getSheetView()->setShowZeros(false);

// 設置工作表標題邊框
$styleArrayTitle = [
    'borders' => [
        'top' => [
            'style' => Border::BORDER_THIN,
            'color' => ['argb' => 'FF000000'],
        ],
        'left' => [
            'style' => Border::BORDER_THIN,
            'color' => ['argb' => 'FF000000'],
        ],
        'bottom' => [
            'style' => Border::BORDER_THIN,
            'color' => ['argb' => 'FF000000'],
        ],
        'right' => [
            'style' => Border::BORDER_THIN,
            'color' => ['argb' => 'FF000000'],
        ],
    ],
];

$sheet->getStyle('A1:D1')->applyFromArray($styleArrayTitle);

// 保存Excel文件
$writer = new Xlsx($spreadsheet);
$fileName = 'example.xlsx';
$writer->save($fileName);

echo "Excel file with borders has been created: " . $fileName;
?>

這個腳本將創建一個包含邊框的簡單Excel文件。你可以根據需要修改樣式、顏色和邊框類型。更多關于PhpSpreadsheet庫的信息和示例，請參考官方文檔：https://phpspreadsheet.readthedocs.io/