28 Iterator

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