首页 / PHP / PHP操作Excel–PHPExcel基本用法详解

PHP操作Excel–PHPExcel基本用法详解

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了PHP操作Excel–PHPExcel基本用法详解，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含12866字，纯文字阅读大概需要19分钟。

内容图文

PHP操作Excel – PHPExcel 基本用法详解

1.header

header("Content-Type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=sample.xls");
header("Pragma:no-cache");
header("Expires:0");

2.PHPExcel

http://www.codeplex.com/PHPExcel
http://www.phpexcel.net
开发包Tests目录有详细使用实例支持中文,注意文件编码文件保存为utf-8

写excel

//Include class
require_once('Classes/PHPExcel.php');
require_once('Classes/PHPExcel/Writer/Excel2007.php');
$objPHPExcel = new PHPExcel();

//Set properties 设置文件属性
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");
$objPHPExcel->getProperties()->setKeywords("office 2007 openxml php");
$objPHPExcel->getProperties()->setCategory("Test result file");

//Add some data 添加数据
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Hello');//可以指定位置
$objPHPExcel->getActiveSheet()->setCellValue('A2', true);
$objPHPExcel->getActiveSheet()->setCellValue('A3', false);
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'world!');
$objPHPExcel->getActiveSheet()->setCellValue('B3', 2);
$objPHPExcel->getActiveSheet()->setCellValue('C1', 'Hello');
$objPHPExcel->getActiveSheet()->setCellValue('D2', 'world!');

//循环
for($i = 1;$i<200;$i++) {
$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
}

//日期格式化
$objPHPExcel->getActiveSheet()->setCellValue('D1', time());
$objPHPExcel->getActiveSheet()->getStyle('D1')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH);

//Add comment 添加注释
$objPHPExcel->getActiveSheet()->getComment('E11')->setAuthor('PHPExcel');
$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun('PHPExcel:');
$objCommentRichText->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun("\r\n");
$objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun('Total amount on the current invoice, excluding VAT.');

//Add rich-text string 添加文字 可设置样式
$objRichText = new PHPExcel_RichText( $objPHPExcel->getActiveSheet()->getCell('A18') );
$objRichText->createText('This invoice is ');
$objPayable = $objRichText->createTextRun('payable within thirty days after the end of the month');
$objPayable->getFont()->setBold(true);
$objPayable->getFont()->setItalic(true);
$objPayable->getFont()->setColor( new PHPExcel_Style_Color( PHPExcel_Style_Color::COLOR_DARKGREEN ) );
$objRichText->createText(', unless specified otherwise on the invoice.');

//Merge cells 合并分离单元格
$objPHPExcel->getActiveSheet()->mergeCells('A18:E22');
$objPHPExcel->getActiveSheet()->unmergeCells('A18:E22');

//Protect cells 保护单元格
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);//Needs to be set to true in order to enable any worksheet protection!
$objPHPExcel->getActiveSheet()->protectCells('A3:E13', 'PHPExcel');

//Set cell number formats 数字格式化
$objPHPExcel->getActiveSheet()->getStyle('E4')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE);
$objPHPExcel->getActiveSheet()->duplicateStyle( $objPHPExcel->getActiveSheet()->getStyle('E4'), 'E5:E13' );

//Set column widths 设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12);

//Set fonts 设置字体
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Candara');
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(20);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);

//Set alignments 设置对齐
$objPHPExcel->getActiveSheet()->getStyle('D11')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY);
$objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A3')->getAlignment()->setWrapText(true);

//Set column borders 设置列边框
$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A10')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('E10')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
$objPHPExcel->getActiveSheet()->getStyle('E13')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);

//Set border colors 设置边框颜色
$objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getLeft()->getColor()->setARGB('FF993300');
$objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getTop()->getColor()->setARGB('FF993300');
$objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getBottom()->getColor()->setARGB('FF993300');
$objPHPExcel->getActiveSheet()->getStyle('E13')->getBorders()->getRight()->getColor()->setARGB('FF993300');

//Set fills 设置填充
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->getStartColor()->setARGB('FF808080');

//Add a hyperlink to the sheet 添加链接
$objPHPExcel->getActiveSheet()->setCellValue('E26', 'www.phpexcel.net');
$objPHPExcel->getActiveSheet()->getCell('E26')->getHyperlink()->setUrl('http://www.phpexcel.net');
$objPHPExcel->getActiveSheet()->getCell('E26')->getHyperlink()->setTooltip('Navigate to website');
$objPHPExcel->getActiveSheet()->getStyle('E26')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);

