Docs For Class Excel

$boundsheets = array()

[line 153]

Type:

mixed

[ Top ]

$cellblock = array()

[line 149]

Type:

mixed

[ Top ]

$charset =

[line 171]

Type:

mixed

[ Top ]

$colblock = array()

[line 147]

Type:

mixed

[ Top ]

$colwidth = array()

[line 181]

Type:

mixed

[ Top ]

$defcolW = array()

[line 193]

Type:

mixed

[ Top ]

$defrowH = array()

[line 191]

Type:

mixed

[ Top ]

$dupsheet = array()

[line 167]

Type:

mixed

[ Top ]

$eachsst = array()

[line 157]

Type:

mixed

[ Top ]

$exp_mode = 0

[line 165]

Type:

mixed

[ Top ]

$globaldat = array()

[line 143]

Type:

mixed

[ Top ]

$hlink = array()

[line 159]

Type:

mixed

[ Top ]

$mergecells = array()

[line 177]

Type:

mixed

[ Top ]

$mergeinfo = array()

[line 179]

Type:

mixed

[ Top ]

$opt_parsemode =

[line 175]

Type:

mixed

[ Top ]

$opt_ref3d =

[line 173]

Type:

mixed

[ Top ]

$prnarea = array()

[line 195]

Type:

mixed

[ Top ]

$prntitle = array()

[line 197]

Type:

mixed

[ Top ]

$recFONT = array()

[line 185]

Type:

mixed

[ Top ]

$recFORMAT = array()

[line 187]

Type:

mixed

[ Top ]

$recXF = array()

[line 189]

Type:

mixed

[ Top ]

$revise_dat = array()

[line 155]

Type:

mixed

[ Top ]

$rmcells = array()

[line 163]

Type:

mixed

[ Top ]

$rmsheets = array()

[line 161]

Type:

mixed

[ Top ]

$rowblock = array()

[line 145]

Type:

mixed

[ Top ]

$rowheight = array()

[line 183]

Type:

mixed

[ Top ]

$sheetbin = array()

[line 151]

Type:

mixed

[ Top ]

$stable = array()

[line 169]

Type:

mixed

[ Top ]

$wbdat = ''

[line 141]

Type:

mixed

[ Top ]

constructor Excel_Reviser [line 200]

Excel_Reviser Excel_Reviser(
)

[ Top ]

method addBlank [line 588]

void addBlank(
integer
$sheet, integer
$row, integer
$col, integer
$refrow, integer
$refcol, [integer
$refsheet = null])

Add Blank Cell

Tags:

access:	public
example:	sample3

Parameters:

integer	$sheet	sheet number 0 base indexed
integer	$row	Row position 0 base indexed
integer	$col	Column posion 0 base indexed
integer	$refrow	reference row(option)
integer	$refcol	reference column(option)
integer	$refsheet	ref sheet number(option)

[ Top ]

method addHLink [line 371]

void addHLink(
integer
$sn, integer
$row, integer
$col, [string
$desc = ''], string
$link, [integer
$refrow = null], [integer
$refcol = null], [integer
$refsheet = null])

Add hyperlink to Cell

Tags:

access:	public
example:	sample

Parameters:

integer	$sn	sheet number
integer	$row	Row position
integer	$col	Column posion 0indexed
string	$desc	cell description(option)
string	$link	absolute link path
integer	$refrow	reference row(option)
integer	$refcol	reference column(option)
integer	$refsheet	reference sheet number(option)

[ Top ]

method addNumber [line 489]

void addNumber(
integer
$sheet, integer
$row, integer
$col, integer
$num, [integer
$refrow = null], [integer
$refcol = null], [integer
$refsheet = null])

Add Number to Cell

Tags:

access:	public
example:	sample

Parameters:

integer	$sheet	sheet number
integer	$row	Row position
integer	$col	Column posion 0indexed
integer	$num	number
integer	$refrow	reference row(option)
integer	$refcol	refernce column(option)
integer	$refsheet	reference sheet number(option)

[ Top ]

method addSheet [line 351]

void addSheet(
integer
$orgsn, integer
$num)

Copy Sheet

Tags:

access:	public
example:	sample2

Parameters:

integer	$orgsn	original sheet-number 0 indexed
integer	$num	number of sheet to duplicate

[ Top ]

method addString [line 466]

void addString(
integer
$sheet, integer
$row, integer
$col, string
$str, [integer
$refrow = null], [integer
$refcol = null], [integer
$refsheet = null])

Add String to Cell

Tags:

access:	public
example:	sample

Parameters:

integer	$sheet	sheet number
integer	$row	Row position
integer	$col	Column posion 0indexed
string	$str	string
integer	$refrow	reference row(option)
integer	$refcol	reference column(option)
integer	$refsheet	reference sheet number(option)

[ Top ]

method buildFile [line 339]

void buildFile(
string
$outfile, [string
$path = null])

