PHP code example of mnb / mnb-phpexcel-application

1. Go to this page and download the library: Download mnb/mnb-phpexcel-application library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

mnb / mnb-phpexcel-application example snippets


use Mnb\PHPExcel\MnbExcel;

$rows = MnbExcel::read('report.xlsx')
    ->sheet('Data')
    ->withHeaderRow()
    ->toArray();

MnbExcel::fromArray($rows)
    ->withHeader()
    ->freezeHeader()
    ->autoWidth()
    ->save('report-copy.xlsx');