28 Iterator

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