PHPExcel_Writer_Excel5
[ class tree: PHPExcel_Writer_Excel5 ] [ index: PHPExcel_Writer_Excel5 ] [ all elements ]
Packages:
default
com-tecnick-tcpdf
JAMA
Math_Stats
PHPExcel
PHPExcel_Calculation
PHPExcel_Cell
PHPExcel_Reader
PHPExcel_Reader_Excel5
PHPExcel_RichText
PHPExcel_Shared
PHPExcel_Shared_Best_Fit
PHPExcel_Shared_Escher
PHPExcel_Shared_OLE
PHPExcel_Style
PHPExcel_Worksheet
PHPExcel_Worksheet_Drawing
PHPExcel_Writer
PHPExcel_Writer_Excel5
PHPExcel_Writer_Excel2007


Files:
BIFFwriter.php
Escher.php
Excel5.php
Font.php
Parser.php
Workbook.php
Worksheet.php
Xf.php

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

Class: PHPExcel_Writer_Excel5_Workbook

Source Location: /PHPExcel/Writer/Excel5/Workbook.php

Class Overview

PHPExcel_Writer_Excel5_BIFFwriter
   |
   --PHPExcel_Writer_Excel5_Workbook

Class for generating Excel Spreadsheets


Author(s):

Variables

Methods

Inherited Variables

Class: PHPExcel_Writer_Excel5_BIFFwriter

PHPExcel_Writer_Excel5_BIFFwriter::$_BIFF_version
PHPExcel_Writer_Excel5_BIFFwriter::$_byte_order
PHPExcel_Writer_Excel5_BIFFwriter::$_data
PHPExcel_Writer_Excel5_BIFFwriter::$_datasize
PHPExcel_Writer_Excel5_BIFFwriter::$_limit

Inherited Methods

Class: PHPExcel_Writer_Excel5_BIFFwriter

PHPExcel_Writer_Excel5_BIFFwriter::PHPExcel_Writer_Excel5_BIFFwriter()
Constructor
PHPExcel_Writer_Excel5_BIFFwriter::writeData()
General storage function like _append, but returns string instead of modifying $this->_data
PHPExcel_Writer_Excel5_BIFFwriter::writeEof()
Writes Excel EOF record to indicate the end of a BIFF stream.
PHPExcel_Writer_Excel5_BIFFwriter::_addContinue()
Excel limits the size of BIFF records. Excel 97 the limit is 8228 bytes. must be split up into CONTINUE blocks.
PHPExcel_Writer_Excel5_BIFFwriter::_append()
General storage function
PHPExcel_Writer_Excel5_BIFFwriter::_setByteOrder()
Determine the byte order and store it as class data to avoid recalculating it for each call to new().
PHPExcel_Writer_Excel5_BIFFwriter::_storeBof()
Writes Excel BOF record to indicate the beginning of a stream or sub-stream in the BIFF file.
PHPExcel_Writer_Excel5_BIFFwriter::_storeEof()
Writes Excel EOF record to indicate the end of a BIFF stream.

Class Details

[line 88]
Class for generating Excel Spreadsheets

Class for generating Excel Spreadsheets




Tags:

author:  Xavier Noguer <xnoguer@rezebra.com>


[ Top ]

Class Variables

$_addedFonts = array()

[line 175]

Added fonts.

Added fonts. Maps from font's hash => index in workbook




Tags:

access:  private

Type:   array


[ Top ]

$_addedNumberFormats = array()

[line 189]

Added number formats.

Added number formats. Maps from numberFormat's hash => index in workbook




Tags:

access:  private

Type:   array


[ Top ]

$_biffsize =

[line 114]

The BIFF file size for the workbook.

The BIFF file size for the workbook.




Tags:

see:  PHPExcel_Writer_Excel5_Workbook::_calcSheetOffsets()
access:  private

Type:   integer


[ Top ]

$_codepage =

[line 138]

The codepage indicates the text encoding used for strings

The codepage indicates the text encoding used for strings




Tags:

access:  private

Type:   integer


[ Top ]

$_colors = array()