Remake file

Tags:

access:	public
example:	sample4

Parameters:

string	$outfile	filename for web output
string	$path	if not null then save file

[ Top ]

method changeStr [line 507]

void changeStr(
string
$org, string
$new)

Change original string to new string

Tags:

access:	public
example:	sample

Parameters:

string	$org	original String
string	$new	new string

[ Top ]

method chgColWidth [line 445]

void chgColWidth(
integer
$sheet, integer
$col, integer
$width)

Set Column width

Tags:

since:	Ver0.21
access:	public
example:	sample3

Parameters:

integer	$sheet	sheet number
integer	$col	Column position
integer	$width	Width of the columns in 1/256 of the width of the zero character

[ Top ]

method chgRowHeight [line 427]

void chgRowHeight(
integer
$sheet, integer
$row, integer
$height)

Set Row height

Tags:

since:	Ver0.21
access:	public
example:	sample3

Parameters:

integer	$sheet	sheet number
integer	$row	Row position
integer	$height	Height of the row, in twips = 1/20 of a point

[ Top ]

method getCellAttrib [line 2169]

mixed getCellAttrib(
integer
$sn, integer
$row, integer
$col)

Get Cell Attribute

Tags:

return:	cell value
access:	public
example:	sample_ex1

Parameters:

integer	$sn	sheet number
integer	$row	Row position
integer	$col	Column position

[ Top ]

method getCellVal [line 2079]

mixed getCellVal(
integer
$sn, integer
$row, integer
$col)

Get Cell Value

Tags:

return:	cell value
access:	public
example:	sample_ex1

Parameters:

integer	$sn	sheet number
integer	$row	Row position
integer	$col	Column position 0indexed

[ Top ]

method getColWidth [line 2290]

integer getColWidth(
integer
$sn, integer
$col)

Get Column Width

Tags:

return:	column-width
access:	public
example:	sample_ex1

Parameters:

integer	$sn	sheet number
integer	$col	Column position

[ Top ]

method getFooter [line 2260]

string getFooter(
integer
$sn)

Get Footer

Tags:

return:	footer
access:	public
example:	sample_ex1

Parameters:

integer

$sn

sheet number

[ Top ]

method getHeader [line 2248]

string getHeader(
integer
$sn)

Get Header

Tags:

return:	header
access:	public
example:	sample_ex1

Parameters:

integer

$sn

sheet number

[ Top ]

method getRowHeight [line 2273]

integer getRowHeight(
integer
$sn, integer
$row)

Get Row Height

Tags:

return:	row-height
access:	public
example:	sample_ex1

Parameters:

integer	$sn	sheet number
integer	$row	Row position

[ Top ]

method getSheetName [line 2236]

string getSheetName(
integer
$sn)

Get sheet-name

Tags:

return:	sheetname
access:	public
example:	sample_ex1

Parameters:

integer

$sn

sheet number

[ Top ]

method parseFile [line 1557]

void parseFile(
$filename:full
$filename, [
$mode = null])

Parse Excel file

Tags:

access:	public
example:	sample_ex1

Parameters:

$filename:full	$filename	path for OLE file
	$mode

[ Top ]

method reviseFile [line 326]

void reviseFile(
string
$readfile, string
$outfile, [string
$path = null])

Parse file and Remake

Tags:

access:	public
example:	sample

Parameters:

string	$readfile	full path filename for read
string	$outfile	filename for web output
string	$path	if not null then save file

[ Top ]

method rmCell [line 412]

void rmCell(
integer
$sheet, integer
$row, integer
$col)

Set remove Cell

Tags:

access:	public
example:	sample

Parameters:

integer	$sheet	sheet number
integer	$row	Row position
integer	$col	Column posion 0 base indexed

[ Top ]

method rmSheet [line 398]

void rmSheet(
integer
$sheet)

Set remove Sheet number

Tags:

access:	public
example:	sample

Parameters:

integer

$sheet

sheet number 0 indexed

[ Top ]

method setCellMerge [line 269]

void setCellMerge(
integer
$sn, integer
$rowst, integer
$rowen, integer
$colst, integer
$colen)

Set Cells to merge

Tags:

access:	public
example:	sample3

Parameters:

integer	$sn	sheet-number 0 base indexed
integer	$rowst	row number for top-cell
integer	$rowen	row number for bottom-cell
integer	$colst	column number for left-cell
integer	$colen	column number for right-cell

[ Top ]

method setFooter [line 564]

void setFooter(
integer
$sn, string
$str)

overwrite footer string

Tags:

access:	public
example:	sample

Parameters:

integer	$sn	sheet number
string	$str	new footer-string

[ Top ]

method setHeader [line 544]

void setHeader(
integer
$sn, string
$str)

overwrite header string

Tags:

access:	public
example:	sample

Parameters:

integer	$sn	sheet number
string	$str	new header-string

[ Top ]

