Docs For Class Spreadsheet_Excel

Class Spreadsheet_Excel_Reader

Description

Recuperare il contenuto di un documento MS Excel in formato testo.

author: Vadim Tkachenko <vt@apachephp.com>
link: http://pear.php.net/package/Spreadsheet_Excel_Reader
license: PHP License 3.0

Located in /adapter/helpers/class.excel2txt.php (line 295)

Variable Summary

mixed $boundsheets

mixed $colindexes

mixed $colInfo

mixed $colnames

mixed $colors

mixed $data

mixed $dateFormats

mixed $defaultColWidth

mixed $fontRecords

mixed $formatRecords

mixed $lineStyles

mixed $lineStylesCss

mixed $numberFormats

mixed $rowInfo

mixed $sheets

mixed $sst

mixed $standardColWidth

mixed $xfRecords

mixed $_coloffset

mixed $_columnsFormat

mixed $_defaultEncoding

mixed $_defaultFormat

mixed $_ole

mixed $_rowoffset

Method Summary

Spreadsheet_Excel_Reader Spreadsheet_Excel_Reader ([ $file = ''], [ $store_extended_info = true], [ $outputEncoding = ''])

void addcell ( $row, $col, $string, [ $info = null])

void align ( $row, $col, [ $sheet = 0])

void bgColor ( $row, $col, [ $sheet = 0])

void bold ( $row, $col, [ $sheet = 0])

void borderBottom ( $row, $col, [ $sheet = 0])

void borderBottomColor ( $row, $col, [ $sheet = 0])

void borderLeft ( $row, $col, [ $sheet = 0])

void borderLeftColor ( $row, $col, [ $sheet = 0])

void borderRight ( $row, $col, [ $sheet = 0])

void borderRightColor ( $row, $col, [ $sheet = 0])

void borderTop ( $row, $col, [ $sheet = 0])

void borderTopColor ( $row, $col, [ $sheet = 0])

void colcount ([ $sheet = 0])

void colhidden ( $col, [ $sheet = 0])

void color ( $row, $col, [ $sheet = 0])

void colspan ( $row, $col, [ $sheet = 0])

void colwidth ( $col, [ $sheet = 0])

void createNumber ( $spos)

void dump ([ $row_numbers = false], [ $col_letters = false], [ $sheet = 0], [ $table_class = 'excel'])

void dumpHexData ( $data, $pos, $length)

void dump_xls2txt ([ $separetor = ' '])

void font ( $row, $col, [ $sheet = 0])

void fontIndex ( $row, $col, [ $sheet = 0])

void fontProperty ( $row, $col, [ $sheet = 0], $prop)

void fontRecord ( $row, $col, [ $sheet = 0])

void format ( $row, $col, [ $sheet = 0])

void formatColor ( $row, $col, [ $sheet = 0])

void formatIndex ( $row, $col, [ $sheet = 0])

void getCol ( $col)

void height ( $row, $col, [ $sheet = 0])

void hyperlink ( $row, $col, [ $sheet = 0])

void info ( $row, $col, [ $type = ''], [ $sheet = 0])

void isDate ( $spos)

void italic ( $row, $col, [ $sheet = 0])

void myHex ( $d)

void raw ( $row, $col, [ $sheet = 0])

void rawColor ( $ci)

void read ( $sFileName)

void read16bitstring ( $data, $start)

void rowcount ([ $sheet = 0])

void rowheight ( $row, [ $sheet = 0])

void rowhidden ( $row, [ $sheet = 0])

void rowspan ( $row, $col, [ $sheet = 0])

void setColumnFormat ( $column, $sFormat)

void setDefaultFormat ( $sFormat)

void setOutputEncoding ( $encoding)

void setRowColOffset ( $iOffset)

void setUTFEncoder ([ $encoder = 'iconv'])

void style ( $row, $col, [ $sheet = 0], [ $properties = ''])

void type ( $row, $col, [ $sheet = 0])

void underline ( $row, $col, [ $sheet = 0])

void val ( $row, $col, [ $sheet = 0])

void value ( $row, $col, [ $sheet = 0])

void xfProperty ( $row, $col, $sheet, $prop)

void xfRecord ( $row, $col, [ $sheet = 0])

void _encodeUTF16 ( $string)

void _format_value ( $format, $num, $f)

void _getCellDetails ( $spos, $numValue, $column)

void _GetIEEE754 ( $rknum)

void _GetInt4d ( $data, $pos)

bool _parse ()

void _parsesheet ( $spos)

Variables

mixed $boundsheets = array() (line 725)

mixed $colindexes = array() (line 345)

mixed $colInfo = array() (line 729)

mixed $colnames = array() (line 344)

