28 Iterator

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