28 Iterator

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