mixed $colors = array(
0x00 => "#000000",
0x01 => "#FFFFFF",
0x02 => "#FF0000",
0x03 => "#00FF00",
0x04 => "#0000FF",
0x05 => "#FFFF00",
0x06 => "#FF00FF",
0x07 => "#00FFFF",
0x08 => "#000000",
0x09 => "#FFFFFF",
0x0A => "#FF0000",
0x0B => "#00FF00",
0x0C => "#0000FF",
0x0D => "#FFFF00",
0x0E => "#FF00FF",
0x0F => "#00FFFF",
0x10 => "#800000",
0x11 => "#008000",
0x12 => "#000080",
0x13 => "#808000",
0x14 => "#800080",
0x15 => "#008080",
0x16 => "#C0C0C0",
0x17 => "#808080",
0x18 => "#9999FF",
0x19 => "#993366",
0x1A => "#FFFFCC",
0x1B => "#CCFFFF",
0x1C => "#660066",
0x1D => "#FF8080",
0x1E => "#0066CC",
0x1F => "#CCCCFF",
0x20 => "#000080",
0x21 => "#FF00FF",
0x22 => "#FFFF00",
0x23 => "#00FFFF",
0x24 => "#800080",
0x25 => "#800000",
0x26 => "#008080",
0x27 => "#0000FF",
0x28 => "#00CCFF",
0x29 => "#CCFFFF",
0x2A => "#CCFFCC",
0x2B => "#FFFF99",
0x2C => "#99CCFF",
0x2D => "#FF99CC",
0x2E => "#CC99FF",
0x2F => "#FFCC99",
0x30 => "#3366FF",
0x31 => "#33CCCC",
0x32 => "#99CC00",
0x33 => "#FFCC00",
0x34 => "#FF9900",
0x35 => "#FF6600",
0x36 => "#666699",
0x37 => "#969696",
0x38 => "#003366",
0x39 => "#339966",
0x3A => "#003300",
0x3B => "#333300",
0x3C => "#993300",
0x3D => "#993366",
0x3E => "#333399",
0x3F => "#333333",
0x40 => "#000000",
0x41 => "#FFFFFF",

0x43 => "#000000",
0x4D => "#000000",
0x4E => "#FFFFFF",
0x4F => "#000000",
0x50 => "#FFFFFF",
0x51 => "#000000",

0x7FFF => "#000000"
) (line 787)

mixed $data (line 735)

