Data Structures
class	OLERead
class	Spreadsheet_Excel_Reader

Namespaces
namespace	Spreadsheet_Excel_Reader

Functions
	GetInt4d ($data, $pos)
	gmgetdate ($ts=null)
	array_comb ($array1, $array2)
	v ($data, $pos)

Variables
const	NUM_BIG_BLOCK_DEPOT_BLOCKS_POS = 0x2c
const	SMALL_BLOCK_DEPOT_BLOCK_POS = 0x3c
const	ROOT_START_BLOCK_POS = 0x30
const	BIG_BLOCK_SIZE = 0x200
const	SMALL_BLOCK_SIZE = 0x40
const	EXTENSION_BLOCK_POS = 0x44
const	NUM_EXTENSION_BLOCK_POS = 0x48
const	PROPERTY_STORAGE_BLOCK_SIZE = 0x80
const	BIG_BLOCK_DEPOT_BLOCKS_POS = 0x4c
const	SMALL_BLOCK_THRESHOLD = 0x1000
const	SIZE_OF_NAME_POS = 0x40
const	TYPE_POS = 0x42
const	START_BLOCK_POS = 0x74
const	SIZE_POS = 0x78
const	IDENTIFIER_OLE = pack("CCCCCCCC",0xd0,0xcf,0x11,0xe0,0xa1,0xb1,0x1a,0xe1)
const	SPREADSHEET_EXCEL_READER_BIFF8 = 0x600
const	SPREADSHEET_EXCEL_READER_BIFF7 = 0x500
const	SPREADSHEET_EXCEL_READER_WORKBOOKGLOBALS = 0x5
const	SPREADSHEET_EXCEL_READER_WORKSHEET = 0x10
const	SPREADSHEET_EXCEL_READER_TYPE_BOF = 0x809
const	SPREADSHEET_EXCEL_READER_TYPE_EOF = 0x0a
const	SPREADSHEET_EXCEL_READER_TYPE_BOUNDSHEET = 0x85
const	SPREADSHEET_EXCEL_READER_TYPE_DIMENSION = 0x200
const	SPREADSHEET_EXCEL_READER_TYPE_ROW = 0x208
const	SPREADSHEET_EXCEL_READER_TYPE_DBCELL = 0xd7
const	SPREADSHEET_EXCEL_READER_TYPE_FILEPASS = 0x2f
const	SPREADSHEET_EXCEL_READER_TYPE_NOTE = 0x1c
const	SPREADSHEET_EXCEL_READER_TYPE_TXO = 0x1b6
const	SPREADSHEET_EXCEL_READER_TYPE_RK = 0x7e
const	SPREADSHEET_EXCEL_READER_TYPE_RK2 = 0x27e
const	SPREADSHEET_EXCEL_READER_TYPE_MULRK = 0xbd
const	SPREADSHEET_EXCEL_READER_TYPE_MULBLANK = 0xbe
const	SPREADSHEET_EXCEL_READER_TYPE_INDEX = 0x20b
const	SPREADSHEET_EXCEL_READER_TYPE_SST = 0xfc
const	SPREADSHEET_EXCEL_READER_TYPE_EXTSST = 0xff
const	SPREADSHEET_EXCEL_READER_TYPE_CONTINUE = 0x3c
const	SPREADSHEET_EXCEL_READER_TYPE_LABEL = 0x204
const	SPREADSHEET_EXCEL_READER_TYPE_LABELSST = 0xfd
const	SPREADSHEET_EXCEL_READER_TYPE_NUMBER = 0x203
const	SPREADSHEET_EXCEL_READER_TYPE_NAME = 0x18
const	SPREADSHEET_EXCEL_READER_TYPE_ARRAY = 0x221
const	SPREADSHEET_EXCEL_READER_TYPE_STRING = 0x207
const	SPREADSHEET_EXCEL_READER_TYPE_FORMULA = 0x406
const	SPREADSHEET_EXCEL_READER_TYPE_FORMULA2 = 0x6
const	SPREADSHEET_EXCEL_READER_TYPE_FORMAT = 0x41e
const	SPREADSHEET_EXCEL_READER_TYPE_XF = 0xe0
const	SPREADSHEET_EXCEL_READER_TYPE_BOOLERR = 0x205
const	SPREADSHEET_EXCEL_READER_TYPE_FONT = 0x0031
const	SPREADSHEET_EXCEL_READER_TYPE_PALETTE = 0x0092
const	SPREADSHEET_EXCEL_READER_TYPE_UNKNOWN = 0xffff
const	SPREADSHEET_EXCEL_READER_TYPE_NINETEENFOUR = 0x22
const	SPREADSHEET_EXCEL_READER_TYPE_MERGEDCELLS = 0xE5
const	SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS = 25569
const	SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904 = 24107
const	SPREADSHEET_EXCEL_READER_MSINADAY = 86400
const	SPREADSHEET_EXCEL_READER_TYPE_HYPER = 0x01b8
const	SPREADSHEET_EXCEL_READER_TYPE_COLINFO = 0x7d
const	SPREADSHEET_EXCEL_READER_TYPE_DEFCOLWIDTH = 0x55
const	SPREADSHEET_EXCEL_READER_TYPE_STANDARDWIDTH = 0x99
const	SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT = "%s"

