28 Iterator

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