[line 161]

Color cache

Color cache




Tags:

access:  private

Type:   mixed


[ Top ]

$_country_code =

[line 144]

The country code used for localization

The country code used for localization




Tags:

access:  private

Type:   integer


[ Top ]

$_fileclosed =

[line 107]

Flag for preventing close from being called twice.

Flag for preventing close from being called twice.




Tags:

see:  PHPExcel_Writer_Excel5_Workbook::close()
access:  private

Type:   integer


[ Top ]

$_filename =

[line 94]

Filename for the Workbook

Filename for the Workbook




Tags:

access:  private

Type:   string


[ Top ]

$_fontWriters = array()

[line 168]

Fonts writers

Fonts writers




Tags:

access:  private

Type:   PHPExcel_Writer_Excel5_Font[]


[ Top ]

$_numberFormats = array()

[line 182]

Shared number formats

Shared number formats




Tags:

access:  private

Type:   array


[ Top ]

$_palette =

[line 132]

Array containing the colour palette

Array containing the colour palette




Tags:

access:  private

Type:   array


[ Top ]

$_parser =

[line 100]

Formula parser

Formula parser




Tags:

access:  private

Type:   object Parser


[ Top ]

$_phpExcel =

[line 156]

Workbook

Workbook




Tags:

access:  private

Type:   PHPExcel


[ Top ]

$_tmp_dir =

[line 150]

The temporary dir for storing the OLE file

The temporary dir for storing the OLE file




Tags:

access:  private

Type:   string


[ Top ]

$_worksheets =

[line 120]

Array containing references to all of this workbook's worksheets

Array containing references to all of this workbook's worksheets




Tags:

access:  private

Type:   array


[ Top ]

$_xfWriters = array()

[line 126]

XF Writers

XF Writers




Tags:

access:  private

Type:   PHPExcel_Writer_Excel5_Xf[]


[ Top ]


Class Methods

constructor PHPExcel_Writer_Excel5_Workbook [line 198]

PHPExcel_Writer_Excel5_Workbook PHPExcel_Writer_Excel5_Workbook( string $filename, PHPExcel $phpExcel)

Class constructor

Class constructor




Tags:

access:  public


Parameters:

PHPExcel   $phpExcel   The Workbook
string   $filename   filename for storing the workbook. "-" for writing to stdout.

[ Top ]

method addWorksheet [line 279]

mixed &addWorksheet( [PHPExcel_Worksheet $phpSheet = null], &$xfIndexes, array $xfIndexes)

Add a new worksheet to the Excel workbook.

Add a new worksheet to the Excel workbook. If no name is given the name of the worksheet will be Sheeti$i, with $i in [1..].




Tags:

return:  reference to a worksheet object on success
access:  public


Parameters:

PHPExcel_Worksheet   $phpSheet  
array   $xfIndexes  
   &$xfIndexes  

[ Top ]

method addXfWriter [line 320]

int addXfWriter( PHPExcel_Style $style, [boolean $isStyleXf = false])

Add a new XF writer

Add a new XF writer




Tags:

return:  Index to XF record
access:  public


Parameters:

PHPExcel_Style   $style  
boolean   $isStyleXf   Is it a style XF?

[ Top ]

method close [line 228]

mixed close( )

Calls finalization methods.

Calls finalization methods. This method should always be the last one to be called on every workbook




Tags:

return:  true on success
access:  public


[ Top ]

method setTempDir [line 559]

true setTempDir( string $dir)

Sets the temp dir used for storing the OLE file

Sets the temp dir used for storing the OLE file




Tags:

return:  if given dir is valid, false otherwise
access:  public


Parameters:

string   $dir   The dir to be used as temp dir

[ Top ]

method setVersion [line 251]

void setVersion( integer $version)

Sets the BIFF version.

Sets the BIFF version. This method exists just to access experimental functionality from BIFF8. It will be deprecated ! Only possible value is 8 (Excel 97/2000). For any other value it fails silently.




Tags:

access:  public


Parameters:

integer   $version   The BIFF version

[ Top ]

