28 Iterator

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