PHP导出excel带图片

1二山似

于 2024-07-16 08:10:25 发布

阅读量129

点赞数 1

分类专栏： PHP # excel 文章标签： php excel

本文链接：https://blog.csdn.net/weixin_42925303/article/details/140440507

版权

PHP 同时被 2 个专栏收录

16 篇文章 0 订阅

订阅专栏

excel

3 篇文章 0 订阅

订阅专栏

<?php
/*设置表头数据*/
$tableheader = array('ID', '头像','姓名', '性别', '年龄', '班级');
/*设置表格数据*/
$data = array(
    array('1', 'imgs/yang.png','小王', '男', '20', 'CS12'),
    array('2', 'imgs/yang.png','小李', '女', '21', 'CS12'),
    array('3', 'imgs/yang.png','小周', '男', '22', 'CS12'),
    array('4', 'imgs/yang.png','小赵', '女', '23', 'CS12')
);
$excel_name='测试导出';
phpexcel_img($excel_name,$tableheader,$data,2);
function phpexcel_img($excel_name,$tableheader,$data,$img_num){
    /*引入phpexcel核心类文件*/
    include './Classes/PHPExcel.php';
    /*实例化excel类*/
    $excel = new PHPExcel();
    /*实例化excel图片处理类*/
    $objDrawing = new PHPExcel_Worksheet_Drawing();
    /*设置文本对齐方式*/
    $excel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $excel->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objActSheet = $excel->getActiveSheet();
    $letter = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z' );
    /*填充表格表头*/
    for($i = 0;$i < count($tableheader);$i++) {
        $excel->getActiveSheet()->setCellValue("$letter[$i]1","$tableheader[$i]");
    }
    /*填充表格内容*/
    for ($i = 0;$i < count($data);$i++) {
        $j = $i + 2;
        /*设置表格宽度*/
        $objActSheet->getColumnDimension("$letter[$i]")->setWidth(20);
        /*设置表格高度*/
        $excel->getActiveSheet()->getRowDimension($j)->setRowHeight(100);
        /*向每行单元格插入数据*/
        for ($row = 0;$row < count($data[$i]);$row++) {
            if ($row == ($img_num-1)) {
                /*实例化插入图片类*/
                $objDrawing = new PHPExcel_Worksheet_Drawing();
                /*设置图片路径 切记：只能是本地图片*/
                $objDrawing->setPath($data[$i][$row]);
                /*设置图片高度*/
                $objDrawing->setHeight(100);
                /*设置图片要插入的单元格*/
                $objDrawing->setCoordinates("$letter[$row]$j");
                /*设置图片所在单元格的格式*/
                $objDrawing->setOffsetX(80);
                $objDrawing->setRotation(20);
                $objDrawing->getShadow()->setVisible(true);
                $objDrawing->getShadow()->setDirection(50);
                $objDrawing->setWorksheet($excel->getActiveSheet());
                continue;
            }
            $excel->getActiveSheet()->setCellValue("$letter[$row]$j",$data[$i][$row]);
        }
    }
    /*实例化excel输入类并完成输出excel文件*/
    $write = new PHPExcel_Writer_Excel5($excel);
    header("Pragma: public");
    header("Expires: 0");
    header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
    header("Content-Type:application/force-download");
    header("Content-Type:application/vnd.ms-execl");
    header("Content-Type:application/octet-stream");
    header("Content-Type:application/download");
    header('Content-Disposition:attachment;filename="'.$excel_name.'.xls"');
    header("Content-Transfer-Encoding:binary");
    $write->save('php://output');
}