Function Documentation

array_comb	(	$array1,
		$array2
	)

Definition at line 83 of file excel_reader2.php.

References $out.

Referenced by gmgetdate().

                                      {
        $out = array();
        foreach ($array1 as $key => $value) {
                $out[$value] = $array2[$key];
        }
        return $out;
}

Here is the caller graph for this function:

GetInt4d	(	$data,
		$pos
	)

Definition at line 68 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets(), and OLERead\read().

                               {
        $value = ord($data[$pos]) | (ord($data[$pos+1]) << 8) | (ord($data[$pos+2]) << 16) | (ord($data[$pos+3]) << 24);
        if ($value>=4294967294) {
                $value=-2;
        }
        return $value;
}

Here is the caller graph for this function:

gmgetdate ( $ts = null )

Definition at line 77 of file excel_reader2.php.

References array_comb().

Referenced by Spreadsheet_Excel_Reader\_getCellDetails().

                              {
        $k = array('seconds','minutes','hours','mday','wday','mon','year','yday','weekday','month',0);
        return(array_comb($k,split(":",gmdate('s:i:G:j:w:n:Y:z:l:F:U',is_null($ts)?time():$ts))));
        } 

Here is the call graph for this function:

Here is the caller graph for this function:

v	(	$data,
		$pos
	)

Definition at line 91 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse(), EvalMath\EvalMath(), EvalMath\evaluate(), TCPDF\openHTMLTagHandler(), and EvalMath\pfx().

                       {
        return ord($data[$pos]) | ord($data[$pos+1])<<8;
}

Here is the caller graph for this function:

Variable Documentation

const BIG_BLOCK_DEPOT_BLOCKS_POS = 0x4c

Definition at line 58 of file excel_reader2.php.

Referenced by OLERead\read().

const BIG_BLOCK_SIZE = 0x200

Definition at line 53 of file excel_reader2.php.

Referenced by OLERead\__readData(), OLERead\getWorkBook(), and OLERead\read().

const EXTENSION_BLOCK_POS = 0x44

Definition at line 55 of file excel_reader2.php.

Referenced by OLERead\read().

const IDENTIFIER_OLE = pack("CCCCCCCC",0xd0,0xcf,0x11,0xe0,0xa1,0xb1,0x1a,0xe1)

Definition at line 65 of file excel_reader2.php.

Referenced by OLERead\read().

const NUM_BIG_BLOCK_DEPOT_BLOCKS_POS = 0x2c

Definition at line 50 of file excel_reader2.php.

Referenced by OLERead\read().

const NUM_EXTENSION_BLOCK_POS = 0x48

Definition at line 56 of file excel_reader2.php.

Referenced by OLERead\read().

const PROPERTY_STORAGE_BLOCK_SIZE = 0x80

Definition at line 57 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().

const ROOT_START_BLOCK_POS = 0x30

Definition at line 52 of file excel_reader2.php.

Referenced by OLERead\read().

const SIZE_OF_NAME_POS = 0x40

Definition at line 61 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().

const SIZE_POS = 0x78

Definition at line 64 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().

const SMALL_BLOCK_DEPOT_BLOCK_POS = 0x3c

Definition at line 51 of file excel_reader2.php.

