28 Iterator

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