The methods ( setXXXX) are quite self explanatory and map to the “Properties” dialog quite well. The properties shown in the above dialog will have corresponding setXXXX methods to set these properties, where XXXX is almost identical to the property names listed in the dialog: $ea -> getProperties ( ) -> setCreator ( 'Taylor Ren' ) -> setTitle ( 'PHPExcel Demo' ) -> setLastModifiedBy ( 'Taylor Ren' ) -> setDescription ( 'A demo to show how to use PHPExcel to manipulate an Excel file' ) -> setSubject ( 'PHP Excel manipulation' ) -> setKeywords ( 'excel php office phpexcel lakers' ) -> setCategory ( 'programming' ) The meta data is shown when we “Alt-Enter” an Excel file (or right click on that file and choose “Properties”): It has its own meta data to describe the file that we create. To instantiate an Excel file, we use: $ea = new \PHPExcel ( ) // ea is short for Excel ApplicationĪn Excel application instance usually is mapped to a physical Excel file. Other important terms may include: cell, range, etc. These are the two most important terms in Excel. The worksheet is the “canvas” we play with. Under normal circumstances, it will also contain a workbook with 3 (in Excel 2013, only 1) worksheets. When we click the icon to launch Excel, the Excel application starts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |