28 Iterator

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