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()
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.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
