如何在PHPspreadsheet生成的Excel文件中添加边框

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

$cellRange = 'A1:D10'; // 例如，要添加边框的范围是从A1到D10的单元格

$style = $sheet->getStyle($cellRange);
$borders = $style->getBorders();

$borders->getTop()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
$borders->getTop()->setColor(new \PhpOffice\PhpSpreadsheet\Style\Color('000000'));
$borders->getBottom()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
$borders->getBottom()->setColor(new \PhpOffice\PhpSpreadsheet\Style\Color('000000'));
$borders->getLeft()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
$borders->getLeft()->setColor(new \PhpOffice\PhpSpreadsheet\Style\Color('000000'));
$borders->getRight()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
$borders->getRight()->setColor(new \PhpOffice\PhpSpreadsheet\Style\Color('000000'));

$style->setBorders($borders);

$writer = new Xlsx($spreadsheet);
$writer->save('path/to/save/excel.xlsx');