Overview

Packages

  • JAMA
  • None
  • PHP
  • PHPExcel
    • CachedObjectStorage
    • Calculation
    • Cell
    • Chart
      • Renderer
    • Reader
      • Excel2007
      • Excel5
    • RichText
    • Settings
    • Shared
      • Escher
      • OLE
      • Trend
      • ZipArchive
    • Style
    • Worksheet
      • Drawing
    • Writer
      • 2007
      • CSV
      • Excel2007
      • Excel5
      • HTML
      • PDF

Classes

  • PHPExcel_Writer_Excel5
  • PHPExcel_Writer_Excel5_BIFFwriter
  • PHPExcel_Writer_Excel5_Escher
  • PHPExcel_Writer_Excel5_Font
  • PHPExcel_Writer_Excel5_Parser
  • PHPExcel_Writer_Excel5_Workbook
  • PHPExcel_Writer_Excel5_Worksheet
  • PHPExcel_Writer_Excel5_Xf
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo
  • Download

Class PHPExcel_Writer_Excel5_Xf

PHPExcel_Writer_Excel5_Xf

Package: PHPExcel\Writer\Excel5
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Writer/Excel5/Xf.php
Methods summary
public
# __construct( PHPExcel_Style $style = null )

Constructor

Constructor

Parameters

$style
XF format
public string
# writeXf( )

Generate an Excel BIFF XF record (style or cell).

Generate an Excel BIFF XF record (style or cell).

Returns

string
The XF record
public
# setIsStyleXf( boolean $value )

Is this a style XF ?

Is this a style XF ?

Parameters

$value
public
# setBottomColor( integer $colorIndex )

Sets the cell's bottom border color

Sets the cell's bottom border color

Parameters

$colorIndex
Color index
public
# setTopColor( integer $colorIndex )

Sets the cell's top border color

Sets the cell's top border color

Parameters

$colorIndex
Color index
public
# setLeftColor( integer $colorIndex )

Sets the cell's left border color

Sets the cell's left border color

Parameters

$colorIndex
Color index
public
# setRightColor( integer $colorIndex )

Sets the cell's right border color

Sets the cell's right border color

Parameters

$colorIndex
Color index
public
# setDiagColor( integer $colorIndex )

Sets the cell's diagonal border color

Sets the cell's diagonal border color

Parameters

$colorIndex
Color index
public
# setFgColor( integer $colorIndex )

Sets the cell's foreground color

Sets the cell's foreground color

Parameters

$colorIndex
Color index
public
# setBgColor( integer $colorIndex )

Sets the cell's background color

Sets the cell's background color

Parameters

$colorIndex
Color index
public
# setNumberFormatIndex( integer $numberFormatIndex )

Sets the index to the number format record It can be date, time, currency, etc...

Sets the index to the number format record It can be date, time, currency, etc...

Parameters

$numberFormatIndex
Index to format record
public
# setFontIndex( integer $value )

Set the font index.

Set the font index.

Parameters

$value
Font index, note that value 4 does not exist
private static integer
# _mapBorderStyle( string $borderStyle )

Map border style

Map border style

Parameters

$borderStyle

Returns

integer
private static integer
# _mapFillType( string $fillType )

Map fill type

Map fill type

Parameters

$fillType

Returns

integer
private integer
# _mapHAlign( string $hAlign )

Map to BIFF2-BIFF8 codes for horizontal alignment

Map to BIFF2-BIFF8 codes for horizontal alignment

Parameters

$hAlign

Returns

integer
private static integer
# _mapVAlign( string $vAlign )

Map to BIFF2-BIFF8 codes for vertical alignment

Map to BIFF2-BIFF8 codes for vertical alignment

Parameters

$vAlign

Returns

integer
private static integer
# _mapTextRotation( integer $textRotation )

Map to BIFF8 codes for text rotation angle

Map to BIFF8 codes for text rotation angle

Parameters

$textRotation

Returns

integer
private static integer
# _mapLocked( string $locked )

Map locked

Map locked

Parameters

$locked

Returns

integer
private static integer
# _mapHidden( string $hidden )

Map hidden

Map hidden

Parameters

$hidden

Returns

integer
Properties summary
private boolean $_isStyleXf

Style XF or a cell XF ?

Style XF or a cell XF ?

#
private integer $_fontIndex

Index to the FONT record. Index 4 does not exist

Index to the FONT record. Index 4 does not exist

#
public integer $_numberFormatIndex

An index (2 bytes) to a FORMAT record (number format).

An index (2 bytes) to a FORMAT record (number format).

#
public integer $_text_justlast

1 bit, apparently not used.

1 bit, apparently not used.

