| Server IP : 199.250.214.225 / Your IP : 18.189.195.251 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/funds/vendor/phpoffice/phpexcel/Documentation/markdown/Overview/ |
Upload File : |
# PHPExcel Developer Documentation ## Creating a spreadsheet ### The PHPExcel class The PHPExcel class is the core of PHPExcel. It contains references to the contained worksheets, document security settings and document meta data. To simplify the PHPExcel concept: the PHPExcel class represents your workbook. Typically, you will create a workbook in one of two ways, either by loading it from a spreadsheet file, or creating it manually. A third option, though less commonly used, is cloning an existing workbook that has been created using one of the previous two methods. #### Loading a Workbook from a file Details of the different spreadsheet formats supported, and the options available to read them into a PHPExcel object are described fully in the PHPExcel User Documentation - Reading Spreadsheet Files document. ```php $inputFileName = './sampleData/example1.xls'; /** Load $inputFileName to a PHPExcel Object **/ $objPHPExcel = PHPExcel_IOFactory::load($inputFileName); ``` #### Creating a new workbook If you want to create a new workbook, rather than load one from file, then you simply need to instantiate it as a new PHPExcel object. ```php /** Create a new PHPExcel Object **/ $objPHPExcel = new PHPExcel(); ``` A new workbook will always be created with a single worksheet.