tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{RE8K;l' e|}Jv"MkN? y S`ب?[Cv%M0Ӂ[">T5ČD6C )N-ى *K8C8|&HH Loou2W; ?5vWvG|c-kC׎[8s-! t̐4l-SA1g4R+(~&xIqv(beq"aovw$$A'syw.4M&L*,$/AHRyunP*Cšmz>8FP("dԹA: KZjH]X VΣ_ItD^"J޹ss/A|#4/]];OǛ)̙OJzC)N-Ͻp&aovw$$A'sy5T)5+ɨv< aovw$$A'sy*-S'NM _X]>H60>(Q|q5I-X5=㛢A0R" ?$L.q:KD눣p\pf,3nMWyPj  |W0W#~}zS; >DZ+ SR+o&?52k@׹R GiJdXQJ >w's-{KM謶 [9E[F N/:,!1Qe4o tLWʃwtϐ\@WvpZǛ-$`1Svj" ^~22tZ!(>}o[LZ@-1B83x'N8Y8.eu5rId h]pȅu9&0d~\%X-[c~:(P՟5x .KĻ%"@ z9;Z9F#2d sfu_ 0j w='Yڥ;Te9FxGU=r~ i&5aƑ~ YQ&ۜjf/'Q[%˦`B;:STE~0GJİ KQ>.ST!= c"̧W~u$\?]1QrD9.9Xr'B3~w2W^3sCzЇ Nn{iqCc^{AƘl4, "!B -rɫ/:,!1Qe4o tLWʃwtI'5MK1,C*:U'4vͥOu#Շ+TX MH?̈Kʓm#+5e.c3B[cyK\U{0U,xl*5 eg_l![z9A!ZӇy/b״]g1AI\mvMG$YytNYp N[yH,=`c b2;Dτ&Hy{ ؆/}Cn_f=m-~ְ%{⿁`( Bj;Yfj8C0l'HoSqIàM~zΟh S􅞒3H;\luA6-9FxGU=r~ o* G/w %n6l(2Ō2$zlIEׯt?~6UG¦!s Pr@~h|>jJJ,{[}[O䇜(e7R,O SjL{Q|)*K :B'ODWa[5YTe /cnoˆv>eE>AUbt9FX2ɟr tNQ! J>&Ih [ŸPi뵸 oDTmp 슱8ۉk"6j.LŅuBok[ء+$!ԻRz1He $H7g1UQxr ggfG?Bv7Um#cx͠Y7ϭƇHz.7] w="<5%4;r ?YsR. 0%хIiZJ/O>X5.dһ`?thWܜrG7m;SE>K 2H6Q]M\U0`Z=%пPfs[0Pe8?xeȾ?%\6l(2Ō2$zlIEׯt?лϒ*O8@ލXÏW7`僈-:ߗK ڴje@e8o9#ZGR 389b.%TJ%ScV$>.Uͧ'үxak=%H9>(* ` uMl Q/4'OwHy[>!oSG8Py |{}vd l-{ ؆/}Cn_f=m-~ְ%{⿁`( Bj;Yfj8C0l'HoSqIàM#7L1y4ˡP!+C_YX*Z@$W#PAʵƦۓ㞘ɋ%z$!Tۋqedxy#E*,@s*RdЙlQC9s-s܅+goY7.}HG?3xgmZweOtצYQxo}uU 5qS&跿1,x ::cDticon-folder-open"> JAMA For an m-by-n matrix A with m >= n, the singular value decomposition is an m-by-n orthogonal matrix U, an n-by-n diagonal matrix S, and an n-by-n orthogonal matrix V so that A = U*S*V'
  •  JAMA Pythagorean Theorem: a = 3 b = 4 r = sqrt(square(a) + square(b)) r = 5 r = sqrt(a^2 + b^2) without under/overflow
  •  PHPExcel
    • Back to top  

    PHPExcel_Writer_Excel5_Workbook

    category PHPExcel
    package PHPExcel_Writer_Excel5
    copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

     Methods

    Class constructor

    __construct(\PHPExcel $phpExcel, int $str_total, int $str_unique, array $str_table, array $colors, mixed $parser) 

    Parameters

    $phpExcel

    \PHPExcel

    The Workbook

    $str_total

    int

    &$str_total Total number of strings

    $str_unique

    int

    &$str_unique Total number of unique strings

    $str_table

    array

    &$str_table String Table

    $colors

    array

    &$colors Colour Table

    $parser

    mixed

    The formula parser created for the Workbook

    Excel limits the size of BIFF records.

    _addContinue(string $data) : string
    Inherited

    In Excel 5 the limit is 2084 bytes. In Excel 97 the limit is 8228 bytes. Records that are longer than these limits must be split up into CONTINUE blocks.

    This function takes a long BIFF record and inserts CONTINUE records as necessary.

    access private
    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::_addContinue()

    Parameters

    $data

    string

    The original binary data to be written

    Returns

    stringA very convenient string of continue blocks

    Add a font to added fonts

    _addFont(\PHPExcel_Style_Font $font) : int

    Parameters

    $font

    \PHPExcel_Style_Font

    Returns

    intIndex to FONT record

    General storage function

    _append(string $data) 
    Inherited
    access private
    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::_append()

    Parameters

    $data

    string

    binary data to append

    Calculate offsets for Worksheet BOF records.

    _calcSheetOffsets() 
    access private

    Sets the colour palette to the Excel 97+ default.

    _setPaletteXl97() 
    access private

    Writes Excel BOF record to indicate the beginning of a stream or sub-stream in the BIFF file.

    _storeBof(integer $type) 
    Inherited
    access private
    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::_storeBof()

    Parameters

    $type

    integer

    Type of BIFF file to write: 0x0005 Workbook, 0x0010 Worksheet.

    Writes Excel EOF record to indicate the end of a BIFF stream.

    _storeEof() 
    Inherited
    access private
    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::_storeEof()

    Add a new XF writer

    addXfWriter(\PHPExcel_Style $style, boolean $isStyleXf) : int

    Parameters

    $style

    \PHPExcel_Style

    $isStyleXf

    boolean

    Is it a style XF?

    Returns

    intIndex to XF record

    Determine the byte order and store it as class data to avoid recalculating it for each call to new().

    getByteOrder() : int
    InheritedStatic
    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::getByteOrder()

    Returns

    int

    Get Escher object

    getEscher() : \PHPExcel_Shared_Escher

    Returns

    \PHPExcel_Shared_Escher

    Set Escher object

    setEscher(\PHPExcel_Shared_Escher $pValue) 

    Parameters

    $pValue

    \PHPExcel_Shared_Escher

    General storage function like _append, but returns string instead of modifying $this->_data

    writeData(string $data) : string
    Inherited
    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::writeData()

    Parameters

    $data

    string

    binary data to write

    Returns

    string

    Writes Excel EOF record to indicate the end of a BIFF stream.

    writeEof() 
    Inherited
    access private
    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::writeEof()

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

    writeWorkbook(array $pWorksheetSizes) : string

    Parameters

    $pWorksheetSizes

    array

    The sizes in bytes of the binary worksheet streams

    Returns

    stringBinary data for workbook stream

    Alter color palette adding a custom color

    _addColor(string $rgb) : int

    Parameters

    $rgb

    string

    E.g. 'FF00AA'

    Returns

    intColor index

    Writes all the DEFINEDNAME records (BIFF8).

    _writeAllDefinedNamesBiff8() 

    So far this is only used for repeating rows/columns (print titles) and print areas

    Store the Excel FONT records.

    _writeAllFonts() 

    Store user defined numerical formats i.e.

    _writeAllNumFormats() 

    FORMAT records

    Write all STYLE records.

    _writeAllStyles() 

    Write all XF records.

    _writeAllXfs() 

    Writes Excel BIFF BOUNDSHEET record.

    _writeBoundsheet(\PHPExcel_Worksheet $sheet, integer $offset) 

    Parameters

    $sheet

    \PHPExcel_Worksheet

    Worksheet name

    $offset

    integer

    Location of worksheet BOF

    Stores the CODEPAGE biff record.

    _writeCodepage() 

    Stores the COUNTRY record for localization

    _writeCountry() : string

    Returns

    string

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

    _writeDatemode() 

    Write a DEFINEDNAME record for BIFF8 using explicit binary formula data

    _writeDefinedNameBiff8(string $name, string $formulaData, string $sheetIndex, boolean $isBuiltIn) : string

    Parameters

    $name

    string

    The name in UTF-8

    $formulaData

    string

    The binary formula data

    $sheetIndex

    string

    1-based sheet index the defined name applies to. 0 = global

    $isBuiltIn

    boolean

    Built-in name?

    Returns

    stringComplete binary record data

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

    _writeExterncount(integer $cxals) 

    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.

    Parameters

    $cxals

    integer

    Number of external references

    Write the EXTERNCOUNT and EXTERNSHEET records.

    _writeExterns() 

    These are used as indexes for the NAME records.

    Writes the Excel BIFF EXTERNSHEET record.

    _writeExternsheet(string $sheetname) 

    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.

    Parameters

    $sheetname

    string

    Worksheet name

    Writes the Excel BIFF EXTERNSHEET record.

    _writeExternsheetBiff8() 

    These references are used by formulas.

    Writes the MSODRAWINGGROUP record if needed.

    _writeMsoDrawingGroup() 

    Possibly split using CONTINUE records.

    Store the NAME record in the long format that is used for storing the repeat rows and columns when both are specified.

    _writeNameLong(integer $index, integer $type, integer $rowmin, integer $rowmax, integer $colmin, integer $colmax) 

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

    Parameters

    $index

    integer

    Sheet index

    $type

    integer

    Built-in name type

    $rowmin

    integer

    Start row

    $rowmax

    integer

    End row

    $colmin

    integer

    Start colum

    $colmax

    integer

    End column

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

    _writeNameShort(integer $index, integer $type, integer $rowmin, integer $rowmax, integer $colmin, integer $colmax) 

    Parameters

    $index

    integer

    Sheet index

    $type

    integer

    Built-in name type

    $rowmin

    integer

    Start row

    $rowmax

    integer

    End row

    $colmin

    integer

    Start colum

    $colmax

    integer

    End column

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

    _writeNames() 

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

    _writeNumFormat(string $format, integer $ifmt) 

    Parameters

    $format

    string

    Custom format string

    $ifmt

    integer

    Format index code

    Stores the PALETTE biff record.

    _writePalette() 

    Write the RECALCID record

    _writeRecalcId() : string

    Returns

    string

    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.

    _writeSharedStringsTable() : string

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

    Returns

    stringBinary data

    Write a short NAME record

    _writeShortNameBiff8(string $name, string $sheetIndex, \integer[][] $rangeBounds, boolean $isHidden) : string

    Parameters

    $name

    string

    $sheetIndex

    string

    1-based sheet index the defined name applies to. 0 = global

    $rangeBounds

    \integer[][]

    range boundaries

    $isHidden

    boolean

    Returns

    stringComplete binary record data

    Write Excel BIFF STYLE records.

    _writeStyle() 

    Write Internal SUPBOOK record

    _writeSupbookInternal() 

    Write Excel BIFF WINDOW1 record.

    _writeWindow1() 

     Properties

     

    $_biffsize : integer
    see \_calcSheetOffsets()
     

    $_codepage : integer
     

    $_country_code : integer
     

    $_data : string
    Inherited
    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::$$_data
     

    $_datasize : integer
    Inherited

    Should be the same as strlen($this->_data)

    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::$$_datasize
     

    $_limit : integer
    Inherited

    See _addContinue()

    see \_addContinue()
    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::$$_limit
     

    $_palette : array
     

    $_addedFonts : array

    Maps from font's hash => index in workbook

     

    $_addedNumberFormats : array

    Maps from numberFormat's hash => index in workbook

     

    $_byte_order : integer
    Inherited

    0 => little endian, 1 => big endian

    inherited_from \PHPExcel_Writer_Excel5_BIFFwriter::$$_byte_order
     

    $_colors 
     

    $_escher : \PHPExcel_Shared_Escher
     

    $_fontWriters : \PHPExcel_Writer_Excel5_Font[]
     

    $_numberFormats : array
     

    $_parser : \PHPExcel_Writer_Excel5_Parser
     

    $_phpExcel : \PHPExcel
     

    $_str_table : array
     

    $_str_total : int
     

    $_str_unique : int
     

    $_worksheetOffsets : array
     

    $_worksheetSizes : array
     

    $_xfWriters : \PHPExcel_Writer_Excel5_Xf[]