当前路径:Classes/PHPExcel.php <?php /** PHPExcel root directory */ if (!defined('PHPEXCEL_ROOT')) { define('PHPEXCEL_ROOT', dirname(__FILE__) . '/'); require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php'); } /** * PHPExcel * * Copyright (c) 2006 - 2015 PHPExcel * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA * * @category PHPExcel * @package PHPExcel * @copyright Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel) * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL * @version ##VERSION##, ##DATE## */ class PHPExcel { /** * Unique ID * * @var string */ private $uniqueID; /** * Document properties * * @var PHPExcel_DocumentProperties */ private $properties; /** * Document security * * @var PHPExcel_DocumentSecurity */ private $security; /** * Collection of Worksheet objects * * @var PHPExcel_Worksheet[] */ private $workSheetCollection = array(); /** * Calculation Engine * * @var PHPExcel_Calculation */ private $calculationEngine; /** * Active sheet index * * @var integer */ private $activeSheetIndex = 0; /** * Named ranges * * @var PHPExcel_NamedRange[] */ private $namedRanges = array(); /** * CellXf supervisor * * @var PHPExcel_Style */ private $cellXfSupervisor; /** * CellXf collection * * @var PHPExcel_Style[] */ private $cellXfCollection = array(); /** * CellStyleXf collection * * @var PHPExcel_Style[] */ private $cellStyleXfCollection = array(); /** * hasMacros : this workbook have macros ? * * @var bool */ private $hasMacros = false; /** * macrosCode : all macros code (the vbaProject.bin file, this include form, code, etc.), null if no macro * * @var binary */ private $macrosCode; /** * macrosCertificate : if macros are signed, contains vbaProjectSignature.bin file, null if not signed * * @var binary */ private $macrosCertificate; /** * ribbonXMLData : null if workbook is'nt Excel 2007 or not contain a customized UI * * @var null|string */ private $ribbonXMLData; /** * ribbonBinObjects : null if workbook is'nt Excel 2007 or not contain embedded objects (picture(s)) for Ribbon Elements * ignored if $ribbonXMLData is null * * @var null|array */ private $ribbonBinObjects; /** * The workbook has macros ? * * @return boolean true if workbook has macros, false if not */ public function hasMacros() { return $this->hasMacros; } /** * Define if a workbook has macros * * @param boolean $hasMacros true|false */ public function setHasMacros($hasMacros = false) { $this->hasMacros = (bool) $hasMacros; } /** * Set the macros code * * @param string $MacrosCode string|null */ public function setMacrosCode($MacrosCode = null) { $this->macrosCode=$MacrosCode; $this->setHasMacros(!is_null($MacrosCode)); } /** * Return the macros code * * @return string|null */ public function getMacrosCode() { return $this->macrosCode; } /** * Set the macros certificate * * @param string|null $Certificate */ public function setMacrosCertificate($Certificate = null) { $this->macrosCertificate=$Certificate; } /** * Is the project signed ? * * @return boolean true|false */ public function hasMacrosCertificate() { return !is_null($this->macrosCertificate); } /** * Return the macros certificate * * @return string|null */ public function getMacrosCertificate() { return $this->macrosCertificate; } /** * Remove all macros, certificate from spreadsheet * */ public function discardMacros() { $this->hasMacros=false; $this->macrosCode=null; $this->macrosCertificate=null; } /** * set ribbon XML data * */ public function setRibbonXMLData($Target = null, $XMLData = null) { if (!is_null($Target) && !is_null($XMLData)) { $this->ribbonXMLData = array('target' => $Target, 'data' => $XMLData); } else { $this->ribbonXMLData = null; } } /** * retrieve ribbon XML Data * * return string|null|array */ public function getRibbonXMLData($What = 'all') //we need some constants here... { $ReturnData = null; $What = strtolower($What); switch ($What){ case 'all': $ReturnData = $this->ribbonXMLData; break; case 'target': case 'data': if (is_array($this->ribbonXMLData) && array_key_exists($What, $this->ribbonXMLData)) { $ReturnData = $this->ribbonXMLData[$What]; } break; } return $ReturnData; } /** * store binaries ribbon objects (pictures) * */ public function setRibbonBinObjects($BinObjectsNames = null, $BinObjectsData = null) { if (!is_null($BinObjectsNames) && !is_null($BinObjectsData)) { $this->ribbonBinObjects = array('names' => $BinObjectsNames, 'data' => $BinObjectsData); } else { $this->ribbonBinObjects = null; } } ...
完整源码文件,请先购买后再查看
相关源码
- JAVA+SPRINGBOOT心灵心理健康平台(心灵治愈交流平台)(含论文)源码2023-09-27
- JAVA+SPRINGBOOT+VUE工厂车间管理系统(含论文)源码2023-09-27
- JAVA_SSM+VUE校园二手物品交易平台(含论文)源码2023-09-27
- JAVA+SSM医院住院管理系统(含论文)源码2023-09-27
- JAVA VUE SSM教材管理系统(含论文、PPT)课程设计2023-09-27
- 基于SPRINGBOOT 旅游共享平台 + 论文2023-09-26
关于我们 | 顾问团队 | 发展历程 | 联系我们 | 源码上传
联系电话(Tel):4008-010-151(免长途)
地址:北京市海淀区大恒科技大厦五层 邮编:100080
Floor 5th,Daheng Building,Zhongguancun,Beijing,China,100080
51Aspx.com 版权所有 CopyRight © 2006-2023. 京ICP备09089570号 | 京公网安备11010702000869号
联系电话(Tel):4008-010-151(免长途)
地址:北京市海淀区大恒科技大厦五层 邮编:100080
Floor 5th,Daheng Building,Zhongguancun,Beijing,China,100080
51Aspx.com 版权所有 CopyRight © 2006-2023. 京ICP备09089570号 | 京公网安备11010702000869号