Export file using PHPExcel

Export steps

1. Create a new excel table

Instantiate the PHPExcel class

2. Create sheet (built-in table)

createSheet()

setActiveSheetIndex()

getActiveSheet()

3. Fill in the data

setCellValue()

4. Save the file

PHPExcel_IOFactory::createWriter()

save()

<?php
$dir = dirname(__FILE__);
//Include class
require_once($dir.&#39;/PHPExcel.php&#39;);


$objPHPExcel = new PHPExcel(); //实例化PHPExcel类
$objPHPExcel->setActiveSheetIndex(0);
$objSheet = $objPHPExcel->getActiveSheet(); //获得当前sheet
$objSheet->setTitle("demo"); //给当前sheet设置名称

$array = array(
	array("姓名","分数"),
	array("李四","60"),
	array("王五","70")
);

$objSheet->setCellValue("A5","姓名");
$objSheet->setCellValue("B5","分数"); //给当前sheet填充数据
$objSheet->setCellValue("A6","张三");
$objSheet->setCellValue("B6","70");

$objSheet->fromArray($array); //直接加载数据块填充数据
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); //按照指定格式生成excel文件

$objWriter->save(str_replace('.php', '.xls', __FILE__));

Copyright statement: This article is an original article by the blogger and may not be reproduced without the blogger's permission.

The above introduces the use of PHPExcel to export files, including aspects of the content. I hope it will be helpful to friends who are interested in PHP tutorials.