28 Iterator

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