mixed $dateFormats = array (
0xe => "m/d/Y",
0xf => "M-d-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 746)

List of default date formats used by Excel

mixed $defaultColWidth = 0 (line 347)

mixed $fontRecords = array() (line 727)

mixed $formatRecords = array() (line 726)

mixed $lineStyles = array(
0x00 => "",
0x01 => "Thin",
0x02 => "Medium",
0x03 => "Dashed",
0x04 => "Dotted",
0x05 => "Thick",
0x06 => "Double",
0x07 => "Hair",
0x08 => "Medium dashed",
0x09 => "Thin dash-dotted",
0x0A => "Medium dash-dotted",
0x0B => "Thin dash-dot-dotted",
0x0C => "Medium dash-dot-dotted",
0x0D => "Slanted medium dash-dotted"
) (line 865)

mixed $lineStylesCss = array(
"Thin" => "1px solid",
"Medium" => "2px solid",
"Dashed" => "1px dashed",
"Dotted" => "1px dotted",
"Thick" => "3px solid",
"Double" => "double",
"Hair" => "1px solid",
"Medium dashed" => "2px dashed",
"Thin dash-dotted" => "1px dashed",
"Medium dash-dotted" => "2px dashed",
"Thin dash-dot-dotted" => "1px dashed",
"Medium dash-dot-dotted" => "2px dashed",
"Slanted medium dash-dotte" => "2px dashed"
) (line 882)

mixed $numberFormats = array(
0x1 => "0",
0x2 => "0.00",
0x3 => "#,##0",
0x4 => "#,##0.00",
0x5 => "\$#,##0;(\$#,##0)",
0x6 => "\$#,##0;[Red](\$#,##0)",
0x7 => "\$#,##0.00;(\$#,##0.00)",
0x8 => "\$#,##0.00;[Red](\$#,##0.00)",
0x9 => "0%",
0xa => "0.00%",
0xb => "0.00E+00",
0x25 => "#,##0;(#,##0)",
0x26 => "#,##0;[Red](#,##0)",
0x27 => "#,##0.00;(#,##0.00)",
0x28 => "#,##0.00;[Red](#,##0.00)",
0x29 => "#,##0;(#,##0)", // Not exactly
0x2a => "\$#,##0;(\$#,##0)", // Not exactly
0x2b => "#,##0.00;(#,##0.00)", // Not exactly
0x2c => "\$#,##0.00;(\$#,##0.00)", // Not exactly
0x30 => "##0.0E+0"
) (line 764)

Default number formats used by Excel

mixed $rowInfo = array() (line 730)

mixed $sheets = array() (line 733)

mixed $sst = array() (line 732)

mixed $standardColWidth = 0 (line 346)

mixed $xfRecords = array() (line 728)

mixed $_coloffset = 1 (line 741)

mixed $_columnsFormat = array() (line 739)

mixed $_defaultEncoding = "UTF-8" (line 737)

mixed $_defaultFormat = SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT (line 738)

mixed $_ole (line 736)

mixed $_rowoffset = 1 (line 740)

Methods

Constructor Spreadsheet_Excel_Reader (line 985)

Constructor

Constructor Some basic initialisation

Spreadsheet_Excel_Reader Spreadsheet_Excel_Reader ([ $file = ''], [ $store_extended_info = true], [ $outputEncoding = ''])

$file
$store_extended_info
$outputEncoding

addcell (line 1747)

void addcell ( $row, $col, $string, [ $info = null])

$row
$col
$string
$info

align (line 531)

void align ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

bgColor (line 534)

void bgColor ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

bold (line 598)

void bold ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

borderBottom (line 546)

void borderBottom ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

borderBottomColor (line 558)

void borderBottomColor ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

borderLeft (line 537)

void borderLeft ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

borderLeftColor (line 549)

void borderLeftColor ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

borderRight (line 540)

void borderRight ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

borderRightColor (line 552)

void borderRightColor ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

borderTop (line 543)

void borderTop ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

borderTopColor (line 555)

void borderTopColor ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

colcount (line 421)

void colcount ([ $sheet = 0])

$sheet

colhidden (line 428)

void colhidden ( $col, [ $sheet = 0])

$col
$sheet

color (line 584)

void color ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

colspan (line 406)

void colspan ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

colwidth (line 424)

void colwidth ( $col, [ $sheet = 0])

$col
$sheet

createNumber (line 1732)

void createNumber ( $spos)

$spos

dump (line 616)

void dump ([ $row_numbers = false], [ $col_letters = false], [ $sheet = 0], [ $table_class = 'excel'])

$row_numbers
$col_letters
$sheet
$table_class

dumpHexData (line 354)

void dumpHexData ( $data, $pos, $length)

$data
$pos
$length

dump_xls2txt (line 681)

void dump_xls2txt ([ $separetor = ' '])

$separetor

font (line 610)

void font ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

fontIndex (line 581)

void fontIndex ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

fontProperty (line 574)

void fontProperty ( $row, $col, [ $sheet = 0], $prop)

$row
$col
$sheet
$prop

fontRecord (line 564)

void fontRecord ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

format (line 505)

void format ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

formatColor (line 511)

void formatColor ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

formatIndex (line 508)

void formatIndex ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

getCol (line 362)

void getCol ( $col)

$col

height (line 607)

void height ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

hyperlink (line 411)

void hyperlink ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

info (line 385)

void info ( $row, $col, [ $type = ''], [ $sheet = 0])

$row
$col
$type
$sheet

isDate (line 1661)

void isDate ( $spos)

$spos

italic (line 601)

void italic ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

myHex (line 349)

void myHex ( $d)

raw (line 398)

void raw ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

rawColor (line 592)

void rawColor ( $ci)

read (line 1045)

Read the spreadsheet file using OLE, then parse

void read ( $sFileName)

$sFileName

read16bitstring (line 898)

void read16bitstring ( $data, $start)

$data
$start

rowcount (line 418)

void rowcount ([ $sheet = 0])

$sheet

rowheight (line 431)

void rowheight ( $row, [ $sheet = 0])

$row
$sheet

rowhidden (line 434)

void rowhidden ( $row, [ $sheet = 0])

$row
$sheet

rowspan (line 401)

void rowspan ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

setColumnFormat (line 1038)

Force a column to use a certain format

void setColumnFormat ( $column, $sFormat)

$column
$sFormat

setDefaultFormat (line 1031)

Set the default number format

void setDefaultFormat ( $sFormat)

$sFormat

setOutputEncoding (line 1005)

Set the encoding method

void setOutputEncoding ( $encoding)

$encoding

setRowColOffset (line 1023)

void setRowColOffset ( $iOffset)

$iOffset

setUTFEncoder (line 1014)

$encoder = 'iconv' or 'mb'

$encoder = 'iconv' or 'mb' set iconv if you would like use 'iconv' for encode UTF-16LE to your encoding set mb if you would like use 'mb_convert_encoding' for encode UTF-16LE to your encoding

void setUTFEncoder ([ $encoder = 'iconv'])

$encoder

style (line 440)

void style ( $row, $col, [ $sheet = 0], [ $properties = ''])

$row
$col
$sheet
$properties

type (line 395)

void type ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

underline (line 604)

void underline ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

val (line 375)

void val ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

value (line 382)

void value ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

xfProperty (line 524)

void xfProperty ( $row, $col, $sheet, $prop)

$row
$col
$sheet
$prop

xfRecord (line 517)

void xfRecord ( $row, $col, [ $sheet = 0])

$row
$col
$sheet

_encodeUTF16 (line 1784)

void _encodeUTF16 ( $string)

$string

_format_value (line 905)

void _format_value ( $format, $num, $f)

$format
$num
$f

_getCellDetails (line 1667)

void _getCellDetails ( $spos, $numValue, $column)

$spos
$numValue
$column

_GetIEEE754 (line 1759)

void _GetIEEE754 ( $rknum)

$rknum

_GetInt4d (line 1797)

void _GetInt4d ( $data, $pos)

$data
$pos

_parse (line 1067)

Parse a workbook

access: private

bool _parse ()

_parsesheet (line 1393)

Parse a worksheet

void _parsesheet ( $spos)

$spos

Documentation generated on Fri, 16 Aug 2013 11:37:25 +0200 by phpDocumentor 1.4.0