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;
}
php导了excel单元格部分字设置不同颜色
最新推荐文章于 2024-04-27 00:33:57 发布