28 Iterator

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