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_Worksheet

PHPExcel_Writer_Excel5_Worksheet

PHPExcel_Writer_Excel5_BIFFwriter
Extended by PHPExcel_Writer_Excel5_Worksheet
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/Worksheet.php
Methods summary
public
# __construct( integer & $str_total, integer & $str_unique, array & $str_table, array & $colors, mixed $parser, boolean $preCalculateFormulas, string $phpSheet, PHPExcel_Worksheet $phpSheet,… )

Constructor

Constructor

Parameters

$str_total
$str_total Total number of strings
$str_unique
$str_unique Total number of unique strings
$str_table
$str_table String Table
$colors
$colors Colour Table
$parser
The formula parser created for the Workbook
$preCalculateFormulas
Flag indicating whether formulas should be calculated or just written
$phpSheet
The worksheet to write
$phpSheet,…

Overrides

PHPExcel_Writer_Excel5_BIFFwriter::__construct()
public
# close( )

Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook.

Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook.

See

PHPExcel_Writer_Excel5_Workbook::storeWorkbook()
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

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

Parameters

$range
E.g. 'A1' or 'A1:B6'

Returns

string
Binary data
public string
# getData( )

Retrieves data from memory in one chunk, or from disk in $buffer sized chunks.

Retrieves data from memory in one chunk, or from disk in $buffer sized chunks.

Returns

string
The data
public
# printRowColHeaders( integer $print = 1 )

Set the option to print the row and column headers on the printed page.

Set the option to print the row and column headers on the printed page.

Parameters

$print
Whether to print the headers or not. Defaults to 1 (print).
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.

This method sets the properties for outlining and grouping. The defaults correspond to Excel's defaults.

Parameters

$visible
$symbols_below
$symbols_right
$auto_style
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.

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.

Returns 0 : normal termination -2 : row or column out of range

Parameters

$row
Zero indexed row
$col
Zero indexed column
$num
The number to write
$xfIndex
The optional XF format

Returns

integer
private
# _writeString( integer $row, integer $col, string $str, integer $xfIndex )

Write a LABELSST record or a LABEL record. Which one depends on BIFF version

Write a LABELSST record or a LABEL record. Which one depends on BIFF version

Parameters

$row
Row index (0-based)
$col
Column index (0-based)
$str
The string
$xfIndex
Index to XF record
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.

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.

Parameters

$row
Row index (0-based)
$col
Column index (0-based)
$str
The string
$xfIndex
The XF format index for the cell
$arrcRun
Index to Font record and characters beginning
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

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

Parameters

$row
Zero indexed row
$col
Zero indexed column
$str
The string to write
$xfIndex
The XF format index for the cell

Returns

integer
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

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

Parameters

$row
Zero indexed row
$col
Zero indexed column
$str
The string to write
$xfIndex
The XF format index for the cell

Returns

integer
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.

Writes a note associated with the cell given by the row and column. NOTE records don't have a length limit.

Parameters

$row
Zero indexed row
$col
Zero indexed column
$note
The note to write
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.

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.

A blank cell without a format serves no purpose. Therefore, we don't write a BLANK record unless a format is specified.

Returns 0 : normal termination (including no format) -1 : insufficient number of arguments -2 : row or column out of range

Parameters

$row
Zero indexed row
$col
Zero indexed column
$xfIndex
The XF format index
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)

Write a boolean or an error type to the specified row and column (zero indexed)

Parameters

$row
Row index (0-based)
$col
Column index (0-based)
$value
$isError
Error or Boolean?
$xfIndex
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.

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.

Returns 0 : normal termination -1 : formula errors (bad formula) -2 : row or column out of range

Parameters

$row
Zero indexed row
$col
Zero indexed column
$formula
The formula text string
$xfIndex
The XF format index
$calculatedValue
Calculated value

Returns

integer
private
# _writeStringRecord( string $stringValue )

Write a STRING record. This

Write a STRING record. This

Parameters

$stringValue
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.

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.

The hyperlink can be to a http, ftp, mail, internal sheet (not yet), or external directory url.

Returns 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars

Parameters

$row
Row
$col
Column
$url
URL string

Returns

integer
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').

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').

Parameters

