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