Docs For Class Spreadsheet_Excel

Description

Located in /ext/Spreadsheet_Excel_Reader/Excel/reader.php (line 71)

Variable Summary

mixed $boundsheets

mixed $data

mixed $dateFormats

mixed $formatRecords

mixed $numberFormats

mixed $pos

mixed $sheets

mixed $sst

mixed $_columnsFormat

mixed $_defaultEncoding

mixed $_defaultFormat

mixed $_ole

Method Summary

Spreadsheet_Excel_Reader Spreadsheet_Excel_Reader ()

void addcell ( $row, $col, $string, [ $raw = ''])

void createDate ( $numValue)

void createNumber ( $spos)

void isDate ( $spos)

void read ( $sFileName)

void setColumnFormat ( $column, $sFormat)

void setDefaultFormat ( $sFormat)

void setOutputEncoding ( $Encoding)

void _encodeUTF16 ( $string)

void _GetIEEE754 ( $rknum)

void _GetInt4d ( $data, $pos)

void _parse ()

void _parsesheet ( $spos)

Variables

mixed $boundsheets = array() (line 73)

mixed $data (line 77)

mixed $dateFormats = array (
0xe => "d/m/Y",
0xf => "d-M-Y",
0x10 => "d-M",
0x11 => "M-Y",
0x12 => "h:i a",
0x13 => "h:i:s a",
0x14 => "H:i",
0x15 => "H:i:s",
0x16 => "d/m/Y H:i",
0x2d => "i:s",
0x2e => "H:i:s",
0x2f => "i:s.S") (line 84)

mixed $formatRecords = array() (line 74)

mixed $numberFormats = array(
0x1 => "%1.0f", // "0"
0x2 => "%1.2f", // "0.00",
0x3 => "%1.0f", //"#,##0",
0x4 => "%1.2f", //"#,##0.00",
0x5 => "%1.0f", /*"$#,##0;($#,##0)",*/
0x6 => '$%1.0f', /*"$#,##0;($#,##0)",*/
0x7 => '$%1.2f', //"$#,##0.00;($#,##0.00)",
0x8 => '$%1.2f', //"$#,##0.00;($#,##0.00)",
0x9 => '%1.0f%%', // "0%"
0xa => '%1.2f%%', // "0.00%"
0xb => '%1.2f', // 0.00E00",
0x25 => '%1.0f', // "#,##0;(#,##0)",
0x26 => '%1.0f', //"#,##0;(#,##0)",
0x27 => '%1.2f', //"#,##0.00;(#,##0.00)",
0x28 => '%1.2f', //"#,##0.00;(#,##0.00)",
0x29 => '%1.0f', //"#,##0;(#,##0)",
0x2a => '$%1.0f', //"$#,##0;($#,##0)",
0x2b => '%1.2f', //"#,##0.00;(#,##0.00)",
0x2c => '$%1.2f', //"$#,##0.00;($#,##0.00)",
0x30 => '%1.0f') (line 98)

mixed $pos (line 78)

mixed $sheets = array() (line 76)

mixed $sst = array() (line 75)

mixed $_columnsFormat = array() (line 82)

mixed $_defaultEncoding (line 80)

mixed $_defaultFormat = Spreadsheet_Excel_Reader_DEF_NUM_FORMAT (line 81)

mixed $_ole (line 79)

Methods

Constructor Spreadsheet_Excel_Reader (line 120)

Spreadsheet_Excel_Reader Spreadsheet_Excel_Reader ()

addcell (line 722)

void addcell ( $row, $col, $string, [ $raw = ''])

$row
$col
$string
$raw

createDate (line 689)

void createDate ( $numValue)

$numValue

createNumber (line 705)

void createNumber ( $spos)

$spos

isDate (line 665)

void isDate ( $spos)

$spos

read (line 138)

void read ( $sFileName)

$sFileName

setColumnFormat (line 133)

void setColumnFormat ( $column, $sFormat)

$column
$sFormat

setDefaultFormat (line 129)

void setDefaultFormat ( $sFormat)

$sFormat

setOutputEncoding (line 125)

void setOutputEncoding ( $Encoding)

$Encoding

_encodeUTF16 (line 768)

void _encodeUTF16 ( $string)

$string

_GetIEEE754 (line 735)

void _GetIEEE754 ( $rknum)

$rknum

_GetInt4d (line 776)

void _GetInt4d ( $data, $pos)

$data
$pos

_parse (line 192)

void _parse ()

_parsesheet (line 456)

void _parsesheet ( $spos)

$spos