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
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
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
size( $size )
name( $name )
underline( $underline_style )
mode( $mode )
color( $color )
bold( $bold )
strike( $strike )
italics( $size )