Web workflows examples
Web workflows Excel examples, explained clearly.
Open a focused example to see the implementation path, copy-ready PHP, expected workbook behavior, and the production boundary that matters.
4examples in this category
21supported categories
5implementation paths
Monolithic library
Web workflows examples with copy-ready, production-minded PHP.
Each example identifies the exact methods it uses and can be opened independently from the right-side index.
- 4
- examples
- 9
- documented methods
MnbExcel::validateUpload()MnbExcel::safeFileName()<?php
declare(strict_types=1);
/*
Summary:
Validate the real uploaded file size, extension, MIME information, filename, XLSX ZIP safety,
macros, links, and encryption policy.
Implementation note:
Validation does not move the file. Store it under a generated server-side name only after the
upload passes policy checks.
*/
use Mnb\PHPExcel\MnbExcel;
$upload = MnbExcel::validateUpload($_FILES['spreadsheet'] ?? [], [
'allowed_extensions' => ['xlsx', 'csv', 'tsv'],
'max_size_mb' => 100,
'reject_macros' => true,
'reject_external_links' => true,
'reject_encrypted' => true,
]);
if (!$upload['valid']) {
http_response_code(422);
header('Content-Type: application/json');
echo json_encode($upload, JSON_THROW_ON_ERROR);
exit;
}MnbExcel::handleAjaxUpload()MnbExcel::storagePath()<?php
declare(strict_types=1);
/*
Summary:
Validate and atomically store an AJAX upload, then return a safe HTTP-oriented result containing
the stored path and digest.
Implementation note:
The returned filename is generated for safe storage. Keep the original display name only as
metadata, never as a trusted filesystem path.
*/
use Mnb\PHPExcel\MnbExcel;
header('Content-Type: application/json; charset=UTF-8');
$response = MnbExcel::handleAjaxUpload(
$_FILES['spreadsheet'] ?? [],
[
'directory' => __DIR__ . '/storage/uploads',
'allowed_extensions' => ['xlsx', 'xls', 'ods', 'csv', 'tsv'],
'max_size_mb' => 250,
]
);
http_response_code((int) ($response['http_status'] ?? 200));
echo json_encode($response, JSON_THROW_ON_ERROR);MnbExcel::importDomainFiles()MnbExcel::validateUpload()<?php
declare(strict_types=1);
/*
Summary:
Process several uploaded product workbooks with one domain schema, shared duplicate rules, and
aggregate progress reporting.
Implementation note:
Validate and store every upload before passing paths to the multi-file importer.
stop_on_error=false allows independent files to report separate results.
*/
use Mnb\PHPExcel\MnbExcel;
$files = [
__DIR__ . '/storage/uploads/products-east.xlsx',
__DIR__ . '/storage/uploads/products-west.xlsx',
];
$result = MnbExcel::importDomainFiles(
'products',
$files,
__DIR__ . '/config/database.php',
'products',
[
'stop_on_error' => false,
'import_options' => [
'duplicate_strategy' => 'update',
'unique_by' => ['sku'],
],
'progress' => static function (array $state): void {
printf(
"%d/%d files completed\n",
$state['files_completed'],
$state['files_total']
);
},
]
);MnbExcel::queue()enqueueDomainImport()work()MnbExcel::pdoQueue()<?php
declare(strict_types=1);
/*
Summary:
Move a long-running domain import out of the request cycle using the built-in durable filesystem
queue and worker.
Implementation note:
The filesystem queue uses pending, processing, completed, and failed directories. Use pdoQueue()
when several application hosts share the worker pool.
*/
use Mnb\PHPExcel\MnbExcel;
$queueDirectory = __DIR__ . '/storage/queue';
$databaseConfig = __DIR__ . '/config/database.php';
$queue = MnbExcel::queue($queueDirectory);
$job = $queue->enqueueDomainImport(
'products',
__DIR__ . '/storage/uploads/products.xlsx',
$databaseConfig,
'products',
[
'duplicate_strategy' => 'update',
'unique_by' => ['sku'],
]
);
printf("Queued job: %s\n", $job->id);
// Run this part from CLI, cron, or a process manager.
$result = $queue->work([
'max_jobs' => 20,
'max_attempts' => 3,
'retry_delay_seconds' => 30,
]);No matching example found.Try a method name, task, or result.
Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.
Open an issue