============== TEST ==============
Test name: 01simple.php
21:24:20 Create new PHPExcel object
21:24:20 Set properties
21:24:20 Add some data
21:24:20 Rename sheet
21:24:20 Write to Excel2007 format
============== TEST ==============
Test name: 02types.php
21:24:20 Create new PHPExcel object
21:24:20 Set properties
21:24:20 Set default font
21:24:20 Add some data
21:24:20 Rename sheet
21:24:20 Write to Excel2007 format
============== TEST ==============
Test name: 03formulas.php
21:24:20 Create new PHPExcel object
21:24:21 Set properties
21:24:21 Add some data
21:24:21 Rename sheet
21:24:21 Write to Excel2007 format
============== TEST ==============
Test name: 04printing.php
21:24:21 Create new PHPExcel object
21:24:21 Set properties
21:24:21 Add some data
21:24:21 Set header/footer
21:24:21 Add a drawing to the header
21:24:21 Set page orientation and size
21:24:21 Rename sheet
21:24:21 Write to Excel2007 format
============== TEST ==============
Test name: 05featuredemo.php
21:24:21 Create new PHPExcel object
21:24:21 Set properties
21:24:21 Add some data
21:24:21 Add comments
21:24:21 Add rich-text string
21:24:21 Merge cells
21:24:21 Protect cells
21:24:21 Set cell number formats
21:24:21 Set column widths
21:24:21 Set fonts
21:24:21 Set alignments
21:24:21 Set thin black border outline around column
21:24:21 Set thick brown border outline around Total
21:24:21 Set fills
21:24:21 Set style for header row using alternative method
21:24:21 Unprotect a cell
21:24:21 Add a hyperlink to the sheet
21:24:21 Add a drawing to the worksheet
21:24:21 Add a drawing to the worksheet
21:24:21 Add a drawing to the worksheet
21:24:21 Play around with inserting and removing rows and columns
21:24:21 Set header/footer
21:24:21 Set page orientation and size
21:24:21 Rename sheet
21:24:21 Create new Worksheet object
21:24:21 Add some data
21:24:21 Set the worksheet tab color
21:24:21 Set alignments
21:24:21 Set column widths
21:24:21 Set fonts
21:24:21 Add a drawing to the worksheet
21:24:21 Set page orientation and size
21:24:21 Rename sheet
21:24:21 Write to Excel2007 format
============== TEST ==============
Test name: 06largescale.php
21:24:21 Create new PHPExcel object
21:24:21 Set properties
21:24:21 Add data
21:24:21 Hide "Phone" and "fax" column
21:24:21 Set outline levels
21:24:21 Freeze panes
21:24:21 Rows to repeat at top
21:24:21 Write to Excel2007 format
============== TEST ==============
Test name: 07reader.php
Please run 05featuredemo.php first.
============== TEST ==============
Test name: 08conditionalformatting.php
21:24:21 Create new PHPExcel object
21:24:21 Set properties
21:24:21 Add some data
21:24:21 Set column widths
21:24:21 Add conditional formatting
21:24:21 Set fonts
21:24:21 Set header/footer
21:24:21 Set page orientation and size
21:24:21 Rename sheet
21:24:21 Write to Excel2007 format
============== TEST ==============
Test name: 09pagebreaks.php
21:24:21 Create new PHPExcel object
21:24:21 Set properties
21:24:21 Add data and breaks
21:24:21 Write to Excel2007 format
============== TEST ==============
Test name: 10autofilter.php
21:24:21 Create new PHPExcel object
21:24:21 Set properties
21:24:21 Add data
21:24:21 Set title row bold
21:24:21 Set autofilter
21:24:21 Write to Excel2007 format
============== TEST ==============
Test name: 11documentsecurity.php
21:24:21 Create new PHPExcel object
21:24:21 Set properties
21:24:21 Add some data
21:24:21 Rename sheet
21:24:21 Set document security
21:24:21 Set sheet security
21:24:21 Write to Excel2007 format
============== TEST ==============
Test name: 13calculation.php
21:24:21 List implemented functions
Array
(
[0] => ABS
[1] => ACCRINT
[2] => ACCRINTM
[3] => ACOS
[4] => ACOSH
[5] => ADDRESS
[6] => AMORDEGRC
[7] => AMORLINC
[8] => AND
[9] => ASIN
[10] => ASINH
[11] => ATAN
[12] => ATAN2
[13] => ATANH
[14] => AVEDEV
[15] => AVERAGE
[16] => AVERAGEA
[17] => AVERAGEIF
[18] => BESSELI
[19] => BESSELJ
[20] => BESSELK
[21] => BESSELY
[22] => BETADIST
[23] => BETAINV
[24] => BIN2DEC
[25] => BIN2HEX
[26] => BIN2OCT
[27] => BINOMDIST
[28] => CEILING
[29] => CHAR
[30] => CHIDIST
[31] => CHIINV
[32] => CHOOSE
[33] => CLEAN
[34] => CODE
[35] => COLUMN
[36] => COLUMNS
[37] => COMBIN
[38] => COMPLEX
[39] => CONCATENATE
[40] => CONFIDENCE
[41] => CONVERT
[42] => CORREL
[43] => COS
[44] => COSH
[45] => COUNT
[46] => COUNTA
[47] => COUNTBLANK
[48] => COUNTIF
[49] => COUPDAYBS
[50] => COUPDAYS
[51] => COUPDAYSNC
[52] => COUPNCD
[53] => COUPNUM
[54] => COUPPCD
[55] => COVAR
[56] => CRITBINOM
[57] => CUMIPMT
[58] => CUMPRINC
[59] => DATE
[60] => DATEDIF
[61] => DATEVALUE
[62] => DAY
[63] => DAYS360
[64] => DB
[65] => DCOUNT
[66] => DCOUNTA
[67] => DDB
[68] => DEC2BIN
[69] => DEC2HEX
[70] => DEC2OCT
[71] => DEGREES
[72] => DELTA
[73] => DEVSQ
[74] => DGET
[75] => DISC
[76] => DMAX
[77] => DMIN
[78] => DOLLAR
[79] => DOLLARDE
[80] => DOLLARFR
[81] => DPRODUCT
[82] => DSTDEV
[83] => DSTDEVP
[84] => DSUM
[85] => DVAR
[86] => DVARP
[87] => EDATE
[88] => EFFECT
[89] => EOMONTH
[90] => ERF
[91] => ERFC
[92] => ERROR.TYPE
[93] => EVEN
[94] => EXP
[95] => EXPONDIST
[96] => FACT
[97] => FACTDOUBLE
[98] => FALSE
[99] => FIND
[100] => FINDB
[101] => FISHER
[102] => FISHERINV
[103] => FIXED
[104] => FLOOR
[105] => FORECAST
[106] => FV
[107] => FVSCHEDULE
[108] => GAMMADIST
[109] => GAMMAINV
[110] => GAMMALN
[111] => GCD
[112] => GEOMEAN
[113] => GESTEP
[114] => GROWTH
[115] => HARMEAN
[116] => HEX2BIN
[117] => HEX2DEC
[118] => HEX2OCT
[119] => HOUR
[120] => HYPERLINK
[121] => HYPGEOMDIST
[122] => IF
[123] => IFERROR
[124] => IMABS
[125] => IMAGINARY
[126] => IMARGUMENT
[127] => IMCONJUGATE
[128] => IMCOS
[129] => IMDIV
[130] => IMEXP
[131] => IMLN
[132] => IMLOG10
[133] => IMLOG2
[134] => IMPOWER
[135] => IMPRODUCT
[136] => IMREAL
[137] => IMSIN
[138] => IMSQRT
[139] => IMSUB
[140] => IMSUM
[141] => INDEX
[142] => INDIRECT
[143] => INT
[144] => INTERCEPT
[145] => INTRATE
[146] => IPMT
[147] => IRR
[148] => ISBLANK
[149] => ISERR
[150] => ISERROR
[151] => ISEVEN
[152] => ISLOGICAL
[153] => ISNA
[154] => ISNONTEXT
[155] => ISNUMBER
[156] => ISODD
[157] => ISPMT
[158] => ISTEXT
[159] => KURT
[160] => LARGE
[161] => LCM
[162] => LEFT
[163] => LEFTB
[164] => LEN
[165] => LENB
[166] => LINEST
[167] => LN
[168] => LOG
[169] => LOG10
[170] => LOGEST
[171] => LOGINV
[172] => LOGNORMDIST
[173] => LOOKUP
[174] => LOWER
[175] => MATCH
[176] => MAX
[177] => MAXA
[178] => MAXIF
[179] => MDETERM
[180] => MEDIAN
[181] => MID
[182] => MIDB
[183] => MIN
[184] => MINA
[185] => MINIF
[186] => MINUTE
[187] => MINVERSE
[188] => MIRR
[189] => MMULT
[190] => MOD
[191] => MODE
[192] => MONTH
[193] => MROUND
[194] => MULTINOMIAL
[195] => N
[196] => NA
[197] => NEGBINOMDIST
[198] => NETWORKDAYS
[199] => NOMINAL
[200] => NORMDIST
[201] => NORMINV
[202] => NORMSDIST
[203] => NORMSINV
[204] => NOT
[205] => NOW
[206] => NPER
[207] => NPV
[208] => OCT2BIN
[209] => OCT2DEC
[210] => OCT2HEX
[211] => ODD
[212] => OFFSET
[213] => OR
[214] => PEARSON
[215] => PERCENTILE
[216] => PERCENTRANK
[217] => PERMUT
[218] => PI
[219] => PMT
[220] => POISSON
[221] => POWER
[222] => PPMT
[223] => PRICE
[224] => PRICEDISC
[225] => PRICEMAT
[226] => PRODUCT
[227] => PROPER
[228] => PV
[229] => QUARTILE
[230] => QUOTIENT
[231] => RADIANS
[232] => RAND
[233] => RANDBETWEEN
[234] => RANK
[235] => RATE
[236] => RECEIVED
[237] => REPLACE
[238] => REPLACEB
[239] => REPT
[240] => RIGHT
[241] => RIGHTB
[242] => ROMAN
[243] => ROUND
[244] => ROUNDDOWN
[245] => ROUNDUP
[246] => ROW
[247] => ROWS
[248] => RSQ
[249] => SEARCH
[250] => SEARCHB
[251] => SECOND
[252] => SERIESSUM
[253] => SIGN
[254] => SIN
[255] => SINH
[256] => SKEW
[257] => SLN
[258] => SLOPE
[259] => SMALL
[260] => SQRT
[261] => SQRTPI
[262] => STANDARDIZE
[263] => STDEV
[264] => STDEVA
[265] => STDEVP
[266] => STDEVPA
[267] => STEYX
[268] => SUBSTITUTE
[269] => SUBTOTAL
[270] => SUM
[271] => SUMIF
[272] => SUMPRODUCT
[273] => SUMSQ
[274] => SUMX2MY2
[275] => SUMX2PY2
[276] => SUMXMY2
[277] => SYD
[278] => T
[279] => TAN
[280] => TANH
[281] => TBILLEQ
[282] => TBILLPRICE
[283] => TBILLYIELD
[284] => TDIST
[285] => TEXT
[286] => TIME
[287] => TIMEVALUE
[288] => TINV
[289] => TODAY
[290] => TRANSPOSE
[291] => TREND
[292] => TRIM
[293] => TRIMMEAN
[294] => TRUE
[295] => TRUNC
[296] => TYPE
[297] => UPPER
[298] => VAR
[299] => VARA
[300] => VARP
[301] => VARPA
[302] => VERSION
[303] => VLOOKUP
[304] => WEEKDAY
[305] => WEEKNUM
[306] => WEIBULL
[307] => WORKDAY
[308] => XIRR
[309] => XNPV
[310] => YEAR
[311] => YEARFRAC
[312] => YIELDDISC
[313] => YIELDMAT
[314] => ZTEST
)
21:24:21 Create new PHPExcel object
21:24:21 Add some data
21:24:21 Calculated data
Value of B14 [=COUNT(B2:B12)]: 7
Value of B15 [=SUM(B2:B12)]: 64
Value of B16 [=MAX(B2:B12)]: 22
Value of B17 [=MIN(B2:B12)]: 2
Value of B18 [=AVERAGE(B2:B12)]: 9.142857142857142
Value of B19 [=MEDIAN(B2:B12)]: 8
Value of B20 [=MODE(B2:B12)]: #N/A
Value of B22 [=COUNTA(B2:B12)]: 10
Value of B23 [=MAXA(B2:B12)]: 22
Value of B24 [=MINA(B2:B12)]: 0
Value of B26 [=STDEV(B2:B12)]: 6.618876325292973
Value of B27 [=STDEVA(B2:B12)]: 6.883958809354461
Value of B28 [=STDEVP(B2:B12)]: 6.127888739864919
Value of B29 [=STDEVPA(B2:B12)]: 6.530696746902279
Value of B31 [=DEVSQ(B2:B12)]: 262.8571428571429
Value of B32 [=VAR(B2:B12)]: 47.44444444444444
Value of B33 [=VARA(B2:B12)]: 47.38888888888889
Value of B34 [=VARP(B2:B12)]: 42.17283950617284
Value of B35 [=VARPA(B2:B12)]: 42.65
Value of C14 [=COUNT(C2:C12)]: 11
Value of C15 [=SUM(C2:C12)]: 30
Value of C16 [=MAX(C2:C12)]: 4
Value of C17 [=MIN(C2:C12)]: 0
Value of C18 [=AVERAGE(C2:C12)]: 2.727272727272727
Value of C19 [=MEDIAN(C2:C12)]: 3
Value of C20 [=MODE(C2:C12)]: 4
Value of C22 [=COUNTA(C2:C12)]: 11
Value of C23 [=MAXA(C2:C12)]: 4
Value of C24 [=MINA(C2:C12)]: 0
Value of C26 [=STDEV(C2:C12)]: 1.348399724926484
Value of C27 [=STDEVA(C2:C12)]: 1.348399724926484
Value of C28 [=STDEVP(C2:C12)]: 1.28564869306645
Value of C29 [=STDEVPA(C2:C12)]: 1.28564869306645
Value of C31 [=DEVSQ(C2:C12)]: 18.18181818181818
Value of C32 [=VAR(C2:C12)]: 1.818181818181818
Value of C33 [=VARA(C2:C12)]: 1.818181818181818
Value of C34 [=VARP(C2:C12)]: 1.652892561983471
Value of C35 [=VARPA(C2:C12)]: 1.652892561983471
Value of B37 [=DATE(2007, 12, 21)]: 39437
Value of B38 [=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )]: 1
Value of B39 [=DATEVALUE("01-Feb-2006 10:06 AM")]: 38749
Value of B40 [=DAY( DATE(2006, 1, 2) )]: 2
Value of B41 [=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )]: 1198
21:24:21 Peak memory usage: 4 MB
21:24:21 Done.
============== TEST ==============
Test name: 14excel5.php
21:24:22 Create new PHPExcel object
21:24:22 Set properties
21:24:22 Add some data
21:24:22 Add comments
21:24:22 Add rich-text string
21:24:22 Merge cells
21:24:22 Protect cells
21:24:22 Set cell number formats
21:24:22 Set column widths
21:24:22 Set fonts
21:24:22 Set alignments
21:24:22 Set thin black border outline around column
21:24:22 Set thick brown border outline around Total
21:24:22 Set fills
21:24:22 Set style for header row using alternative method
21:24:22 Unprotect a cell
21:24:22 Add a hyperlink to the sheet
21:24:22 Add a drawing to the worksheet
21:24:22 Add a drawing to the worksheet
21:24:22 Add a drawing to the worksheet
21:24:22 Play around with inserting and removing rows and columns
21:24:22 Set header/footer
21:24:22 Set page orientation and size
21:24:22 Rename sheet
21:24:22 Create new Worksheet object
21:24:22 Add some data
21:24:22 Set the worksheet tab color
21:24:22 Set alignments
21:24:22 Set column widths
21:24:22 Set fonts
21:24:22 Add a drawing to the worksheet
21:24:22 Set page orientation and size
21:24:22 Rename sheet
21:24:22 Write to Excel5 format
21:24:22 Peak memory usage: 6 MB
21:24:22 Done writing files.
============== TEST ==============
Test name: 15datavalidation.php
21:24:22 Create new PHPExcel object
21:24:22 Set properties
21:24:22 Add data
21:24:22 Set data validation
21:24:22 Write to Excel2007 format
============== TEST ==============
Test name: 16csv.php
21:24:22 Create new PHPExcel object
21:24:22 Set properties
21:24:22 Add some data
21:24:22 Add comments
21:24:22 Add rich-text string
21:24:22 Merge cells
21:24:22 Protect cells
21:24:22 Set cell number formats
21:24:22 Set column widths
21:24:22 Set fonts
21:24:22 Set alignments
21:24:22 Set thin black border outline around column
21:24:22 Set thick brown border outline around Total
21:24:22 Set fills
21:24:22 Set style for header row using alternative method
21:24:22 Unprotect a cell
21:24:22 Add a hyperlink to the sheet
21:24:22 Add a drawing to the worksheet
21:24:22 Add a drawing to the worksheet
21:24:22 Add a drawing to the worksheet
21:24:22 Play around with inserting and removing rows and columns
21:24:22 Set header/footer
21:24:22 Set page orientation and size
21:24:22 Rename sheet
21:24:22 Create new Worksheet object
21:24:22 Add some data
21:24:22 Set the worksheet tab color
21:24:22 Set alignments
21:24:22 Set column widths
21:24:22 Set fonts
21:24:22 Add a drawing to the worksheet
21:24:22 Set page orientation and size
21:24:22 Rename sheet
21:24:22 Write to CSV format
21:24:22 Read from CSV format
21:24:22 Write to Excel2007 format
============== TEST ==============
Test name: 17html.php
21:24:22 Create new PHPExcel object
21:24:22 Set properties
21:24:22 Add some data
21:24:22 Add comments
21:24:22 Add rich-text string
21:24:22 Merge cells
21:24:22 Protect cells
21:24:22 Set cell number formats
21:24:22 Set column widths
21:24:22 Set fonts
21:24:22 Set alignments
21:24:22 Set thin black border outline around column
21:24:22 Set thick brown border outline around Total
21:24:22 Set fills
21:24:22 Set style for header row using alternative method
21:24:22 Unprotect a cell
21:24:22 Add a hyperlink to the sheet
21:24:22 Add a drawing to the worksheet
21:24:22 Add a drawing to the worksheet
21:24:22 Add a drawing to the worksheet
21:24:22 Play around with inserting and removing rows and columns
21:24:22 Set header/footer
21:24:22 Set page orientation and size
21:24:22 Rename sheet
21:24:22 Create new Worksheet object
21:24:22 Add some data
21:24:22 Set the worksheet tab color
21:24:22 Set alignments
21:24:22 Set column widths
21:24:22 Set fonts
21:24:22 Add a drawing to the worksheet
21:24:22 Set page orientation and size
21:24:22 Rename sheet
21:24:22 Write to HTML format
21:24:22 Peak memory usage: 6 MB
21:24:22 Done writing files.
============== TEST ==============
Test name: 18extendedcalculation.php
21:24:22 List implemented functions
Array
(
[0] => ABS
[1] => ACCRINT
[2] => ACCRINTM
[3] => ACOS
[4] => ACOSH
[5] => ADDRESS
[6] => AMORDEGRC
[7] => AMORLINC
[8] => AND
[9] => ASIN
[10] => ASINH
[11] => ATAN
[12] => ATAN2
[13] => ATANH
[14] => AVEDEV
[15] => AVERAGE
[16] => AVERAGEA
[17] => AVERAGEIF
[18] => BESSELI
[19] => BESSELJ
[20] => BESSELK
[21] => BESSELY
[22] => BETADIST
[23] => BETAINV
[24] => BIN2DEC
[25] => BIN2HEX
[26] => BIN2OCT
[27] => BINOMDIST
[28] => CEILING
[29] => CHAR
[30] => CHIDIST
[31] => CHIINV
[32] => CHOOSE
[33] => CLEAN
[34] => CODE
[35] => COLUMN
[36] => COLUMNS
[37] => COMBIN
[38] => COMPLEX
[39] => CONCATENATE
[40] => CONFIDENCE
[41] => CONVERT
[42] => CORREL
[43] => COS
[44] => COSH
[45] => COUNT
[46] => COUNTA
[47] => COUNTBLANK
[48] => COUNTIF
[49] => COUPDAYBS
[50] => COUPDAYS
[51] => COUPDAYSNC
[52] => COUPNCD
[53] => COUPNUM
[54] => COUPPCD
[55] => COVAR
[56] => CRITBINOM
[57] => CUMIPMT
[58] => CUMPRINC
[59] => DATE
[60] => DATEDIF
[61] => DATEVALUE
[62] => DAY
[63] => DAYS360
[64] => DB
[65] => DCOUNT
[66] => DCOUNTA
[67] => DDB
[68] => DEC2BIN
[69] => DEC2HEX
[70] => DEC2OCT
[71] => DEGREES
[72] => DELTA
[73] => DEVSQ
[74] => DGET
[75] => DISC
[76] => DMAX
[77] => DMIN
[78] => DOLLAR
[79] => DOLLARDE
[80] => DOLLARFR
[81] => DPRODUCT
[82] => DSTDEV
[83] => DSTDEVP
[84] => DSUM
[85] => DVAR
[86] => DVARP
[87] => EDATE
[88] => EFFECT
[89] => EOMONTH
[90] => ERF
[91] => ERFC
[92] => ERROR.TYPE
[93] => EVEN
[94] => EXP
[95] => EXPONDIST
[96] => FACT
[97] => FACTDOUBLE
[98] => FALSE
[99] => FIND
[100] => FINDB
[101] => FISHER
[102] => FISHERINV
[103] => FIXED
[104] => FLOOR
[105] => FORECAST
[106] => FV
[107] => FVSCHEDULE
[108] => GAMMADIST
[109] => GAMMAINV
[110] => GAMMALN
[111] => GCD
[112] => GEOMEAN
[113] => GESTEP
[114] => GROWTH
[115] => HARMEAN
[116] => HEX2BIN
[117] => HEX2DEC
[118] => HEX2OCT
[119] => HOUR
[120] => HYPERLINK
[121] => HYPGEOMDIST
[122] => IF
[123] => IFERROR
[124] => IMABS
[125] => IMAGINARY
[126] => IMARGUMENT
[127] => IMCONJUGATE
[128] => IMCOS
[129] => IMDIV
[130] => IMEXP
[131] => IMLN
[132] => IMLOG10
[133] => IMLOG2
[134] => IMPOWER
[135] => IMPRODUCT
[136] => IMREAL
[137] => IMSIN
[138] => IMSQRT
[139] => IMSUB
[140] => IMSUM
[141] => INDEX
[142] => INDIRECT
[143] => INT
[144] => INTERCEPT
[145] => INTRATE
[146] => IPMT
[147] => IRR
[148] => ISBLANK
[149] => ISERR
[150] => ISERROR
[151] => ISEVEN
[152] => ISLOGICAL
[153] => ISNA
[154] => ISNONTEXT
[155] => ISNUMBER
[156] => ISODD
[157] => ISPMT
[158] => ISTEXT
[159] => KURT
[160] => LARGE
[161] => LCM
[162] => LEFT
[163] => LEFTB
[164] => LEN
[165] => LENB
[166] => LINEST
[167] => LN
[168] => LOG
[169] => LOG10
[170] => LOGEST
[171] => LOGINV
[172] => LOGNORMDIST
[173] => LOOKUP
[174] => LOWER
[175] => MATCH
[176] => MAX
[177] => MAXA
[178] => MAXIF
[179] => MDETERM
[180] => MEDIAN
[181] => MID
[182] => MIDB
[183] => MIN
[184] => MINA
[185] => MINIF
[186] => MINUTE
[187] => MINVERSE
[188] => MIRR
[189] => MMULT
[190] => MOD
[191] => MODE
[192] => MONTH
[193] => MROUND
[194] => MULTINOMIAL
[195] => N
[196] => NA
[197] => NEGBINOMDIST
[198] => NETWORKDAYS
[199] => NOMINAL
[200] => NORMDIST
[201] => NORMINV
[202] => NORMSDIST
[203] => NORMSINV
[204] => NOT
[205] => NOW
[206] => NPER
[207] => NPV
[208] => OCT2BIN
[209] => OCT2DEC
[210] => OCT2HEX
[211] => ODD
[212] => OFFSET
[213] => OR
[214] => PEARSON
[215] => PERCENTILE
[216] => PERCENTRANK
[217] => PERMUT
[218] => PI
[219] => PMT
[220] => POISSON
[221] => POWER
[222] => PPMT
[223] => PRICE
[224] => PRICEDISC
[225] => PRICEMAT
[226] => PRODUCT
[227] => PROPER
[228] => PV
[229] => QUARTILE
[230] => QUOTIENT
[231] => RADIANS
[232] => RAND
[233] => RANDBETWEEN
[234] => RANK
[235] => RATE
[236] => RECEIVED
[237] => REPLACE
[238] => REPLACEB
[239] => REPT
[240] => RIGHT
[241] => RIGHTB
[242] => ROMAN
[243] => ROUND
[244] => ROUNDDOWN
[245] => ROUNDUP
[246] => ROW
[247] => ROWS
[248] => RSQ
[249] => SEARCH
[250] => SEARCHB
[251] => SECOND
[252] => SERIESSUM
[253] => SIGN
[254] => SIN
[255] => SINH
[256] => SKEW
[257] => SLN
[258] => SLOPE
[259] => SMALL
[260] => SQRT
[261] => SQRTPI
[262] => STANDARDIZE
[263] => STDEV
[264] => STDEVA
[265] => STDEVP
[266] => STDEVPA
[267] => STEYX
[268] => SUBSTITUTE
[269] => SUBTOTAL
[270] => SUM
[271] => SUMIF
[272] => SUMPRODUCT
[273] => SUMSQ
[274] => SUMX2MY2
[275] => SUMX2PY2
[276] => SUMXMY2
[277] => SYD
[278] => T
[279] => TAN
[280] => TANH
[281] => TBILLEQ
[282] => TBILLPRICE
[283] => TBILLYIELD
[284] => TDIST
[285] => TEXT
[286] => TIME
[287] => TIMEVALUE
[288] => TINV
[289] => TODAY
[290] => TRANSPOSE
[291] => TREND
[292] => TRIM
[293] => TRIMMEAN
[294] => TRUE
[295] => TRUNC
[296] => TYPE
[297] => UPPER
[298] => VAR
[299] => VARA
[300] => VARP
[301] => VARPA
[302] => VERSION
[303] => VLOOKUP
[304] => WEEKDAY
[305] => WEEKNUM
[306] => WEIBULL
[307] => WORKDAY
[308] => XIRR
[309] => XNPV
[310] => YEAR
[311] => YEARFRAC
[312] => YIELDDISC
[313] => YIELDMAT
[314] => ZTEST
)
21:24:22 Create new PHPExcel object
21:24:22 Add some data
21:24:22 Calculated data
Value of B14 [=COUNT(B2:B12)]: 7
Value of B15 [=SUM(B2:B12)]: 64
Value of B16 [=MAX(B2:B12)]: 22
Value of B17 [=MIN(B2:B12)]: 2
Value of B18 [=AVERAGE(B2:B12)]: 9.142857142857142
Value of B19 [=MEDIAN(B2:B12)]: 8
Value of B20 [=MODE(B2:B12)]: #N/A
Value of B22 [=COUNTA(B2:B12)]: 10
Value of B23 [=MAXA(B2:B12)]: 22
Value of B24 [=MINA(B2:B12)]: 0
Value of B26 [=STDEV(B2:B12)]: 6.618876325292973
Value of B27 [=STDEVA(B2:B12)]: 6.883958809354461
Value of B28 [=STDEVP(B2:B12)]: 6.127888739864919
Value of B29 [=STDEVPA(B2:B12)]: 6.530696746902279
Value of B31 [=DEVSQ(B2:B12)]: 262.8571428571429
Value of B32 [=VAR(B2:B12)]: 47.44444444444444
Value of B33 [=VARA(B2:B12)]: 47.38888888888889
Value of B34 [=VARP(B2:B12)]: 42.17283950617284
Value of B35 [=VARPA(B2:B12)]: 42.65
Value of C14 [=COUNT(C2:C12)]: 11
Value of C15 [=SUM(C2:C12)]: 30
Value of C16 [=MAX(C2:C12)]: 4
Value of C17 [=MIN(C2:C12)]: 0
Value of C18 [=AVERAGE(C2:C12)]: 2.727272727272727
Value of C19 [=MEDIAN(C2:C12)]: 3
Value of C20 [=MODE(C2:C12)]: 4
Value of C22 [=COUNTA(C2:C12)]: 11
Value of C23 [=MAXA(C2:C12)]: 4
Value of C24 [=MINA(C2:C12)]: 0
Value of C26 [=STDEV(C2:C12)]: 1.348399724926484
Value of C27 [=STDEVA(C2:C12)]: 1.348399724926484
Value of C28 [=STDEVP(C2:C12)]: 1.28564869306645
Value of C29 [=STDEVPA(C2:C12)]: 1.28564869306645
Value of C31 [=DEVSQ(C2:C12)]: 18.18181818181818
Value of C32 [=VAR(C2:C12)]: 1.818181818181818
Value of C33 [=VARA(C2:C12)]: 1.818181818181818
Value of C34 [=VARP(C2:C12)]: 1.652892561983471
Value of C35 [=VARPA(C2:C12)]: 1.652892561983471
21:24:22 Peak memory usage: 4 MB
21:24:22 Done.
============== TEST ==============
Test name: 19namedrange.php
21:24:22 Create new PHPExcel object
21:24:22 Set properties
21:24:22 Add some data
21:24:22 Define named ranges
21:24:22 Rename named ranges
21:24:22 Rename sheet
21:24:22 Create new Worksheet object
21:24:22 Add some data
21:24:22 Resolve range
Cell B1 {=PersonFN}: Maarten
Cell B3 {=PersonFN & " " & PersonLN}: Maarten Balliauw
Cell Person!B1: Maarten
21:24:22 Rename sheet
21:24:22 Write to Excel2007 format
============== TEST ==============
Test name: 20readexcel5.php
21:24:22 Load from Excel5 file
21:24:22 Write to Excel2007 format
============== TEST ==============
Test name: 21pdf.php
21:24:22 Create new PHPExcel object
21:24:22 Set properties
21:24:22 Add some data
21:24:22 Add comments
21:24:22 Add rich-text string
21:24:22 Merge cells
21:24:22 Protect cells
21:24:22 Set cell number formats
21:24:22 Set column widths
21:24:22 Set fonts
21:24:22 Set alignments
21:24:22 Set thin black border outline around column
21:24:22 Set thick brown border outline around Total
21:24:22 Set fills
21:24:22 Set style for header row using alternative method
21:24:22 Unprotect a cell
21:24:22 Add a hyperlink to the sheet
21:24:22 Add a drawing to the worksheet
21:24:22 Add a drawing to the worksheet
21:24:22 Add a drawing to the worksheet
21:24:22 Play around with inserting and removing rows and columns
21:24:22 Set header/footer
21:24:22 Set page orientation and size
21:24:22 Rename sheet
21:24:22 Create new Worksheet object
21:24:22 Add some data
21:24:22 Set the worksheet tab color
21:24:22 Set alignments
21:24:22 Set column widths
21:24:22 Set fonts
21:24:22 Add a drawing to the worksheet
21:24:22 Set page orientation and size
21:24:22 Rename sheet
21:24:22 Hide grid lines
21:24:22 Set orientation to landscape
21:24:22 Write to PDF format
21:24:22 Peak memory usage: 18 MB
21:24:22 Done writing files.
============== TEST ==============
Test name: 22heavilyformatted.php
21:24:22 Create new PHPExcel object
21:24:22 Set properties
21:24:22 Add some data
21:24:22 Write to Excel2007 format
============== TEST ==============
Test name: 23sharedstyles.php
21:24:23 Create new PHPExcel object
21:24:23 Set properties
21:24:23 Add some data
21:24:23 Write to Excel2007 format
============== TEST ==============
Test name: 24readfilter.php
Please run 06largescale.php first.
============== TEST ==============
Test name: 25inmemoryimage.php
21:24:23 Create new PHPExcel object
21:24:23 Set properties
21:24:23 Generate an image
21:24:23 Add a drawing to the worksheet
21:24:23 Write to Excel2007 format
============== TEST ==============
Test name: 26utf8.php
21:24:23 Create new PHPExcel object
21:24:23 Load Excel2007 template file
============== TEST ==============
Test name: 27imagesexcel5.php
21:24:23 Create new PHPExcel object
21:24:23 Load Excel2007 template file
21:24:23 Write to Excel5 format
============== TEST ==============
Test name: 28iterator.php
Please run 05featuredemo.php first.
============== TEST ==============
Test name: 29advancedvaluebinder.php
21:24:23 Set timezone
21:24:23 Set value binder
21:24:23 Create new PHPExcel object
21:24:23 Set properties
21:24:23 Set default font
21:24:23 Set column widths
21:24:23 Add some data
21:24:23 Rename sheet
21:24:23 Write to Excel5 format
21:24:23 Peak memory usage: 6 MB
21:24:23 Done writing file.
============== TEST ==============
Test name: 30template.php
21:24:23 Load from Excel5 template
21:24:23 Add new data to the template
21:24:23 Write to Excel5 format
21:24:23 Peak memory usage: 6 MB
21:24:23 Done writing file.
============== TEST ==============
Test name: OOCalcReader.php
PHPExcel OOCalc Reader Test
21:24:23 Load from OOCalc file
============== TEST ==============
Test name: SylkReader.php
21:24:23 Load from SYLK file
21:24:23 Write to Excel2007 format
============== TEST ==============
Test name: Excel2003XMLReader.php
PHPExcel Excel2003XML Reader Test
21:24:23 Load from Excel2003XML file
Call time to read Workbook was 0.2307 seconds
21:24:23 Current memory usage: 4 MB
21:24:23 Write to Excel2007 format
============== TEST ==============
Test name: XMLReader.php
21:24:23 Load from XML file
Loading XMLTest.xml using Excel2003XML Reader
21:24:23 Write to Excel2007 format
============== TEST ==============
Test name: GnumericReader.php
PHPExcel Gnumeric Reader Test
21:24:24 Load from Gnumeric file
Call time to read Workbook was 0.0712 seconds
21:24:24 Current memory usage: 4 MB
21:24:24 Write to Excel2007 format