28 Iterator

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