PhpSpreadsheet 是一个用纯 PHP 编写的库，提供了一组类，允许您读取和写入各种电子表格文件格式，例如 Excel

<?php namespace PhpOffice\PhpSpreadsheet\Reader; use PhpOffice\PhpSpreadsheet\Cell\Coordinate; use PhpOffice\PhpSpreadsheet\Cell\DataType; use PhpOffice\PhpSpreadsheet\Cell\DataValidation; use PhpOffice\PhpSpreadsheet\Exception as PhpSpreadsheetException; use PhpOffice\PhpSpreadsheet\NamedRange; use PhpOffice\PhpSpreadsheet\Reader\Xls\ConditionalFormatting; use PhpOffice\PhpSpreadsheet\Reader\Xls\Style\CellFont; use PhpOffice\PhpSpreadsheet\Reader\Xls\Style\FillPattern; use PhpOffice\PhpSpreadsheet\RichText\RichText; use PhpOffice\PhpSpreadsheet\Shared\CodePage; use PhpOffice\PhpSpreadsheet\Shared\Date; use PhpOffice\PhpSpreadsheet\Shared\Escher; use PhpOffice\PhpSpreadsheet\Shared\Escher\DgContainer\SpgrContainer\SpContainer; use PhpOffice\PhpSpreadsheet\Shared\Escher\DggContainer\BstoreContainer\BSE; use PhpOffice\PhpSpreadsheet\Shared\File; use PhpOffice\PhpSpreadsheet\Shared\OLE; use PhpOffice\PhpSpreadsheet\Shared\OLERead; use PhpOffice\PhpSpreadsheet\Shared\StringHelper; use PhpOffice\PhpSpreadsheet\Shared\Xls as SharedXls; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Style\Alignment; use PhpOffice\PhpSpreadsheet\Style\Borders; use PhpOffice\PhpSpreadsheet\Style\Conditional; use PhpOffice\PhpSpreadsheet\Style\Fill; use PhpOffice\PhpSpreadsheet\Style\Font; use PhpOffice\PhpSpreadsheet\Style\NumberFormat; use PhpOffice\PhpSpreadsheet\Style\Protection; use PhpOffice\PhpSpreadsheet\Style\Style; use PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing; use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup; use PhpOffice\PhpSpreadsheet\Worksheet\SheetView; use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet; // 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) // https://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 Xls extends BaseReader { private const HIGH_ORDER_BIT = 0x80 << 24; private const FC000000 = 0xFC << 24; private const FE000000 = 0xFE << 24; // ParseXL definitions const XLS_BIFF8 = 0x0600; const XLS_BIFF7 = 0x0500; const XLS_WORKBOOKGLOBALS = 0x0005; const XLS_WORKSHEET = 0x0010; // record identifiers const XLS_TYPE_FORMULA = 0x0006; const XLS_TYPE_EOF = 0x000A; const XLS_TYPE_PROTECT = 0x0012; const XLS_TYPE_OBJECTPROTECT = 0x0063; const XLS_TYPE_SCENPROTECT = 0x00DD; const XLS_TYPE_PASSWORD = 0x0013; const XLS_TYPE_HEADER = 0x0014; const XLS_TYPE_FOOTER = 0x0015; const XLS_TYPE_EXTERNSHEET = 0x0017; const XLS_TYPE_DEFINEDNAME = 0x0018; const XLS_TYPE_VERTICALPAGEBREAKS = 0x001A; const XLS_TYPE_HORIZONTALPAGEBREAKS = 0x001B; const XLS_TYPE_NOTE = 0x001C; const XLS_TYPE_SELECTION = 0x001D; const XLS_TYPE_DATEMODE = 0x0022; const XLS_TYPE_EXTERNNAME = 0x0023; const XLS_TYPE_LEFTMARGIN = 0x0026; const XLS_TYPE_RIGHTMARGIN = 0x0027; const XLS_TYPE_TOPMARGIN = 0x0028; const XLS_TYPE_BOTTOMMARGIN = 0x0029; const XLS_TYPE_PRINTGRIDLINES = 0x002B; const XLS_TYPE_FILEPASS = 0x002F; const XLS_TYPE_FONT = 0x0031; const XLS_TYPE_CONTINUE = 0x003C; const XLS_TYPE_PANE = 0x0041; const XLS_TYPE_CODEPAGE = 0x0042; const XLS_TYPE_DEFCOLWIDTH = 0x0055; const XLS_TYPE_OBJ = 0x005D; const XLS_TYPE_COLINFO = 0x007D; const XLS_TYPE_IMDATA = 0x007F; const XLS_TYPE_SHEETPR = 0x0081; const XLS_TYPE_HCENTER = 0x0083; const XLS_TYPE_VCENTER = 0x0084; const XLS_TYPE_SHEET = 0x0085; const XLS_TYPE_PALETTE = 0x0092; const XLS_TYPE_SCL = 0x00A0; const XLS_TYPE_PAGESETUP = 0x00A1; const XLS_TYPE_MULRK = 0x00BD; const XLS_TYPE_MULBLANK = 0x00BE; const XLS_TYPE_DBCELL = 0x00D7; const XLS_TYPE_XF = 0x00E0; const XLS_TYPE_MERGEDCELLS = 0x00E5; const XLS_TYPE_MSODRAWINGGROUP = 0x00EB; const XLS_TYPE_MSODRAWING = 0x00EC; const XLS_TYPE_SST = 0x00FC; const XLS_TYPE_LABELSST = 0x00FD; const XLS_TYPE_EXTSST = 0x00FF; const XLS_TYPE_EXTERNALBOOK = 0x01AE; const XLS_TYPE_DATAVALIDATIONS = 0x01B2; const XLS_TYPE_TXO = 0x01B6; const XLS_TYPE_HYPERLINK = 0x01B8; const XLS_TYPE_DATAVALIDATION = 0x01BE; const XLS_TYPE_DIMENSION = 0x0200; const XLS_TYPE_BLANK = 0x0201; const XLS_TYPE_NUMBER = 0x0203; const XLS_TYPE_LABEL = 0x0204; const XLS_TYPE_BOOLERR = 0x0205; const XLS_TYPE_STRING = 0x0207; const XLS_TYPE_ROW = 0x0208; const XLS_TYPE_INDEX = 0x020B; const XLS_TYPE_ARRAY = 0x0221; const XLS_TYPE_DEFAULTROWHEIGHT = 0x0225; const XLS_TYPE_WINDOW2 = 0x023E; const XLS_TYPE_RK = 0x027E; const XLS_TYPE_STYLE = 0x0293; const XLS_TYPE_FORMAT = 0x041E; const XLS_TYPE_SHAREDFMLA = 0x04BC; const XLS_TYPE_BOF = 0x0809; const XLS_TYPE_SHEETPROTECTION = 0x0867; const XLS_TYPE_RANGEPROTECTION = 0x0868; const XLS_TYPE_SHEETLAYOUT = 0x0862; const XLS_TYPE_XFEXT = 0x087D; const XLS_TYPE_PAGELAYOUTVIEW = 0x088B; const XLS_TYPE_CFHEADER = 0x01B0; const XLS_TYPE_CFRULE = 0x01B1; 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. */ private ?string $summaryInformation = null; /** * Extended Summary Information stream data. */ private ?string $documentSummaryInformation = null; /** * Workbook stream data. (Includes workbook globals substream as well as sheet substreams). */ private string $data; /** * Size in bytes of $this->data. */ private int $dataSize; /** * Current position in stream. */ private int $pos; /** * Workbook to be returned by the reader. */ private Spreadsheet $spreadsheet; /** * Worksheet that is currently being built by the reader. */ private Worksheet $phpSheet; /** * BIFF version. */ private int $version = 0; /** * 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'. */ private string $codepage = ''; /** * Shared formats. */ private array $formats; /** * Shared fonts. * * @var F