method setInternalCharset [line 221]

string setInternalCharset(
[string
$chrset = ''])

Set(Get) internal charset, if you use multibyte-code.

Tags:

return:	current charector-set name
access:	public

Parameters:

string

$chrset

charactor-set name(Ex. SJIS)

[ Top ]

method setOptionRef3d [line 252]

integer setOptionRef3d(
[integer
$opt = null])

Set reference option for graph-object in added sheet

(This is experimental function. It operates under only the conditions which are limited.)

Tags:

return:	current value
access:	public
example:	sample2

Parameters:

integer

$opt

= change link to self-sheet 0 = keep original link-address

[ Top ]

method setParseMode [line 235]

string setParseMode(
[string
$mode = null])

Set(Get) parse mode, 1: include cell-attribute.

Tags:

return:	current parse mode
access:	public
example:	sample_ex1

Parameters:

string

$mode

set parse mode

[ Top ]

method setPrintArea [line 665]

void setPrintArea(
integer
$sheet, integer
$row1st, integer
$rowlast, integer
$col1st, integer
$collast)

Set PrintArea

Tags:

access:	public
example:	sample4

Parameters:

integer	$sheet	sheet number 0 base indexed
integer	$row1st	First Row position 0 base indexed
integer	$rowlast	Last Row position 0 base indexed
integer	$col1st	First Column position 0 base indexed
integer	$collast	Last Column position 0 base indexed

[ Top ]

method setPrintTitle [line 608]

void setPrintTitle(
integer
$sheet, [integer
$row1st = null], [integer
$rowlast = null], [integer
$col1st = null], [integer
$collast = null])

Set Printtitle

Tags:

access:	public
example:	sample4

Parameters:

integer	$sheet	sheet number 0 base indexed
integer	$row1st	First Row position 0 base indexed
integer	$rowlast	Last Row position 0 base indexed
integer	$col1st	First Column position 0 base indexed
integer	$collast	Last Column position 0 base indexed

[ Top ]

method setPrintTitleCol [line 646]

void setPrintTitleCol(
integer
$sheet, integer
$col1st, [integer
$collast = null])

Set Column Printtitle

Tags:

access:	public
example:	sample4

Parameters:

integer	$sheet	sheet number 0 base indexed
integer	$col1st	First Column position 0 base indexed
integer	$collast	Last Column position 0 base indexed

[ Top ]

method setPrintTitleRow [line 629]

void setPrintTitleRow(
integer
$sheet, integer
$row1st, [integer
$rowlast = null])

Set Row Print-title

Tags:

access:	public
example:	sample4

Parameters:

integer	$sheet	sheet number 0 base indexed
integer	$row1st	First Row position 0 base indexed
integer	$rowlast	Last Row position 0 base indexed

[ Top ]

method setSheetname [line 524]

void setSheetname(
integer
$sn, string
$str)

overwrite Sheetname

Tags:

access:	public
example:	sample

Parameters:

integer	$sn	sheet number
string	$str	new sheet name

[ Top ]

method unsetCellMerge [line 292]

void unsetCellMerge(
integer
$sn)

Unset original MergedCells

Tags:

access:	public
example:	sample3

Parameters:

integer

$sn

sheet-number 0 base indexed

[ Top ]

Class: Excel_Reviser

Class Overview

Author(s):

Copyright:

Variables

Methods

Class Details

Tags:

Class Variables

$boundsheets = array()

$cellblock = array()

$charset =

$colblock = array()

$colwidth = array()

$defcolW = array()

$defrowH = array()

$dupsheet = array()

$eachsst = array()

$exp_mode = 0

$globaldat = array()

$hlink = array()

$mergecells = array()

$mergeinfo = array()

$opt_parsemode =

$opt_ref3d =

$prnarea = array()

$prntitle = array()

$recFONT = array()

$recFORMAT = array()

$recXF = array()

$revise_dat = array()

$rmcells = array()

$rmsheets = array()

$rowblock = array()

$rowheight = array()

$sheetbin = array()

$stable = array()

$wbdat = ''

Class Methods

constructor Excel_Reviser [line 200]

method addBlank [line 588]

Tags:

Parameters:

method addHLink [line 371]

Tags:

Parameters:

method addNumber [line 489]

Tags:

Parameters:

method addSheet [line 351]

Tags:

Parameters:

method addString [line 466]

Tags:

Parameters:

method buildFile [line 339]

Tags:

Parameters:

method changeStr [line 507]

Tags:

Parameters:

method chgColWidth [line 445]

Tags:

Parameters:

method chgRowHeight [line 427]

Tags:

Parameters:

method getCellAttrib [line 2169]

Tags:

Parameters:

method getCellVal [line 2079]

Tags:

Parameters:

method getColWidth [line 2290]

Tags:

Parameters:

method getFooter [line 2260]

Tags:

Parameters:

method getHeader [line 2248]