MNB PHPExcelDeveloper Guide
v2.0.5
Documentation versions v2.0.5Current v2.0.4Maintenance v2.0.3Maintenance v2.0.0Initial v2 Compare versions →
Writing workbooks

Create Workbooks and Worksheets

Build one-sheet reports or multi-sheet workbooks from PHP iterables and arrays.

Updated

PHP 8.1+Full packageNative XLSX
LevelBeginnerReading time10 minPackagemnb/mnb-phpexcel
MnbExcel::fromArray()MnbExcel::fromWorkbookArray()MnbExcel::report()WorkbookBuilder::save()

What you will learn

  • Create a workbook from associative data.
  • Create several worksheets in one file.
  • Choose a report-oriented or raw-data builder.

Create one worksheet from rows#

PHP
use Mnb\PHPExcel\MnbExcel;

MnbExcel::fromArray($rows)
    ->withHeader()
    ->save('data.xlsx');

Use report defaults for business output#

PHP
MnbExcel::report($rows, template: 'business')
    ->title('Monthly Sales')
    ->creator('Finance Application')
    ->company('Example Company')
    ->freezeHeader()
    ->autoFilter()
    ->autoWidth()
    ->save('monthly-sales.xlsx');

Create a multi-sheet workbook#

PHP
$workbook = MnbExcel::fromWorkbookArray([
    'Orders' => $orders,
    'Customers' => $customers,
    'Summary' => $summary,
]);

$workbook
    ->withHeader()
    ->autoWidth()
    ->save('operations.xlsx');

Save to an application-controlled path#

PHP
$path = MnbExcel::storagePath('exports', 'monthly-sales.xlsx');
$workbook->save($path);

Do not write directly to a filename received from a browser. Use safeFileName(), controlled directories, and explicit extensions.