Interactive tools

PHP Reader and Import Options Builder

Configure reader or database-import behavior and generate production-minded PHP without memorizing every fluent method or option key.

Level: All levels
Reading time: 8 min
Package: mnb/mnb-phpexcel or mnb/mnb-phpexcel-xlsx
Updated: August 1, 2026

PHP 8.1+Full packageIndividual XLSXInteractive builder

Available sincev2.0.5Version guide

Configure and generate PHP#

Generated locally in your browser

Reader workflow

Configure the read session

Choose only the options your application needs. The PHP preview updates immediately.

Quick start

Source

Package mode

Workbook pathUse a PHP path expression or a quoted path value.

Worksheet selection

Read behavior

Header row0 keeps numeric column indexes.

Result method

ColumnsComma-separated header names. Leave empty to read every column.

Maximum rows0 means no builder-level row limit.

Safety and cleanup

Skip empty rowsIgnore completely empty worksheet rows. Exception handlingInclude an MNB exception boundary in the generated script.

Ready — Reader configuration is valid.

Generated PHProws() · Full package

Nothing is uploaded or executed. Review paths, limits, workbook structure, and application error handling before production use.

Database workflow

Configure a dry-run-first import

Generate the import boundary, duplicate policy, batch size, and transaction behavior together.

Quick start

Source and destination

Workbook path

Worksheet

Database tableSimple table or schema.table identifier.

Import policy

Unique columnsComma-separated database columns used to detect existing rows.

Duplicate strategy

Batch size

Execution

Generate dry-run previewInspect planned inserts, updates, skips, and failures before changing data. Wrap final import in a transactionUsed only when the generated example performs the final import.

Ready — Import configuration is valid.

Generated PHPDry run · update duplicates · batch 500

Replace the sample PDO connection and column map. Keep upload validation, private storage, schema checks, logging, and public error responses in your application boundary.

Review before production#

Continue with the production-safe upload/import recipe →

Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.

Open an issue