28 Iterator

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