method writeAllDefinedNamesBiff8 [line 772]

void writeAllDefinedNamesBiff8( )

Writes all the DEFINEDNAME records (BIFF8).

Writes all the DEFINEDNAME records (BIFF8). So far this is only used for repeating rows/columns (print titles) and print areas




Tags:

access:  public


[ Top ]

method writeCountry [line 1286]

string writeCountry( )

Stores the COUNTRY record for localization

Stores the COUNTRY record for localization




Tags:

access:  public


[ Top ]

method writeDefinedNameBiff8 [line 863]

string writeDefinedNameBiff8( string $name, string $formulaData, [string $sheetIndex = 0], [boolean $isBuiltIn = false])

Write a DEFINEDNAME record for BIFF8 using explicit binary formula data

Write a DEFINEDNAME record for BIFF8 using explicit binary formula data




Tags:

return:  Complete binary record data
access:  public


Parameters:

string   $name   The name in UTF-8
string   $formulaData   The binary formula data
string   $sheetIndex   1-based sheet index the defined name applies to. 0 = global
boolean   $isBuiltIn   Built-in name?

[ Top ]

method writeExternsheetBiff8 [line 1000]

void writeExternsheetBiff8( string $sheetname)

Writes the Excel BIFF EXTERNSHEET record. formulas.

Writes the Excel BIFF EXTERNSHEET record. These references are used by formulas.




Tags:

access:  public


Parameters:

string   $sheetname   Worksheet name

[ Top ]

method writeMsoDrawingGroup [line 1459]

void writeMsoDrawingGroup( )

Writes the MSODRAWINGGROUP record if needed.

Writes the MSODRAWINGGROUP record if needed. Possibly split using CONTINUE records.




Tags:

access:  public


[ Top ]

method writeSharedStringsTable [line 1337]

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. additional complications that will arise later when/if Rich Strings are supported).

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). The Excel documentation says that the SST record should be followed by an EXTSST record. The EXTSST record is a hash table that is used to optimise access to SST. However, despite the documentation it doesn't seem to be required so we will ignore it.




Tags:

return:  Binary data
access:  public


[ Top ]

method writeSupbookInternal [line 981]

void writeSupbookInternal( )

Write Internal SUPBOOK record

Write Internal SUPBOOK record




Tags:

access:  public


[ Top ]

method _addColor [line 384]

int _addColor( string $rgb)

Alter color palette adding a custom color

Alter color palette adding a custom color




Tags:

return:  Color index
access:  private


Parameters:

string   $rgb   E.g. 'FF00AA'

[ Top ]

method _calcSheetOffsets [line 604]

void _calcSheetOffsets( )

Calculate offsets for Worksheet BOF records.

Calculate offsets for Worksheet BOF records.




Tags:

access:  private


[ Top ]

method _setPaletteXl97 [line 413]

void _setPaletteXl97( )

Sets the colour palette to the Excel 97+ default.

Sets the colour palette to the Excel 97+ default.




Tags:

access:  private


[ Top ]

method _storeAllFonts [line 638]

void _storeAllFonts( )

Store the Excel FONT records.

Store the Excel FONT records.




Tags:

access:  private


[ Top ]

method _storeAllNumFormats [line 650]

void _storeAllNumFormats( )

Store user defined numerical formats i.

Store user defined numerical formats i.e. FORMAT records




Tags:

access:  private


[ Top ]

method _storeAllStyles [line 674]

void _storeAllStyles( )

Write all STYLE records.

Write all STYLE records.




Tags:

access:  private


[ Top ]

method _storeAllXfs [line 662]

void _storeAllXfs( )

Write all XF records.

Write all XF records.




Tags:

access:  private


[ Top ]

method _storeBoundsheet [line 957]

void _storeBoundsheet( string $sheetname, integer $offset)

Writes Excel BIFF BOUNDSHEET record.

Writes Excel BIFF BOUNDSHEET record. FIXME: inconsistent with BIFF documentation




Tags:

access:  private


Parameters:

string   $sheetname   Worksheet name
integer   $offset   Location of worksheet BOF

[ Top ]

