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

Data Validation, Comments, and Hyperlinks

Create user-friendly templates with dropdowns, validation rules, instructions, notes, and safe links.

Updated

LevelIntermediateReading time11 minPackagemnb/mnb-phpexcel
dataValidation()validationList()comment()hyperlink()importTemplate()

What you will learn

  • Generate guided import templates.
  • Add list and rule validation to ranges.
  • Add explanatory comments and controlled hyperlinks.

Create a dropdown list#

PHP
$workbook->validationList('D2:D5000', [
    'Draft',
    'Active',
    'Archived',
], [
    'prompt_title' => 'Status',
    'prompt' => 'Choose one of the available statuses.',
    'error_title' => 'Invalid status',
]);

Add numeric or date validation#

PHP
$workbook->dataValidation('C2:C5000', 'decimal', [
    'operator' => 'between',
    'formula1' => 0,
    'formula2' => 1000000,
    'allow_blank' => false,
]);
PHP
$workbook
    ->comment('A1', 'Import Guide', 'SKU is required and must be unique.')
    ->hyperlink('H2', 'https://example.com/products/123', 'Open product');

Generate a complete import template#

PHP
MnbExcel::domainImportTemplate('products', [
    'include_examples' => true,
    'include_instructions' => true,
])
    ->save('product-import-template.xlsx');