$row1
Start row
$col1
Start column
$row2
End row
$col2
End column
$url
URL string

Returns

integer

See

PHPExcel_Writer_Excel5_Worksheet::_writeUrl()
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.

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.

Parameters

$row1
Start row
$col1
Start column
$row2
End row
$col2
End column
$url
URL string

Returns

integer

See

PHPExcel_Writer_Excel5_Worksheet::_writeUrl()
public integer
# _writeUrlInternal( integer $row1, integer $col1, integer $row2, integer $col2, string $url )

Used to write internal reference hyperlinks such as "Sheet1!A1".

Used to write internal reference hyperlinks such as "Sheet1!A1".

Parameters

$row1
Start row
$col1
Start column
$row2
End row
$col2
End column
$url
URL string

Returns

integer

See

PHPExcel_Writer_Excel5_Worksheet::_writeUrl()
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'.

Write links to external directory names such as 'c:\foo.xls', c:\foo.xls#Sheet1!A1', '../../foo.xls'. and '../../foo.xls#Sheet1!A1'.

Note: Excel writes some relative links with the $dir_long string. We ignore these cases for the sake of simpler code.

Parameters

$row1
Start row
$col1
Start column
$row2
End row
$col2
End column
$url
URL string

Returns

integer

See

PHPExcel_Writer_Excel5_Worksheet::_writeUrl()
private
# _writeRow( integer $row, integer $height, integer $xfIndex, boolean $hidden = false, integer $level = 0 )

This method is used to set the height and format for a row.

This method is used to set the height and format for a row.

Parameters

$row
The row to set
$height

Height we are giving to the row. Use null to set XF without setting height

$xfIndex
The optional cell style Xf index to apply to the columns
$hidden
The optional hidden attribute
$level
The optional outline level for row, in range [0,7]
private
# _writeDimensions( )

Writes Excel DIMENSIONS to define the area in which there is data.

Writes Excel DIMENSIONS to define the area in which there is data.

private
# _writeWindow2( )

Write BIFF record Window2.

Write BIFF record Window2.

private
# _writeDefaultRowHeight( )

Write BIFF record DEFAULTROWHEIGHT.

Write BIFF record DEFAULTROWHEIGHT.

private
# _writeDefcol( )

Write BIFF record DEFCOLWIDTH if COLINFO records are in use.

Write BIFF record DEFCOLWIDTH if COLINFO records are in use.

private
# _writeColinfo( array $col_array )

Write BIFF record COLINFO to define column widths

Write BIFF record COLINFO to define column widths

Note: The SDK says the record length is 0x0B but Excel writes a 0x0C length record.

Parameters

$col_array

This is the only parameter received and is composed of the following: 0 => First formatted column, 1 => Last formatted column, 2 => Col width (8.43 is Excel default), 3 => The optional XF format of the column, 4 => Option flags. 5 => Optional outline level

private
# _writeSelection( )

Write BIFF record SELECTION.

Write BIFF record SELECTION.

private
# _writeMergedCells( )

Store the MERGEDCELLS records for all ranges of merged cells

Store the MERGEDCELLS records for all ranges of merged cells

private
# _writeSheetLayout( )

Write SHEETLAYOUT record

Write SHEETLAYOUT record

private
# _writeSheetProtection( )

Write SHEETPROTECTION

Write SHEETPROTECTION

private
# _writeRangeProtection( )

Write BIFF record RANGEPROTECTION

Write BIFF record RANGEPROTECTION

Openoffice.org's Documentaion of the Microsoft Excel File Format uses term RANGEPROTECTION for these records Microsoft Office Excel 97-2007 Binary File Format Specification uses term FEAT for these records

private
# _writeExterncount( integer $count )

Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet.

Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet.

Excel only stores references to external sheets that are used in formulas. For simplicity we store references to all the sheets in the workbook regardless of whether they are used or not. This reduces the overall complexity and eliminates the need for a two way dialogue between the formula parser the worksheet objects.

Parameters

$count
The number of external sheet references in this 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.

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.

Parameters

$sheetname
The name of a external worksheet
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.

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
# _writeSetup( )

Store the page setup SETUP BIFF record.

Store the page setup SETUP BIFF record.

