28 Iterator

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