ExcelBook
addFont( $font )
addFormat( $format )
getAllFormats( )
getError( )
loadFile( $filename )
load( $data )
save( $filename )
getSheet( $sheet )
addSheet( $name )
copySheet( $name, $sheet_number )
deleteSheet( $sheet )
sheetCount( )
activeSheet( $sheet )
getCustomFormat( $id )
addCustomFormat( $format )
packDate( $timestamp )
unpackDate( $date )
getActiveSheet( )
setActiveSheet( $sheet )
getDefaultFont( )
setDefaultFont( $font, $font_size )
setLocale( )
addPictureFromFile( $filename )
addPictureFromString( $data )
rgbMode( )
setRGBMode( $mode )
colorPack( $r, $g, $b )
colorUnpack( $color )
ExcelSheet
ExcelSheet::CELLTYPE_EMPTY = 0
ExcelSheet::CELLTYPE_NUMBER = 1
ExcelSheet::CELLTYPE_STRING = 2
ExcelSheet::CELLTYPE_BOOLEAN = 3
ExcelSheet::CELLTYPE_BLANK = 4
ExcelSheet::CELLTYPE_ERROR = 5
ExcelSheet::ERRORTYPE_NA = 42
ExcelSheet::ERRORTYPE_NUM = 36
ExcelSheet::ERRORTYPE_NAME = 29
ExcelSheet::ERRORTYPE_REF = 23
ExcelSheet::ERRORTYPE_VALUE = 15
ExcelSheet::ERRORTYPE_DIV_0 = 7
ExcelSheet::ERRORTYPE_NULL = 0
ExcelSheet::PAPER_DEFAULT = 0
ExcelSheet::PAPER_LETTER = 1
ExcelSheet::PAPER_LETTERSMALL = 2
ExcelSheet::PAPER_TABLOID = 3
ExcelSheet::PAPER_LEDGER = 4
ExcelSheet::PAPER_LEGAL = 5
ExcelSheet::PAPER_STATEMENT = 6
ExcelSheet::PAPER_EXECUTIVE = 7
ExcelSheet::PAPER_A3 = 8
ExcelSheet::PAPER_A4 = 9
ExcelSheet::PAPER_A4SMALL = 10
ExcelSheet::PAPER_A5 = 11
ExcelSheet::PAPER_B4 = 12
ExcelSheet::PAPER_B5 = 13
ExcelSheet::PAPER_FOLIO = 14
ExcelSheet::PAPER_QUATRO = 15
ExcelSheet::PAPER_10x14 = 16
ExcelSheet::PAPER_10x17 = 17
ExcelSheet::PAPER_NOTE = 18
ExcelSheet::PAPER_ENVELOPE_9 = 19
ExcelSheet::PAPER_ENVELOPE_10 = 20
ExcelSheet::PAPER_ENVELOPE_11 = 21
ExcelSheet::PAPER_ENVELOPE_12 = 22
ExcelSheet::PAPER_ENVELOPE_14 = 23
ExcelSheet::PAPER_C_SIZE = 24
ExcelSheet::PAPER_D_SIZE = 25
ExcelSheet::PAPER_E_SIZE = 26
ExcelSheet::PAPER_ENVELOPE_DL = 27
ExcelSheet::PAPER_ENVELOPE_C5 = 28
ExcelSheet::PAPER_ENVELOPE_C3 = 29
ExcelSheet::PAPER_ENVELOPE_C4 = 30
ExcelSheet::PAPER_ENVELOPE_C6 = 31
ExcelSheet::PAPER_ENVELOPE_C65 = 32
ExcelSheet::PAPER_ENVELOPE_B4 = 33
ExcelSheet::PAPER_ENVELOPE_B5 = 34
ExcelSheet::PAPER_ENVELOPE_B6 = 35
ExcelSheet::PAPER_ENVELOPE = 36
ExcelSheet::PAPER_ENVELOPE_MONARCH = 37
ExcelSheet::PAPER_US_ENVELOPE = 38
ExcelSheet::PAPER_FANFOLD = 39
ExcelSheet::PAPER_GERMAN_STD_FANFOLD = 40
ExcelSheet::PAPER_GERMAN_LEGAL_FANFOLD = 41
cellType( $row, $column )
cellFormat( $row, $column )
setCellFormat( $row, $column, $format )
read( $row, $column, $format )
readRow( $row, $start_col, $end_column )
readCol( $column, $start_row, $end_row )
write( $row, $column, $data, $format, $datatype )
writeRow( $row, $data, $start_column, $format )
writeCol( $row, $data, $start_row, $format )
isFormula( $row, $column )
isDate( $row, $column )
insertRow( $row_first, $row_last )
insertCol( $col_first, $col_last )
removeRow( $row_first, $row_last )
removeCol( $col_first, $col_last )
colWidth( $column )
rowHeight( $row )
readComment( $row, $column )
writeComment( $row, $column, $value, $author, $width, $height )
setColWidth( $column_start, $column_end, $width, $hidden, $format )
setRowHeight( $row, $height, $format, $hidden )
getMerge( $row, $column )
setMerge( $row_start, $row_end, $col_start, $col_end )
deleteMerge( $row, $column )
addPictureScaled( $row, $column, $pic_id, $scale )
addPictureDim( $row, $column, $pic_id, $width, $height )
horPageBreak( $row, $break )
verPageBreak( $col, $break )
splitSheet( $row, $column )
groupRows( $start_row, $end_row, $collapse )
groupCols( $start_column, $end_column, $collapse )
clear( $row_s, $row_e, $col_s, $col_s )
copy( $row, $col, $to_row, $to_col )
firstRow( )
lastRow( )
firstCol( )
lastCol( )
displayGridlines( )
printGridlines( )
setDisplayGridlines( $value )
setPrintGridlines( $value )
zoom( )
zoomPrint( )
setZoom( $value )
setZoomPrint( $value )
setLandscape( $value )
landscape( )
paper( )
setPaper( $value )
header( )
footer( )
setHeader( )
setFooter( )
headerMargin( )
footerMargin( )
hcenter( )
vcenter( )
setHCenter( $value )
setVCenter( $value )
marginLeft( )
marginRight( )
marginTop( )
marginBottom( )
setMarginLeft( $value )
setMarginRight( $value )
setMarginTop( $value )
setMarginBottom( $value )
printHeaders( )
setPrintHeaders( $value )
name( )
setName( )
protect( )
setProtect( $value )
setNamedRange( $name, $row, $col, $to_row, $to_col )
delNamedRange( $name )
setPrintRepeatRows( $row_start, $row_end )
setPrintRepeatCols( $col_start, $col_end )
clearPrintRepeats( )
clearPrintArea( )
getGroupSummaryRight( )
setGroupSummaryBelow( $direction )
getGroupSummaryBelow( )
setGroupSummaryRight( $direction )
ExcelFormat
ExcelFormat::AS_DATE = 1
ExcelFormat::AS_FORMULA = 2
ExcelFormat::AS_NUMERIC_STRING = 3
ExcelFormat::COLOR_BLACK = 8
ExcelFormat::COLOR_WHITE = 9
ExcelFormat::COLOR_RED = 10
ExcelFormat::COLOR_BRIGHTGREEN = 11
ExcelFormat::COLOR_BLUE = 12
ExcelFormat::COLOR_YELLOW = 13
ExcelFormat::COLOR_PINK = 14
ExcelFormat::COLOR_TURQUOISE = 15
ExcelFormat::COLOR_DARKRED = 16
ExcelFormat::COLOR_GREEN = 17
ExcelFormat::COLOR_DARKBLUE = 18
ExcelFormat::COLOR_DARKYELLOW = 19
ExcelFormat::COLOR_VIOLET = 20
ExcelFormat::COLOR_TEAL = 21
ExcelFormat::COLOR_GRAY25 = 22
ExcelFormat::COLOR_GRAY50 = 23
ExcelFormat::COLOR_PERIWINKLE_CF = 24
ExcelFormat::COLOR_PLUM_CF = 25
ExcelFormat::COLOR_IVORY_CF = 26
ExcelFormat::COLOR_LIGHTTURQUOISE_CF = 27
ExcelFormat::COLOR_DARKPURPLE_CF = 28
ExcelFormat::COLOR_CORAL_CF = 29
ExcelFormat::COLOR_OCEANBLUE_CF = 30
ExcelFormat::COLOR_ICEBLUE_CF = 31
ExcelFormat::COLOR_DARKBLUE_CL = 32
ExcelFormat::COLOR_PINK_CL = 33
ExcelFormat::COLOR_YELLOW_CL = 34
ExcelFormat::COLOR_TURQUOISE_CL = 35
ExcelFormat::COLOR_VIOLET_CL = 36
ExcelFormat::COLOR_DARKRED_CL = 37
ExcelFormat::COLOR_TEAL_CL = 38
ExcelFormat::COLOR_BLUE_CL = 39
ExcelFormat::COLOR_SKYBLUE = 40
ExcelFormat::COLOR_LIGHTTURQUOISE = 41
ExcelFormat::COLOR_LIGHTGREEN = 42
ExcelFormat::COLOR_LIGHTYELLOW = 43
ExcelFormat::COLOR_PALEBLUE = 44
ExcelFormat::COLOR_ROSE = 45
ExcelFormat::COLOR_LAVENDER = 46
ExcelFormat::COLOR_TAN = 47
ExcelFormat::COLOR_LIGHTBLUE = 48
ExcelFormat::COLOR_AQUA = 49
ExcelFormat::COLOR_LIME = 50
ExcelFormat::COLOR_GOLD = 51
ExcelFormat::COLOR_LIGHTORANGE = 52
ExcelFormat::COLOR_ORANGE = 53
ExcelFormat::COLOR_BLUEGRAY = 54
ExcelFormat::COLOR_GRAY40 = 55
ExcelFormat::COLOR_DARKTEAL = 56
ExcelFormat::COLOR_SEAGREEN = 57
ExcelFormat::COLOR_DARKGREEN = 58
ExcelFormat::COLOR_OLIVEGREEN = 59
ExcelFormat::COLOR_BROWN = 60
ExcelFormat::COLOR_PLUM = 61
ExcelFormat::COLOR_INDIGO = 62
ExcelFormat::COLOR_GRAY80 = 63
ExcelFormat::COLOR_DEFAULT_FOREGROUND = 64
ExcelFormat::COLOR_DEFAULT_BACKGROUND = 65
ExcelFormat::NUMFORMAT_GENERAL = 0
ExcelFormat::NUMFORMAT_NUMBER = 1
ExcelFormat::NUMFORMAT_NUMBER_D2 = 2
ExcelFormat::NUMFORMAT_NUMBER_SEP = 3
ExcelFormat::NUMFORMAT_NUMBER_SEP_D2 = 4
ExcelFormat::NUMFORMAT_CURRENCY_NEGBRA = 5
ExcelFormat::NUMFORMAT_CURRENCY_NEGBRARED = 6
ExcelFormat::NUMFORMAT_CURRENCY_D2_NEGBRA = 7
ExcelFormat::NUMFORMAT_CURRENCY_D2_NEGBRARED = 8
ExcelFormat::NUMFORMAT_PERCENT = 9
ExcelFormat::NUMFORMAT_PERCENT_D2 = 10
ExcelFormat::NUMFORMAT_SCIENTIFIC_D2 = 11
ExcelFormat::NUMFORMAT_FRACTION_ONEDIG = 12
ExcelFormat::NUMFORMAT_FRACTION_TWODIG = 13
ExcelFormat::NUMFORMAT_DATE = 14
ExcelFormat::NUMFORMAT_CUSTOM_D_MON_YY = 15
ExcelFormat::NUMFORMAT_CUSTOM_D_MON = 16
ExcelFormat::NUMFORMAT_CUSTOM_MON_YY = 17
ExcelFormat::NUMFORMAT_CUSTOM_HMM_AM = 18
ExcelFormat::NUMFORMAT_CUSTOM_HMMSS_AM = 19
ExcelFormat::NUMFORMAT_CUSTOM_HMM = 20
ExcelFormat::NUMFORMAT_CUSTOM_HMMSS = 21
ExcelFormat::NUMFORMAT_CUSTOM_MDYYYY_HMM = 22
ExcelFormat::NUMFORMAT_NUMBER_SEP_NEGBRA = 37
ExcelFormat::NUMFORMAT_NUMBER_SEP_NEGBRARED = 38
ExcelFormat::NUMFORMAT_NUMBER_D2_SEP_NEGBRA = 39
ExcelFormat::NUMFORMAT_NUMBER_D2_SEP_NEGBRARED = 40
ExcelFormat::NUMFORMAT_ACCOUNT = 41
ExcelFormat::NUMFORMAT_ACCOUNTCUR = 42
ExcelFormat::NUMFORMAT_ACCOUNT_D2 = 43
ExcelFormat::NUMFORMAT_ACCOUNT_D2_CUR = 44
ExcelFormat::NUMFORMAT_CUSTOM_MMSS = 45
ExcelFormat::NUMFORMAT_CUSTOM_H0MMSS = 46
ExcelFormat::NUMFORMAT_CUSTOM_MMSS0 = 47
ExcelFormat::NUMFORMAT_CUSTOM_000P0E_PLUS0 = 48
ExcelFormat::NUMFORMAT_TEXT = 49
ExcelFormat::ALIGNH_GENERAL = 0
ExcelFormat::ALIGNH_LEFT = 1
ExcelFormat::ALIGNH_CENTER = 2
ExcelFormat::ALIGNH_RIGHT = 3
ExcelFormat::ALIGNH_FILL = 4
ExcelFormat::ALIGNH_JUSTIFY = 5
ExcelFormat::ALIGNH_MERGE = 6
ExcelFormat::ALIGNH_DISTRIBUTED = 7
ExcelFormat::ALIGNV_TOP = 0
ExcelFormat::ALIGNV_CENTER = 1
ExcelFormat::ALIGNV_BOTTOM = 2
ExcelFormat::ALIGNV_JUSTIFY = 3
ExcelFormat::ALIGNV_DISTRIBUTED = 4
ExcelFormat::BORDERSTYLE_NONE = 0
ExcelFormat::BORDERSTYLE_THIN = 1
ExcelFormat::BORDERSTYLE_MEDIUM = 2
ExcelFormat::BORDERSTYLE_DASHED = 3
ExcelFormat::BORDERSTYLE_DOTTED = 4
ExcelFormat::BORDERSTYLE_THICK = 5
ExcelFormat::BORDERSTYLE_DOUBLE = 6
ExcelFormat::BORDERSTYLE_HAIR = 7
ExcelFormat::BORDERSTYLE_MEDIUMDASHED = 8
ExcelFormat::BORDERSTYLE_DASHDOT = 9
ExcelFormat::BORDERSTYLE_MEDIUMDASHDOT = 10
ExcelFormat::BORDERSTYLE_DASHDOTDOT = 11
ExcelFormat::BORDERSTYLE_MEDIUMDASHDOTDOT = 12
ExcelFormat::BORDERSTYLE_SLANTDASHDOT = 13
ExcelFormat::BORDERDIAGONAL_NONE = 0
ExcelFormat::BORDERDIAGONAL_DOWN = 1
ExcelFormat::BORDERDIAGONAL_UP = 2
ExcelFormat::BORDERDIAGONAL_BOTH = 3
ExcelFormat::FILLPATTERN_NONE = 0
ExcelFormat::FILLPATTERN_SOLID = 1
ExcelFormat::FILLPATTERN_GRAY50 = 2
ExcelFormat::FILLPATTERN_GRAY75 = 3
ExcelFormat::FILLPATTERN_GRAY25 = 4
ExcelFormat::FILLPATTERN_HORSTRIPE = 5
ExcelFormat::FILLPATTERN_VERSTRIPE = 6
ExcelFormat::FILLPATTERN_REVDIAGSTRIPE = 7
ExcelFormat::FILLPATTERN_DIAGSTRIPE = 8
ExcelFormat::FILLPATTERN_DIAGCROSSHATCH = 9
ExcelFormat::FILLPATTERN_THICKDIAGCROSSHATCH = 10
ExcelFormat::FILLPATTERN_THINHORSTRIPE = 11
ExcelFormat::FILLPATTERN_THINVERSTRIPE = 12
ExcelFormat::FILLPATTERN_THINREVDIAGSTRIPE = 13
ExcelFormat::FILLPATTERN_THINDIAGSTRIPE = 14
ExcelFormat::FILLPATTERN_THINHORCROSSHATCH = 15
ExcelFormat::FILLPATTERN_THINDIAGCROSSHATCH = 16
ExcelFormat::FILLPATTERN_GRAY12P5 = 17
ExcelFormat::FILLPATTERN_GRAY6P25 = 18
getFont( )
setFont( $font )
numberFormat( $format )
horizontalAlign( $align_mode )
verticalAlign( $align_mode )
wrap( $wrap )
rotate( $angle )
indent( $indent )
shrinkToFit( $shrink )
borderStyle( $style )
borderColor( $color )
borderLeftStyle( $style )
borderLeftColor( $color )
borderRightStyle( $style )
borderRightColor( $color )
borderTopStyle( $style )
borderTopColor( $color )
borderBottomStyle( $style )
borderBottomColor( $color )
borderDiagonalStyle( $style )
borderDiagonalColor( $color )
fillPattern( $patern )
patternForegroundColor( $color )
patternBackgroundColor( $color )
locked( $locked )
hidden( $hidden )
ExcelFont
ExcelFont::NORMAL = 0
ExcelFont::SUBSCRIPT = 2
ExcelFont::SUPERSCRIPT = 1
ExcelFont::UNDERLINE_NONE = 0
ExcelFont::UNDERLINE_SINGLE = 1
ExcelFont::UNDERLINE_DOUBLE = 2
ExcelFont::UNDERLINE_SINGLEACC = 33
ExcelFont::UNDERLINE_DOUBLEACC = 34
size( $size )
name( $name )
underline( $underline_style )
mode( $mode )
color( $color )
bold( $bold )
strike( $strike )
italics( $size )