Home>Article>Backend Development> PHP Export EXCEL Quick Development Guide
php excelhas a proprietary development document. For detailed operations, please refer to thephp exceldevelopment document. This article only optimizes and integrates its use to facilitate new projects. Rapid development. If you are interested, you can also look at thephp exceldevelopment documentation.
There are also two ways for phpexcel to generate files, one is direct output, and the other is to generate static files.
Direct output:
The main file is (the file in the same directory of the class directory):
save("php://output"); } // 如果需要输出PDF格式 if($m_exportType=="pdf"){ $objWriter = PHPExcel_IOFactory::createWriter($m_objPHPExcel, 'PDF'); $objWriter->setSheetIndex(0); 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/pdf"); header("Content-Type:application/octet-stream"); header("Content-Type:application/download"); header("Content-Disposition:attachment;filename=".$m_strOutputPdfFileName); header("Content-Transfer-Encoding:binary"); $objWriter->save("php://output"); } ?>
Template file content (with additional common operations)
getProperties()->setCreator("Sun Star Data Center") ->setLastModifiedBy("Sun Star Data Center") ->setTitle("Microsoft Office Excel Document") ->setSubject("Test Data Report -- From Sunstar Data Center") ->setDescription("LD Test Data Report, Generate by Sunstar Data Center") ->setKeywords("sunstar ld report") ->setCategory("Test result file"); // 创建多个工作薄 $sheet1 = $m_objPHPExcel->createSheet(); $sheet2 = $m_objPHPExcel->createSheet(); // 通过操作索引即可操作对应的工作薄 // 只需设置要操作的工作簿索引为当前活动工作簿,如 // $m_objPHPExcel->setActiveSheetIndex(0); // 设置第一个工作簿为活动工作簿 $m_objPHPExcel->setActiveSheetIndex(0); // 设置活动工作簿名称 // 如果是中文一定要使用iconv函数转换编码 $m_objPHPExcel->getActiveSheet()->setTitle(iconv('gbk', 'utf-8', '测试工作簿')); // 设置默认字体和大小 $m_objPHPExcel->getDefaultStyle()->getFont()->setName(iconv('gbk', 'utf-8', '宋体')); $m_objPHPExcel->getDefaultStyle()->getFont()->setSize(10); // 设置一列的宽度 $m_objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15); // 设置一行的高度 $m_objPHPExcel->getActiveSheet()->getRowDimension('6')->setRowHeight(30); // 合并单元格 $m_objPHPExcel->getActiveSheet()->mergeCells('A1:P1'); // 定义一个样式,加粗,居中 $styleArray1 = array( 'font' => array( 'bold' => true, 'color'=>array( 'argb' => '00000000', ), ), 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER, ), ); // 将样式应用于A1单元格 $m_objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray1); // 设置单元格样式(黑色字体) $m_objPHPExcel->getActiveSheet()->getStyle('H5')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK); // 黑色 // 设置单元格格式(背景) $m_objPHPExcel->getActiveSheet()->getStyle('H5')->getFill()->getStartColor()->setARGB('00ff99cc'); // 将背景设置为浅粉色 // 设置单元格格式(数字格式) $m_objPHPExcel->getActiveSheet()->getStyle('F1')->getNumberFormat()->setFormatCode('0.000'); // 给特定单元格中写入内容 $m_objPHPExcel->getActiveSheet()->setCellValue('A1', 'Hello Baby'); // 设置单元格样式(居中) $m_objPHPExcel->getActiveSheet()->getStyle('H5')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); // 给单元格中放入图片, 将数据图片放在J1单元格内 $objDrawing = new PHPExcel_Worksheet_Drawing(); $objDrawing->setName('Logo'); $objDrawing->setDescription('Logo'); $objDrawing->setPath("../logo.jpg"); // 图片路径,只能是相对路径 $objDrawing->setWidth(400); // 图片宽度 $objDrawing->setHeight(123); // 图片高度 $objDrawing->setCoordinates('J1'); $objDrawing->setWorksheet($m_objPHPExcel->getActiveSheet()); // 设置A5单元格内容并增加超链接 $m_objPHPExcel->getActiveSheet()->setCellValue('A5', iconv('gbk', 'utf-8', '超链接keiyi.com')); $m_objPHPExcel->getActiveSheet()->getCell('A5')->getHyperlink()->setUrl('http://www.keiyi.com/'); ?>
Generate static files on the server side
Compared with direct generation, the main difference between these two methods is the generation format. The template file is completely The same, the following is a modified version based on the above example, pay attention to the difference from the above example.
save($m_strOutputPath.$m_strOutputExcelFileName); } // 如果需要输出PDF格式 if($m_exportType=="pdf"){ $objWriter = new PHPExcel_Writer_PDF($m_objPHPExcel); $objWriter->save($m_strOutputPath.$m_strOutputPdfFileName); } ?>
The above is all the contents of the PHP Export EXCEL Rapid Development Guide. If you are interested, you can search for more on the PHP Chinese website~
##Related recommendations:
Introduction to the method of freezing and locking table headers in PHPExcel
Example of how phpexcel imports excel to process big data code
Use PHPExcel to upload data in batches
Introduction to the use process of PHPExcel
The above is the detailed content of PHP Export EXCEL Quick Development Guide. For more information, please follow other related articles on the PHP Chinese website!