[ Index ]

MailPress 544

[ Index ]     [ Classes ]     [ Functions ]     [ Variables ]     [ Constants ]     [ Statistics ]    

title

Body

[close]

/mp-includes/class/options/import/importers/parseexcel/ -> parseexcel.lib.php (summary)

A class for reading Microsoft Excel (97/2003) Spreadsheets.

Author: Vadim Tkachenko <vt@apachephp.com>
License: http://www.php.net/license/3_0.txt PHP License 3.0
Version: CVS: $Id: reader.php 19 2007-03-13 12:42:41Z shangxiao $
File Size: 1737 lines (60 kb)
Included or required: 1 time
Referenced: 0 times
Includes or requires: 0 files

Defines 2 classes

OLERead:: (5 methods):
  OLERead()
  read()
  __readData()
  __readPropertySets()
  getWorkBook()

Spreadsheet_Excel_Reader:: (62 methods):
  myHex()
  dumpHexData()
  getCol()
  val()
  value()
  info()
  type()
  raw()
  rowspan()
  colspan()
  hyperlink()
  rowcount()
  colcount()
  colwidth()
  colhidden()
  rowheight()
  rowhidden()
  style()
  format()
  formatIndex()
  formatColor()
  xfRecord()
  xfProperty()
  align()
  bgColor()
  borderLeft()
  borderRight()
  borderTop()
  borderBottom()
  borderLeftColor()
  borderRightColor()
  borderTopColor()
  borderBottomColor()
  fontRecord()
  fontProperty()
  fontIndex()
  color()
  rawColor()
  bold()
  italic()
  underline()
  height()
  font()
  dump()
  read16bitstring()
  _format_value()
  Spreadsheet_Excel_Reader()
  setOutputEncoding()
  setUTFEncoder()
  setRowColOffset()
  setDefaultFormat()
  setColumnFormat()
  read()
  _parse()
  _parsesheet()
  isDate()
  _getCellDetails()
  createNumber()
  addcell()
  _GetIEEE754()
  _encodeUTF16()
  _GetInt4d()

Defines 62 functions

  GetInt4d()
  gmgetdate()
  array_comb()
  v()

Class: OLERead  - X-Ref

OLERead()   X-Ref
No description

read($sFileName)   X-Ref
No description

__readData($bl)   X-Ref
No description

__readPropertySets()   X-Ref
No description

getWorkBook()   X-Ref
No description

Class: Spreadsheet_Excel_Reader  - X-Ref

myHex($d)   X-Ref
No description

dumpHexData($data, $pos, $length)   X-Ref
No description

getCol($col)   X-Ref
No description

val($row,$col,$sheet=0)   X-Ref
No description

value($row,$col,$sheet=0)   X-Ref
No description

info($row,$col,$type='',$sheet=0)   X-Ref
No description

type($row,$col,$sheet=0)   X-Ref
No description

raw($row,$col,$sheet=0)   X-Ref
No description

rowspan($row,$col,$sheet=0)   X-Ref
No description

colspan($row,$col,$sheet=0)   X-Ref
No description

hyperlink($row,$col,$sheet=0)   X-Ref
No description

rowcount($sheet=0)   X-Ref
No description

colcount($sheet=0)   X-Ref
No description

colwidth($col,$sheet=0)   X-Ref
No description

colhidden($col,$sheet=0)   X-Ref
No description

rowheight($row,$sheet=0)   X-Ref
No description

rowhidden($row,$sheet=0)   X-Ref
No description

style($row,$col,$sheet=0,$properties='')   X-Ref
No description

format($row,$col,$sheet=0)   X-Ref
No description

formatIndex($row,$col,$sheet=0)   X-Ref
No description

formatColor($row,$col,$sheet=0)   X-Ref
No description

xfRecord($row,$col,$sheet=0)   X-Ref
No description

xfProperty($row,$col,$sheet,$prop)   X-Ref
No description

align($row,$col,$sheet=0)   X-Ref
No description

bgColor($row,$col,$sheet=0)   X-Ref
No description

borderLeft($row,$col,$sheet=0)   X-Ref
No description

borderRight($row,$col,$sheet=0)   X-Ref
No description

borderTop($row,$col,$sheet=0)   X-Ref
No description

borderBottom($row,$col,$sheet=0)   X-Ref
No description

borderLeftColor($row,$col,$sheet=0)   X-Ref
No description

borderRightColor($row,$col,$sheet=0)   X-Ref
No description

borderTopColor($row,$col,$sheet=0)   X-Ref
No description

borderBottomColor($row,$col,$sheet=0)   X-Ref
No description

fontRecord($row,$col,$sheet=0)   X-Ref
No description

fontProperty($row,$col,$sheet=0,$prop)   X-Ref
No description

fontIndex($row,$col,$sheet=0)   X-Ref
No description

color($row,$col,$sheet=0)   X-Ref
No description

rawColor($ci)   X-Ref
No description

bold($row,$col,$sheet=0)   X-Ref
No description

italic($row,$col,$sheet=0)   X-Ref
No description

underline($row,$col,$sheet=0)   X-Ref
No description

height($row,$col,$sheet=0)   X-Ref
No description

font($row,$col,$sheet=0)   X-Ref
No description

dump($row_numbers=false,$col_letters=false,$sheet=0,$table_class='excel')   X-Ref
No description

read16bitstring($data, $start)   X-Ref
No description

_format_value($format,$num,$f)   X-Ref
No description

Spreadsheet_Excel_Reader($file='',$store_extended_info=true,$outputEncoding='')   X-Ref
Constructor

Some basic initialisation

setOutputEncoding($encoding)   X-Ref
Set the encoding method


setUTFEncoder($encoder = 'iconv')   X-Ref
$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


setRowColOffset($iOffset)   X-Ref
No description

setDefaultFormat($sFormat)   X-Ref
Set the default number format


setColumnFormat($column, $sFormat)   X-Ref
Force a column to use a certain format


read($sFileName)   X-Ref
Read the spreadsheet file using OLE, then parse


_parse()   X-Ref
Parse a workbook

return: bool

_parsesheet($spos)   X-Ref
Parse a worksheet


isDate($spos)   X-Ref
No description

_getCellDetails($spos,$numValue,$column)   X-Ref
No description

createNumber($spos)   X-Ref
No description

addcell($row, $col, $string, $info=null)   X-Ref
No description

_GetIEEE754($rknum)   X-Ref
No description

_encodeUTF16($string)   X-Ref
No description

_GetInt4d($data, $pos)   X-Ref
No description

Functions
Functions that are not part of a class:

GetInt4d($data, $pos)   X-Ref
No description

gmgetdate($ts = null)   X-Ref
No description

array_comb($array1, $array2)   X-Ref
No description

v($data,$pos)   X-Ref
No description



Generated: Thu Apr 28 18:38:52 2016 Cross-referenced by PHPXref 0.7.1