28 Iterator

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