28 Iterator

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