tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{WkMY X1,~84ǺAaPi˄(;wѻ]cºP"cJDz^?zo~_UY̳-=~J*U \ֵ/5}z}Z''b]MSzљsEvtTg1 Ϲ }=7pOSYa5& mN2:v3c c2&Ɖ|t o.Щ3cdRExbPpd}ib|J/n\j&rJ%+j[,xl2O& w4}Q8vO惤VJ4]i W߱n6ŇXɸAQN$sGzƨNƨFC+q-%BgMdSYa5& mN2:v3c c2&Ɖ|t IɆ< SYa5& mN2:v3c c2&Ɖ|t fm$|c:=? dbUEa^=T"XUe!h rCR<…lS# bT%N؄c<4I\}?ay#8tȺvw_1>4Jh n;'; qkEGYq)]Y(V2!WjɳPٽ=E hΗk&=Ƃ $8"ut=m,u;{gu˜i*@ͥ>Sgc?yx?h1랰pE;b"`e؝m)`Q.Z]b"{aPd MV́q MQ3.3mT,*Raiz#m,f[qܩ֨*TVMׂgxZB4J8V;Qˋю [0dMTRb,gmG!!ET\`&hq(Q i6ކ3OP%!2uJ3/!i x0Uwv4\ܲZ,uu:*́ o:*'d}׳ ֗ӣ/WbnTpp?Qsaܙ~.> &3Q{ $eUS^[\{"QJFWM+}xüQ(VCUgRIn.H| Ҕ.${X[ >@e=ng Q4>2 7W}TH'kE}I؆u,YY"-cFCĶ8nn&,`\ft! jRr!E#*`-f<|ı5fEZ^ BJq\B2ӭȽsu$sv#0)NiHG}/xQ瑄v'?FITp͑K*ClWJt7$qiY4:o飙4I ,i$݈ n.OR4k쵼W QJ >w's-{KM謶 [ NRF.e ]pSXzA@$ke·_~F? C[􋍡MQJm V,iAu  vK,:_(5Kӱښ@:U$r3 TyaJe3J1 di20Kr-\Ōo@jtxAkB7薩xRܖ"NQ(8Cj|zK\Gv0>vMG$YytNYp N[\%1vԛ'_2GMyIXWcN jv UV*⨀i<%`ԓtv4t 8N_QFͦIm-$T>'a۸Y_Z=2 sR]~yYTe /cnoˆv>eE>AUbt9FX2\Zis#&䢻EHn1P! vp#ZP왲;X7W៼[x?J_?rͷLX 'uUavyճ- yT2(GNRopTH\VQHG QɐXL4,w,М#fnn74^"U& C,hk #0*"?,r2fIsJj6G&azr~slԯ+ߕ( tQÒu"dOB Cۉ) wK \jG5vln.ӘW= ŭ VvL,DǛ-$D.=+.-ↀq su7klD]%3ZCy@g $"0ȵ[T{on qdwْDv+;Q-i=mo<4AO=5uBp/_}Y @oJZk^pMj%cB(XՖw.8F`6pq6$3$VyQzgX<?$U?4;%) &$$ꇇ|q{:>SIC"Mx|Zш缿Xjvüevr7ҲvS183ZPԽ HϴoH|> Gb}HQ@ӖOVY_Y1 тiܱ]U`Ok=>tXz_An &fIsJj6G&azr$Bz`^\"-iIy})e)!T8@1?"3Mj< 団=kvKˬx+ےoO@rhILe?c4;BU,7@cEbDq؉[Ǧm 6|y[OE(}XPR# LYE"DM > vVcil!ԻRH^{j8=W) ~+N'1P! vp#ZP왲;X7W៼[x?J_?rͷLX 'uUavyճ- yT2(~/MiŦ_Qx'#IxRچ(*#c.ܸ&l1OtצYQxokv qaI~je/7w  <+̉H3Zq"?mLz@rb fF]VK޺)q55*=C<]i4ԡh;NH6L|"Oڴje@e8o9#ZGR 38JAMA 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

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

     Methods

    Implement PHP __clone to create a deep clone, not just a shallow copy.

    __clone() 

    Create a new PHPExcel with one Worksheet

    __construct() 

    Code to execute when this worksheet is unset()

    __destruct() 

    Add a cellStyleXf to the workbook

    addCellStyleXf(\PHPExcel_Style $pStyle) 

    Parameters

    $pStyle

    \PHPExcel_Style

    Add a cellXf to the workbook

    addCellXf(\PHPExcel_Style $style) 

    Parameters

    $style

    \PHPExcel_Style

    Add external sheet

    addExternalSheet(\PHPExcel_Worksheet $pSheet, int | null $iSheetIndex) : \PHPExcel_Worksheet

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    External sheet to add

    $iSheetIndex

    intnull

    Index where sheet should go (0,1,..., or null for last)

    Exceptions

    \PHPExcel_Exception

    Returns

    \PHPExcel_Worksheet

    Add named range

    addNamedRange(\PHPExcel_NamedRange $namedRange) : \PHPExcel

    Parameters

    $namedRange

    \PHPExcel_NamedRange

    Returns

    \PHPExcel

    Add sheet

    addSheet(\PHPExcel_Worksheet $pSheet, int | null $iSheetIndex) : \PHPExcel_Worksheet

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    $iSheetIndex

    intnull

    Index where sheet should go (0,1,..., or null for last)

    Exceptions

    \PHPExcel_Exception

    Returns

    \PHPExcel_Worksheet

    Check if style exists in style collection

    cellXfExists(\PHPExcel_Style $pCellStyle) : boolean

    Parameters

    $pCellStyle

    \PHPExcel_Style

    Returns

    boolean

    Copy workbook (!= clone!)

    copy() : \PHPExcel

    Returns

    \PHPExcel

    Create sheet and add it to this workbook

    createSheet(int | null $iSheetIndex) : \PHPExcel_Worksheet

    Parameters

    $iSheetIndex

    intnull

    Index where sheet should go (0,1,..., or null for last)

    Exceptions

    \PHPExcel_Exception

    Returns

    \PHPExcel_Worksheet

    Remove all macros, certificate from spreadsheet

    discardMacros() : void

    Disconnect all worksheets from this PHPExcel workbook object, typically so that the PHPExcel object can be unset

    disconnectWorksheets() 

    Eliminate all unneeded cellXf and afterwards update the xfIndex for all cells and columns in the workbook

    garbageCollect() 

    Get active sheet

    getActiveSheet() : \PHPExcel_Worksheet

    Returns

    \PHPExcel_Worksheet

    Get active sheet index

    getActiveSheetIndex() : int

    Returns

    intActive sheet index

    Get all sheets

    getAllSheets() : \PHPExcel_Worksheet[]

    Returns

    \PHPExcel_Worksheet[]

    Return the calculation engine for this worksheet

    getCalculationEngine() : \PHPExcel_Calculation

    Returns

    \PHPExcel_Calculation

    Get cellStyleXf by hash code

    getCellStyleXfByHashCode(string $pValue) : \PHPExcel_Style | false

    Parameters

    $pValue

    string

    Returns

    \PHPExcel_Stylefalse

    Get cellStyleXf by index

    getCellStyleXfByIndex(int $pIndex) : \PHPExcel_Style

    Parameters

    $pIndex

    int

    Returns

    \PHPExcel_Style

    Get the workbook collection of cellStyleXfs

    getCellStyleXfCollection() : \PHPExcel_Style[]

    Returns

    \PHPExcel_Style[]

    Get cellXf by hash code

    getCellXfByHashCode(string $pValue) : \PHPExcel_Style | false

    Parameters

    $pValue

    string

    Returns

    \PHPExcel_Stylefalse

    Get cellXf by index

    getCellXfByIndex(int $pIndex) : \PHPExcel_Style

    Parameters

    $pIndex

    int

    Returns

    \PHPExcel_Style

    Get the workbook collection of cellXfs

    getCellXfCollection() : \PHPExcel_Style[]

    Returns

    \PHPExcel_Style[]

    Get the cellXf supervisor

    getCellXfSupervisor() : \PHPExcel_Style

    Returns

    \PHPExcel_Style

    Get default style

    getDefaultStyle() : \PHPExcel_Style

    Exceptions

    \PHPExcel_Exception

    Returns

    \PHPExcel_Style

    Return the unique ID value assigned to this spreadsheet workbook

    getID() : string

    Returns

    string

    Get index for sheet

    getIndex(\PHPExcel_Worksheet $pSheet) : \Sheet

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    Exceptions

    \PHPExcel_Exception

    Returns

    \Sheetindex

    Return the macros certificate

    getMacrosCertificate() : \binary | null

    Returns

    \binarynull

    Return the macros code

    getMacrosCode() : \binary | null

    Returns

    \binarynull

    Get named range

    getNamedRange(string $namedRange, \PHPExcel_Worksheet $pSheet) : \PHPExcel_NamedRange | null

    Parameters

    $namedRange

    string

    $pSheet

    \PHPExcel_Worksheetnull

    Scope. Use null for global scope

    Returns

    \PHPExcel_NamedRangenull

    Get named ranges

    getNamedRanges() : \PHPExcel_NamedRange[]

    Returns

    \PHPExcel_NamedRange[]

    Get properties

    getProperties() : \PHPExcel_DocumentProperties

    Returns

    \PHPExcel_DocumentProperties

    retrieve Binaries Ribbon Objects

    getRibbonBinObjects($What) 

    Parameters

    $What

    retrieve ribbon XML Data

    getRibbonXMLData($What) 

    return string|null|array

    Parameters

    $What

    Get security

    getSecurity() : \PHPExcel_DocumentSecurity

    Returns

    \PHPExcel_DocumentSecurity

    Get sheet by index

    getSheet(int $pIndex) : \PHPExcel_Worksheet

    Parameters

    $pIndex

    int

    Sheet index

    Exceptions

    \PHPExcel_Exception

    Returns

    \PHPExcel_Worksheet

    Get sheet by code name.

    getSheetByCodeName(string $pName) : \PHPExcel_Worksheet

    Warning : sheet don't have always a code name !

    Parameters

    $pName

    string

    Sheet name

    Returns

    \PHPExcel_Worksheet

    Get sheet by name

    getSheetByName(string $pName) : \PHPExcel_Worksheet

    Parameters

    $pName

    string

    Sheet name

    Returns

    \PHPExcel_Worksheet

    Get sheet count

    getSheetCount() : int

    Returns

    int

    Get sheet names

    getSheetNames() : string[]

    Returns

    string[]

    Get worksheet iterator

    getWorksheetIterator() : \PHPExcel_WorksheetIterator

    Returns

    \PHPExcel_WorksheetIterator

    The workbook has macros ?

    hasMacros() : true

    Returns

    trueif workbook has macros, false if not

    Is the project signed ?

    hasMacrosCertificate() : true | false

    Returns

    truefalse

    This workbook have a custom UI ?

    hasRibbon() : true | false

    Returns

    truefalse

    This workbook have additionnal object for the ribbon ?

    hasRibbonBinObjects() : true | false

    Returns

    truefalse

    Remove cellStyleXf by index

    removeCellStyleXfByIndex(int $pIndex) 

    Parameters

    $pIndex

    int

    Exceptions

    \PHPExcel_Exception

    Remove cellXf by index.

    removeCellXfByIndex(int $pIndex) 

    It is ensured that all cells get their xf index updated.

    Parameters

    $pIndex

    int

    Index to cellXf

    Exceptions

    \PHPExcel_Exception

    Remove named range

    removeNamedRange(string $namedRange, \PHPExcel_Worksheet $pSheet) : \PHPExcel

    Parameters

    $namedRange

    string

    $pSheet

    \PHPExcel_Worksheetnull

    Scope: use null for global scope.

    Returns

    \PHPExcel

    Remove sheet by index

    removeSheetByIndex(int $pIndex) 

    Parameters

    $pIndex

    int

    Active sheet index

    Exceptions

    \PHPExcel_Exception

    Set active sheet index

    setActiveSheetIndex(int $pIndex) : \PHPExcel_Worksheet

    Parameters

    $pIndex

    int

    Active sheet index

    Exceptions

    \PHPExcel_Exception

    Returns

    \PHPExcel_Worksheet

    Set active sheet index by name

    setActiveSheetIndexByName(string $pValue) : \PHPExcel_Worksheet

    Parameters

    $pValue

    string

    Sheet title

    Exceptions

    \PHPExcel_Exception

    Returns

    \PHPExcel_Worksheet

    Define if a workbook has macros

    setHasMacros(true | false $hasMacros) 

    Parameters

    $hasMacros

    truefalse

    Set index for sheet by sheet name.

    setIndexByName(string $sheetName, int $newIndex) : \New

    Parameters

    $sheetName

    string

    Sheet name to modify index for

    $newIndex

    int

    New index for the sheet

    Exceptions

    \PHPExcel_Exception

    Returns

    \Newsheet index

    Set the macros certificate

    setMacrosCertificate(\binary | null $Certificate) 

    Parameters

    $Certificate

    \binarynull

    Set the macros code

    setMacrosCode(\binary $MacrosCode) 

    Parameters

    $MacrosCode

    \binary

    string|null

    Set properties

    setProperties(\PHPExcel_DocumentProperties $pValue) 

    Parameters

    $pValue

    \PHPExcel_DocumentProperties

    store binaries ribbon objects (pictures)

    setRibbonBinObjects($BinObjectsNames, $BinObjectsData) 

    Parameters

    $BinObjectsNames

    $BinObjectsData

    set ribbon XML data

    setRibbonXMLData($Target, $XMLData) 

    Parameters

    $Target

    $XMLData

    Set security

    setSecurity(\PHPExcel_DocumentSecurity $pValue) 

    Parameters

    $pValue

    \PHPExcel_DocumentSecurity

    Check if a sheet with a specified code name already exists

    sheetCodeNameExists(string $pSheetCodeName) : boolean

    Parameters

    $pSheetCodeName

    string

    Name of the worksheet to check

    Returns

    boolean

    Check if a sheet with a specified name already exists

    sheetNameExists(string $pSheetName) : boolean

    Parameters

    $pSheetName

    string

    Name of the worksheet to check

    Returns

    boolean

    return the extension of a filename.

    _getExtensionOnly($ThePath) 

    Internal use for a array_map callback (php<5.3 don't like lambda function)

    Parameters

    $ThePath

     Properties

     

    $_activeSheetIndex : int
     

    $_calculationEngine : \PHPExcel_Calculation
     

    $_cellStyleXfCollection : \PHPExcel_Style[]
     

    $_cellXfCollection : \PHPExcel_Style[]
     

    $_cellXfSupervisor : \PHPExcel_Style
     

    $_hasMacros : bool
     

    $_macrosCertificate : \binary
     

    $_macrosCode : \binary
     

    $_namedRanges : \PHPExcel_NamedRange[]
     

    $_properties : \PHPExcel_DocumentProperties
     

    $_ribbonBinObjects : NULL | array
     

    $_ribbonXMLData : NULL | string
     

    $_security : \PHPExcel_DocumentSecurity
     

    $_uniqueID : string
     

    $_workSheetCollection : \PHPExcel_Worksheet[]