Class PHPExcel_Writer_Excel5_Workbook
PHPExcel_Writer_Excel5_Workbook
- PHPExcel_Writer_Excel5_BIFFwriter
- PHPExcel_Writer_Excel5_Workbook
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Writer/Excel5/Workbook.php
public
|
#
__construct(
Class constructor |
public
integer
|
|
public
integer
|
|
private
integer
|
|
public
|
|
public
string
|
#
writeWorkbook( array $pWorksheetSizes = null )
Assemble worksheets into a workbook and send the BIFF data to an OLE storage. |
public
|
|
private
|
|
private
|
|
private
|
|
private
|
|
private
|
#
_writeExterns( )
Write the EXTERNCOUNT and EXTERNSHEET records. These are used as indexes for the NAME records. |
private
|
|
private
|
#
_writeAllDefinedNamesBiff8( )
Writes all the DEFINEDNAME records (BIFF8). So far this is only used for repeating rows/columns (print titles) and print areas |
private
string
|
#
_writeDefinedNameBiff8( string $name, string $formulaData, string $sheetIndex = 0, boolean $isBuiltIn = false )
Write a DEFINEDNAME record for BIFF8 using explicit binary formula data |
private
string
|
#
_writeShortNameBiff8( string $name, string $sheetIndex, integer[][] $rangeBounds, boolean $isHidden = false )
Write a short NAME record |
private
|
|
private
|
|
private
|
#
_writeBoundsheet(
Writes Excel BIFF BOUNDSHEET record. |
private
|
|
private
|
#
_writeExternsheetBiff8( )
Writes the Excel BIFF EXTERNSHEET record. These references are used by formulas. |
private
|
|
private
|
#
_writeNumFormat( string $format, integer $ifmt )
Writes Excel FORMAT record for non "built-in" numerical formats. |
private
|
|
private
|
#
_writeExterncount( integer $cxals )
Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in the workbook. |
private
|
#
_writeExternsheet( string $sheetname )
Writes the Excel BIFF EXTERNSHEET record. These references are used by formulas. NAME record is required to define the print area and the repeat rows and columns. |
private
|
#
_writeNameShort( integer $index, integer $type, integer $rowmin, integer $rowmax, integer $colmin, integer $colmax )
Store the NAME record in the short format that is used for storing the print area, repeat rows only and repeat columns only. |
private
|
#
_writeNameLong( integer $index, integer $type, integer $rowmin, integer $rowmax, integer $colmin, integer $colmax )
Store the NAME record in the long format that is used for storing the repeat rows and columns when both are specified. This shares a lot of code with _writeNameShort() but we use a separate method to keep the code clean. Code abstraction for reuse can be carried too far, and I should know. ;-) |
private
string
|
|
private
string
|
|
private
|
|
private
string
|
#
_writeSharedStringsTable( )
Handling of the SST continue blocks is complicated by the need to include an additional continuation byte depending on whether the string is split between blocks or whether it starts at the beginning of the block. (There are also additional complications that will arise later when/if Rich Strings are supported). |
private
|
#
_writeMsoDrawingGroup( )
Writes the MSODRAWINGGROUP record if needed. Possibly split using CONTINUE records. |
public
|
|
public
|
_addContinue(),
_append(),
_storeBof(),
_storeEof(),
getByteOrder(),
writeData(),
writeEof()
|
private
|
$_parser
Formula parser |
|
public
integer
|
$_biffsize
The BIFF file size for the workbook. |
|
private
|
$_xfWriters
XF Writers |
#
array()
|
public
array
|
$_palette
Array containing the colour palette |
|
public
integer
|
$_codepage
The codepage indicates the text encoding used for strings |
|
public
integer
|
$_country_code
The country code used for localization |
|
private
|
$_phpExcel
Workbook |
|
private
|
$_fontWriters
Fonts writers |
#
array()
|
private
array
|
$_addedFonts
Added fonts. Maps from font's hash => index in workbook |
#
array()
|
private
array
|
$_numberFormats
Shared number formats |
#
array()
|
private
array
|
$_addedNumberFormats
Added number formats. Maps from numberFormat's hash => index in workbook |
#
array()
|
private
array
|
$_worksheetSizes
Sizes of the binary worksheet streams |
#
array()
|
private
array
|
$_worksheetOffsets
Offsets of the binary worksheet streams relative to the start of the global workbook stream |
#
array()
|
private
integer
|
$_str_total
Total number of shared strings in workbook |
|
private
integer
|
$_str_unique
Number of unique shared strings in workbook |
|
private
array
|
$_str_table
Array of unique shared strings in workbook |
|
private
|
$_colors
Color cache |
|
private
|
$_escher
Escher object corresponding to MSODRAWINGGROUP |
$_data,
$_datasize,
$_limit
|