Class: ExcelFileParser

ExcelFileParser ExcelFileParser( [mixed $logfile = ""], [mixed $level = ABC_NO_LOG], string $logfilename, int $logtype)

Create Excel parser object

Log type can be one of the following: ABC_CRITICAL ABC_ERROR ABC_ALERT ABC_WARNING ABC_NOTICE ABC_INFO ABC_DEBUG ABC_TRACE ABC_VAR_DUMP ABC_NO_LOG

Bitwise combination of these flags is not allowed. You can use only one of them.

Parameters:

void find_stream( mixed $dir, mixed $item_name, [mixed $item_num = 0])

void getByteString( mixed $str, mixed $ofs)

Returns string from stream

Tags:

void getDateArray( mixed $date)

void getUnicodeString( mixed $str, mixed $ofs)

mixed get_blocks_chain( int $start, [bool $small_fat = false])

Get blocks chain

Parameters:

mixed InitParser( )

bool isDateFormat( array $val)

Parameters:

void ParseFromFile( string $filename)

Parse Excel file

This function is optimized for memory usage, but the script takes more times to be completely executed and to parse the selected data. Use with large files.

Parameters:

int ParseFromString( string $contents)

ParseFromString

This function is not optimized for memory usage, but the script takes less times to be completely executed and to parse the selected data. Use when parsing speed is critical (PHP memory limit can be exceed for huge files and script will terminate!).

IN: string contents - File contents string filename - File name of an existing Excel file.

Tags:

Parameters:

void parse_workbook( mixed $f_header, mixed $dp)

Parse workbook

void parse_worksheet( string $ws, [int $_format_needed = 1])

Parse worksheet

Parameters:

array populateFormat( )

Tags:

array rk_decode( int $rk)

An RK value is an encoded integer or floating-point value. RK values have a size of 4 bytes and are used to decrease filesize for floating-point values.

Bit Mask Contents

1. 00000001H 0 = Value not changed 1 = Value is multiplied by 100
2. 00000002H 0 = Floating-point value 1 = Signed integer value

31-2 FFFFFFFCH Encoded value If bit 1 is cleared, the encoded value represents the 30 most significant bits of an IEEE 754 floating-point value (64-bit double precision). The 34 least significant bits must be set to zero. If bit 1 is set, the encoded value represents a signed 30-bit integer value. To get the correct integer, the encoded value has to be shifted right arithmetically by 2 bits. If bit is set, the decoded value (both integer and floating-point) must be divided by 100 to get the final result.

Examples: RK value Type Div 100 Encoded value Decoded value Result 3FF00000H float no 3FF00000H 3FF0000000000000H = 1.0 1.0 3FF00001H float yes 3FF00000H 3FF0000000000000H = 1.0 0.01 004B5646H integer no 004B5644H 0012D591H = 1234321 1234321 004B5647H integer yes 004B5644H 0012D591H = 1234321 12343.21