Referenced by OLERead\read().

const SMALL_BLOCK_SIZE = 0x40

Definition at line 54 of file excel_reader2.php.

Referenced by OLERead\getWorkBook().

const SMALL_BLOCK_THRESHOLD = 0x1000

Definition at line 59 of file excel_reader2.php.

Referenced by OLERead\getWorkBook().

const SPREADSHEET_EXCEL_READER_BIFF7 = 0x500

Definition at line 263 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse(), and Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_BIFF8 = 0x600

Definition at line 262 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse(), and Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT = "%s"

Definition at line 306 of file excel_reader2.php.

const SPREADSHEET_EXCEL_READER_MSINADAY = 86400

Definition at line 301 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_getCellDetails().

const SPREADSHEET_EXCEL_READER_TYPE_ARRAY = 0x221

Definition at line 287 of file excel_reader2.php.

const SPREADSHEET_EXCEL_READER_TYPE_BOF = 0x809

Definition at line 266 of file excel_reader2.php.

const SPREADSHEET_EXCEL_READER_TYPE_BOOLERR = 0x205

Definition at line 293 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_BOUNDSHEET = 0x85

Definition at line 268 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_TYPE_COLINFO = 0x7d

Definition at line 303 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_CONTINUE = 0x3c

Definition at line 282 of file excel_reader2.php.

const SPREADSHEET_EXCEL_READER_TYPE_DBCELL = 0xd7

Definition at line 271 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_DEFCOLWIDTH = 0x55

Definition at line 304 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_DIMENSION = 0x200

Definition at line 269 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_EOF = 0x0a

Definition at line 267 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse(), and Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_EXTSST = 0xff

Definition at line 281 of file excel_reader2.php.

const SPREADSHEET_EXCEL_READER_TYPE_FILEPASS = 0x2f

Definition at line 272 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_TYPE_FONT = 0x0031

Definition at line 294 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_TYPE_FORMAT = 0x41e

Definition at line 291 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_TYPE_FORMULA = 0x406

Definition at line 289 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_FORMULA2 = 0x6

Definition at line 290 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_HYPER = 0x01b8

Definition at line 302 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_INDEX = 0x20b

Definition at line 279 of file excel_reader2.php.

const SPREADSHEET_EXCEL_READER_TYPE_LABEL = 0x204

Definition at line 283 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_LABELSST = 0xfd

Definition at line 284 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_MERGEDCELLS = 0xE5

Definition at line 298 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_MULBLANK = 0xbe

Definition at line 278 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_MULRK = 0xbd

Definition at line 277 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_NAME = 0x18

Definition at line 286 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_TYPE_NINETEENFOUR = 0x22

Definition at line 297 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_TYPE_NOTE = 0x1c

Definition at line 273 of file excel_reader2.php.

const SPREADSHEET_EXCEL_READER_TYPE_NUMBER = 0x203

Definition at line 285 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_PALETTE = 0x0092

Definition at line 295 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_TYPE_RK = 0x7e

Definition at line 275 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_RK2 = 0x27e

Definition at line 276 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_ROW = 0x208

Definition at line 270 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_SST = 0xfc

Definition at line 280 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_TYPE_STANDARDWIDTH = 0x99

Definition at line 305 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_STRING = 0x207

Definition at line 288 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const SPREADSHEET_EXCEL_READER_TYPE_TXO = 0x1b6

Definition at line 274 of file excel_reader2.php.

const SPREADSHEET_EXCEL_READER_TYPE_UNKNOWN = 0xffff

Definition at line 296 of file excel_reader2.php.

const SPREADSHEET_EXCEL_READER_TYPE_XF = 0xe0

Definition at line 292 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS = 25569

Definition at line 299 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_getCellDetails().

const SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904 = 24107

Definition at line 300 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_getCellDetails().

const SPREADSHEET_EXCEL_READER_WORKBOOKGLOBALS = 0x5

Definition at line 264 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

const SPREADSHEET_EXCEL_READER_WORKSHEET = 0x10

Definition at line 265 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

const START_BLOCK_POS = 0x74

Definition at line 63 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().

const TYPE_POS = 0x42

Definition at line 62 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().

Data Structures

Namespaces

Functions

Variables

Function Documentation

Variable Documentation