excel_reader2.php File Reference

Go to the source code of this file.

Data Structures
class	OLERead
class	Spreadsheet_Excel_Reader

Namespaces
	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()

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()

GetInt4d	(		$data,
			$pos
	)

Definition at line 68 of file excel_reader2.php.

References $data.

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()

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()

v	(		$data,
			$pos
	)

Definition at line 91 of file excel_reader2.php.

References $data.

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

BIG_BLOCK_DEPOT_BLOCKS_POS

const BIG_BLOCK_DEPOT_BLOCKS_POS 0x4c

Definition at line 58 of file excel_reader2.php.

Referenced by OLERead\read().

BIG_BLOCK_SIZE

const BIG_BLOCK_SIZE 0x200

Definition at line 53 of file excel_reader2.php.

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

EXTENSION_BLOCK_POS

const EXTENSION_BLOCK_POS 0x44

Definition at line 55 of file excel_reader2.php.

Referenced by OLERead\read().

IDENTIFIER_OLE

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().

NUM_BIG_BLOCK_DEPOT_BLOCKS_POS

const NUM_BIG_BLOCK_DEPOT_BLOCKS_POS 0x2c

Definition at line 50 of file excel_reader2.php.

Referenced by OLERead\read().

NUM_EXTENSION_BLOCK_POS

const NUM_EXTENSION_BLOCK_POS 0x48

Definition at line 56 of file excel_reader2.php.

Referenced by OLERead\read().

PROPERTY_STORAGE_BLOCK_SIZE

const PROPERTY_STORAGE_BLOCK_SIZE 0x80

Definition at line 57 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().

ROOT_START_BLOCK_POS

const ROOT_START_BLOCK_POS 0x30

Definition at line 52 of file excel_reader2.php.

Referenced by OLERead\read().

SIZE_OF_NAME_POS

const SIZE_OF_NAME_POS 0x40

Definition at line 61 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().

SIZE_POS

const SIZE_POS 0x78

Definition at line 64 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().

SMALL_BLOCK_DEPOT_BLOCK_POS

const SMALL_BLOCK_DEPOT_BLOCK_POS 0x3c

Definition at line 51 of file excel_reader2.php.

Referenced by OLERead\read().

SMALL_BLOCK_SIZE

const SMALL_BLOCK_SIZE 0x40

Definition at line 54 of file excel_reader2.php.

Referenced by OLERead\getWorkBook().

SMALL_BLOCK_THRESHOLD

const SMALL_BLOCK_THRESHOLD 0x1000

Definition at line 59 of file excel_reader2.php.

Referenced by OLERead\getWorkBook().

SPREADSHEET_EXCEL_READER_BIFF7

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().

SPREADSHEET_EXCEL_READER_BIFF8

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().

SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT

const SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT "%s"

Definition at line 306 of file excel_reader2.php.

SPREADSHEET_EXCEL_READER_MSINADAY

const SPREADSHEET_EXCEL_READER_MSINADAY 86400

Definition at line 301 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_getCellDetails().

SPREADSHEET_EXCEL_READER_TYPE_ARRAY

const SPREADSHEET_EXCEL_READER_TYPE_ARRAY 0x221

Definition at line 287 of file excel_reader2.php.

SPREADSHEET_EXCEL_READER_TYPE_BOF

const SPREADSHEET_EXCEL_READER_TYPE_BOF 0x809

Definition at line 266 of file excel_reader2.php.

SPREADSHEET_EXCEL_READER_TYPE_BOOLERR

const SPREADSHEET_EXCEL_READER_TYPE_BOOLERR 0x205

Definition at line 293 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_BOUNDSHEET

const SPREADSHEET_EXCEL_READER_TYPE_BOUNDSHEET 0x85

Definition at line 268 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_TYPE_COLINFO

const SPREADSHEET_EXCEL_READER_TYPE_COLINFO 0x7d

Definition at line 303 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_CONTINUE

const SPREADSHEET_EXCEL_READER_TYPE_CONTINUE 0x3c

Definition at line 282 of file excel_reader2.php.

SPREADSHEET_EXCEL_READER_TYPE_DBCELL

const SPREADSHEET_EXCEL_READER_TYPE_DBCELL 0xd7

Definition at line 271 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_DEFCOLWIDTH

const SPREADSHEET_EXCEL_READER_TYPE_DEFCOLWIDTH 0x55

Definition at line 304 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_DIMENSION

const SPREADSHEET_EXCEL_READER_TYPE_DIMENSION 0x200

Definition at line 269 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_EOF

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().

SPREADSHEET_EXCEL_READER_TYPE_EXTSST

const SPREADSHEET_EXCEL_READER_TYPE_EXTSST 0xff

