tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{(ՑD# 4q=a5.`3QQESa0z&(O./< p`e綊ptx/Ϋ(A~"~,siH,ՑyX#PB'S*઴c59Q]@Z<5c 60 AajjH]X V'#.~i4O<J@ZaC ʠSYa5& mN2:v3c c2&Ɖ|t 6~\Ҵ-ͼUsTMk?*N(=coָ7(GGS@$tP= 5(BqITMk?*N(=coָ7(GGS@$tP=ɳ D#CozB|#F 912קəG:nz_|2|IK5!f[~+JB25k_7a%FZ-:$trGV3/$)4'(V2!WjɳPREV[9xKl>kQ 8:(raYbn~:T&_pes XȈuN"UpBQDG& Хh n;';"oXzG#W||h7̥ =KN%բzɈGO<`IFpC=s2bbGE|L>ݞϣMCK8=OG[C/fK'Ta[TĨj#sh\/3Fpy-Έ4VA ۭr{:murHHiю T&D@is@ůte jvm1qzߙي7#,d-(`sv7 to,~ګkKAwF]q4p*?bnl- 0=9ߓ #:WYnQ R2 ܮIg?׹Kkk6SJCWپ,VHehnh'y PWҫs-",cʠu)3ǡ-@M}%'$&NM^qjV6 7W}1M}MmL= (B̿B1]&1(2RJ&ndS'Xb>8nn&,`\f%p|5ST[0#@#6[e*ӍIqqߧYŝ0mK7ȮL$@MxXx_m/:,!1Qe4o )rLqnb)Θ‚Rˆ7OUo4;:STE~0ɻ_"ܓZQYj{׵X PxL{ۥ:0wńhψnH,|hr-)iGlو#!We7I WsE~T?1ϸ } 0&ug*AgioH|> GbUuȺ(*E5偻W"PD+(]j( >ێRJD $vP؝3/ [PZ!rF1ԕUM̌uZjNb~)Yq4:6G&azrLspA.h:`ү1,x ::cDtb I%+piKDQOky`i?Pp'ĔĻ p ̉/%6DP3Vחz硊_@Ӊ6`Z6ɸfyszeΑۂ3!ݠ]?0fE dMߖRQMG\5$.ˢgO/ၕigIX PxL{]l493h#=AnYʢkƚ"Hq oҊH[Д/0wW xGbp$FT/eQzZ;uk~f+޴2}=te< 団=kvKˬx+ےoO@rhI1y\m>= TO%$]>Uj"Nk rv5%O#ҹbk4vf{ ؆/}Cn_f=m\::)#Qtq+(';#g~7kQka>NZFFIpޗOVJ;oBBXhs Rۃ־ =GhN٥.7] w="<5%4;r ?YsR. 0%хIiZJ/O>X5.dһ`?thWܜrڪKߘLU҇{<>H6Q]M.>Hc!u=!B i6G&azrX;R#SO Up<:~PH%!xhke|-hrϯ*afKewulOR8M={_^Pf: r#{1ð%i2M– 騞 1>I,菮a?3dF&8X9Wݎԧ鱌Ӛ z}lF1S`ْD -[9"K95LI9Ѐvrs`mly0n{iqCc^{ *D(}T@{+Xw2ȃn݄mF##0vґODXƉ}2)6[-$aW=5?7|;aYݰo&?52k@ǔuOv_0=mLDg/u!!{N[ϛt<~@6}4%E-wƾ{/NkďelRI8,!S.dNI~a ;9}6LE!'5fNTT0=!'QÀ %S:~PH%!xhke|-hrϯ*G'|{o7 (z~jѾIZ,\{Ǜ-$D.=+.-ↀq su7klD]%3ZCy@g *O#"a! ժJ[T{onuڸz KG ñe:([3Ϩ:/e}=>$ …~6ȿ3W|e%Jo4xʕV(o|.7] w="<5%4;r ?YsR. 0%хIiZJ/O>X5.dһ`?thWܜr6v̓k[2Gz/sxRxR(\g]M=a9{AB_וRDϽ;=u,{9aɹ>Ab!pM+Ǿb+'Ro75|;pN3x`j솵keC>3\r8UY򇔎hs&XnSy ;89dehYTe /cnoˆv>older-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_Excel2007

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

     Methods

    Create a new PHPExcel_Writer_Excel2007

    __construct(\PHPExcel $pPHPExcel) 

    Parameters

    $pPHPExcel

    \PHPExcel

    Get PHPExcel_Style_Borders HashTable

    getBordersHashTable() : \PHPExcel_HashTable

    Returns

    \PHPExcel_HashTable

    Get disk caching directory

    getDiskCachingDirectory() : string
    Inherited
    inherited_from \PHPExcel_Writer_Abstract::getDiskCachingDirectory()

    Returns

    string

    Get PHPExcel_Worksheet_BaseDrawing HashTable

    getDrawingHashTable() : \PHPExcel_HashTable

    Returns

    \PHPExcel_HashTable

    Get PHPExcel_Style_Fill HashTable

    getFillHashTable() : \PHPExcel_HashTable

    Returns

    \PHPExcel_HashTable

    Get PHPExcel_Style_Font HashTable

    getFontHashTable() : \PHPExcel_HashTable

    Returns

    \PHPExcel_HashTable

    Write charts in workbook? If this is true, then the Writer will write definitions for any charts that exist in the PHPExcel object.

    getIncludeCharts() : boolean
    Inherited

    If false (the default) it will ignore any charts defined in the PHPExcel object.

    inherited_from \PHPExcel_Writer_Abstract::getIncludeCharts()

    Returns

    boolean

    Get PHPExcel_Style_NumberFormat HashTable

    getNumFmtHashTable() : \PHPExcel_HashTable

    Returns

    \PHPExcel_HashTable

    Get Office2003 compatibility

    getOffice2003Compatibility() : boolean

    Returns

    boolean

    Get PHPExcel object

    getPHPExcel() : \PHPExcel

    Exceptions

    \PHPExcel_Writer_Exception

    Returns

    \PHPExcel

    Get Pre-Calculate Formulas flag If this is true (the default), then the writer will recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file If false, then formulae are not calculated on save.

    getPreCalculateFormulas() : boolean
    Inherited

    This is faster for saving in PHPExcel, but slower when opening the resulting file in MS Excel, because Excel has to recalculate the formulae itself

    inherited_from \PHPExcel_Writer_Abstract::getPreCalculateFormulas()

    Returns

    boolean

    Get string table

    getStringTable() : string[]

    Returns

    string[]

    Get PHPExcel_Style HashTable

    getStyleHashTable() : \PHPExcel_HashTable

    Returns

    \PHPExcel_HashTable

    Get PHPExcel_Style_Conditional HashTable

    getStylesConditionalHashTable() : \PHPExcel_HashTable

    Returns

    \PHPExcel_HashTable

    Get use disk caching where possible?

    getUseDiskCaching() : boolean
    Inherited
    inherited_from \PHPExcel_Writer_Abstract::getUseDiskCaching()

    Returns

    boolean

    Get writer part

    getWriterPart(string $pPartName) : \PHPExcel_Writer_Excel2007_WriterPart

    Parameters

    $pPartName

    string

    Writer part name

    Returns

    \PHPExcel_Writer_Excel2007_WriterPart

    Save PHPExcel to file

    save(string $pFilename) 

    @param string $pFilename Name of the file to save

    Parameters

    $pFilename

    string

    Exceptions

    \PHPExcel_Writer_Exception

    Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PHPExcel object.

    setIncludeCharts(boolean $pValue) : \PHPExcel_Writer_IWriter
    Inherited

    Set to false (the default) to ignore charts.

    inherited_from \PHPExcel_Writer_Abstract::setIncludeCharts()

    Parameters

    $pValue

    boolean

    Returns

    \PHPExcel_Writer_IWriter

    Set Office2003 compatibility

    setOffice2003Compatibility(boolean $pValue) : \PHPExcel_Writer_Excel2007

    Parameters

    $pValue

    boolean

    Office2003 compatibility?

    Returns

    \PHPExcel_Writer_Excel2007

    Set PHPExcel object

    setPHPExcel(\PHPExcel $pPHPExcel) : \PHPExcel_Writer_Excel2007

    Parameters

    $pPHPExcel

    \PHPExcel

    PHPExcel object

    Exceptions

    \PHPExcel_Writer_Exception

    Returns

    \PHPExcel_Writer_Excel2007

    Set Pre-Calculate Formulas Set to true (the default) to advise the Writer to calculate all formulae on save Set to false to prevent precalculation of formulae on save.

    setPreCalculateFormulas(boolean $pValue) : \PHPExcel_Writer_IWriter
    Inherited
    inherited_from \PHPExcel_Writer_Abstract::setPreCalculateFormulas()

    Parameters

    $pValue

    boolean

    Pre-Calculate Formulas?

    Returns

    \PHPExcel_Writer_IWriter

    Set use disk caching where possible?

    setUseDiskCaching(boolean $pValue, string $pDirectory) : \PHPExcel_Writer_Excel2007
    Inherited
    inherited_from \PHPExcel_Writer_Abstract::setUseDiskCaching()

    Parameters

    $pValue

    boolean

    $pDirectory

    string

    Disk caching directory

    Exceptions

    \PHPExcel_Writer_Exception when directory does not exist

    Returns

    \PHPExcel_Writer_Excel2007

     Properties

     

    $_diskCachingDirectory : string
    Inherited
    inherited_from \PHPExcel_Writer_Abstract::$$_diskCachingDirectory
     

    $_includeCharts : boolean
    Inherited
    inherited_from \PHPExcel_Writer_Abstract::$$_includeCharts
     

    $_preCalculateFormulas : boolean

    Overrides the default TRUE for this specific writer for performance reasons

     

    $_useDiskCaching : boolean
    Inherited
    inherited_from \PHPExcel_Writer_Abstract::$$_useDiskCaching
     

    $_bordersHashTable : \PHPExcel_HashTable
     

    $_drawingHashTable : \PHPExcel_HashTable
     

    $_fillHashTable : \PHPExcel_HashTable
     

    $_fontHashTable : \PHPExcel_HashTable
     

    $_numFmtHashTable : \PHPExcel_HashTable
     

    $_office2003compatibility : boolean
     

    $_spreadSheet : \PHPExcel
     

    $_stringTable : string[]
     

    $_styleHashTable : \PHPExcel_HashTable
     

    $_stylesConditionalHashTable : \PHPExcel_HashTable
     

    $_writerParts : \PHPExcel_Writer_Excel2007_WriterPart[]