28 Iterator

17:01:38 Create new Spreadsheet object
17:01:38 Set document properties
17:01:38 Add some data
17:01:38 Add comments
17:01:38 Add rich-text string
17:01:38 Merge cells
17:01:38 Protect cells
17:01:38 Set cell number formats
17:01:38 Set column widths
17:01:38 Set fonts
17:01:38 Set alignments
17:01:38 Set thin black border outline around column
17:01:38 Set thick brown border outline around Total
17:01:38 Set fills
17:01:38 Set style for header row using alternative method
17:01:38 Unprotect a cell
17:01:38 Add a hyperlink to an external website
17:01:38 Add a hyperlink to another cell on a different worksheet within the workbook
17:01:38 Add a drawing to the worksheet
17:01:38 Add a drawing to the worksheet
17:01:38 Add a drawing to the worksheet
17:01:38 Play around with inserting and removing rows and columns
17:01:38 Set header/footer
17:01:38 Set page orientation and size
17:01:38 Rename first worksheet
17:01:38 Create a second Worksheet object
17:01:38 Add some data
17:01:38 Set the worksheet tab color
17:01:38 Set alignments
17:01:38 Set column widths
17:01:38 Set fonts
17:01:38 Add a drawing to the worksheet
17:01:38 Set page orientation and size
17:01:38 Rename second worksheet
17:01:38 Write Xlsx format to /tmp/phpspreadsheet/phpspreadsheet-Qc7qfz.xlsx in 0.0449 seconds
17:01:38 Read Xlsx format from /tmp/phpspreadsheet/phpspreadsheet-Qc7qfz.xlsx in 0.0390 seconds
17:01:38 Iterate worksheets
17:01:38 Worksheet - Invoice
17:01:38 Row number - 1
17:01:38 Cell - A1 -
17:01:38 Cell - B1 - Invoice
17:01:38 Cell - C1 -
17:01:38 Cell - D1 - 43928
17:01:38 Cell - E1 - #12566
17:01:38 Row number - 2
17:01:38 Cell - A2 -
17:01:38 Cell - B2 -
17:01:38 Cell - C2 -
17:01:38 Cell - D2 -
17:01:38 Cell - E2 -
17:01:38 Row number - 3
17:01:38 Cell - A3 - Product Id
17:01:38 Cell - B3 - Description
17:01:38 Cell - C3 - Price
17:01:38 Cell - D3 - Amount
17:01:38 Cell - E3 - Total
17:01:38 Row number - 4
17:01:38 Cell - A4 - 1001
17:01:38 Cell - B4 - PHP for dummies
17:01:38 Cell - C4 - 20
17:01:38 Cell - D4 - 1
17:01:38 Cell - E4 - 20
17:01:38 Row number - 5
17:01:38 Cell - A5 - 1012
17:01:38 Cell - B5 - OpenXML for dummies
17:01:38 Cell - C5 - 22
17:01:38 Cell - D5 - 2
17:01:38 Cell - E5 - 44
17:01:38 Row number - 6
17:01:38 Cell - A6 -
17:01:38 Cell - B6 -
17:01:38 Cell - C6 -
17:01:38 Cell - D6 -
17:01:38 Cell - E6 -
17:01:38 Row number - 7
17:01:38 Cell - A7 -
17:01:38 Cell - B7 -
17:01:38 Cell - C7 -
17:01:38 Cell - D7 -
17:01:38 Cell - E7 -
17:01:38 Row number - 8
17:01:38 Cell - A8 -
17:01:38 Cell - B8 -
17:01:38 Cell - C8 -
17:01:38 Cell - D8 -
17:01:38 Cell - E8 -
17:01:38 Row number - 9
17:01:38 Cell - A9 -
17:01:38 Cell - B9 -
17:01:38 Cell - C9 -
17:01:38 Cell - D9 -
17:01:38 Cell - E9 -
17:01:38 Row number - 10
17:01:38 Cell - A10 -
17:01:38 Cell - B10 -
17:01:38 Cell - C10 -
17:01:38 Cell - D10 -
17:01:38 Cell - E10 -
17:01:38 Row number - 11
17:01:38 Cell - A11 -
17:01:38 Cell - B11 -
17:01:38 Cell - C11 -
17:01:38 Cell - D11 - Total excl.:
17:01:38 Cell - E11 - 64
17:01:38 Row number - 12
17:01:38 Cell - A12 -
17:01:38 Cell - B12 -
17:01:38 Cell - C12 -
17:01:38 Cell - D12 - VAT:
17:01:38 Cell - E12 - 13.44
17:01:38 Row number - 13
17:01:38 Cell - A13 -
17:01:38 Cell - B13 -
17:01:38 Cell - C13 -
17:01:38 Cell - D13 - Total incl.:
17:01:38 Cell - E13 - 77.44
17:01:38 Row number - 14
17:01:38 Cell - A14 -
17:01:38 Cell - B14 -
17:01:38 Cell - C14 -
17:01:38 Cell - D14 -
17:01:38 Cell - E14 -
17:01:38 Row number - 15
17:01:38 Cell - A15 -
17:01:38 Cell - B15 -
17:01:38 Cell - C15 -
17:01:38 Cell - D15 -
17:01:38 Cell - E15 -
17:01:38 Row number - 16
17:01:38 Cell - A16 -
17:01:38 Cell - B16 -
17:01:38 Cell - C16 -
17:01:38 Cell - D16 -
17:01:38 Cell - E16 -
17:01:38 Row number - 17
17:01:38 Cell - A17 -
17:01:38 Cell - B17 -
17:01:38 Cell - C17 -
17:01:38 Cell - D17 -
17:01:38 Cell - E17 -
17:01:38 Row number - 18
17:01:38 Cell - A18 - This invoice is payable within thirty days after the end of the month, unless specified otherwise on the invoice.
17:01:38 Cell - B18 -
17:01:38 Cell - C18 -
17:01:38 Cell - D18 -
17:01:38 Cell - E18 -
17:01:38 Row number - 19
17:01:38 Cell - A19 -
17:01:38 Cell - B19 -
17:01:38 Cell - C19 -
17:01:38 Cell - D19 -
17:01:38 Cell - E19 -
17:01:38 Row number - 20
17:01:38 Cell - A20 -
17:01:38 Cell - B20 -
17:01:38 Cell - C20 -
17:01:38 Cell - D20 -
17:01:38 Cell - E20 -
17:01:38 Row number - 21
17:01:38 Cell - A21 -
17:01:38 Cell - B21 -
17:01:38 Cell - C21 -
17:01:38 Cell - D21 -
17:01:38 Cell - E21 -
17:01:38 Row number - 22
17:01:38 Cell - A22 -
17:01:38 Cell - B22 -
17:01:38 Cell - C22 -
17:01:38 Cell - D22 -
17:01:38 Cell - E22 -
17:01:38 Row number - 23
17:01:38 Cell - A23 -
17:01:38 Cell - B23 -
17:01:38 Cell - C23 -
17:01:38 Cell - D23 -
17:01:38 Cell - E23 -
17:01:38 Row number - 24
17:01:38 Cell - A24 -
17:01:38 Cell - B24 -
17:01:38 Cell - C24 -
17:01:38 Cell - D24 -
17:01:38 Cell - E24 -
17:01:38 Row number - 25
17:01:38 Cell - A25 -
17:01:38 Cell - B25 -
17:01:38 Cell - C25 -
17:01:38 Cell - D25 -
17:01:38 Cell - E25 -
17:01:38 Row number - 26
17:01:38 Cell - A26 -
17:01:38 Cell - B26 -
17:01:38 Cell - C26 -
17:01:38 Cell - D26 -
17:01:38 Cell - E26 - www.phpexcel.net
17:01:38 Row number - 27
17:01:38 Cell - A27 -
17:01:38 Cell - B27 -
17:01:38 Cell - C27 -
17:01:38 Cell - D27 -
17:01:38 Cell - E27 - Terms and conditions
17:01:38 Row number - 28
17:01:38 Cell - A28 -
17:01:38 Cell - B28 -
17:01:38 Cell - C28 -
17:01:38 Cell - D28 -
17:01:38 Cell - E28 -
17:01:38 Worksheet - Terms and conditions
17:01:38 Row number - 1
17:01:38 Cell - A1 - Terms and conditions
17:01:38 Cell - B1 -
17:01:38 Row number - 2
17:01:38 Cell - A2 -
17:01:38 Cell - B2 -
17:01:38 Row number - 3
17:01:38 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.
17:01:38 Cell - B3 -
17:01:38 Row number - 4
17:01:38 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.
17:01:38 Cell - B4 -
17:01:38 Row number - 5
17:01:38 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.
17:01:38 Cell - B5 -
17:01:38 Row number - 6
17:01:38 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.
17:01:38 Cell - B6 -
17:01:38 Row number - 7
17:01:38 Cell - A7 -
17:01:38 Cell - B7 -
17:01:38 Row number - 8
17:01:38 Cell - A8 -
17:01:38 Cell - B8 -
17:01:38 Row number - 9
17:01:38 Cell - A9 -
17:01:38 Cell - B9 -
17:01:38 Row number - 10
17:01:38 Cell - A10 -
17:01:38 Cell - B10 -
17:01:38 Row number - 11
17:01:38 Cell - A11 -
17:01:38 Cell - B11 -
17:01:38 Row number - 12
17:01:38 Cell - A12 -
17:01:38 Cell - B12 -
17:01:38 Row number - 13
17:01:38 Cell - A13 -
17:01:38 Cell - B13 -
17:01:38 Row number - 14
17:01:38 Cell - A14 -
17:01:38 Cell - B14 -