#
public integer $_fg_color

The cell's foreground color.

The cell's foreground color.

#
public integer $_bg_color

The cell's background color.

The cell's background color.

#
public integer $_bottom_color

Color of the bottom border of the cell.

Color of the bottom border of the cell.

#
public integer $_top_color

Color of the top border of the cell.

Color of the top border of the cell.

#
public integer $_left_color

Color of the left border of the cell.

Color of the left border of the cell.

#
public integer $_right_color

Color of the right border of the cell.

Color of the right border of the cell.

#
private static array $_mapBorderStyle

Map of BIFF2-BIFF8 codes for border styles

Map of BIFF2-BIFF8 codes for border styles

# array ( PHPExcel_Style_Border::BORDER_NONE => 0x00, PHPExcel_Style_Border::BORDER_THIN => 0x01, PHPExcel_Style_Border::BORDER_MEDIUM => 0x02, PHPExcel_Style_Border::BORDER_DASHED => 0x03, PHPExcel_Style_Border::BORDER_DOTTED => 0x04, PHPExcel_Style_Border::BORDER_THICK => 0x05, PHPExcel_Style_Border::BORDER_DOUBLE => 0x06, PHPExcel_Style_Border::BORDER_HAIR => 0x07, PHPExcel_Style_Border::BORDER_MEDIUMDASHED => 0x08, PHPExcel_Style_Border::BORDER_DASHDOT => 0x09, PHPExcel_Style_Border::BORDER_MEDIUMDASHDOT => 0x0A, PHPExcel_Style_Border::BORDER_DASHDOTDOT => 0x0B, PHPExcel_Style_Border::BORDER_MEDIUMDASHDOTDOT => 0x0C, PHPExcel_Style_Border::BORDER_SLANTDASHDOT => 0x0D, )
private static array $_mapFillType

Map of BIFF2-BIFF8 codes for fill types

Map of BIFF2-BIFF8 codes for fill types

# array( PHPExcel_Style_Fill::FILL_NONE => 0x00, PHPExcel_Style_Fill::FILL_SOLID => 0x01, PHPExcel_Style_Fill::FILL_PATTERN_MEDIUMGRAY => 0x02, PHPExcel_Style_Fill::FILL_PATTERN_DARKGRAY => 0x03, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRAY => 0x04, PHPExcel_Style_Fill::FILL_PATTERN_DARKHORIZONTAL => 0x05, PHPExcel_Style_Fill::FILL_PATTERN_DARKVERTICAL => 0x06, PHPExcel_Style_Fill::FILL_PATTERN_DARKDOWN => 0x07, PHPExcel_Style_Fill::FILL_PATTERN_DARKUP => 0x08, PHPExcel_Style_Fill::FILL_PATTERN_DARKGRID => 0x09, PHPExcel_Style_Fill::FILL_PATTERN_DARKTRELLIS => 0x0A, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTHORIZONTAL => 0x0B, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTVERTICAL => 0x0C, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTDOWN => 0x0D, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTUP => 0x0E, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRID => 0x0F, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTTRELLIS => 0x10, PHPExcel_Style_Fill::FILL_PATTERN_GRAY125 => 0x11, PHPExcel_Style_Fill::FILL_PATTERN_GRAY0625 => 0x12, PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR => 0x00, // does not exist in BIFF8 PHPExcel_Style_Fill::FILL_GRADIENT_PATH => 0x00, // does not exist in BIFF8 )
private static array $_mapHAlign

Map of BIFF2-BIFF8 codes for horizontal alignment

Map of BIFF2-BIFF8 codes for horizontal alignment

# array( PHPExcel_Style_Alignment::HORIZONTAL_GENERAL => 0, PHPExcel_Style_Alignment::HORIZONTAL_LEFT => 1, PHPExcel_Style_Alignment::HORIZONTAL_CENTER => 2, PHPExcel_Style_Alignment::HORIZONTAL_RIGHT => 3, PHPExcel_Style_Alignment::HORIZONTAL_FILL => 4, PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY => 5, PHPExcel_Style_Alignment::HORIZONTAL_CENTER_CONTINUOUS => 6, )
private static array $_mapVAlign

Map of BIFF2-BIFF8 codes for vertical alignment

Map of BIFF2-BIFF8 codes for vertical alignment

# array( PHPExcel_Style_Alignment::VERTICAL_TOP => 0, PHPExcel_Style_Alignment::VERTICAL_CENTER => 1, PHPExcel_Style_Alignment::VERTICAL_BOTTOM => 2, PHPExcel_Style_Alignment::VERTICAL_JUSTIFY => 3, )
Autene API documentation generated by ApiGen