28 Iterator

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