public function exportDataTest(Request $request){ $filename = time(); $spreadshee
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; }
--结束END--
本文标题: php导了excel单元格部分字设置不同颜色
本文链接: https://www.lsjlt.com/news/385574.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0