private
# _writeHeader( )

Store the header caption BIFF record.

Store the header caption BIFF record.

private
# _writeFooter( )

Store the footer caption BIFF record.

Store the footer caption BIFF record.

private
# _writeHcenter( )

Store the horizontal centering HCENTER BIFF record.

Store the horizontal centering HCENTER BIFF record.

private
# _writeVcenter( )

Store the vertical centering VCENTER BIFF record.

Store the vertical centering VCENTER BIFF record.

private
# _writeMarginLeft( )

Store the LEFTMARGIN BIFF record.

Store the LEFTMARGIN BIFF record.

private
# _writeMarginRight( )

Store the RIGHTMARGIN BIFF record.

Store the RIGHTMARGIN BIFF record.

private
# _writeMarginTop( )

Store the TOPMARGIN BIFF record.

Store the TOPMARGIN BIFF record.

private
# _writeMarginBottom( )

Store the BOTTOMMARGIN BIFF record.

Store the BOTTOMMARGIN BIFF record.

private
# _writePrintHeaders( )

Write the PRINTHEADERS BIFF record.

Write the PRINTHEADERS BIFF record.

private
# _writePrintGridlines( )

Write the PRINTGRIDLINES BIFF record. Must be used in conjunction with the GRIDSET record.

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.

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.

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.

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.

See

PHPExcel_Writer_Excel5_Worksheet::_writeWsbool()
private
# _writeWsbool( )

Write the WSBOOL BIFF record, mainly for fit-to-page. Used in conjunction with the SETUP record.

Write the WSBOOL BIFF record, mainly for fit-to-page. Used in conjunction with the SETUP record.

private
# _writeBreaks( )

Write the HORIZONTALPAGEBREAKS and VERTICALPAGEBREAKS BIFF records.

Write the HORIZONTALPAGEBREAKS and VERTICALPAGEBREAKS BIFF records.

private
# _writeProtect( )

Set the Biff PROTECT record to indicate that the worksheet is protected.

Set the Biff PROTECT record to indicate that the worksheet is protected.

private
# _writeScenProtect( )

Write SCENPROTECT

Write SCENPROTECT

private
# _writeObjectProtect( )

Write OBJECTPROTECT

Write OBJECTPROTECT

private
# _writePassword( )

Write the worksheet PASSWORD record.

Write the worksheet PASSWORD record.

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.

Insert a 24bit bitmap image in a worksheet.

Parameters

$row
The row we are going to insert the bitmap into
$col
The column we are going to insert the bitmap into
$bitmap
The bitmap filename or GD-image resource
$x
The horizontal position (offset) of the image inside the cell.
$y
The vertical position (offset) of the image inside the cell.
$scale_x
The horizontal scale
$scale_y
The vertical scale
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.

Calculate the vertices that define the position of the image as required by the OBJ record.

+------------+------------+ | A | B | +-----+------------+------------+ | |(x1,y1) | | | 1 |(A1)._______|______ | | | | | | | | | | | +-----+----| BITMAP |-----+ | | | | | | 2 | |______________. | | | | (B2)| | | | (x2,y2)| +---- +------------+------------+

Example of a bitmap that covers some of the area from cell A1 to cell B2.

Based on the width and height of the bitmap we need to calculate 8 vars: $col_start, $row_start, $col_end, $row_end, $x1, $y1, $x2, $y2. The width and height of the cells are also variable and have to be taken into account. The values of $col_start and $row_start are passed in from the calling function. The values of $col_end and $row_end are calculated by subtracting the width and height of the bitmap from the width and height of the underlying cells. The vertices are expressed as a percentage of the underlying cell width as follows (rhs values are in pixels): x1 = X / W *1024 y1 = Y / H *256 x2 = (X-1) / W *1024 y2 = (Y-1) / H *256 Where: X is distance from the left side of the underlying cell Y is distance from the top of the underlying cell W is the width of the cell H is the height of the cell The SDK incorrectly states that the height should be expressed as a percentage of 1024.

Parameters

$col_start
Col containing upper left corner of object
$row_start
Row containing top left corner of object
$x1
Distance to left side of object
$y1
Distance to top of object
$width
Width of image frame
$height
Height of image frame
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.

