28 Iterator

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