//Add a drawing to the worksheet 添加图片
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('Logo');
$objDrawing->setDescription('Logo');
$objDrawing->setPath('./images/officelogo.jpg');
$objDrawing->setHeight(36);
$objDrawing->setCoordinates('B15');
$objDrawing->setOffsetX(110);
$objDrawing->setRotation(25);
$objDrawing->getShadow()->setVisible(true);
$objDrawing->getShadow()->setDirection(45);
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

//Play around with inserting and removing rows and columns
$objPHPExcel->getActiveSheet()->insertNewRowBefore(6, 10);
$objPHPExcel->getActiveSheet()->removeRow(6, 10);
$objPHPExcel->getActiveSheet()->insertNewColumnBefore('E', 5);
$objPHPExcel->getActiveSheet()->removeColumn('E', 5);

//Add conditional formatting
$objConditional1 = new PHPExcel_Style_Conditional();
$objConditional1->setConditionType(PHPExcel_Style_Conditional::CONDITION_CELLIS);
$objConditional1->setOperatorType(PHPExcel_Style_Conditional::OPERATOR_LESSTHAN);
$objConditional1->setCondition('0');
$objConditional1->getStyle()->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);
$objConditional1->getStyle()->getFont()->setBold(true);

//Set autofilter 自动过滤
$objPHPExcel->getActiveSheet()->setAutoFilter('A1:C9');

//Hide "Phone" and "fax" column 隐藏列
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setVisible(false);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setVisible(false);

//Set document security 设置文档安全
$objPHPExcel->getSecurity()->setLockWindows(true);
$objPHPExcel->getSecurity()->setLockStructure(true);
$objPHPExcel->getSecurity()->setWorkbookPassword("PHPExcel");

//Set sheet security 设置工作表安全
$objPHPExcel->getActiveSheet()->getProtection()->setPassword('PHPExcel');
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);// This should be enabled in order to enable any of the following!
$objPHPExcel->getActiveSheet()->getProtection()->setSort(true);
$objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true);
$objPHPExcel->getActiveSheet()->getProtection()->setFormatCells(true);

//Calculated data 计算
echo 'Value of B14 [=COUNT(B2:B12)]: ' . $objPHPExcel->getActiveSheet()->getCell('B14')->getCalculatedValue() . "\r\n";

//Set outline levels
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setVisible(false);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setCollapsed(true);

//Freeze panes
$objPHPExcel->getActiveSheet()->freezePane('A2');

//Rows to repeat at top
$objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1, 1);

//Set data validation 验证输入值
$objValidation = $objPHPExcel->getActiveSheet()->getCell('B3')->getDataValidation();
$objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_WHOLE );
$objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_STOP );
$objValidation->setAllowBlank(true);
$objValidation->setShowInputMessage(true);
$objValidation->setShowErrorMessage(true);
$objValidation->setErrorTitle('Input error');
$objValidation->setError('Number is not allowed!');
$objValidation->setPromptTitle('Allowed input');
$objValidation->setPrompt('Only numbers between 10 and 20 are allowed.');
$objValidation->setFormula1(10);
$objValidation->setFormula2(20);
$objPHPExcel->getActiveSheet()->getCell('B3')->setDataValidation($objValidation);

//Create a new worksheet, after the default sheet 创建新的工作标签
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex(1);

//Set header and footer. When no different headers for odd/even are used, odd header is assumed. 页眉页脚
$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&C&HPlease treat this document as confidential!');
$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');

//Set page orientation and size 方向大小
$objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);

//Rename sheet 重命名工作表标签
$objPHPExcel->getActiveSheet()->setTitle('Simple');

//Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);

//Save Excel 2007 file 保存
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
 
//Save Excel 5 file 保存
require_once('Classes/PHPExcel/Writer/Excel5.php');
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
$objWriter->save(str_replace('.php', '.xls', __FILE__));

//1.6.2新版保存
require_once('Classes/PHPExcel/IOFactory.php');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save(str_replace('.php', '.xls', __FILE__));

读excel

//Include class
require_once('Classes/PHPExcel/Reader/Excel2007.php');
$objReader = new PHPExcel_Reader_Excel2007;
$objPHPExcel = $objReader->load("05featuredemo.xlsx");

读写csv

