Skip to content
PHP 8.1+ Open source Developer documentation
Tools Packagist
Docs v2.0.6
Documentation versions v2.0.6Current v2.0.5Maintenance v2.0.4Maintenance v2.0.3Maintenance v2.0.0Initial v2 Compare versions →
MNB PHPExcelDeveloper Guide
AI

XML library

Writing XML Output

Write row arrays, workbook wrappers, metadata, typed values, and arbitrary structured payloads as XML.

Level
Intermediate
Reading time
7 min
Package
mnb/mnb-phpexcel-xml
Updated
Xml::write()XmlWriter::writeWorkbook()XmlWriter::payloadToString()

Write associative rows#

PHP
Xml::write($products, 'products.xml', [
    'root' => 'products',
    'row_tag' => 'product',
    'include_row_number' => true,
    'declaration' => true,
    'pretty' => true,
]);

Write a complete workbook#

PHP
use Mnb\PHPExcel\Writer\XmlWriter;

$xml = (new XmlWriter())->workbookToString($workbook, [
    'root' => 'workbook',
    'sheet_tag' => 'sheet',
    'row_tag' => 'row',
    'include_metadata' => true,
    'workbook_wrapper' => true,
]);

Serialize any structured payload#

PHP
$payload = Xml::read('report.xml', ['row_tag' => 'row'])
    ->withHeaderRow(1)
    ->toStructuredWorkbookArray();

$xml = (new XmlWriter())->payloadToString($payload, [
    'root' => 'spreadsheet',
    'pretty' => true,
]);