PhpSpreadsheet 使用

HTML

PhpOffice\PhpSpreadsheet\Helper\Html

$html = new Html();
$setValue = $html->toRichTextObject($setValue);

日期

PhpOffice\PhpSpreadsheet\Shared\Date

Date::excelToTimestamp($value['date'])

单元格背景

PhpOffice\PhpSpreadsheet\Style\Color
PhpOffice\PhpSpreadsheet\Style\Fill

$spreadsheet->getActiveSheet()->getStyle('2')
            ->getFill()
            ->setFillType(Fill::FILL_SOLID)
            ->getStartColor()
            ->setARGB(Color::COLOR_YELLOW);