28 Iterator

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