Class PHPExcel_Writer_Excel5_Worksheet
PHPExcel_Writer_Excel5_Worksheet
- PHPExcel_Writer_Excel5_BIFFwriter
- PHPExcel_Writer_Excel5_Worksheet
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Writer/Excel5/Worksheet.php
public
|
#
__construct( integer & $str_total, integer & $str_unique, array & $str_table, array & $colors, mixed $parser, boolean $preCalculateFormulas, string $phpSheet,
Constructor |
public
|
|
private
string
|
#
_writeBIFF8CellRangeAddressFixed( string $range = 'A1' )
Write a cell range address in BIFF8 always fixed range See section 2.5.14 in OpenOffice.org's Documentation of the Microsoft Excel File Format |
public
string
|
|
public
|
#
printRowColHeaders( integer $print = 1 )
Set the option to print the row and column headers on the printed page. |
public
|
#
setOutline( boolean $visible = true, boolean $symbols_below = true, boolean $symbols_right = true, boolean $auto_style = false )
This method sets the properties for outlining and grouping. The defaults correspond to Excel's defaults. |
private
integer
|
#
_writeNumber( integer $row, integer $col, float $num, mixed $xfIndex )
Write a double to the specified row and column (zero indexed). An integer can be written as a double. Excel will display an integer. $format is optional. |
private
|
#
_writeString( integer $row, integer $col, string $str, integer $xfIndex )
Write a LABELSST record or a LABEL record. Which one depends on BIFF version |
private
|
#
_writeRichTextString( integer $row, integer $col, string $str, mixed $xfIndex, array $arrcRun )
Write a LABELSST record or a LABEL record. Which one depends on BIFF version It differs from _writeString by the writing of rich text strings. |
private
integer
|
#
_writeLabel( integer $row, integer $col, string $str, mixed $xfIndex )
Write a string to the specified row and column (zero indexed). NOTE: there is an Excel 5 defined limit of 255 characters. $format is optional. Returns 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars |
private
integer
|
#
_writeLabelSst( integer $row, integer $col, string $str, mixed $xfIndex )
Write a string to the specified row and column (zero indexed). This is the BIFF8 version (no 255 chars limit). $format is optional. Returns 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars |
private
|
#
_writeNote( integer $row, integer $col, string $note )
Writes a note associated with the cell given by the row and column. NOTE records don't have a length limit. |
public
|
#
_writeBlank( integer $row, integer $col, mixed $xfIndex )
Write a blank cell to the specified row and column (zero indexed). A blank cell is used to specify formatting without adding a string or a number. |
private
|
#
_writeBoolErr( integer $row, integer $col, integer $value, boolean $isError, integer $xfIndex )
Write a boolean or an error type to the specified row and column (zero indexed) |
private
integer
|
#
_writeFormula( integer $row, integer $col, string $formula, mixed $xfIndex, mixed $calculatedValue )
Write a formula to the specified row and column (zero indexed). The textual representation of the formula is passed to the parser in Parser.php which returns a packed binary string. |
private
|
|
private
integer
|
#
_writeUrl( integer $row, integer $col, string $url )
Write a hyperlink. This is comprised of two elements: the visible label and the invisible link. The visible label is the same as the link unless an alternative string is specified. The label is written using the _writeString() method. Therefore the 255 characters string limit applies. $string and $format are optional. |
public
integer
|
#
_writeUrlRange( integer $row1, integer $col1, integer $row2, integer $col2, string $url )
This is the more general form of _writeUrl(). It allows a hyperlink to be written to a range of cells. This function also decides the type of hyperlink to be written. These are either, Web (http, ftp, mailto), Internal (Sheet1!A1) or external ('c:\temp\foo.xls#Sheet1!A1'). |
public
integer
|
#
_writeUrlWeb( integer $row1, integer $col1, integer $row2, integer $col2, string $url )
Used to write http, ftp and mailto hyperlinks. The link type ($options) is 0x03 is the same as absolute dir ref without sheet. However it is differentiated by the $unknown2 data stream. |
public
integer
|
#
_writeUrlInternal( integer $row1, integer $col1, integer $row2, integer $col2, string $url )
Used to write internal reference hyperlinks such as "Sheet1!A1". |
public
integer
|
#
_writeUrlExternal( integer $row1, integer $col1, integer $row2, integer $col2, string $url )
Write links to external directory names such as 'c:\foo.xls', c:\foo.xls#Sheet1!A1', '../../foo.xls'. and '../../foo.xls#Sheet1!A1'. |
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
#
_writeExterncount( integer $count )
Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet. |
private
|
#
_writeExternsheet( string $sheetname )
Writes the Excel BIFF EXTERNSHEET record. These references are used by formulas. A formula references a sheet name via an index. Since we store a reference to all of the external worksheets the EXTERNSHEET index is the same as the worksheet index. |
private
|
#
_writePanes( )
Writes the Excel BIFF PANE record. The panes can either be frozen or thawed (unfrozen). Frozen panes are specified in terms of an integer number of rows and columns. Thawed panes are specified in terms of Excel's units for rows and columns. |
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
#
_writePrintGridlines( )
Write the PRINTGRIDLINES BIFF record. Must be used in conjunction with the GRIDSET record. |
private
|
#
_writeGridset( )
Write the GRIDSET BIFF record. Must be used in conjunction with the PRINTGRIDLINES record. |
private
|
#
_writeAutoFilterInfo( )
Write the AUTOFILTERINFO BIFF record. This is used to configure the number of autofilter select used in the sheet. |
private
|
#
_writeGuts( )
Write the GUTS BIFF record. This is used to configure the gutter margins where Excel outline symbols are displayed. The visibility of the gutters is controlled by a flag in WSBOOL. |
private
|
#
_writeWsbool( )
Write the WSBOOL BIFF record, mainly for fit-to-page. Used in conjunction with the SETUP record. |
private
|
|
private
|
|
private
|
|
private
|
|
private
|
|
public
|
#
insertBitmap( integer $row, integer $col, mixed $bitmap, integer $x = 0, integer $y = 0, float $scale_x = 1, float $scale_y = 1 )
Insert a 24bit bitmap image in a worksheet. |
public
|
#
_positionImage( integer $col_start, integer $row_start, integer $x1, integer $y1, integer $width, integer $height )
Calculate the vertices that define the position of the image as required by the OBJ record. |
private
|
#
_writeObjPicture( integer $colL, integer $dxL, integer $rwT, integer $dyT, integer $colR, integer $dxR, integer $rwB, integer $dyB )
Store the OBJ record that precedes an IMDATA record. This could be generalise to support other Excel objects. |
public
array
|
|
public
array
|
#
_processBitmap( string $bitmap )
Convert a 24 bit bitmap into the modified internal format used by Windows. This is described in BITMAPCOREHEADER and BITMAPCOREINFO structures in the MSDN library. |
private
|
#
_writeZoom( )
Store the window zoom factor. This should be a reduced fraction but for simplicity we will store all fractions with a numerator of 100. |
public
|
|
public
|
|
private
|
|
private
|
|
private static
integer
|
|
private
|
|
private
|
|
private
|
_addContinue(),
_append(),
_storeBof(),
_storeEof(),
getByteOrder(),
writeData(),
writeEof()
|
private
|
$_parser
Formula parser |
|
public
integer
|
$_xls_strmax
Maximum number of characters for a string (LABEL record in BIFF5) |
|
public
array
|
$_colinfo
Array containing format information for columns |
|
public
array
|
$_selection
Array containing the selected area for the worksheet |
|
public
integer
|
$_active_pane
The active pane for the worksheet |
|
public
integer
|
$_outline_on
Whether to use outline. |
|
public
boolean
|
$_outline_style
Auto outline styles. |
|
public
boolean
|
$_outline_below
Whether to have outline summary below. |
|
public
boolean
|
$_outline_right
Whether to have outline summary at the right. |
|
public
integer
|
$_str_total
Reference to the total number of strings in the workbook |
|
public
integer
|
$_str_unique
Reference to the number of unique strings in the workbook |
|
public
array
|
$_str_table
Reference to the array containing all the unique strings in the workbook |
|
private
|
$_colors
Color cache |
|
private
integer
|
$_firstRowIndex
Index of first used row (at least 0) |
|
private
integer
|
$_lastRowIndex
Index of last used row. (no used rows means -1) |
|
private
integer
|
$_firstColumnIndex
Index of first used column (at least 0) |
|
private
integer
|
$_lastColumnIndex
Index of last used column (no used columns means -1) |
|
public
|
$_phpSheet
Sheet object |
|
private
integer
|
$_countCellStyleXfs
Count cell style Xfs |
|
private
|
$_escher
Escher object corresponding to MSODRAWING |
|
public
array
|
$_fntHashIndex
Array of font hashes associated to FONT records index |
$_data,
$_datasize,
$_limit
|