最新版Muu云课堂V2 v2.1.0.zip

<?php //解密QQ:507728995 /** PHPExcel root directory */ if (!defined('PHPEXCEL_ROOT')) { /** * @ignore */ define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../'); require PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php'; } /** * PHPExcel_Reader_Excel5 * * 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_Reader_Excel5 * @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## */ // Original file header of ParseXL (used as the base for this class): // -------------------------------------------------------------------------------- // Adapted from Excel_Spreadsheet_Reader developed by users bizon153, // trex005, and mmp11 (SourceForge.net) // http://sourceforge.net/projects/phpexcelreader/ // Primary changes made by canyoncasa (dvc) for ParseXL 1.00 ... // Modelled moreso after Perl Excel Parse/Write modules // Added Parse_Excel_Spreadsheet object // Reads a whole worksheet or tab as row,column array or as // associated hash of indexed rows and named column fields // Added variables for worksheet (tab) indexes and names // Added an object call for loading individual woorksheets // Changed default indexing defaults to 0 based arrays // Fixed date/time and percent formats // Includes patches found at SourceForge... // unicode patch by nobody // unpack("d") machine depedency patch by matchy // boundsheet utf16 patch by bjaenichen // Renamed functions for shorter names // General code cleanup and rigor, including <80 column width // Included a testcase Excel file and PHP example calls // Code works for PHP 5.x // Primary changes made by canyoncasa (dvc) for ParseXL 1.10 ... // http://sourceforge.net/tracker/index.php?func=detail&aid=1466964&group_id=99160&atid=623334 // Decoding of formula conditions, results, and tokens. // Support for user-defined named cells added as an array "namedcells" // Patch code for user-defined named cells supports single cells only. // NOTE: this patch only works for BIFF8 as BIFF5-7 use a different // external sheet reference structure class PHPExcel_Reader_Excel5 extends PHPExcel_Reader_Abstract implements PHPExcel_Reader_IReader { // ParseXL definitions const XLS_BIFF8 = 0x600; const XLS_BIFF7 = 0x500; const XLS_WorkbookGlobals = 0x5; const XLS_Worksheet = 0x10; // record identifiers const XLS_TYPE_FORMULA = 0x6; const XLS_TYPE_EOF = 0xa; const XLS_TYPE_PROTECT = 0x12; const XLS_TYPE_OBJECTPROTECT = 0x63; const XLS_TYPE_SCENPROTECT = 0xdd; const XLS_TYPE_PASSWORD = 0x13; const XLS_TYPE_HEADER = 0x14; const XLS_TYPE_FOOTER = 0x15; const XLS_TYPE_EXTERNSHEET = 0x17; const XLS_TYPE_DEFINEDNAME = 0x18; const XLS_TYPE_VERTICALPAGEBREAKS = 0x1a; const XLS_TYPE_HORIZONTALPAGEBREAKS = 0x1b; const XLS_TYPE_NOTE = 0x1c; const XLS_TYPE_SELECTION = 0x1d; const XLS_TYPE_DATEMODE = 0x22; const XLS_TYPE_EXTERNNAME = 0x23; const XLS_TYPE_LEFTMARGIN = 0x26; const XLS_TYPE_RIGHTMARGIN = 0x27; const XLS_TYPE_TOPMARGIN = 0x28; const XLS_TYPE_BOTTOMMARGIN = 0x29; const XLS_TYPE_PRINTGRIDLINES = 0x2b; const XLS_TYPE_FILEPASS = 0x2f; const XLS_TYPE_FONT = 0x31; const XLS_TYPE_CONTINUE = 0x3c; const XLS_TYPE_PANE = 0x41; const XLS_TYPE_CODEPAGE = 0x42; const XLS_TYPE_DEFCOLWIDTH = 0x55; const XLS_TYPE_OBJ = 0x5d; const XLS_TYPE_COLINFO = 0x7d; const XLS_TYPE_IMDATA = 0x7f; const XLS_TYPE_SHEETPR = 0x81; const XLS_TYPE_HCENTER = 0x83; const XLS_TYPE_VCENTER = 0x84; const XLS_TYPE_SHEET = 0x85; const XLS_TYPE_PALETTE = 0x92; const XLS_TYPE_SCL = 0xa0; const XLS_TYPE_PAGESETUP = 0xa1; const XLS_TYPE_MULRK = 0xbd; const XLS_TYPE_MULBLANK = 0xbe; const XLS_TYPE_DBCELL = 0xd7; const XLS_TYPE_XF = 0xe0; const XLS_TYPE_MERGEDCELLS = 0xe5; const XLS_TYPE_MSODRAWINGGROUP = 0xeb; const XLS_TYPE_MSODRAWING = 0xec; const XLS_TYPE_SST = 0xfc; const XLS_TYPE_LABELSST = 0xfd; const XLS_TYPE_EXTSST = 0xff; const XLS_TYPE_EXTERNALBOOK = 0x1ae; const XLS_TYPE_DATAVALIDATIONS = 0x1b2; const XLS_TYPE_TXO = 0x1b6; const XLS_TYPE_HYPERLINK = 0x1b8; const XLS_TYPE_DATAVALIDATION = 0x1be; const XLS_TYPE_DIMENSION = 0x200; const XLS_TYPE_BLANK = 0x201; const XLS_TYPE_NUMBER = 0x203; const XLS_TYPE_LABEL = 0x204; const XLS_TYPE_BOOLERR = 0x205; const XLS_TYPE_STRING = 0x207; const XLS_TYPE_ROW = 0x208; const XLS_TYPE_INDEX = 0x20b; const XLS_TYPE_ARRAY = 0x221; const XLS_TYPE_DEFAULTROWHEIGHT = 0x225; const XLS_TYPE_WINDOW2 = 0x23e; const XLS_TYPE_RK = 0x27e; const XLS_TYPE_STYLE = 0x293; const XLS_TYPE_FORMAT = 0x41e; const XLS_TYPE_SHAREDFMLA = 0x4bc; const XLS_TYPE_BOF = 0x809; const XLS_TYPE_SHEETPROTECTION = 0x867; const XLS_TYPE_RANGEPROTECTION = 0x868; const XLS_TYPE_SHEETLAYOUT = 0x862; const XLS_TYPE_XFEXT = 0x87d; const XLS_TYPE_PAGELAYOUTVIEW = 0x88b; const XLS_TYPE_UNKNOWN = 0xffff; // Encryption type const MS_BIFF_CRYPTO_NONE = 0; const MS_BIFF_CRYPTO_XOR = 1; const MS_BIFF_CRYPTO_RC4 = 2; // Size of stream blocks when using RC4 encryption const REKEY_BLOCK = 0x400; /** * Summary Information stream data. * * @var string */ private $summaryInformation; /** * Extended Summary Information stream data. * * @var string */ private $documentSummaryInformation; /** * User-Defined Properties stream data. * * @var string */ private $userDefinedProperties; /** * Workbook stream data. (Includes workbook globals substream as well as sheet substreams) * * @var string */ private $data; /** * Size in bytes of $this->data * * @var int */ private $dataSize; /** * Current position in stream * * @var integer */ private $pos; /** * Workbook to be returned by the reader. * * @var PHPExcel */ private $phpExcel; /** * Worksheet that is currently being built by the reader. * * @var PHPExcel_Worksheet */ private $phpSheet; /** * BIFF version * * @var int */ private $version; /** * Codepage set in the Excel file being read. Only important for BIFF5 (Excel 5.0 - Excel 95) * For BIFF8 (Excel 97 - Excel 2003) this will always have the value 'UTF-16LE' * * @var string */ private $codepage; /** * Shared formats * * @var array */ private $formats; /** * Shared fonts * * @var array */ private $objFonts; /** * Color palette * * @var array */ private $palette; /** * Worksheets * * @var array */ private $sheets; /** * External books * * @var array */ private $externalBooks; /** * REF structures. Onl