============== TEST ============== Test name: 01simple.php 02:38:28 Create new PHPExcel object 02:38:28 Set document properties 02:38:28 Add some data 02:38:28 Rename worksheet 02:38:28 Write to Excel2007 format ============== TEST ============== Test name: 02types.php 02:38:28 Create new PHPExcel object 02:38:28 Set document properties 02:38:28 Set default font 02:38:28 Add some data 02:38:28 Rename worksheet 02:38:28 Write to Excel2007 format ============== TEST ============== Test name: 02types-xls.php 02:38:28 Create new PHPExcel object 02:38:28 Set document properties 02:38:28 Set default font 02:38:28 Add some data 02:38:28 Rename worksheet 02:38:28 Write to Excel5 format ============== TEST ============== Test name: 03formulas.php 02:38:28 Create new PHPExcel object 02:38:28 Set document properties 02:38:28 Add some data 02:38:28 Sum of Range #1 is ============== TEST ============== Test name: 04printing.php 02:38:28 Create new PHPExcel object 02:38:28 Set document properties 02:38:28 Add some data 02:38:28 Set header/footer 02:38:28 Add a drawing to the header 02:38:28 Set page orientation and size 02:38:28 Rename worksheet 02:38:28 Write to Excel2007 format ============== TEST ============== Test name: 05featuredemo.php 02:38:28 Create new PHPExcel object 02:38:28 Set document properties 02:38:28 Add some data 02:38:28 Add comments 02:38:28 Add rich-text string 02:38:28 Merge cells 02:38:28 Protect cells 02:38:28 Set cell number formats 02:38:28 Set column widths 02:38:28 Set fonts 02:38:28 Set alignments 02:38:28 Set thin black border outline around column 02:38:28 Set thick brown border outline around Total 02:38:28 Set fills 02:38:28 Set style for header row using alternative method 02:38:28 Unprotect a cell 02:38:28 Add a hyperlink to the sheet 02:38:28 Add a drawing to the worksheet 02:38:28 Add a drawing to the worksheet 02:38:28 Add a drawing to the worksheet 02:38:28 Play around with inserting and removing rows and columns 02:38:28 Set header/footer 02:38:28 Set page orientation and size 02:38:28 Rename first worksheet 02:38:28 Create a second Worksheet object 02:38:28 Add some data 02:38:28 Set the worksheet tab color 02:38:28 Set alignments 02:38:28 Set column widths 02:38:28 Set fonts 02:38:28 Add a drawing to the worksheet 02:38:28 Set page orientation and size 02:38:28 Rename second worksheet 02:38:28 Write to Excel2007 format ============== TEST ============== Test name: 06largescale.php 02:38:29 Create new PHPExcel object 02:38:29 Set properties 02:38:29 Add data 02:38:29 Hide 'Phone' and 'fax' columns 02:38:29 Set outline levels 02:38:29 Freeze panes 02:38:29 Rows to repeat at top 02:38:29 Write to Excel2007 format ============== TEST ============== Test name: 06largescale-xls.php 02:38:29 Create new PHPExcel object 02:38:29 Set properties 02:38:29 Add data 02:38:29 Hide 'Phone' and 'fax' columns 02:38:29 Set outline levels 02:38:29 Freeze panes 02:38:29 Rows to repeat at top 02:38:29 Write to Excel5 format ============== TEST ============== Test name: 07reader.php 02:38:29 Load from Excel2007 file 02:38:29 Write to Excel2007 format ============== TEST ============== Test name: 08conditionalformatting.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add some data 02:38:30 Set column widths 02:38:30 Add conditional formatting 02:38:30 Duplicate the conditional formatting across a range of cells 02:38:30 Set fonts 02:38:30 Set header/footer 02:38:30 Set page orientation and size 02:38:30 Rename worksheet 02:38:30 Write to Excel2007 format ============== TEST ============== Test name: 09pagebreaks.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add data and page breaks 02:38:30 Write to Excel2007 format ============== TEST ============== Test name: 10autofilter.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add data 02:38:30 Set title row bold 02:38:30 Set autofilter 02:38:30 Write to Excel2007 format ============== TEST ============== Test name: 11documentsecurity.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add some data 02:38:30 Rename worksheet 02:38:30 Set document security 02:38:30 Set sheet security 02:38:30 Write to Excel2007 format ============== TEST ============== Test name: 11documentsecurity-xls.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add some data 02:38:30 Rename worksheet 02:38:30 Set document security 02:38:30 Set sheet security 02:38:30 Write to Excel5 format ============== TEST ============== Test name: 13calculation.php 02:38:30 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] => DAVERAGE [63] => DAY [64] => DAYS360 [65] => DB [66] => DCOUNT [67] => DCOUNTA [68] => DDB [69] => DEC2BIN [70] => DEC2HEX [71] => DEC2OCT [72] => DEGREES [73] => DELTA [74] => DEVSQ [75] => DGET [76] => DISC [77] => DMAX [78] => DMIN [79] => DOLLAR [80] => DOLLARDE [81] => DOLLARFR [82] => DPRODUCT [83] => DSTDEV [84] => DSTDEVP [85] => DSUM [86] => DVAR [87] => DVARP [88] => EDATE [89] => EFFECT [90] => EOMONTH [91] => ERF [92] => ERFC [93] => ERROR.TYPE [94] => EVEN [95] => EXP [96] => EXPONDIST [97] => FACT [98] => FACTDOUBLE [99] => FALSE [100] => FIND [101] => FINDB [102] => FISHER [103] => FISHERINV [104] => FIXED [105] => FLOOR [106] => FORECAST [107] => FV [108] => FVSCHEDULE [109] => GAMMADIST [110] => GAMMAINV [111] => GAMMALN [112] => GCD [113] => GEOMEAN [114] => GESTEP [115] => GROWTH [116] => HARMEAN [117] => HEX2BIN [118] => HEX2DEC [119] => HEX2OCT [120] => HOUR [121] => HYPERLINK [122] => HYPGEOMDIST [123] => IF [124] => IFERROR [125] => IMABS [126] => IMAGINARY [127] => IMARGUMENT [128] => IMCONJUGATE [129] => IMCOS [130] => IMDIV [131] => IMEXP [132] => IMLN [133] => IMLOG10 [134] => IMLOG2 [135] => IMPOWER [136] => IMPRODUCT [137] => IMREAL [138] => IMSIN [139] => IMSQRT [140] => IMSUB [141] => IMSUM [142] => INDEX [143] => INDIRECT [144] => INT [145] => INTERCEPT [146] => INTRATE [147] => IPMT [148] => IRR [149] => ISBLANK [150] => ISERR [151] => ISERROR [152] => ISEVEN [153] => ISLOGICAL [154] => ISNA [155] => ISNONTEXT [156] => ISNUMBER [157] => ISODD [158] => ISPMT [159] => ISTEXT [160] => KURT [161] => LARGE [162] => LCM [163] => LEFT [164] => LEFTB [165] => LEN [166] => LENB [167] => LINEST [168] => LN [169] => LOG [170] => LOG10 [171] => LOGEST [172] => LOGINV [173] => LOGNORMDIST [174] => LOOKUP [175] => LOWER [176] => MATCH [177] => MAX [178] => MAXA [179] => MAXIF [180] => MDETERM [181] => MEDIAN [182] => MID [183] => MIDB [184] => MIN [185] => MINA [186] => MINIF [187] => MINUTE [188] => MINVERSE [189] => MIRR [190] => MMULT [191] => MOD [192] => MODE [193] => MONTH [194] => MROUND [195] => MULTINOMIAL [196] => N [197] => NA [198] => NEGBINOMDIST [199] => NETWORKDAYS [200] => NOMINAL [201] => NORMDIST [202] => NORMINV [203] => NORMSDIST [204] => NORMSINV [205] => NOT [206] => NOW [207] => NPER [208] => NPV [209] => OCT2BIN [210] => OCT2DEC [211] => OCT2HEX [212] => ODD [213] => OFFSET [214] => OR [215] => PEARSON [216] => PERCENTILE [217] => PERCENTRANK [218] => PERMUT [219] => PI [220] => PMT [221] => POISSON [222] => POWER [223] => PPMT [224] => PRICE [225] => PRICEDISC [226] => PRICEMAT [227] => PRODUCT [228] => PROPER [229] => PV [230] => QUARTILE [231] => QUOTIENT [232] => RADIANS [233] => RAND [234] => RANDBETWEEN [235] => RANK [236] => RATE [237] => RECEIVED [238] => REPLACE [239] => REPLACEB [240] => REPT [241] => RIGHT [242] => RIGHTB [243] => ROMAN [244] => ROUND [245] => ROUNDDOWN [246] => ROUNDUP [247] => ROW [248] => ROWS [249] => RSQ [250] => SEARCH [251] => SEARCHB [252] => SECOND [253] => SERIESSUM [254] => SIGN [255] => SIN [256] => SINH [257] => SKEW [258] => SLN [259] => SLOPE [260] => SMALL [261] => SQRT [262] => SQRTPI [263] => STANDARDIZE [264] => STDEV [265] => STDEVA [266] => STDEVP [267] => STDEVPA [268] => STEYX [269] => SUBSTITUTE [270] => SUBTOTAL [271] => SUM [272] => SUMIF [273] => SUMPRODUCT [274] => SUMSQ [275] => SUMX2MY2 [276] => SUMX2PY2 [277] => SUMXMY2 [278] => SYD [279] => T [280] => TAN [281] => TANH [282] => TBILLEQ [283] => TBILLPRICE [284] => TBILLYIELD [285] => TDIST [286] => TEXT [287] => TIME [288] => TIMEVALUE [289] => TINV [290] => TODAY [291] => TRANSPOSE [292] => TREND [293] => TRIM [294] => TRIMMEAN [295] => TRUE [296] => TRUNC [297] => TYPE [298] => UPPER [299] => VAR [300] => VARA [301] => VARP [302] => VARPA [303] => VERSION [304] => VLOOKUP [305] => WEEKDAY [306] => WEEKNUM [307] => WEIBULL [308] => WORKDAY [309] => XIRR [310] => XNPV [311] => YEAR [312] => YEARFRAC [313] => YIELDDISC [314] => YIELDMAT [315] => ZTEST ) 02:38:30 Create new PHPExcel object 02:38:30 Add some data and formulas 02:38:30 Calculated data Value of B14 [=COUNT(B2:B12)]: ============== TEST ============== Test name: 14excel5.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add some data 02:38:30 Add comments 02:38:30 Add rich-text string 02:38:30 Merge cells 02:38:30 Protect cells 02:38:30 Set cell number formats 02:38:30 Set column widths 02:38:30 Set fonts 02:38:30 Set alignments 02:38:30 Set thin black border outline around column 02:38:30 Set thick brown border outline around Total 02:38:30 Set fills 02:38:30 Set style for header row using alternative method 02:38:30 Unprotect a cell 02:38:30 Add a hyperlink to the sheet 02:38:30 Add a drawing to the worksheet 02:38:30 Add a drawing to the worksheet 02:38:30 Add a drawing to the worksheet 02:38:30 Play around with inserting and removing rows and columns 02:38:30 Set header/footer 02:38:30 Set page orientation and size 02:38:30 Rename first worksheet 02:38:30 Create a second Worksheet object 02:38:30 Add some data 02:38:30 Set the worksheet tab color 02:38:30 Set alignments 02:38:30 Set column widths 02:38:30 Set fonts 02:38:30 Add a drawing to the worksheet 02:38:30 Set page orientation and size 02:38:30 Rename second worksheet 02:38:30 Write to Excel5 format ============== TEST ============== Test name: 15datavalidation.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add data 02:38:30 Set data validation 02:38:30 Write to Excel2007 format ============== TEST ============== Test name: 15datavalidation-xls.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add data 02:38:30 Set data validation 02:38:30 Write to Excel5 format ============== TEST ============== Test name: 16csv.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add some data 02:38:30 Add comments 02:38:30 Add rich-text string 02:38:30 Merge cells 02:38:30 Protect cells 02:38:30 Set cell number formats 02:38:30 Set column widths 02:38:30 Set fonts 02:38:30 Set alignments 02:38:30 Set thin black border outline around column 02:38:30 Set thick brown border outline around Total 02:38:30 Set fills 02:38:30 Set style for header row using alternative method 02:38:30 Unprotect a cell 02:38:30 Add a hyperlink to the sheet 02:38:30 Add a drawing to the worksheet 02:38:30 Add a drawing to the worksheet 02:38:30 Add a drawing to the worksheet 02:38:30 Play around with inserting and removing rows and columns 02:38:30 Set header/footer 02:38:30 Set page orientation and size 02:38:30 Rename first worksheet 02:38:30 Create a second Worksheet object 02:38:30 Add some data 02:38:30 Set the worksheet tab color 02:38:30 Set alignments 02:38:30 Set column widths 02:38:30 Set fonts 02:38:30 Add a drawing to the worksheet 02:38:30 Set page orientation and size 02:38:30 Rename second worksheet 02:38:30 Write to CSV format ============== TEST ============== Test name: 17html.php 02:38:30 Create new PHPExcel object 02:38:30 Set document properties 02:38:30 Add some data 02:38:30 Add comments 02:38:30 Add rich-text string 02:38:30 Merge cells 02:38:30 Protect cells 02:38:30 Set cell number formats 02:38:30 Set column widths 02:38:30 Set fonts 02:38:30 Set alignments 02:38:30 Set thin black border outline around column 02:38:30 Set thick brown border outline around Total 02:38:30 Set fills 02:38:30 Set style for header row using alternative method 02:38:30 Unprotect a cell 02:38:30 Add a hyperlink to the sheet 02:38:30 Add a drawing to the worksheet 02:38:30 Add a drawing to the worksheet 02:38:30 Add a drawing to the worksheet 02:38:30 Play around with inserting and removing rows and columns 02:38:30 Set header/footer 02:38:30 Set page orientation and size 02:38:30 Rename first worksheet 02:38:30 Create a second Worksheet object 02:38:30 Add some data 02:38:30 Set the worksheet tab color 02:38:30 Set alignments 02:38:30 Set column widths 02:38:30 Set fonts 02:38:30 Add a drawing to the worksheet 02:38:30 Set page orientation and size 02:38:30 Rename second worksheet 02:38:30 Write to HTML format ============== TEST ============== Test name: 18extendedcalculation.php 02:38:30 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] => DAVERAGE [63] => DAY [64] => DAYS360 [65] => DB [66] => DCOUNT [67] => DCOUNTA [68] => DDB [69] => DEC2BIN [70] => DEC2HEX [71] => DEC2OCT [72] => DEGREES [73] => DELTA [74] => DEVSQ [75] => DGET [76] => DISC [77] => DMAX [78] => DMIN [79] => DOLLAR [80] => DOLLARDE [81] => DOLLARFR [82] => DPRODUCT [83] => DSTDEV [84] => DSTDEVP [85] => DSUM [86] => DVAR [87] => DVARP [88] => EDATE [89] => EFFECT [90] => EOMONTH [91] => ERF [92] => ERFC [93] => ERROR.TYPE [94] => EVEN [95] => EXP [96] => EXPONDIST [97] => FACT [98] => FACTDOUBLE [99] => FALSE [100] => FIND [101] => FINDB [102] => FISHER [103] => FISHERINV [104] => FIXED [105] => FLOOR [106] => FORECAST [107] => FV [108] => FVSCHEDULE [109] => GAMMADIST [110] => GAMMAINV [111] => GAMMALN [112] => GCD [113] => GEOMEAN [114] => GESTEP [115] => GROWTH [116] => HARMEAN [117] => HEX2BIN [118] => HEX2DEC [119] => HEX2OCT [120] => HOUR [121] => HYPERLINK [122] => HYPGEOMDIST [123] => IF [124] => IFERROR [125] => IMABS [126] => IMAGINARY [127] => IMARGUMENT [128] => IMCONJUGATE [129] => IMCOS [130] => IMDIV [131] => IMEXP [132] => IMLN [133] => IMLOG10 [134] => IMLOG2 [135] => IMPOWER [136] => IMPRODUCT [137] => IMREAL [138] => IMSIN [139] => IMSQRT [140] => IMSUB [141] => IMSUM [142] => INDEX [143] => INDIRECT [144] => INT [145] => INTERCEPT [146] => INTRATE [147] => IPMT [148] => IRR [149] => ISBLANK [150] => ISERR [151] => ISERROR [152] => ISEVEN [153] => ISLOGICAL [154] => ISNA [155] => ISNONTEXT [156] => ISNUMBER [157] => ISODD [158] => ISPMT [159] => ISTEXT [160] => KURT [161] => LARGE [162] => LCM [163] => LEFT [164] => LEFTB [165] => LEN [166] => LENB [167] => LINEST [168] => LN [169] => LOG [170] => LOG10 [171] => LOGEST [172] => LOGINV [173] => LOGNORMDIST [174] => LOOKUP [175] => LOWER [176] => MATCH [177] => MAX [178] => MAXA [179] => MAXIF [180] => MDETERM [181] => MEDIAN [182] => MID [183] => MIDB [184] => MIN [185] => MINA [186] => MINIF [187] => MINUTE [188] => MINVERSE [189] => MIRR [190] => MMULT [191] => MOD [192] => MODE [193] => MONTH [194] => MROUND [195] => MULTINOMIAL [196] => N [197] => NA [198] => NEGBINOMDIST [199] => NETWORKDAYS [200] => NOMINAL [201] => NORMDIST [202] => NORMINV [203] => NORMSDIST [204] => NORMSINV [205] => NOT [206] => NOW [207] => NPER [208] => NPV [209] => OCT2BIN [210] => OCT2DEC [211] => OCT2HEX [212] => ODD [213] => OFFSET [214] => OR [215] => PEARSON [216] => PERCENTILE [217] => PERCENTRANK [218] => PERMUT [219] => PI [220] => PMT [221] => POISSON [222] => POWER [223] => PPMT [224] => PRICE [225] => PRICEDISC [226] => PRICEMAT [227] => PRODUCT [228] => PROPER [229] => PV [230] => QUARTILE [231] => QUOTIENT [232] => RADIANS [233] => RAND [234] => RANDBETWEEN [235] => RANK [236] => RATE [237] => RECEIVED [238] => REPLACE [239] => REPLACEB [240] => REPT [241] => RIGHT [242] => RIGHTB [243] => ROMAN [244] => ROUND [245] => ROUNDDOWN [246] => ROUNDUP [247] => ROW [248] => ROWS [249] => RSQ [250] => SEARCH [251] => SEARCHB [252] => SECOND [253] => SERIESSUM [254] => SIGN [255] => SIN [256] => SINH [257] => SKEW [258] => SLN [259] => SLOPE [260] => SMALL [261] => SQRT [262] => SQRTPI [263] => STANDARDIZE [264] => STDEV [265] => STDEVA [266] => STDEVP [267] => STDEVPA [268] => STEYX [269] => SUBSTITUTE [270] => SUBTOTAL [271] => SUM [272] => SUMIF [273] => SUMPRODUCT [274] => SUMSQ [275] => SUMX2MY2 [276] => SUMX2PY2 [277] => SUMXMY2 [278] => SYD [279] => T [280] => TAN [281] => TANH [282] => TBILLEQ [283] => TBILLPRICE [284] => TBILLYIELD [285] => TDIST [286] => TEXT [287] => TIME [288] => TIMEVALUE [289] => TINV [290] => TODAY [291] => TRANSPOSE [292] => TREND [293] => TRIM [294] => TRIMMEAN [295] => TRUE [296] => TRUNC [297] => TYPE [298] => UPPER [299] => VAR [300] => VARA [301] => VARP [302] => VARPA [303] => VERSION [304] => VLOOKUP [305] => WEEKDAY [306] => WEEKNUM [307] => WEIBULL [308] => WORKDAY [309] => XIRR [310] => XNPV [311] => YEAR [312] => YEARFRAC [313] => YIELDDISC [314] => YIELDMAT [315] => ZTEST ) 02:38:30 Create new PHPExcel object 02:38:31 Add some data 02:38:31 Calculated data ============== TEST ============== Test name: 19namedrange.php 02:38:31 Create new PHPExcel object 02:38:31 Set document properties 02:38:31 Add some data 02:38:31 Define named ranges 02:38:31 Rename named ranges 02:38:31 Rename worksheet 02:38:31 Create new Worksheet object 02:38:31 Add some data 02:38:31 Resolve range Cell B1 {=PersonFN}: ============== TEST ============== Test name: 20readexcel5.php 02:38:31 Load workbook from Excel5 file 02:38:31 Write to Excel2007 format ============== TEST ============== Test name: 21pdf.php 02:38:31 Create new PHPExcel object 02:38:31 Set document properties 02:38:31 Add some data 02:38:31 Add comments 02:38:31 Add rich-text string 02:38:31 Merge cells 02:38:31 Protect cells 02:38:31 Set cell number formats 02:38:31 Set column widths 02:38:31 Set fonts 02:38:31 Set alignments 02:38:31 Set thin black border outline around column 02:38:31 Set thick brown border outline around Total 02:38:31 Set fills 02:38:31 Set style for header row using alternative method 02:38:31 Unprotect a cell 02:38:31 Add a hyperlink to the sheet 02:38:31 Add a drawing to the worksheet 02:38:31 Add a drawing to the worksheet 02:38:31 Add a drawing to the worksheet 02:38:31 Play around with inserting and removing rows and columns 02:38:31 Set header/footer 02:38:31 Set page orientation and size 02:38:31 Rename first worksheet 02:38:31 Create a second Worksheet object 02:38:31 Add some data 02:38:31 Set the worksheet tab color 02:38:31 Set alignments 02:38:31 Set column widths 02:38:31 Set fonts 02:38:31 Add a drawing to the worksheet 02:38:31 Set page orientation and size 02:38:31 Rename second worksheet 02:38:31 Hide grid lines 02:38:31 Set orientation to landscape 02:38:31 Write to PDF format ============== TEST ============== Test name: 22heavilyformatted.php 02:38:31 Create new PHPExcel object 02:38:31 Set document properties 02:38:31 Add some data 02:38:31 Write to Excel2007 format ============== TEST ============== Test name: 23sharedstyles.php 02:38:31 Create new PHPExcel object 02:38:31 Set document properties 02:38:31 Add some data 02:38:31 Write to Excel2007 format ============== TEST ============== Test name: 24readfilter.php 02:38:31 Load from Excel2007 file 02:38:31 Remove unnecessary rows 02:38:31 Write to Excel2007 format ============== TEST ============== Test name: 25inmemoryimage.php 02:38:31 Create new PHPExcel object 02:38:31 Set document properties 02:38:31 Generate an image 02:38:31 Add a drawing to the worksheet 02:38:31 Write to Excel2007 format ============== TEST ============== Test name: 26utf8.php 02:38:32 Load Excel2007 template file 02:38:32 Write to Excel5 format ============== TEST ============== Test name: 27imagesexcel5.php 02:38:32 Load Excel2007 template file 02:38:32 Write to Excel5 format ============== TEST ============== Test name: 28iterator.php 02:38:32 Load from Excel2007 file 02:38:32 Iterate worksheets Worksheet - Invoice Row number - 1 Cell - A1 - Cell - B1 - Invoice Cell - C1 - Cell - D1 - 41134 Cell - E1 - #12566 Cell - F1 - Cell - G1 - Cell - H1 - Cell - I1 - Cell - J1 - Row number - 2 Cell - A2 - Cell - B2 - Cell - C2 - Cell - D2 - Cell - E2 - Cell - F2 - Cell - G2 - Cell - H2 - Cell - I2 - Cell - J2 - Row number - 3 Cell - A3 - Product Id Cell - B3 - Description Cell - C3 - Price Cell - D3 - Amount Cell - E3 - Total Cell - F3 - Cell - G3 - Cell - H3 - Cell - I3 - Cell - J3 - Row number - 4 Cell - A4 - 1001 Cell - B4 - PHP for dummies Cell - C4 - 20 Cell - D4 - 1 Cell - E4 - ============== TEST ============== Test name: 29advancedvaluebinder.php 02:38:32 Set timezone 02:38:32 Set value binder 02:38:32 Create new PHPExcel object 02:38:32 Set document properties 02:38:32 Set default font 02:38:32 Set column widths 02:38:32 Add some data ============== TEST ============== Test name: 30template.php 02:38:32 Load from Excel5 template 02:38:32 Add new data to the template 02:38:32 Write to Excel5 format ============== TEST ============== Test name: 31docproperties_write.php 02:38:32 Load Tests from Excel2007 file Call time to read Workbook was 0.0266 seconds 02:38:32 Current memory usage: 4 MB 02:38:32 Adjust properties 02:38:32 Write to Excel2007 format ============== TEST ============== Test name: 31docproperties_write-xls.php 02:38:32 Load Tests from Excel5 file Call time to read Workbook was 0.0319 seconds 02:38:32 Current memory usage: 6 MB 02:38:32 Adjust properties 02:38:32 Write to Excel5 format ============== TEST ============== Test name: 32chartreadwrite.php 02:38:32 Load Test from Excel2007 file 32readwriteAreaChart1.xlsx 02:38:32 Iterate worksheets looking at the charts Worksheet: Data chart1 - "Sales" areaChart 02:38:32 Write Tests to Excel2007 file ============== TEST ============== Test name: OOCalcReader.php 02:38:32 Load from OOCalc file Call time to read Workbook was 0.0407 seconds 02:38:32 Current memory usage: 4 MB 02:38:32 Write to Excel2007 format ============== TEST ============== Test name: SylkReader.php 02:38:32 Load from SYLK file 02:38:32 Write to Excel2007 format ============== TEST ============== Test name: Excel2003XMLReader.php 02:38:32 Load from Excel2003XML file Call time to read Workbook was 0.2547 seconds 02:38:33 Current memory usage: 4 MB 02:38:33 Write to Excel5 format ============== TEST ============== Test name: XMLReader.php 02:38:33 Load from XML file Loading XMLTest.xml using Excel2003XML Reader 02:38:33 Write to Excel2007 format ============== TEST ============== Test name: GnumericReader.php 02:38:33 Load from Gnumeric file Call time to read Workbook was 0.0975 seconds 02:38:33 Current memory usage: 4 MB 02:38:33 Write to Excel2007 format