require_once("05featuredemo.inc.php");
require_once('Classes/PHPExcel/Writer/CSV.php');
require_once('Classes/PHPExcel/Reader/CSV.php');
require_once('Classes/PHPExcel/Writer/Excel2007.php');
//Write to CSV format 写
$objWriter = new PHPExcel_Writer_CSV($objPHPExcel);
$objWriter->setDelimiter(';');
$objWriter->setEnclosure('');
$objWriter->setLineEnding("\r\n");
$objWriter->setSheetIndex(0);
$objWriter->save(str_replace('.php', '.csv', __FILE__));
//Read from CSV format 读
$objReader = new PHPExcel_Reader_CSV();
$objReader->setDelimiter(';');
$objReader->setEnclosure('');
$objReader->setLineEnding("\r\n");
$objReader->setSheetIndex(0);
$objPHPExcelFromCSV = $objReader->load(str_replace('.php', '.csv', __FILE__));
//Write to Excel2007 format
$objWriter2007 = new PHPExcel_Writer_Excel2007($objPHPExcelFromCSV);
$objWriter2007->save(str_replace('.php', '.xlsx', __FILE__));

写html

require_once("05featuredemo.inc.php");
require_once('Classes/PHPExcel/Writer/HTML.php');
//Write to HTML format
$objWriter = new PHPExcel_Writer_HTML($objPHPExcel);
$objWriter->setSheetIndex(0);
$objWriter->save(str_replace('.php', '.htm', __FILE__));

写pdf

require_once("05featuredemo.inc.php");
require_once('Classes/PHPExcel/IOFactory.php');
//Write to PDF format
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');
$objWriter->setSheetIndex(0);
$objWriter->save(str_replace('.php', '.pdf', __FILE__));
//Echo memory peak usage
echo date('H:i:s') . " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB\r\n";

内容总结

以上是互联网集市为您收集整理的PHP操作Excel–PHPExcel基本用法详解全部内容，希望文章能够帮你解决PHP操作Excel–PHPExcel基本用法详解所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/206560.html

来源：【匿名】

【上一篇】PHP实现多说评论实时同步回网站数据库【下一篇】PHP 5 数据对象 (PDO) 抽象层与 Oracle

更多 ►

【PHP操作Excel–PHPExcel基本用法详解】教程文章相关的互联网学习教程文章

用PHP读取Excel、CSV文件【代码】

PHP读取excel、csv文件的库有很多，但用的比较多的有： PHPOffice/PHPExcel、PHPOffice/PhpSpreadsheet，现在PHPExcel已经不再维护了，最新的一次提交还是在2017年12月25号，建议直接使用PhpSpreadsheet，而且这两个项目都是同一个组织维护的，本文介绍PhpSpreadsheet的使用。介绍PhpSpreadsheetPhpSpreadsheet这个库是纯PHP写的，提供了非常丰富的类和方法，而且支持很多文件格式：环境要求PHP >= 5.6开启php_zip扩展开启php_xml扩...

PHP将Excel导入数据库以及数据库数据导出至Excel【代码】

一.导入导入需要使用能读取Excel的组件，网上也有比较好的组件，这里分享我使用的：下载提取码：vxyn。(注意两个文件有引用关系)<?php //传入要导入的Excel的文件名function import_to_DB($filename) {require_once‘reader.php‘;$data = new Spreadsheet_Excel_Reader(); //创建读取Excel的对象$data->setOutputEncoding(‘utf-8‘); //设置读取Excel内容后输出的字符编码$data->read("data/Excel/{$filename}.xls");$d...

PHP操作Excel – PHPExcel 基本用法详解-来源diandian_520【代码】

以下文章来源：diandian_520http://blog.csdn.net/diandian_520/article/details/78270381.headerheader("Content-Type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename=sample.xls"); header("Pragma:no-cache"); header("Expires:0"); 2.PHPExcel开发包Tests目录有详细使用实例支持中文,注意文件编码文件保存为utf-8 写excel//Include class require_once(‘Classes/PHPExcel.php‘);...

excel 列数大于Z时如何使用PHP程序读取【代码】

