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

Read Password-Encrypted XLSX Files

Detect encrypted workbooks, provide passwords safely, and handle wrong-password failures.

Updated

LevelAdvancedReading time9 minPackagemnb/mnb-phpexcel
Xlsx::isEncrypted()Xlsx::encryptionMode()ReaderOptions::withPassword()MnbExcel::decryptXlsx()

What you will learn

  • Detect encryption before starting a read.
  • Open Standard or Agile encrypted XLSX files.
  • Avoid leaking passwords into logs and manifests.

Detect encryption and mode#

PHP
use Mnb\PHPExcel\Format\Xlsx;

if (Xlsx::isEncrypted('secure-report.xlsx')) {
    printf("Mode: %s\n", Xlsx::encryptionMode('secure-report.xlsx') ?? 'unknown');
}

Read with an explicit password#

PHP
use Mnb\PHPExcel\Reader\Options\ReaderOptions;

$options = ReaderOptions::defaults()->withPassword($password);

foreach (MnbExcel::read('secure-report.xlsx', $options)
    ->sheet('Report')
    ->withHeaderRow(1)
    ->rows() as $row) {
    // Process decrypted rows.
}

Read a large encrypted workbook#

PHP
MnbExcel::largeRead('secure-orders.xlsx')
    ->password($password)
    ->sheet('Orders')
    ->withHeader()
    ->chunk(1000, $callback);

Handle password secrets correctly#

  • Read passwords from a secret store or protected configuration.
  • Never include the password in queue payload logs or failed-row exports.
  • Clear temporary decrypted files and restrict filesystem permissions.
  • Return a generic “password invalid or file unsupported” message to untrusted clients.