Home / Questions / 553109
Accepted
Luis Jair Juarez Sanchez
Asked: 2022-08-23 08:56:17 +0800 CST 2022-08-23 08:56:17 +0800 CST

How do I put borders for Excel cells with PHPSpreadSheet?

  • 772

Hello, I am generating an Excel with PHPSpreadSheet but I cannot get the cell to be generated with vertical borders

$bordes = [
  'borders' => array(
    'outline' => array(
      'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
      'color' => array('argb' => '000000'),
    ),
  ),
];

When I generate it this way the format it applies to the cell is this

enter image description here

When I would like only the verticals to be painted, thanks in advance

html

1 Answers

  1. Best Answer

    I already found the error, I'll leave it here if it helps someone on occasion

    $bordes = [
  'borders' => array(
    'vertical' => array(
      'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
      'color' => array('argb' => '000000'),
    ),
  ),
];

    You had to place vertical as a parameter, everything comes in the documentation of PHPSpreadSheet

    • 0