Store the OBJ record that precedes an IMDATA record. This could be generalise to support other Excel objects.

Parameters

$colL
Column containing upper left corner of object
$dxL
Distance from left side of cell
$rwT
Row containing top left corner of object
$dyT
Distance from top of cell
$colR
Column containing lower right corner of object
$dxR
Distance from right of cell
$rwB
Row containing bottom right corner of object
$dyB
Distance from bottom of cell
public array
# _processBitmapGd( resource $image )

Convert a GD-image into the internal format.

Convert a GD-image into the internal format.

Parameters

$image
The image to process

Returns

array
Array with data and properties of the bitmap
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.

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.

Parameters

$bitmap
The bitmap to process

Returns

array
Array with data and properties of the bitmap
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.

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 PHPExcel_Shared_Escher
# getEscher( )

Get Escher object

Get Escher object

Returns

PHPExcel_Shared_Escher
public
# setEscher( PHPExcel_Shared_Escher $pValue = null )

Set Escher object

Set Escher object

Parameters

$pValue
private
# _writeMsoDrawing( )

Write MSODRAWING record

Write MSODRAWING record

private
# _writeDataValidity( )

Store the DATAVALIDATIONS and DATAVALIDATION records.

Store the DATAVALIDATIONS and DATAVALIDATION records.

private static integer
# _mapErrorCode( string $errorCode )

Map Error code

Map Error code

Parameters

$errorCode

Returns

integer
private
# _writePageLayoutView( )

Write PLV Record

Write PLV Record

private
# _writeCFRule( PHPExcel_Style_Conditional $conditional )

Write CFRule Record

Write CFRule Record

Parameters

$conditional
private
# _writeCFHeader( )

Write CFHeader record

Write CFHeader record

Methods inherited from PHPExcel_Writer_Excel5_BIFFwriter
_addContinue(), _append(), _storeBof(), _storeEof(), getByteOrder(), writeData(), writeEof()
Properties summary
private PHPExcel_Writer_Excel5_Parser $_parser

Formula parser

Formula parser

#
public integer $_xls_strmax

Maximum number of characters for a string (LABEL record in BIFF5)

Maximum number of characters for a string (LABEL record in BIFF5)

#
public array $_colinfo

Array containing format information for columns

Array containing format information for columns

#
public array $_selection

Array containing the selected area for the worksheet

Array containing the selected area for the worksheet

#
public integer $_active_pane

The active pane for the worksheet

The active pane for the worksheet

#
public integer $_outline_on

Whether to use outline.

Whether to use outline.

#
public boolean $_outline_style

Auto outline styles.

Auto outline styles.

#
public boolean $_outline_below

Whether to have outline summary below.

Whether to have outline summary below.

#
public boolean $_outline_right

Whether to have outline summary at the right.

Whether to have outline summary at the right.

#
public integer $_str_total

Reference to the total number of strings in the workbook

Reference to the total number of strings in the workbook

#
public integer $_str_unique

Reference to the number of unique strings in the workbook

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

Reference to the array containing all the unique strings in the workbook

#
private $_colors

Color cache

Color cache

#
private integer $_firstRowIndex

Index of first used row (at least 0)

Index of first used row (at least 0)

#
private integer $_lastRowIndex

Index of last used row. (no used rows means -1)

Index of last used row. (no used rows means -1)

#
private integer $_firstColumnIndex

Index of first used column (at least 0)

Index of first used column (at least 0)

#
private integer $_lastColumnIndex

Index of last used column (no used columns means -1)

Index of last used column (no used columns means -1)

#
public PHPExcel_Worksheet $_phpSheet

Sheet object

Sheet object

#
private integer $_countCellStyleXfs

Count cell style Xfs

Count cell style Xfs

#
private PHPExcel_Shared_Escher $_escher

Escher object corresponding to MSODRAWING

Escher object corresponding to MSODRAWING

#
public array $_fntHashIndex

Array of font hashes associated to FONT records index

Array of font hashes associated to FONT records index

#
Properties inherited from PHPExcel_Writer_Excel5_BIFFwriter
$_data, $_datasize, $_limit
Autene API documentation generated by ApiGen