<?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\RichText\RichText;
use PhpOffice\PhpSpreadsheet\Shared\CodePage;
use PhpOffice\PhpSpreadsheet\Shared\Date;
use PhpOffice\PhpSpreadsheet\Shared\Escher;
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\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Borders;
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
{
// 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_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;
/**
* 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 int
*/
private $pos;
/**
* Workbook to be returned by the reader.
*
* @var Spreadsheet
*/
private $spreadsheet;
/**
* Worksheet that is currently being built by the reader.
*
* @var 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. Only applies to BIFF8.
*
* @var array
*/
private $ref;
/**
* External names.
*
没有合适的资源?快使用搜索试试~ 我知道了~
免费thinkphp开源版ab一件代发礼品网系统源码-知途云仓V2
共2000个文件
php:2268个
js:358个
png:357个
需积分: 11 1 下载量 13 浏览量
2022-03-15
11:27:15
上传
评论
收藏 24.79MB ZIP 举报
温馨提示
我们的优势 代发的优势商家为什么要用代发 为什么选择我们? 降库存压力 不用以前垫付资金自己囤货 集中仓储快递价格更低 中小商家由于每天发货量不高他们单 发快递价格至少2.5元以上,如果使用 代发平台最低1.25元可发全国 降低人力成本 不用自己安排专人打单打包发货省去 了商家人力成本 庞大的市场规模 市场庞大 集中仓储快递价格更低 据不完全统计每天有数十万商家使用代发 每天代发规模百万订单以上 平均每10个商家就有一个使用过代发 庞大的市场规模小 您只要有商家资源就可以变成钱
资源详情
资源评论
资源推荐
收起资源包目录
免费thinkphp开源版ab一件代发礼品网系统源码-知途云仓V2 (2000个子文件)
.htaccess_apache2.4 53B
random_compat.phar.pubkey.asc 488B
404.html.back 479B
test.bmp 0B
CHANGELOG 1KB
Changelog 939B
COMMITMENT 2KB
config 322B
config 293B
config 280B
config 263B
config 263B
config 252B
config 247B
config 241B
config 241B
config 239B
config 239B
config 238B
config 238B
config 237B
config 237B
config 236B
config 235B
config 71B
CREDITS 341B
chunk-vendors.41990863.css 205KB
chunk-vendors.41990863.css 205KB
chunk-vendors.41990863.css 205KB
bootstrap.min.css 123KB
bootstrap.min.css 123KB
bootstrap.min.css 122KB
theme.min.css 121KB
bootstrap.min.css 112KB
layui.css 88KB
layui.css 78KB
ueditor.css 43KB
app.cd5445c2.css 40KB
app.e86d4bdf.css 40KB
app.00ee3e68.css 40KB
app.c4c48516.css 40KB
app.526649f2.css 40KB
app.8cbfaaf1.css 39KB
ueditor.min.css 34KB
style.css 33KB
style.css 33KB
style.css 32KB
font-awesome.min.css 30KB
animate.css 23KB
demo.css 21KB
video-js.css 21KB
bootstrap-theme.min.css 20KB
image.css 18KB
noty.css 17KB
layer.css 15KB
video.css 15KB
layer.css 14KB
attachment.css 14KB
layer.css 14KB
simplebootadminindex.min.css 12KB
simplebootadminindex.min.css 12KB
simplebootadminindex.min.css 12KB
bootstrap-datetimepicker.css 12KB
video-js.min.css 11KB
chunk-3e80f9fe.1c2d6fee.css 9KB
chunk-9aaa21da.1c2d6fee.css 9KB
chunk-73756acd.2d0bba98.css 9KB
chunk-8de863d6.75a15e78.css 9KB
style.css 9KB
laydate.css 8KB
blue.css 8KB
default.css 8KB
laydate.css 7KB
shCoreDefault.css 7KB
sami.css 7KB
chunk-579fab94.cb25ac32.css 6KB
chunk-a07a78ec.ca1c0dae.css 6KB
chunk-033d05b5.08453786.css 6KB
chunk-3dc4950a.c9fd2ec8.css 6KB
chunk-8dbc789a.203c9924.css 5KB
layer.css 5KB
chunk-622c9d99.63c1bc71.css 5KB
chunk-3bd7b1cb.10d89994.css 5KB
chunk-43bc6fb0.2cedc9b6.css 5KB
chunk-21d0058b.5490a30a.css 5KB
chunk-e10bf4b4.0afd4a94.css 5KB
chunk-4541a66a.e3b5188c.css 5KB
chunk-c89dc808.89fa9298.css 5KB
style.css 4KB
scrawl.css 4KB
install.css 3KB
chunk-60f82c77.d86582b2.css 3KB
chunk-46cbf10b.c2f90bb3.css 3KB
chunk-46cbf10b.c2f90bb3.css 3KB
chunk-30a14d7e.13acfec0.css 3KB
colorpicker.css 3KB
codemirror.css 3KB
chunk-178f6ccd.877ffca0.css 3KB
chunk-cfca719c.cdd0a486.css 3KB
chunk-cfca719c.cdd0a486.css 3KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
ZHItyc_
- 粉丝: 0
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 数据库课程设计e-processing开发笔记
- 基于Python与Tkinter的可视化五子棋游戏
- 111111111111111111111111111111111111111111111111111
- Radically simplified static file serving for Python web apps
- Python解析域名生成Hosts文件
- mindspore基础入门和快速介绍
- mindspore基础入门和快速介绍
- qqmusichd_4.7.0.5_android_r39612_20151228112921.apk
- qqmusicpad_4.12.1.4_DEFAULT_10003480_release.apk
- da_1718811404508..apk
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0