php导了excel单元格部分字设置不同颜色

    public function exportDataTest(Request $request){        $filename = time();        $spreadsheet = new \PHPExcel();        $spreadsheet->getActiveSheet()->getCell("A1")->setValue('dadada');        $richText = new \PHPExcel_RichText();        $styleObj = $richText->createTextRun('红红红');        $styleObj->getFont()->setColor(new \PHPExcel_Style_Color("FFCC0000")); //设置颜色        $styleObj = $richText->createTextRun('dadada');        $styleObj->getFont()->setColor(new \PHPExcel_Style_Color("FF000000")); //设置颜色        $styleObj = $richText->createTextRun('蓝蓝蓝');        $styleObj->getFont()->setColor(new \PHPExcel_Style_Color("FF0000FF")); //设置颜色        $styleObj = $richText->createTextRun('dadada');        $styleObj->getFont()->setColor(new \PHPExcel_Style_Color("FF000000")); //设置颜色        $styleObj = $richText->createTextRun('绿绿绿');        $styleObj->getFont()->setColor(new \PHPExcel_Style_Color("FF12D712")); //设置颜色        $styleObj = $richText->createTextRun('时光隧道');        $styleObj->getFont()->setColor(new \PHPExcel_Style_Color("FFFF00FF")); //设置颜色        $spreadsheet->getActiveSheet()->getCell("B1")->setValue($richText);        // 导出excel        ob_end_clean();        header('Content-Type: application/vnd.ms-excel');        header('Content-Disposition: attachment;filename="' . $filename . '.xls');        header('Cache-Control: max-age=0');        header('Content-Type: text/html; charset=utf-8');        //$objWriter = \PHPExcel_IOFactory::createWriter($spreadsheet, 'Excel5');        $objWriter = \PHPExcel_IOFactory::createWriter($spreadsheet, "Excel2007");       // $objWriter = IOFactory::createWriter($spreadsheet, 'Xls');        $objWriter->save('php://output');        exit;    }

来源地址：https://blog.csdn.net/xcbzsy/article/details/132434381