28 Iterator

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