28 Iterator

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