phpExcel操作表中多个Sheet表

大得369

已于 2023-04-10 08:07:37 修改

阅读量1.7k

点赞数

分类专栏： php 文章标签： ue4 图论

于 2021-11-01 16:01:53 首次发布

本文链接：https://blog.csdn.net/qq_34631220/article/details/121082056

版权

php 专栏收录该内容

76 篇文章 2 订阅

订阅专栏

 //导出
        $objPHPExcel = new \PHPExcel();
        $objPHPExcel->getProperties()->setCreator("ctos")
            ->setLastModifiedBy("ctos")
            ->setTitle("Office 2007 XLSX Test Document")
            ->setSubject("Office 2007 XLSX Test Document")
            ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
            ->setKeywords("office 2007 openxml php")
            ->setCategory("Test result file");
        //设置各列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(18);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(48);
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(18);
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(24);

        //设置列名
        $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', '编号')
            ->setCellValue('B1', '姓名')
            ->setCellValue('C1', '收费对象')
            ->setCellValue('D1', '金额')
            ->setCellValue('E1', '状态')
            ->setCellValue('F1', '生成时间');
        //给底部0名称命名
        $objPHPExcel->setActiveSheetIndex(0)->setTitle("房产");

        //底部多创建一个表
        $objPHPExcel->createSheet();
        //给底部1名称命名
        $objPHPExcel->setActiveSheetIndex(1)->setTitle("车位");

        //底部多创建一个表
        $objPHPExcel->createSheet();
        //给底部2名称命名
        $objPHPExcel->setActiveSheetIndex(2)->setTitle("储藏室");

        //底部多创建一个表
        $objPHPExcel->createSheet();
        //给底部2名称命名
        $objPHPExcel->setActiveSheetIndex(3)->setTitle("商铺");

        //所有单元格居中
        $objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        //设置行高
        $objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(20);

        //冻结(锁定)表头
        $objPHPExcel->getActiveSheet()->freezePane('A2');

        //给数据

        $num = 2;
        $objPHPExcel->setActiveSheetIndex(0)//Excel的第A列，uid是你查出数组的键值，下面以此类推
        ->setCellValue('A'.$num, "1\t")
            ->setCellValue('B'.$num, "2")
            ->setCellValue('C'.$num, "3")
            ->setCellValue('D'.$num, "4")
            ->setCellValue('E'.$num, "5")
            ->setCellValue('F'.$num, "6");

        //导出文件名
        $filename = date('Y-m-d',time()).'导入.xlsx';
        ob_end_clean();
        header('Content-Type: applicationnd.ms-excel');
        header('Content-Disposition: attachment;filename='.$filename);
        header('Cache-Control: max-age=0');
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');  //excel5为xls格式，excel2007为xlsx格式
        $objWriter->save('php://output');

如何安装

tp6使用phpexcel导出_大得369的博客-CSDN博客