Definition at line 281 of file excel_reader2.php.

SPREADSHEET_EXCEL_READER_TYPE_FILEPASS

const SPREADSHEET_EXCEL_READER_TYPE_FILEPASS 0x2f

Definition at line 272 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_TYPE_FONT

const SPREADSHEET_EXCEL_READER_TYPE_FONT 0x0031

Definition at line 294 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_TYPE_FORMAT

const SPREADSHEET_EXCEL_READER_TYPE_FORMAT 0x41e

Definition at line 291 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_TYPE_FORMULA

const SPREADSHEET_EXCEL_READER_TYPE_FORMULA 0x406

Definition at line 289 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_FORMULA2

const SPREADSHEET_EXCEL_READER_TYPE_FORMULA2 0x6

Definition at line 290 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_HYPER

const SPREADSHEET_EXCEL_READER_TYPE_HYPER 0x01b8

Definition at line 302 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_INDEX

const SPREADSHEET_EXCEL_READER_TYPE_INDEX 0x20b

Definition at line 279 of file excel_reader2.php.

SPREADSHEET_EXCEL_READER_TYPE_LABEL

const SPREADSHEET_EXCEL_READER_TYPE_LABEL 0x204

Definition at line 283 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_LABELSST

const SPREADSHEET_EXCEL_READER_TYPE_LABELSST 0xfd

Definition at line 284 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_MERGEDCELLS

const SPREADSHEET_EXCEL_READER_TYPE_MERGEDCELLS 0xE5

Definition at line 298 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_MULBLANK

const SPREADSHEET_EXCEL_READER_TYPE_MULBLANK 0xbe

Definition at line 278 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_MULRK

const SPREADSHEET_EXCEL_READER_TYPE_MULRK 0xbd

Definition at line 277 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_NAME

const SPREADSHEET_EXCEL_READER_TYPE_NAME 0x18

Definition at line 286 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_TYPE_NINETEENFOUR

const SPREADSHEET_EXCEL_READER_TYPE_NINETEENFOUR 0x22

Definition at line 297 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_TYPE_NOTE

const SPREADSHEET_EXCEL_READER_TYPE_NOTE 0x1c

Definition at line 273 of file excel_reader2.php.

SPREADSHEET_EXCEL_READER_TYPE_NUMBER

const SPREADSHEET_EXCEL_READER_TYPE_NUMBER 0x203

Definition at line 285 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_PALETTE

const SPREADSHEET_EXCEL_READER_TYPE_PALETTE 0x0092

Definition at line 295 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_TYPE_RK

const SPREADSHEET_EXCEL_READER_TYPE_RK 0x7e

Definition at line 275 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_RK2

const SPREADSHEET_EXCEL_READER_TYPE_RK2 0x27e

Definition at line 276 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_ROW

const SPREADSHEET_EXCEL_READER_TYPE_ROW 0x208

Definition at line 270 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_SST

const SPREADSHEET_EXCEL_READER_TYPE_SST 0xfc

Definition at line 280 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_TYPE_STANDARDWIDTH

const SPREADSHEET_EXCEL_READER_TYPE_STANDARDWIDTH 0x99

Definition at line 305 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_STRING

const SPREADSHEET_EXCEL_READER_TYPE_STRING 0x207

Definition at line 288 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

SPREADSHEET_EXCEL_READER_TYPE_TXO

const SPREADSHEET_EXCEL_READER_TYPE_TXO 0x1b6

Definition at line 274 of file excel_reader2.php.

SPREADSHEET_EXCEL_READER_TYPE_UNKNOWN

const SPREADSHEET_EXCEL_READER_TYPE_UNKNOWN 0xffff

Definition at line 296 of file excel_reader2.php.

SPREADSHEET_EXCEL_READER_TYPE_XF

const SPREADSHEET_EXCEL_READER_TYPE_XF 0xe0

Definition at line 292 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS

const SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS 25569

Definition at line 299 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_getCellDetails().

SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904

const SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904 24107

Definition at line 300 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_getCellDetails().

SPREADSHEET_EXCEL_READER_WORKBOOKGLOBALS

const SPREADSHEET_EXCEL_READER_WORKBOOKGLOBALS 0x5

Definition at line 264 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parse().

SPREADSHEET_EXCEL_READER_WORKSHEET

const SPREADSHEET_EXCEL_READER_WORKSHEET 0x10

Definition at line 265 of file excel_reader2.php.

Referenced by Spreadsheet_Excel_Reader\_parsesheet().

START_BLOCK_POS

const START_BLOCK_POS 0x74

Definition at line 63 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().

TYPE_POS

const TYPE_POS 0x42

Definition at line 62 of file excel_reader2.php.

Referenced by OLERead\__readPropertySets().