PHPExcel导出订单数据实例，含图片导出对齐方式背景颜色

最新推荐文章于 2022-11-11 11:28:20 发布

陪代码一起浪迹天涯

最新推荐文章于 2022-11-11 11:28:20 发布

阅读量1.5k

点赞数

分类专栏：程序成长之路文章标签： PHPExcel导出 PHPExcel导出实例

本文链接：https://blog.csdn.net/seoyundu/article/details/80427974

版权

PHPExcel导出订单数据实例，含图片导出对齐方式背景颜色

<?php
//防止直接运行
$_s = $_SERVER['PHP_SELF'];
$_s = strtolower(substr($_s,strripos($_s,"/")+1,-4));
if($_s=="output"){die();}
 
set_time_limit(0);
$totalcount = count($data);
//创建、设置Excel
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()
    ->setCreator("guohua.info")
    ->setLastModifiedBy("guohua.info")
    ->setTitle("PHPExcel Test Document")
    ->setSubject("PHPExcel Test Document")
    ->setDescription("Test document for PHPExcel, generated using PHP classes.")
    ->setKeywords("office PHPExcel php")
    ->setCategory("Test result file");
//设置活跃表
$objPHPExcel->setActiveSheetIndex(0);
//设置宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
$objPHPE