PHP code example of iter8 / builder

1. Go to this page and download the library: Download iter8/builder 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/ */

iter8 / builder example snippets


$app['builder.default']   = 'spout'; // or 'phpspreadsheet'
$app['builder.cache_dir'] = '/var/cache';

$app->register(new BuilderServiceProvider());
// --- OR ---
$app->register(
    new BuilderServiceProvider(),
    [
        'builder.default'   => 'phpspreadsheet',
        'builder.cache_dir' => '/var/cache',
    ]
);


$builder = $app['builder'];

$reportArray = [
    'headers' => [
        'Column 1',
        'Column B',
    ],
    'rows' => [
        [
            'Some Data',
            'Some Other Data',
        ],
        [
            'Some Data 2',
            'Some Other Data 2',
        ],
    ],
];

$builder->setSheets([$reportArray]);

$builder->setCreator('App Name');
$builder->setTitle('My Spreadsheet');
$builder->setSheetTitles(['Sheet 1']);
$builder->setDescription('Spreadsheet that contains some data');
$builder->setFilename('App_Name_Spreadsheet_' . $startDate->format('d_m_Y'));

// use generate() to output headers and force file download.
$builder->generate();

// use generateExcel() to create the file.
$builder->generateExcel();