28 Iterator

16:05:04 Create new Spreadsheet object
16:05:04 Set document properties
16:05:04 Add some data
16:05:04 Add comments
16:05:04 Add rich-text string
16:05:04 Merge cells
16:05:04 Protect cells
16:05:04 Set cell number formats
16:05:04 Set column widths
16:05:04 Set fonts
16:05:04 Set alignments
16:05:04 Set thin black border outline around column
16:05:04 Set thick brown border outline around Total
16:05:04 Set fills
16:05:04 Set style for header row using alternative method
16:05:04 Unprotect a cell
16:05:04 Add a hyperlink to an external website
16:05:04 Add a hyperlink to another cell on a different worksheet within the workbook
16:05:04 Add a drawing to the worksheet
16:05:04 Add a drawing to the worksheet
16:05:04 Add a drawing to the worksheet
16:05:04 Play around with inserting and removing rows and columns
16:05:05 Set header/footer
16:05:05 Set page orientation and size
16:05:05 Rename first worksheet
16:05:05 Create a second Worksheet object
16:05:05 Add some data
16:05:05 Set the worksheet tab color
16:05:05 Set alignments
16:05:05 Set column widths
16:05:05 Set fonts
16:05:05 Add a drawing to the worksheet
16:05:05 Set page orientation and size
16:05:05 Rename second worksheet
16:05:05 Write Xlsx format to /tmp/phpspreadsheet/phpspreadsheet-GgwHQE.xlsx in 0.0266 seconds
16:05:05 Read Xlsx format from /tmp/phpspreadsheet/phpspreadsheet-GgwHQE.xlsx in 0.0231 seconds
16:05:05 Iterate worksheets
16:05:05 Worksheet - Invoice
16:05:05 Row number - 1
16:05:05 Cell - A1 -
16:05:05 Cell - B1 - Invoice
16:05:05 Cell - C1 -
16:05:05 Cell - D1 - 43395
16:05:05 Cell - E1 - #12566
16:05:05 Row number - 2
16:05:05 Cell - A2 -
16:05:05 Cell - B2 -
16:05:05 Cell - C2 -
16:05:05 Cell - D2 -
16:05:05 Cell - E2 -
16:05:05 Row number - 3
16:05:05 Cell - A3 - Product Id
16:05:05 Cell - B3 - Description
16:05:05 Cell - C3 - Price
16:05:05 Cell - D3 - Amount
16:05:05 Cell - E3 - Total
16:05:05 Row number - 4
16:05:05 Cell - A4 - 1001
16:05:05 Cell - B4 - PHP for dummies
16:05:05 Cell - C4 - 20
16:05:05 Cell - D4 - 1
16:05:05 Cell - E4 - 20
16:05:05 Row number - 5
16:05:05 Cell - A5 - 1012
16:05:05 Cell - B5 - OpenXML for dummies
16:05:05 Cell - C5 - 22
16:05:05 Cell - D5 - 2
16:05:05 Cell - E5 - 44
16:05:05 Row number - 6
16:05:05 Cell - A6 -
16:05:05 Cell - B6 -
16:05:05 Cell - C6 -
16:05:05 Cell - D6 -
16:05:05 Cell - E6 -
16:05:05 Row number - 7
16:05:05 Cell - A7 -
16:05:05 Cell - B7 -
16:05:05 Cell - C7 -
16:05:05 Cell - D7 -
16:05:05 Cell - E7 -
16:05:05 Row number - 8
16:05:05 Cell - A8 -
16:05:05 Cell - B8 -
16:05:05 Cell - C8 -
16:05:05 Cell - D8 -
16:05:05 Cell - E8 -
16:05:05 Row number - 9
16:05:05 Cell - A9 -
16:05:05 Cell - B9 -
16:05:05 Cell - C9 -
16:05:05 Cell - D9 -
16:05:05 Cell - E9 -
16:05:05 Row number - 10
16:05:05 Cell - A10 -
16:05:05 Cell - B10 -
16:05:05 Cell - C10 -
16:05:05 Cell - D10 -
16:05:05 Cell - E10 -
16:05:05 Row number - 11
16:05:05 Cell - A11 -
16:05:05 Cell - B11 -
16:05:05 Cell - C11 -
16:05:05 Cell - D11 - Total excl.:
16:05:05 Cell - E11 - 64
16:05:05 Row number - 12
16:05:05 Cell - A12 -
16:05:05 Cell - B12 -
16:05:05 Cell - C12 -
16:05:05 Cell - D12 - VAT:
16:05:05 Cell - E12 - 13.44
16:05:05 Row number - 13
16:05:05 Cell - A13 -
16:05:05 Cell - B13 -
16:05:05 Cell - C13 -
16:05:05 Cell - D13 - Total incl.:
16:05:05 Cell - E13 - 77.44
16:05:05 Row number - 14
16:05:05 Cell - A14 -
16:05:05 Cell - B14 -
16:05:05 Cell - C14 -
16:05:05 Cell - D14 -
16:05:05 Cell - E14 -
16:05:05 Row number - 15
16:05:05 Cell - A15 -
16:05:05 Cell - B15 -
16:05:05 Cell - C15 -
16:05:05 Cell - D15 -
16:05:05 Cell - E15 -
16:05:05 Row number - 16
16:05:05 Cell - A16 -
16:05:05 Cell - B16 -
16:05:05 Cell - C16 -
16:05:05 Cell - D16 -
16:05:05 Cell - E16 -
16:05:05 Row number - 17
16:05:05 Cell - A17 -
16:05:05 Cell - B17 -
16:05:05 Cell - C17 -
16:05:05 Cell - D17 -
16:05:05 Cell - E17 -
16:05:05 Row number - 18
16:05:05 Cell - A18 - payable within thirty days after the end of the month
16:05:05 Cell - B18 -
16:05:05 Cell - C18 -
16:05:05 Cell - D18 -
16:05:05 Cell - E18 -
16:05:05 Row number - 19
16:05:05 Cell - A19 -
16:05:05 Cell - B19 -
16:05:05 Cell - C19 -
16:05:05 Cell - D19 -
16:05:05 Cell - E19 -
16:05:05 Row number - 20
16:05:05 Cell - A20 -
16:05:05 Cell - B20 -
16:05:05 Cell - C20 -
16:05:05 Cell - D20 -
16:05:05 Cell - E20 -
16:05:05 Row number - 21
16:05:05 Cell - A21 -
16:05:05 Cell - B21 -
16:05:05 Cell - C21 -
16:05:05 Cell - D21 -
16:05:05 Cell - E21 -
16:05:05 Row number - 22
16:05:05 Cell - A22 -
16:05:05 Cell - B22 -
16:05:05 Cell - C22 -
16:05:05 Cell - D22 -
16:05:05 Cell - E22 -
16:05:05 Row number - 23
16:05:05 Cell - A23 -
16:05:05 Cell - B23 -
16:05:05 Cell - C23 -
16:05:05 Cell - D23 -
16:05:05 Cell - E23 -
16:05:05 Row number - 24
16:05:05 Cell - A24 -
16:05:05 Cell - B24 -
16:05:05 Cell - C24 -
16:05:05 Cell - D24 -
16:05:05 Cell - E24 -
16:05:05 Row number - 25
16:05:05 Cell - A25 -
16:05:05 Cell - B25 -
16:05:05 Cell - C25 -
16:05:05 Cell - D25 -
16:05:05 Cell - E25 -
16:05:05 Row number - 26
16:05:05 Cell - A26 -
16:05:05 Cell - B26 -
16:05:05 Cell - C26 -
16:05:05 Cell - D26 -
16:05:05 Cell - E26 - www.phpexcel.net
16:05:05 Row number - 27
16:05:05 Cell - A27 -
16:05:05 Cell - B27 -
16:05:05 Cell - C27 -
16:05:05 Cell - D27 -
16:05:05 Cell - E27 - Terms and conditions
16:05:05 Row number - 28
16:05:05 Cell - A28 -
16:05:05 Cell - B28 -
16:05:05 Cell - C28 -
16:05:05 Cell - D28 -
16:05:05 Cell - E28 -
16:05:05 Worksheet - Terms and conditions
16:05:05 Row number - 1
16:05:05 Cell - A1 - Terms and conditions
16:05:05 Cell - B1 -
16:05:05 Row number - 2
16:05:05 Cell - A2 -
16:05:05 Cell - B2 -
16:05:05 Row number - 3
16:05:05 Cell - A3 - Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus eget ante. Sed cursus nunc semper tortor. Aliquam luctus purus non elit. Fusce vel elit commodo sapien dignissim dignissim. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Curabitur accumsan magna sed massa. Nullam bibendum quam ac ipsum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin augue. Praesent malesuada justo sed orci. Pellentesque lacus ligula, sodales quis, ultricies a, ultricies vitae, elit. Sed luctus consectetuer dolor. Vivamus vel sem ut nisi sodales accumsan. Nunc et felis. Suspendisse semper viverra odio. Morbi at odio. Integer a orci a purus venenatis molestie. Nam mattis. Praesent rhoncus, nisi vel mattis auctor, neque nisi faucibus sem, non dapibus elit pede ac nisl. Cras turpis.
16:05:05 Cell - B3 -
16:05:05 Row number - 4
16:05:05 Cell - A4 - Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus eget ante. Sed cursus nunc semper tortor. Aliquam luctus purus non elit. Fusce vel elit commodo sapien dignissim dignissim. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Curabitur accumsan magna sed massa. Nullam bibendum quam ac ipsum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin augue. Praesent malesuada justo sed orci. Pellentesque lacus ligula, sodales quis, ultricies a, ultricies vitae, elit. Sed luctus consectetuer dolor. Vivamus vel sem ut nisi sodales accumsan. Nunc et felis. Suspendisse semper viverra odio. Morbi at odio. Integer a orci a purus venenatis molestie. Nam mattis. Praesent rhoncus, nisi vel mattis auctor, neque nisi faucibus sem, non dapibus elit pede ac nisl. Cras turpis.
16:05:05 Cell - B4 -
16:05:05 Row number - 5
16:05:05 Cell - A5 - Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus eget ante. Sed cursus nunc semper tortor. Aliquam luctus purus non elit. Fusce vel elit commodo sapien dignissim dignissim. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Curabitur accumsan magna sed massa. Nullam bibendum quam ac ipsum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin augue. Praesent malesuada justo sed orci. Pellentesque lacus ligula, sodales quis, ultricies a, ultricies vitae, elit. Sed luctus consectetuer dolor. Vivamus vel sem ut nisi sodales accumsan. Nunc et felis. Suspendisse semper viverra odio. Morbi at odio. Integer a orci a purus venenatis molestie. Nam mattis. Praesent rhoncus, nisi vel mattis auctor, neque nisi faucibus sem, non dapibus elit pede ac nisl. Cras turpis.
16:05:05 Cell - B5 -
16:05:05 Row number - 6
16:05:05 Cell - A6 - Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus eget ante. Sed cursus nunc semper tortor. Aliquam luctus purus non elit. Fusce vel elit commodo sapien dignissim dignissim. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Curabitur accumsan magna sed massa. Nullam bibendum quam ac ipsum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin augue. Praesent malesuada justo sed orci. Pellentesque lacus ligula, sodales quis, ultricies a, ultricies vitae, elit. Sed luctus consectetuer dolor. Vivamus vel sem ut nisi sodales accumsan. Nunc et felis. Suspendisse semper viverra odio. Morbi at odio. Integer a orci a purus venenatis molestie. Nam mattis. Praesent rhoncus, nisi vel mattis auctor, neque nisi faucibus sem, non dapibus elit pede ac nisl. Cras turpis.
16:05:05 Cell - B6 -
16:05:05 Row number - 7
16:05:05 Cell - A7 -
16:05:05 Cell - B7 -
16:05:05 Row number - 8
16:05:05 Cell - A8 -
16:05:05 Cell - B8 -
16:05:05 Row number - 9
16:05:05 Cell - A9 -
16:05:05 Cell - B9 -
16:05:05 Row number - 10
16:05:05 Cell - A10 -
16:05:05 Cell - B10 -
16:05:05 Row number - 11
16:05:05 Cell - A11 -
16:05:05 Cell - B11 -
16:05:05 Row number - 12
16:05:05 Cell - A12 -
16:05:05 Cell - B12 -
16:05:05 Row number - 13
16:05:05 Cell - A13 -
16:05:05 Cell - B13 -
16:05:05 Row number - 14
16:05:05 Cell - A14 -
16:05:05 Cell - B14 -