28 Iterator

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