\excelExcel

Summary

Methods

Properties

Constants

__construct()
load()
read()
getExcel()
getSheet()
setInfo()
setColumnType()
setTitle()
setPageHeader()
setPageFooter()
setHeader()
addRow()
delRow()
clear()
saveTo()
output()

$rowcount

No constants found

No protected methods found

No protected properties found

N/A

No private methods found

$format
$excel
$sheet
$rownum
$columntype
$columnmap

N/A

File: extend/excel/Excel.php
Package: Default
Class hierarchy: \excel\Excel

Properties

$rowcount

$rowcount :

Type

$format

$format :

Excel5,Excel2007

Type

$excel

$excel :

Type

$sheet

$sheet :

Type

$rownum

$rownum :

Type

$columntype

$columntype :

Type

$columnmap

$columnmap :

Type

Methods

__construct()

__construct(string  $fmt = 'Xls')

Parameters

string

$fmt

Excel5,Excel2007

load()

load(  $file)

Parameters

$file

read()

read(  $file = '',   $start = 1,   $limit = 100,   $maxcolumn = 255)

Parameters

	$file
	$start
	$limit
	$maxcolumn

getExcel()

getExcel()

getSheet()

getSheet()

setInfo()

setInfo(  $info)

Parameters

$info

setColumnType()

setColumnType(  $column,   $type)

Parameters

	$column	int\|string
	$type	string DataType

setTitle()

setTitle(  $title)

Parameters

$title

setPageHeader()

setPageHeader(  $header = '&C&B&TITLE')

Parameters

$header

setPageFooter()

setPageFooter(  $footer = '&L&TITLE &RPage &P of &N')

Parameters

$footer

setHeader()

setHeader(  $header = array())

设置表头,其实与设置行一样，以后会增加其它功能

Parameters

$header

addRow()

addRow(  $row)

Parameters

$row

delRow()

delRow(  $row = null,   $num = 1)

删除行,默认删除尾行

Parameters

	$row
	$num

clear()

clear(  $wh = false)

清空,是否清空表头

Parameters

$wh

saveTo()

saveTo(  $path) : \excel\TRUE/FALSE

保存到文件

Parameters

$path

string

Returns

\excel\TRUE/FALSE

output()

output(  $filename = '')

输出

Parameters

$filename

string 文件名