[ Index ]

MailPress 7.1

[ 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: 1735 lines (61 kb)
Included or required: 1 time
Referenced: 0 times
Includes or requires: 0 files

Defines 2 classes

OLERead:: (5 methods):
  __construct()
  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()
  __construct()
  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

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

__construct( $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: Mon Mar 11 18:33:33 2019 Cross-referenced by PHPXref 0.7.1