method _storeCodepage [line 903]

void _storeCodepage( )

Stores the CODEPAGE biff record.

Stores the CODEPAGE biff record.




Tags:

access:  private


[ Top ]

method _storeDatemode [line 1071]

void _storeDatemode( )

Write DATEMODE record to indicate the date system in use (1904 or 1900).

Write DATEMODE record to indicate the date system in use (1904 or 1900).




Tags:

access:  private


[ Top ]

method _storeExterncount [line 1098]

void _storeExterncount( integer $cxals)

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

Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in the workbook. Excel only stores references to external sheets that are used in NAME. The workbook NAME record is required to define the print area and the repeat rows and columns. A similar method is used in Worksheet.php for a slightly different purpose.




Tags:

access:  private


Parameters:

integer   $cxals   Number of external references

[ Top ]

method _storeExterns [line 685]

void _storeExterns( )

Write the EXTERNCOUNT and EXTERNSHEET records. the NAME records.

Write the EXTERNCOUNT and EXTERNSHEET records. These are used as indexes for the NAME records.




Tags:

access:  private


[ Top ]

method _storeExternsheet [line 1119]

void _storeExternsheet( string $sheetname)

Writes the Excel BIFF EXTERNSHEET record. formulas. rows and columns.

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. A similar method is used in Worksheet.php for a slightly different purpose.




Tags:

access:  private


Parameters:

string   $sheetname   Worksheet name

[ Top ]

method _storeNameLong [line 1211]

void _storeNameLong( 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. _storeNameShort() but we use a separate method to keep the code clean.

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 _storeNameShort() but we use a separate method to keep the code clean. Code abstraction for reuse can be carried too far, and I should know. ;-)




Tags:

access:  private


Parameters:

integer   $index   Sheet index
integer   $type   Built-in name type
integer   $rowmin   Start row
integer   $rowmax   End row
integer   $colmin   Start colum
integer   $colmax   End column

[ Top ]

method _storeNames [line 701]

void _storeNames( )

Write the NAME record to define the print area and the repeat rows and cols.

Write the NAME record to define the print area and the repeat rows and cols.




Tags:

access:  private


[ Top ]

method _storeNameShort [line 1145]

void _storeNameShort( 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.

Store the NAME record in the short format that is used for storing the print area, repeat rows only and repeat columns only.




Tags:

access:  private


Parameters:

integer   $index   Sheet index
integer   $type   Built-in name type
integer   $rowmin   Start row
integer   $rowmax   End row
integer   $colmin   Start colum
integer   $colmax   End column

[ Top ]

method _storeNumFormat [line 1043]

void _storeNumFormat( string $format, integer $ifmt)

Writes Excel FORMAT record for non "built-in" numerical formats.

Writes Excel FORMAT record for non "built-in" numerical formats.




Tags:

access:  private


Parameters:

string   $format   Custom format string
integer   $ifmt   Format index code

[ Top ]

method _storeOLEFile [line 574]

mixed _storeOLEFile( )

Store the workbook in an OLE container

Store the workbook in an OLE container




Tags:

return:  true on success
access:  private


[ Top ]

method _storePalette [line 1303]

void _storePalette( )

Stores the PALETTE biff record.

Stores the PALETTE biff record.




Tags:

access:  private


[ Top ]

method _storeStyle [line 1021]

void _storeStyle( )

Write Excel BIFF STYLE records.

Write Excel BIFF STYLE records.




Tags:

access:  private


[ Top ]

method _storeWindow1 [line 920]

void _storeWindow1( )

Write Excel BIFF WINDOW1 record.

Write Excel BIFF WINDOW1 record.




Tags:

access:  private


[ Top ]

method _storeWorkbook [line 482]

mixed _storeWorkbook( )

Assemble worksheets into a workbook and send the BIFF data to an OLE storage.

Assemble worksheets into a workbook and send the BIFF data to an OLE storage.




Tags:

return:  true on success
access:  private


[ Top ]

Documentation generated on Wed, 22 Apr 2009 09:06:28 +0200 by phpDocumentor 1.4.1