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

Reading workbooks

Images, Styles, Links, Comments, and Metadata

Inspect workbook objects beyond plain cell values and extract embedded media safely.

Level
Advanced
Reading time
11 min
Package
mnb/mnb-phpexcel
Updated
images()extractImages()cellDetails()sheetMetadata()protection()

List images without loading image bytes#

PHP
$sheet = MnbExcel::read('catalog.xlsx')->sheet('Products');

foreach ($sheet->images(includeBytes: false) as $image) {
    printf("%s at %s\n", $image['filename'], $image['anchor']['from'] ?? '?');
}

Extract images safely#

PHP
$files = MnbExcel::read('catalog.xlsx')
    ->sheet('Products')
    ->extractImages(__DIR__ . '/storage/extracted-images');

Read metadata through a cell snapshot#

PHP
$cell = MnbExcel::read('review.xlsx')
    ->sheet('Review')
    ->cellDetails('B7');

print_r([
    'style' => $cell->style,
    'hyperlink' => $cell->hyperlink,
    'comment' => $cell->comment,
    'mergedRange' => $cell->mergedRange,
    'richText' => $cell->richText,
    'protection' => $cell->protection,
]);

Inspect worksheet-level metadata#

PHP
$sheet = MnbExcel::read('report.xlsx')->sheet('Summary');

print_r($sheet->sheetMetadata());
print_r($sheet->protection());