MNB PHPExcelDeveloper Guide
v2.0.5
Reading workbooks

Images, Styles, Links, Comments, and Metadata

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

Updated

LevelAdvancedReading time11 minPackagemnb/mnb-phpexcel
images()extractImages()cellDetails()sheetMetadata()protection()

What you will learn

  • Inventory workbook objects without loading unnecessary binary data.
  • Extract media into a controlled directory.
  • Read style and protection metadata from detailed cells.

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());