最近深圳网站建设搜客来在处理一个项目，需要读取EXCEL数据并导入数据库中。因为EXCEL表格数据列数超过了Z，使用传统方式无能读取。今天特地和大家分享最后的解决方案，代码如下：本方法使用的是PHPExcel插件，请自行下载。public static function import_excel($file){ // 判断文件是什么格式$type = pathinfo($file);$type = strtolower($type["extension"]);$type=$type===‘csv‘ ? $type : ‘Excel5‘;ini_set(‘max_exec...

php excel类 phpExcel使用方法介绍

下载地址：http://www.codeplex.com/PHPExcel　　下面是总结的几个使用方法　　include ‘PHPExcel.php‘; 　　include ‘PHPExcel/Writer/Excel2007.php‘; 　　//或者include ‘PHPExcel/Writer/Excel5.php‘; 用于输出.xls的　　创建一个excel 　　$objPHPExcel = new PHPExcel(); 　　保存excel—2007格式　　$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); 　　//或者$objWriter = new PHPExcel_Writer_Excel...

PHP导出EXCEL【代码】

用phpexcel类导出excel，由于之前直接通过header导出下载excel，本地打开之后一直是乱码，但是如果直接保存在服务器上打开不是乱码，没办法最后只有先保存到服务器上，然后下载完再删除。附上代码 1 <?php2require_once ‘PHPExcel.php‘;3require_once ‘PHPExcel/Writer/Excel5.php‘; // 用于其他低版本xls 4require_once ‘PHPExcel/Writer/Excel2007.php‘; //用于 excel-2007 格式 5header("Content-type: text/html;...

php 导出excel CVS格式

php excel导出 CVS格式乐杨俊 <?php $param=array(); //模拟导出数据 $param [1] = array ( ‘po‘ => ‘651651616‘, ‘pick_mode‘ => ‘1‘, ‘auto_add_goods‘ => ‘0‘, ‘type‘ => ‘jit‘, ‘schedule_time‘ => ‘20013-00-00‘, ‘num‘ => ‘25045‘, ‘sale_num‘ => ‘2054‘, ‘unpick_num‘ => ‘6234‘, ...

PHP 导出Excel表格【代码】

在实际开发中，有很多场景是需要导出Excel表格的，比如后台的统计数据，客户希望能导出为表格的形式，今天介绍一下TP5框架内实现Excel表格的导出功能，首先下载phpexcel.zip,解压后放到vendor第三方类库目录下，直接用函数vendor()引入就可以啦，直接贴代码： public function pushExcelAll(Request $request){vendor(‘phpexcel.PHPExcel‘); //引入核心库文件 vendor(‘phpexcel.PHPExcel.Writer.Excel2007‘); //引入excel2...

PHP操作Excel – PHPExcel 基本用法详解【代码】

1.headerheader("Content-Type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename=product.xls"); header("Pragma:no-cache"); header("Expires:0");2.PHPExcel写excel//Include class require_once(‘Classes/PHPExcel.php‘); require_once(‘Classes/PHPExcel/Writer/Excel2007.php‘); $objPHPExcel = new PHPExcel(); //Set properties 设置文件属性 $objPHPExcel->getProperties()->setC...

Atitit.导出excel报表的设计与实现java .net php 总结

Atitit.导出excel报表的设计与实现java .net php 总结 1. 导出报表表格的设计要素1转换1' ref='nofollow'>1.1. 支持通用list转换11.2. 对于空列是否输出11.3. 支持http web直接输出12. Api2 list,OutputStream outStrm)2' ref='nofollow'>2.1. private static void toExcel(String titles, String filds,List list,OutputStream outStrm)2 li,HttpServletResponse response )2' ref='nofollow'>2.2. Response版 toExcel(String t...

php 备份数据库代码(生成word,excel,json,xml,sql)

单表备份代码：复制代码代码如下:<?php class Db { var $conn; function Db($host="localhost",$user="root",$pass="root",$db="test") { if(!$this->conn=mysql_connect($host,$user,$pass)) die("can‘t connect to mysql sever"); mysql_select_db($db,$this->conn); mysql_query("SET NAMES ‘UTF-8‘"); } function execute($sql) { ...

php中使用PHPExcel读写excel(xls)文件的方法【代码】

本文实例讲述了PHP中使用PHPExcel读写excel(xls)文件的方法，非常实用。分享给大家供大家参考之用。具体方法如下：很多PHP类库在读取中文的xls、csv文件时会有问题，网上找了下资料，发现PHPExcel类库好用，官网地址为：http://phpexcel.codeplex.com/。现将PHPExcel读写Excel的方法分别叙述如下：1、读取xls文件内容 <?php//向xls文件写入内容error_reporting(E_ALL);ini_set(‘display_errors‘, TRUE); include ‘Classes/PHPE...

借助csv用PHP生成excel文件

当你将xml文件改为csv后缀会发现原先的表格结构都变成用逗号隔开的一行一行数据，就像这样编号，姓名，年龄001，王宇，28002，刘三，20由此看来，如果能将PHP数据输出为这样的格式，然后再改后缀为xml就可以得到xml文件的数据了。代码很简单：将所有数据放入二维数组，遍历时，将每一组元素用逗号分隔，然后在文件中换行写入即可。注意，在windows下换行为："\r\n",mac环境下为"\r",linux环境下为"\n"。原文：http://www.cnblogs....

PHP简单导出Excel表格

<?php header(‘Content-Type: application/vnd.ms-excel‘); header(‘Content-Disposition: attachment; filename=demo.xls‘); header(‘Pragma: no-cache‘); header(‘Expires: 0‘); $title = array(‘编号‘, ‘姓名‘, ‘性别‘, ‘年龄‘, ‘身高‘, ‘体重‘); $data = array( array(1, ‘张三‘, ‘男‘, ‘22‘, 183, 72), array(2, ‘李四‘, ‘女‘, ‘18‘, 170, 50), array(3, ‘王五‘, ‘男‘, ‘14‘, 178, ...

PHP导出excel文件，第二步先实现自写二维数组加入模板excel文件后导出

今天主要研究数据加入EXCEL并导出的问题，先不从数据库提取数据导出，自己先写一个二维数组，然后遍历二维数组写入excel模板中导出，首先根据模板excel的内容书写对应的二维数组$arr=array(array("111-3004394-8497032","UMN207-05MM","UMN207-05MM","2","Eric S Herbert / Entergy","600 Rockyhill Rd","PNPS"," ","plymouth","ma","02360","US","508 830-8823","","","","","","","1",""), array("112-3297805-3545827","UMN207-...

PHP - 技术教程分类

PHP 教程 PHP 简介 PHP 安装 PHP 语法 PHP 变量 PHP echo/print PHP EOF(heredoc) PHP 数据类型 PHP 类型比较 PHP 常量 PHP 字符串 PHP 运算符 PHP If...Else PHP Switch PHP 数组 PHP 数组排序 PHP 超级全局变量 PHP While 循环 PHP For 循环 PHP 函数 PHP 魔术常量 PHP 命名空间 PHP 面向对象 PHP 测验 PHP 表单 PHP 表单验证 PHP 表单 - 必需字段 PHP 完整表单实例 PHP $_GET 变量 PHP $_POST 变量 PHP 多维数组 PHP 日期 PHP 包含 PHP 文件 PHP 文件上传 PHP Cookie PHP Session PHP E-mail PHP Error PHP Exception PHP 过滤器 PHP 7 新特性 PHP MySQL 简介 PHP MySQL 连接 PHP MySQL 创建数据库 PHP MySQL 创建数据表 PHP MySQL 插入数据 PHP MySQL 插入多条数据 PHP MySQL 预处理语句 PHP MySQL 读取数据 PHP MySQL Where PHP MySQL Order By PHP MySQL Update PHP MySQL Delete PHP ODBC AJAX 简介 AJAX PHP AJAX 数据库 AJAX 实时搜索 AJAX 投票 PHP Array PHP Calendar PHP cURL PHP Date PHP Directory PHP Error PHP Filesystem PHP Filter PHP FTP PHP HTTP PHP Mail PHP Math PHP Misc PHP MySQLi PHP PDO PHP String PHP Zip PHP Timezones PHP 图像处理 PHP RESTful PHP PCRE PHP 可用的函数 PHP Composer php 全部

PHP - 最热教程

php如何取出数组的前几个元素 PHP变量什么时候释放 PHP如何实现在数据库随机获取几条记录如何解决php base64解码乱码 php主要用于哪些领域 Laravel 批量插入(insert)数据六款国内优秀免费wordpress主题推荐 React如何从后端获取数据并渲染到前端？纯PHP实现定时器任务（Timer），php实现...php该如何安装pdo_mysql扩展

首页 / PHP / PHP操作Excel–PHPExcel基本用法详解

PHP操作Excel–PHPExcel基本用法详解

内容导读

内容图文

PHP操作Excel – PHPExcel 基本用法详解

1.header

2.PHPExcel

写excel

读excel

读写csv

写html

写pdf

内容总结

内容备注

内容手机端

【PHP操作Excel–PHPExcel基本用法详解】教程文章相关的互联网学习教程文章

PHP - 技术教程分类

PHP - 最新教程

PHP - 最热教程