MNB PHPExcel classes and methods.
Browse every public class and method in the monolithic library. Search by class, method, parameter, or return type.
Updated
# Generates a dependency-free upload form and JavaScript client for AjaxUploadHandler/SpreadsheetHttpEndpoint.# Declaration: final class AjaxUploader# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Application\AjaxUploader{# Purpose: Performs the html operation.public static function html(string $endpoint, # Target URL that receives the request. Example: 'https://example.com/upload'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the script operation.public static function script(string $formId, # HTML form element ID. Example: 'upload-form'string $endpoint, # Target URL that receives the request. Example: 'https://example.com/upload'array $options = [] # Configuration options for this operation. Example: []): string}# Provides the ajax upload handler class API for application operations.# Declaration: final class AjaxUploadHandler# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Application\AjaxUploadHandler{# Purpose: Performs the handle operation.public function handle(array|string $file, # File path or file value used by the operation. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the json operation.public function json(array $response, # Input value for `$response` (array). Example: []int $flags = JSON_UNESCAPED_SLASHES|JSON_UNESCAPED_UNICODE # Input value for `$flags` (int). Example: JSON_UNESCAPED_SLASHES|JSON_UNESCAPED_UNICODE): string}# Provides the file rate limiter class API for http operations.# Declaration: final class FileRateLimiter implements RateLimiterInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Application\Http\FileRateLimiter{# Purpose: Creates a new FileRateLimiter instance.public function __construct(string $directory # Input value for `$directory` (string). Example: 'value'): mixed# Purpose: Performs the consume operation.public function consume(string $key, # Key used to identify the target value. Example: 'value'int $limit, # Maximum number of items to process. Example: 1000int $windowSeconds # Input value for `$windowSeconds` (int). Example: 1): array}# Provides the http response class API for http operations.# Declaration: final class HttpResponse# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Application\Http\HttpResponse{# Purpose: Creates a new HttpResponse instance.public function __construct(int $status, # Input value for `$status` (int). Example: 1string $body = '', # Input value for `$body` (string). Example: ''array $headers = [] # Input value for `$headers` (array). Example: []): mixed# Purpose: Performs the emit operation.public function emit(): never# Purpose: Performs the json operation.public static function json(array $data, # Input value for `$data` (array). Example: []int $status = 200, # Input value for `$status` (int). Example: 200array $headers = [] # Input value for `$headers` (array). Example: []): self}# Provides the pdo rate limiter class API for http operations.# Declaration: final class PdoRateLimiter implements RateLimiterInterface# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\Http\PdoRateLimiter{# Purpose: Creates a new PdoRateLimiter instance.public function __construct(PDO $pdo, # PDO connection used for database operations.string $table = 'mnb_excel_rate_limits', # Database table name. Example: 'mnb_excel_rate_limits'bool $autoCreate = true # Input value for `$autoCreate` (bool). Example: true): mixed}# Provides the rate limiter interface interface API for http operations.# Declaration: interface RateLimiterInterface# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\Http\RateLimiterInterface{# Purpose: Performs the consume operation.abstract public function consume(string $key, # Key used to identify the target value. Example: 'value'int $limit, # Maximum number of items to process. Example: 1000int $windowSeconds # Input value for `$windowSeconds` (int). Example: 1): array}# Complete framework-neutral HTTP endpoint: routing, JSON/form parsing, CORS, bearer/HMAC/CSRF authentication, rate limiting and consistent responses.# Declaration: final class SpreadsheetHttpEndpoint# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Application\Http\SpreadsheetHttpEndpoint{# Purpose: Creates a new SpreadsheetHttpEndpoint instance.public function __construct(SpreadsheetApi $api = new SpreadsheetApi(), # Input value for `$api` (SpreadsheetApi). Example: new SpreadsheetApi()array $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Performs the handle operation.public function handle(array $server, # Input value for `$server` (array). Example: []array $query = [], # SQL query or search expression. Example: []array $form = [], # Input value for `$form` (array). Example: []array $files = [], # Input value for `$files` (array). Example: []string $rawBody = '', # Input value for `$rawBody` (string). Example: ''PDO|array|string|null $pdo = null # PDO connection used for database operations. Example: []): HttpResponse# Purpose: Handle PHP superglobals directly.public function handleGlobals(PDO|array|string|null $pdo = null # PDO connection used for database operations. Example: []): HttpResponse}# Converts a resumable import manifest into an API/admin-dashboard friendly shape.# Declaration: final class ImportDashboardHelper# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\ImportDashboardHelper{# Purpose: Performs the response operation.public static function response(string|array $manifestOrStatus, # Input value for `$manifestOrStatus` (string|array). Example: []array $options = [] # Configuration options for this operation. Example: []): array}# Provides the import job runner class API for application operations.# Declaration: final class ImportJobRunner# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\ImportJobRunner{# Purpose: Performs the resume operation.public static function resume(string $manifestPath, # Input value for `$manifestPath` (string). Example: 'value'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []array $options = [] # Configuration options for this operation. Example: []): array}# Provides the import profile class API for application operations.# Declaration: final class ImportProfile# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Application\ImportProfile{# Purpose: Creates a new ImportProfile instance.public function __construct(string $name, # Name used to identify the target value. Example: 'value'array $profile # Input value for `$profile` (array). Example: []): mixed# Purpose: Performs the config operation.public function config(): array# Purpose: Performs the plan operation.public function plan(array $serverOptions = [] # Input value for `$serverOptions` (array). Example: []): array# Purpose: Runs the configured operation.public function run(PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []array $overrides = [] # Input value for `$overrides` (array). Example: []): array# Purpose: Performs the source operation.public function source(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): self}# Provides the import profile manager class API for application operations.# Declaration: final class ImportProfileManager# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Application\ImportProfileManager{# Purpose: Returns all matching items.public static function all(): array# Purpose: Performs the clear operation.public static function clear(): void# Purpose: Performs the get operation.public static function get(string $name # Name used to identify the target value. Example: 'value'): array# Purpose: Performs the load operation.public static function load(array|string $profiles # Input value for `$profiles` (array|string). Example: []): void# Purpose: Performs the profile operation.public static function profile(string $name # Name used to identify the target value. Example: 'value'): ImportProfile# Purpose: Performs the register operation.public static function register(string $name, # Name used to identify the target value. Example: 'value'array $profile # Input value for `$profile` (array). Example: []): void}# Provides the import status reader class API for application operations.# Declaration: final class ImportStatusReader# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\ImportStatusReader{# Purpose: Creates a read session for the supplied source.public static function read(string $manifestPath, # Input value for `$manifestPath` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): array}# Optional logger bridge. Accepts PSR-3-like objects or callables.# Declaration: final class LoggerBridge# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Application\LoggerBridge{# Purpose: Performs the error operation.public static function error(string $message, # Input value for `$message` (string). Example: 'value'array $context = [] # Input value for `$context` (array). Example: []): void# Purpose: Performs the get operation.public static function get(): mixed# Purpose: Performs the info operation.public static function info(string $message, # Input value for `$message` (string). Example: 'value'array $context = [] # Input value for `$context` (array). Example: []): void# Purpose: Performs the log operation.public static function log(string $level, # Input value for `$level` (string). Example: 'value'string $message, # Input value for `$message` (string). Example: 'value'array $context = [] # Input value for `$context` (array). Example: []): void# Purpose: Performs the set operation.public static function set($logger # Input value for `$logger`.): void# Purpose: Performs the warning operation.public static function warning(string $message, # Input value for `$message` (string). Example: 'value'array $context = [] # Input value for `$context` (array). Example: []): void}# Provides the callback mailer class API for mail operations.# Declaration: final class CallbackMailer implements MailerInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Application\Mail\CallbackMailer{# Purpose: Creates a new CallbackMailer instance.public function __construct($callback # Callback invoked during this operation.): mixed# Purpose: Performs the send operation.public function send(MailMessage $message # Input value for `$message` (MailMessage).): bool}# Provides the mailer interface interface API for mail operations.# Declaration: interface MailerInterface# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\Mail\MailerInterface{# Purpose: Performs the send operation.abstract public function send(MailMessage $message # Input value for `$message` (MailMessage).): bool}# Provides the mail message class API for mail operations.# Declaration: final class MailMessage# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\Mail\MailMessage{# Purpose: Creates a new MailMessage instance.public function __construct(array $to, # Input value for `$to` (array). Example: []string $subject, # Input value for `$subject` (string). Example: 'value'string $body, # Input value for `$body` (string). Example: 'value'bool $html = false, # Input value for `$html` (bool). Example: falsearray $attachments = [], # Input value for `$attachments` (array). Example: []array $headers = [] # Input value for `$headers` (array). Example: []): mixed}# Provides the mime message builder class API for mail operations.# Declaration: final class MimeMessageBuilder# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\Mail\MimeMessageBuilder{# Purpose: Performs the build operation.public function build(MailMessage $message, # Input value for `$message` (MailMessage).string $from # Input value for `$from` (string). Example: 'value'): array}# Provides the native mailer class API for mail operations.# Declaration: final class NativeMailer implements MailerInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Application\Mail\NativeMailer{# Purpose: Creates a new NativeMailer instance.public function __construct($transport = null, # Input value for `$transport`.string $from = '' # Input value for `$from` (string). Example: ''): mixed# Purpose: Performs the send operation.public function send(MailMessage $message # Input value for `$message` (MailMessage).): bool}# Native SMTP transport with STARTTLS/SMTPS, AUTH LOGIN/PLAIN and attachments.# Declaration: final class SmtpMailer implements MailerInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Application\Mail\SmtpMailer{# Purpose: Creates a new SmtpMailer instance.public function __construct(array $options # Configuration options for this operation. Example: []): mixed# Purpose: Performs the send operation.public function send(MailMessage $message # Input value for `$message` (MailMessage).): bool}# Provides the spreadsheet mailer class API for mail operations.# Declaration: final class SpreadsheetMailer# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Application\Mail\SpreadsheetMailer{# Purpose: Creates a new SpreadsheetMailer instance.public function __construct(MailerInterface $mailer # Input value for `$mailer` (MailerInterface).): mixed# Purpose: Performs the send operation.public function send(WorkbookBuilder|string $workbook, # Input value for `$workbook` (WorkbookBuilder|string). Example: 'value'string|array $to, # Input value for `$to` (string|array). Example: []string $subject, # Input value for `$subject` (string). Example: 'value'string $body = '', # Input value for `$body` (string). Example: ''array $options = [] # Configuration options for this operation. Example: []): bool}# Provides the multi file import manager class API for application operations.# Declaration: final class MultiFileImportManager# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Application\MultiFileImportManager{# Purpose: Imports domain.public function importDomain(DomainImportType|string $domain, # Input value for `$domain` (DomainImportType|string). Example: 'value'array $files, # Input value for `$files` (array). Example: []PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = '', # Database table name. Example: ''array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports to sql.public function importToSql(array $files, # Input value for `$files` (array). Example: []PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string $table, # Database table name. Example: 'imports'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Runs the configured operation.public function run(array $files, # Input value for `$files` (array). Example: []callable $importer, # Input value for `$importer` (callable). Example: static fn ($value) => $valuearray $options = [] # Configuration options for this operation. Example: []): array}# Provides the file queue class API for queue operations.# Declaration: final class FileQueue implements QueueBackendInterface# Package: mnb/mnb-phpexcel# Methods: 7Mnb\PHPExcel\Application\Queue\FileQueue{# Purpose: Creates a new FileQueue instance.public function __construct(string $directory # Input value for `$directory` (string). Example: 'value'): mixed# Purpose: Performs the complete operation.public function complete(QueueJob $job, # Input value for `$job` (QueueJob).array $result = [] # Input value for `$result` (array). Example: []): void# Purpose: Performs the enqueue operation.public function enqueue(string $type, # Input value for `$type` (string). Example: 'value'array $payload, # Input value for `$payload` (array). Example: []int $delaySeconds = 0 # Input value for `$delaySeconds` (int). Example: 0): QueueJob# Purpose: Performs the fail operation.public function fail(QueueJob $job, # Input value for `$job` (QueueJob).\Throwable $exception, # Input value for `$exception` (\Throwable).int $retryDelaySeconds = 0, # Input value for `$retryDelaySeconds` (int). Example: 0int $maxAttempts = 3 # Input value for `$maxAttempts` (int). Example: 3): void# Purpose: Performs the release expired operation.public function releaseExpired(int $visibilityTimeoutSeconds = 300 # Input value for `$visibilityTimeoutSeconds` (int). Example: 300): int# Purpose: Performs the reserve operation.public function reserve(int $visibilityTimeoutSeconds = 300, # Input value for `$visibilityTimeoutSeconds` (int). Example: 300?string $workerId = null # Identifier used by the operation. Example: 'value'): ?QueueJob# Purpose: Performs the stats operation.public function stats(): array}# Transactional queue backend suitable for multiple hosts and workers. Supports SQLite, MySQL/MariaDB and PostgreSQL through portable PDO SQL.# Declaration: final class PdoQueue implements QueueBackendInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Application\Queue\PdoQueue{# Purpose: Creates a new PdoQueue instance.public function __construct(PDO $pdo, # PDO connection used for database operations.string $table = 'mnb_excel_queue', # Database table name. Example: 'mnb_excel_queue'bool $autoCreate = true # Input value for `$autoCreate` (bool). Example: true): mixed# Purpose: Creates table.public function createTable(): void}# Provides the queue backend interface interface API for queue operations.# Declaration: interface QueueBackendInterface# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Application\Queue\QueueBackendInterface{# Purpose: Performs the complete operation.abstract public function complete(QueueJob $job, # Input value for `$job` (QueueJob).array $result = [] # Input value for `$result` (array). Example: []): void# Purpose: Performs the enqueue operation.abstract public function enqueue(string $type, # Input value for `$type` (string). Example: 'value'array $payload, # Input value for `$payload` (array). Example: []int $delaySeconds = 0 # Input value for `$delaySeconds` (int). Example: 0): QueueJob# Purpose: Performs the fail operation.abstract public function fail(QueueJob $job, # Input value for `$job` (QueueJob).\Throwable $exception, # Input value for `$exception` (\Throwable).int $retryDelaySeconds = 0, # Input value for `$retryDelaySeconds` (int). Example: 0int $maxAttempts = 3 # Input value for `$maxAttempts` (int). Example: 3): void# Purpose: Performs the release expired operation.abstract public function releaseExpired(int $visibilityTimeoutSeconds = 300 # Input value for `$visibilityTimeoutSeconds` (int). Example: 300): int# Purpose: Performs the reserve operation.abstract public function reserve(int $visibilityTimeoutSeconds = 300, # Input value for `$visibilityTimeoutSeconds` (int). Example: 300?string $workerId = null # Identifier used by the operation. Example: 'value'): ?QueueJob# Purpose: Performs the stats operation.abstract public function stats(): array}# Provides the queue job class API for queue operations.# Declaration: final class QueueJob# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Application\Queue\QueueJob{# Purpose: Creates a new QueueJob instance.public function __construct(string $id, # Identifier used by the operation. Example: 'value'string $type, # Input value for `$type` (string). Example: 'value'array $payload, # Input value for `$payload` (array). Example: []int $attempts = 0, # Input value for `$attempts` (int). Example: 0int $availableAt = 0, # Input value for `$availableAt` (int). Example: 0string $createdAt = '' # Input value for `$createdAt` (string). Example: ''): mixed# Purpose: Creates the value from array.public static function fromArray(array $data # Input value for `$data` (array). Example: []): self# Purpose: Returns the current result as an array.public function toArray(): array}# Provides the queue worker class API for queue operations.# Declaration: final class QueueWorker# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Application\Queue\QueueWorker{# Purpose: Creates a new QueueWorker instance.public function __construct(QueueBackendInterface $queue # Input value for `$queue` (QueueBackendInterface).): mixed# Purpose: Performs the register operation.public function register(string $type, # Input value for `$type` (string). Example: 'value'callable $handler # Handler invoked by the operation. Example: static fn ($value) => $value): self# Purpose: Performs the work operation.public function work(array $options = [] # Configuration options for this operation. Example: []): array}# Provides the spreadsheet queue class API for queue operations.# Declaration: final class SpreadsheetQueue# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Application\Queue\SpreadsheetQueue{# Purpose: Creates a new SpreadsheetQueue instance.public function __construct(QueueBackendInterface $queue # Input value for `$queue` (QueueBackendInterface).): mixed# Purpose: Performs the enqueue domain import operation.public function enqueueDomainImport(string $domain, # Input value for `$domain` (string). Example: 'value'string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|string|null $database = null, # Input value for `$database` (array|string|null). Example: []string $table = '', # Database table name. Example: ''array $options = [], # Configuration options for this operation. Example: []int $delaySeconds = 0 # Input value for `$delaySeconds` (int). Example: 0): QueueJob# Purpose: Performs the enqueue export operation.public function enqueueExport(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [], # Configuration options for this operation. Example: []int $delaySeconds = 0 # Input value for `$delaySeconds` (int). Example: 0): QueueJob# Purpose: Performs the enqueue import operation.public function enqueueImport(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|string|null $database, # Input value for `$database` (array|string|null). Example: []string $table, # Database table name. Example: 'imports'array $options = [], # Configuration options for this operation. Example: []int $delaySeconds = 0 # Input value for `$delaySeconds` (int). Example: 0): QueueJob# Purpose: Performs the work operation.public function work(array $options = [] # Configuration options for this operation. Example: []): array}# Ordered row transformations for application imports.# Declaration: final class RowTransformerPipeline# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Application\RowTransformerPipeline{# Purpose: Performs the apply operation.public static function apply(array $row, # Row value or 1-based row number. Example: []array $transformers = [], # Input value for `$transformers` (array). Example: []array $context = [] # Input value for `$context` (array). Example: []): array# Purpose: Applies rows.public static function applyRows(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $transformers = [], # Input value for `$transformers` (array). Example: []array $context = [] # Input value for `$context` (array). Example: []): array# Purpose: Performs the clear operation.public static function clear(): void# Purpose: Performs the names operation.public static function names(): array# Purpose: Performs the register operation.public static function register(string $name, # Name used to identify the target value. Example: 'value'callable $transformer # Input value for `$transformer` (callable). Example: static fn ($value) => $value): void}# Provides the cron expression class API for schedule operations.# Declaration: final class CronExpression# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Application\Schedule\CronExpression{# Purpose: Creates a new CronExpression instance.public function __construct(string $expression # Input value for `$expression` (string). Example: 'value'): mixed# Purpose: Checks whether due.public function isDue(DateTimeInterface $time # Input value for `$time` (DateTimeInterface).): bool# Purpose: Performs the to string operation.public function __toString(): string}# Provides the file scheduler class API for schedule operations.# Declaration: final class FileScheduler implements SchedulerStoreInterface# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Application\Schedule\FileScheduler{# Purpose: Creates a new FileScheduler instance.public function __construct(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): mixed# Purpose: Performs the add operation.public function add(string $id, # Identifier used by the operation. Example: 'value'string $cron, # Input value for `$cron` (string). Example: 'value'string $type, # Input value for `$type` (string). Example: 'value'array $payload, # Input value for `$payload` (array). Example: []bool $enabled = true # Input value for `$enabled` (bool). Example: true): void# Purpose: Returns all matching items.public function all(): array# Purpose: Performs the remove operation.public function remove(string $id # Identifier used by the operation. Example: 'value'): void# Purpose: Performs the run due operation.public function runDue(callable $dispatcher, # Input value for `$dispatcher` (callable). Example: static fn ($value) => $value?DateTimeInterface $now = null # Input value for `$now` (?DateTimeInterface).): array}# Transactional scheduler store for multi-host deployments.# Declaration: final class PdoScheduler implements SchedulerStoreInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Application\Schedule\PdoScheduler{# Purpose: Creates a new PdoScheduler instance.public function __construct(PDO $pdo, # PDO connection used for database operations.string $table = 'mnb_excel_schedule', # Database table name. Example: 'mnb_excel_schedule'bool $autoCreate = true # Input value for `$autoCreate` (bool). Example: true): mixed# Purpose: Creates table.public function createTable(): void}# Long-running scheduler runner with process lock and graceful signals.# Declaration: final class SchedulerRunner# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Application\Schedule\SchedulerRunner{# Purpose: Creates a new SchedulerRunner instance.public function __construct(SpreadsheetScheduler $scheduler # Input value for `$scheduler` (SpreadsheetScheduler).): mixed# Purpose: Performs the run forever operation.public function runForever(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the stop operation.public function stop(): void}# Provides the scheduler store interface interface API for schedule operations.# Declaration: interface SchedulerStoreInterface# Package: mnb/mnb-phpexcel# Methods: 4Mnb\PHPExcel\Application\Schedule\SchedulerStoreInterface{# Purpose: Performs the add operation.abstract public function add(string $id, # Identifier used by the operation. Example: 'value'string $cron, # Input value for `$cron` (string). Example: 'value'string $type, # Input value for `$type` (string). Example: 'value'array $payload, # Input value for `$payload` (array). Example: []bool $enabled = true # Input value for `$enabled` (bool). Example: true): void# Purpose: Returns all matching items.abstract public function all(): array# Purpose: Performs the remove operation.abstract public function remove(string $id # Identifier used by the operation. Example: 'value'): void# Purpose: Performs the run due operation.abstract public function runDue(callable $dispatcher, # Input value for `$dispatcher` (callable). Example: static fn ($value) => $value?DateTimeInterface $now = null # Input value for `$now` (?DateTimeInterface).): array}# Provides the spreadsheet scheduler class API for schedule operations.# Declaration: final class SpreadsheetScheduler# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Application\Schedule\SpreadsheetScheduler{# Purpose: Creates a new SpreadsheetScheduler instance.public function __construct(SchedulerStoreInterface $scheduler # Input value for `$scheduler` (SchedulerStoreInterface).): mixed# Purpose: Performs the run due operation.public function runDue(?DateTimeInterface $now = null # Input value for `$now` (?DateTimeInterface).): array# Purpose: Run due jobs continuously with locking, signal handling and bounded cycles.public function runForever(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the schedule export operation.public function scheduleExport(string $id, # Identifier used by the operation. Example: 'value'string $cron, # Input value for `$cron` (string). Example: 'value'array $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Performs the schedule import operation.public function scheduleImport(string $id, # Identifier used by the operation. Example: 'value'string $cron, # Input value for `$cron` (string). Example: 'value'string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|string|null $database, # Input value for `$database` (array|string|null). Example: []string $table, # Database table name. Example: 'imports'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Performs the tasks operation.public function tasks(): array}# Provides the spreadsheet api class API for application operations.# Declaration: final class SpreadsheetApi# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\SpreadsheetApi{# Purpose: Performs the handle operation.public function handle(string $action, # Input value for `$action` (string). Example: 'value'array $request, # Input value for `$request` (array). Example: []PDO|array|string|null $pdo = null # PDO connection used for database operations. Example: []): array}# Provides the upload safety validator class API for application operations.# Declaration: final class UploadSafetyValidator# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Application\UploadSafetyValidator{# Purpose: Validates the supplied input and returns the validation result.public static function validate(array|string $file, # File path or file value used by the operation. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array}# Optional legacy .xls adapter powered by PhpSpreadsheet.# Declaration: final class XlsReader implements IterableReaderInterface# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Compatibility\XlsReader{# Purpose: Iterates over sheet.public function iterateSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): iterable# Purpose: Reads sheet.public function readSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the sheet names operation.public function sheetNames(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): array}# Legacy BIFF8/XLS writer powered by the optional XLS compatibility module.# Declaration: final class XlsWriter# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Compatibility\XlsWriter{# Purpose: Writes the supplied data to the destination.public function write(WorkbookData $workbook, # Input value for `$workbook` (WorkbookData).string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void}# Provides the database target interface interface API for contracts operations.# Declaration: interface DatabaseTargetInterface# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Contracts\DatabaseTargetInterface{# Purpose: Performs the insert rows operation.abstract public function insertRows(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): int}# Provides the reader plugin interface interface API for contracts operations.# Declaration: interface ReaderPluginInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Contracts\ReaderPluginInterface{# Purpose: Creates a read session for the supplied source.abstract public function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): iterable# Purpose: Performs the supports operation.abstract public function supports(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): bool}# Provides the writer plugin interface interface API for contracts operations.# Declaration: interface WriterPluginInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Contracts\WriterPluginInterface{# Purpose: Performs the supports operation.abstract public function supports(string $format, # Spreadsheet or data format identifier. Example: 'xlsx'array $options = [] # Configuration options for this operation. Example: []): bool# Purpose: Writes the supplied data to the destination.abstract public function write(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): string}# Explicit typed cell value for array-first exports.# Declaration: final class CellValue# Package: mnb/mnb-phpexcel# Methods: 13Mnb\PHPExcel\Core\CellValue{# Purpose: Performs the blank operation.public static function blank(): self# Purpose: Performs the bool operation.public static function bool(bool $value # Value supplied to the operation. Example: true): self# Purpose: Performs the cached value operation.public function cachedValue(): mixed# Purpose: Performs the date operation.public static function date(DateTimeInterface|string $value, # Value supplied to the operation. Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the display value operation.public function displayValue(): string|int|float|bool|null# Purpose: Performs the error operation.public static function error(string $code # Input value for `$code` (string). Example: 'value'): self# Purpose: Performs the formula operation.public static function formula(string $formula, # Input value for `$formula` (string). Example: 'value'$cachedValue = null, # Input value for `$cachedValue`.array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Creates the value from array.public static function fromArray(array $definition # Input value for `$definition` (array). Example: []): self# Purpose: Performs the number operation.public static function number(int|float|string $value # Value supplied to the operation. Example: 1): self# Purpose: Performs the options operation.public function options(): array# Purpose: Performs the text operation.public static function text($value # Value supplied to the operation.): self# Purpose: Performs the type operation.public function type(): string# Purpose: Performs the value operation.public function value(): mixed}# Provides the rich text class API for core operations.# Declaration: final class RichText implements \Stringable, \JsonSerializable# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Core\RichText{# Purpose: Creates a new RichText instance.public function __construct(array $runs # Input value for `$runs` (array). Example: []): mixed# Purpose: Creates the value from array.public static function fromArray(array $runs # Input value for `$runs` (array). Example: []): self# Purpose: Performs the json serialize operation.public function jsonSerialize(): array# Purpose: Performs the plain operation.public static function plain(string $text # Input value for `$text` (string). Example: 'value'): self# Purpose: Performs the text operation.public function text(): string# Purpose: Performs the to string operation.public function __toString(): string}# Provides the rich text run class API for core operations.# Declaration: final class RichTextRun implements \JsonSerializable# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Core\RichTextRun{# Purpose: Creates a new RichTextRun instance.public function __construct(string $text, # Input value for `$text` (string). Example: 'value'array $style = [] # Input value for `$style` (array). Example: []): mixed# Purpose: Creates the value from array.public static function fromArray(array $data # Input value for `$data` (array). Example: []): self# Purpose: Performs the json serialize operation.public function jsonSerialize(): array}# Provides the workbook builder class API for core operations.# Declaration: final class WorkbookBuilder# Package: mnb/mnb-phpexcel# Methods: 102Mnb\PHPExcel\Core\WorkbookBuilder{# Purpose: Add a native chart. Series items contain name, values and optional categories.public function addChart(string $type, # Input value for `$type` (string). Example: 'value'string $title, # Input value for `$title` (string). Example: 'value'array $series, # Input value for `$series` (array). Example: []array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Adds image.public function addImage(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $cell, # Worksheet cell reference. Example: 'A1'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Create a native pivot table from source data without requiring a template.public function addPivotTable(string $name, # Name used to identify the target value. Example: 'value'string $sourceSheet, # Input value for `$sourceSheet` (string). Example: 'value'string $sourceRange, # Input value for `$sourceRange` (string). Example: 'value'string $targetCell = 'A1', # Input value for `$targetCell` (string). Example: 'A1'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the allow formulas operation.public function allowFormulas(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Performs the auto filter operation.public function autoFilter(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Configure an explicit auto-filter range such as A1:H500.public function autoFilterRange(string $range # Worksheet cell range. Example: 'A1:D100'): self# Purpose: Estimate column widths from visible row values. Manual columnWidth() values override estimates.public function autoWidth(bool|array $enabled = true, # Input value for `$enabled` (bool|array). Example: truearray $options = [] # Configuration options for this operation. Example: []): self# Purpose: Configure cell text safety behavior for XLSX/CSV export.public function cellSafety(array $options # Configuration options for this operation. Example: []): self# Purpose: Performs the cell style operation.public function cellStyle(string $cell, # Worksheet cell reference. Example: 'A1'string|array $style # Input value for `$style` (string|array). Example: []): self# Purpose: Performs the cell styles operation.public function cellStyles(array $styles # Input value for `$styles` (array). Example: []): self# Purpose: Returns the available columns.public function columns(array $columns # Columns included in the operation. Example: []): self# Purpose: Performs the column style operation.public function columnStyle(int|string $column, # Column name, letter, or index. Example: 'A'string|array $style # Input value for `$style` (string|array). Example: []): self# Purpose: Performs the column styles operation.public function columnStyles(array $styles # Input value for `$styles` (array). Example: []): self# Purpose: Performs the column width operation.public function columnWidth(int|string $column, # Column name, letter, or index. Example: 'A'float|int $width # Input value for `$width` (float|int). Example: 1): self# Purpose: Performs the column widths operation.public function columnWidths(array $widths # Input value for `$widths` (array). Example: []): self# Purpose: Add a legacy Excel note/comment to a generated XLSX worksheet.public function comment(string $cell, # Worksheet cell reference. Example: 'A1'string $author, # Input value for `$author` (string). Example: 'value'string $text, # Input value for `$text` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Add many comments. Each item may contain: cell, author, text, sheet, width, height, visible.public function comments(array $comments # Input value for `$comments` (array). Example: []): self# Purpose: Performs the company operation.public function company(string $company # Input value for `$company` (string). Example: 'value'): self# Purpose: Performs the conditional cell is operation.public function conditionalCellIs(string $range, # Worksheet cell range. Example: 'A1:D100'string $operator, # Input value for `$operator` (string). Example: 'value'$formula, # Input value for `$formula`.string|array $style # Input value for `$style` (string|array). Example: []): self# Purpose: Performs the conditional color scale operation.public function conditionalColorScale(string $range, # Worksheet cell range. Example: 'A1:D100'array $colors = ['#F8696B', '#FFEB84', '#63BE7B'] # Input value for `$colors` (array). Example: ['#F8696B', '#FFEB84', '#63BE7B']): self# Purpose: Performs the conditional data bar operation.public function conditionalDataBar(string $range, # Worksheet cell range. Example: 'A1:D100'string $color = '#638EC6' # Input value for `$color` (string). Example: '#638EC6'): self# Purpose: Performs the conditional expression operation.public function conditionalExpression(string $range, # Worksheet cell range. Example: 'A1:D100'string $formula, # Input value for `$formula` (string). Example: 'value'string|array $style # Input value for `$style` (string|array). Example: []): self# Purpose: Add a native conditional-formatting rule to an XLSX range.public function conditionalFormatting(string $range, # Worksheet cell range. Example: 'A1:D100'string $type, # Input value for `$type` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the conditional icon set operation.public function conditionalIconSet(string $range, # Worksheet cell range. Example: 'A1:D100'string $iconSet = '3TrafficLights1' # Input value for `$iconSet` (string). Example: '3TrafficLights1'): self# Purpose: Style data rows when a condition returns true. Callback receives: original row, normalized row, data row number, Excel row number.public function conditionalRowStyle(callable $condition, # Input value for `$condition` (callable). Example: static fn ($value) => $valuestring|array $style # Input value for `$style` (string|array). Example: []): self# Purpose: Performs the control char policy operation.public function controlCharPolicy(string $policy # Input value for `$policy` (string). Example: 'value'): self# Purpose: Performs the creator operation.public function creator(string $creator # Input value for `$creator` (string). Example: 'value'): self# Purpose: Performs the csv bom operation.public function csvBom(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Performs the csv delimiter operation.public function csvDelimiter(string $delimiter # Field delimiter character. Example: ','): self# Purpose: Performs the csv dialect operation.public function csvDialect(string $dialect # Input value for `$dialect` (string). Example: 'value'): self# Purpose: Performs the csv enclosure operation.public function csvEnclosure(string $enclosure # Input value for `$enclosure` (string). Example: 'value'): self# Purpose: Performs the csv encoding operation.public function csvEncoding(string $encoding # Text character encoding. Example: 'UTF-8'): self# Purpose: Performs the csv escape operation.public function csvEscape(string $escape # Input value for `$escape` (string). Example: 'value'): self# Purpose: Performs the csv injection policy operation.public function csvInjectionPolicy(string $policy # Input value for `$policy` (string). Example: 'value'): self# Purpose: Configure CSV read/write behavior for CSV exports generated by this builder.public function csvOptions(array $options # Configuration options for this operation. Example: []): self# Purpose: Performs the currency columns operation.public function currencyColumns(array $columns, # Columns included in the operation. Example: []string $symbol = '$' # Input value for `$symbol` (string). Example: '$'): self# Purpose: Add native Excel data validation to a range.public function dataValidation(string $range, # Worksheet cell range. Example: 'A1:D100'string $type, # Input value for `$type` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the date columns operation.public function dateColumns(array $columns # Columns included in the operation. Example: []): self# Purpose: Performs the date style columns operation.public function dateStyleColumns(array $columns, # Columns included in the operation. Example: []string $format = 'yyyy-mm-dd' # Spreadsheet or data format identifier. Example: 'yyyy-mm-dd'): self# Purpose: Performs the datetime style columns operation.public function datetimeStyleColumns(array $columns, # Columns included in the operation. Example: []string $format = 'yyyy-mm-dd hh:mm:ss' # Spreadsheet or data format identifier. Example: 'yyyy-mm-dd hh:mm:ss'): self# Purpose: Performs the decimal columns operation.public function decimalColumns(array $columns, # Columns included in the operation. Example: []int $decimals = 2 # Input value for `$decimals` (int). Example: 2): self# Purpose: Encrypt the final XLSX package with a password-to-open using Agile AES-256 encryption.public function encryptWithPassword(string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the escape formula like text operation.public function escapeFormulaLikeText(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Add a native Excel filter definition.public function filterColumn(int|string $column, # Column name, letter, or index. Example: 'A'array $criteria # Input value for `$criteria` (array). Example: []): self# Purpose: Filters values.public function filterValues(int|string $column, # Column name, letter, or index. Example: 'A'array $values, # Values supplied to the operation. Example: []bool $includeBlank = false # Input value for `$includeBlank` (bool). Example: false): self# Purpose: Add footer rows after summary rows.public function footerRows(array|string $rows, # Rows supplied for reading, writing, validation, or import. Example: []string|array|null $style = null # Input value for `$style` (string|array|null). Example: []): self# Purpose: Apply one number-format preset or custom Excel format to many columns.public function formatColumns(array $columns, # Columns included in the operation. Example: []string $format, # Spreadsheet or data format identifier. Example: 'xlsx'array $extraStyle = [] # Input value for `$extraStyle` (array). Example: []): self# Purpose: Configure explicit formula handling. Policies: safe, allow, block. Default: safe.public function formulaPolicy(array|string $policyOrOptions # Input value for `$policyOrOptions` (array|string). Example: []): self# Purpose: Freeze all rows above and columns left of the selected cell.public function freezeAt(string $cell # Worksheet cell reference. Example: 'A1'): self# Purpose: Performs the freeze header operation.public function freezeHeader(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Freeze arbitrary rows and columns. Example: freezePanes(1, 2) freezes row 1 and columns A:B.public function freezePanes(int $rows = 1, # Rows supplied for reading, writing, validation, or import. Example: 1int $columns = 0, # Columns included in the operation. Example: 0?string $topLeftCell = null # Input value for `$topLeftCell` (?string). Example: 'value'): self# Purpose: Creates the value from array.public static function fromArray(array $rows # Rows supplied for reading, writing, validation, or import. Example: []): self# Purpose: Build a one-sheet import summary workbook.public static function fromImportSummary(array $summary, # Input value for `$summary` (array). Example: []array $validationResult = [] # Input value for `$validationResult` (array). Example: []): self# Purpose: Creates the value from workbook array.public static function fromWorkbookArray(array $sheets # Input value for `$sheets` (array). Example: []): self# Purpose: Add a clickable hyperlink to a generated XLSX worksheet.public function hyperlink(string $cell, # Worksheet cell reference. Example: 'A1'string $url, # URL used by the operation. Example: 'https://example.com'?string $display = null, # Input value for `$display` (?string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Add many hyperlinks. Each item may contain: cell, url, display, tooltip, sheet.public function hyperlinks(array $hyperlinks # Input value for `$hyperlinks` (array). Example: []): self# Purpose: Build a reusable import template with header styling, instructions and validation rules.public static function importTemplate(array $columns, # Columns included in the operation. Example: []array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Imports to sql.public function importToSql(PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string $table, # Database table name. Example: 'imports'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the integer columns operation.public function integerColumns(array $columns # Columns included in the operation. Example: []): self# Purpose: Performs the max cell text length operation.public function maxCellTextLength(int $length, # Maximum length or number of items. Example: 1string $policy = 'truncate' # Input value for `$policy` (string). Example: 'truncate'): self# Purpose: Merge one or more cell ranges. Example: mergeCells('A1:D1') or mergeCells(['A1:D1', 'A2:B2']).public function mergeCells(string|array $ranges # Input value for `$ranges` (string|array). Example: []): self# Purpose: Performs the metadata operation.public function metadata(array $metadata # Input value for `$metadata` (array). Example: []): self# Purpose: Performs the named style operation.public function namedStyle(string $name, # Name used to identify the target value. Example: 'value'array $style # Input value for `$style` (array). Example: []): self# Purpose: Performs the number columns operation.public function numberColumns(array $columns # Columns included in the operation. Example: []): self# Purpose: Encrypt the file and optionally protect workbook structure and worksheets with one password.public function passwordProtectOutput(string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the percentage columns operation.public function percentageColumns(array $columns # Columns included in the operation. Example: []): self# Purpose: Alias for preserveAdvancedObjectsFrom().public function preserveAdvancedExcelObjects(string $xlsxPath, # Input value for `$xlsxPath` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Preserve unsupported/advanced XLSX package objects from a source workbook while writing new row data. This keeps small-file output practical without silently dropping comments, drawings, tables, legacy notes, hyperlinks, VML, embedded media, pivot/chart/table package parts, and related worksheet relationships.public function preserveAdvancedObjectsFrom(string $xlsxPath, # Input value for `$xlsxPath` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Preserve working pivot tables from an XLSX template and bind their cache to a new source range. Excel refreshes the pivot cache when the file opens.public function preservePivotTablesFrom(string $xlsxPath, # Input value for `$xlsxPath` (string). Example: 'value'string $sourceSheet, # Input value for `$sourceSheet` (string). Example: 'value'string $sourceRange, # Input value for `$sourceRange` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the protect all sheets operation.public function protectAllSheets(string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Protect one worksheet by name, or use "*" to protect every worksheet.public function protectSheet(string $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Protect workbook structure/windows with an OOXML password verifier.public function protectWorkbook(string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the range style operation.public function rangeStyle(string $range, # Worksheet cell range. Example: 'A1:D100'string|array $style # Input value for `$style` (string|array). Example: []): self# Purpose: Performs the range styles operation.public function rangeStyles(array $styles # Input value for `$styles` (array). Example: []): self# Purpose: Performs the report template operation.public function reportTemplate(string $name # Name used to identify the target value. Example: 'value'): self# Purpose: Performs the row height operation.public function rowHeight(int $row, # Row value or 1-based row number. Example: 1float|int $height # Input value for `$height` (float|int). Example: 1): self# Purpose: Performs the row heights operation.public function rowHeights(array $heights # Input value for `$heights` (array). Example: []): self# Purpose: Performs the row style operation.public function rowStyle(int $row, # Row value or 1-based row number. Example: 1string|array $style # Input value for `$style` (string|array). Example: []): self# Purpose: Performs the row styles operation.public function rowStyles(array $styles # Input value for `$styles` (array). Example: []): self# Purpose: Performs the safe file name operation.public static function safeFileName(string $filename, # File name used by the operation. Example: 'workbook.xlsx'string $extension = '' # Input value for `$extension` (string). Example: ''): string# Purpose: Performs the save operation.public function save(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): string# Purpose: Saves csv sheets.public function saveCsvSheets(string $directory # Input value for `$directory` (string). Example: 'value'): array# Purpose: Saves json.public function saveJson(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Saves safe.public function saveSafe(string $directory, # Input value for `$directory` (string). Example: 'value'string $filename, # File name used by the operation. Example: 'workbook.xlsx'string $extension = 'xlsx' # Input value for `$extension` (string). Example: 'xlsx'): string# Purpose: Saves xml.public function saveXml(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Scan source rows for formula-like text, unsafe explicit formulas, invalid XML characters, overlong text, and long numeric text that may lose precision in Excel.public function scanCellSafety(): array# Purpose: Disable save-time XLSX integrity validation for special/debug workflows.public function skipXlsxIntegrityValidation(): self# Purpose: Require ext-xmlreader for strict XML well-formedness checks during XLSX save validation.public function strictXlsxIntegrityValidation(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Performs the style header operation.public function styleHeader(array|string $style # Input value for `$style` (array|string). Example: []): self# Purpose: Add summary rows after the data section.public function summaryRows(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []string|array|null $style = null # Input value for `$style` (string|array|null). Example: []): self# Purpose: Performs the text columns operation.public function textColumns(array $columns # Columns included in the operation. Example: []): self# Purpose: Performs the text style columns operation.public function textStyleColumns(array $columns # Columns included in the operation. Example: []): self# Purpose: Add a merged report title row before the header/data section.public function title(string $title, # Input value for `$title` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Add any custom row before the header/data section.public function titleRow(string|array $values, # Values supplied to the operation. Example: []array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Returns the current result as an array.public function toArray(): array# Purpose: Converts the value to json.public function toJson(array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Converts the value to workbook data.public function toWorkbookData(): WorkbookData# Purpose: Converts the value to xml.public function toXml(array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the validation list operation.public function validationList(string $range, # Worksheet cell range. Example: 'A1:D100'array $values, # Values supplied to the operation. Example: []array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Returns a copy configured with header.public function withHeader(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Add a dedicated import summary sheet, useful beside failed-row reports.public function withImportSummarySheet(array $summary, # Input value for `$summary` (array). Example: []array $validationResult = [], # Input value for `$validationResult` (array). Example: []string $sheetName = 'Import Summary' # Worksheet name. Example: 'Import Summary'): self# Purpose: Configure save-time XLSX integrity validation.public function xlsxIntegrityValidation(bool $enabled = true, # Input value for `$enabled` (bool). Example: truearray $options = [] # Configuration options for this operation. Example: []): self}# Provides the workbook data class API for core operations.# Declaration: final class WorkbookData# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Core\WorkbookData{# Purpose: Creates a new WorkbookData instance.public function __construct(array $sheets, # Input value for `$sheets` (array). Example: []array $metadata = [] # Input value for `$metadata` (array). Example: []): mixed}# Small, dependency-free factory used by format-specific modular facades.# Declaration: final class WorkbookFactory# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Core\WorkbookFactory{# Purpose: Performs the workbook operation.public static function workbook(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $sheetName = 'Sheet1', # Worksheet name. Example: 'Sheet1'bool $withHeader = false # Input value for `$withHeader` (bool). Example: false): WorkbookData# Purpose: Performs the worksheet operation.public static function worksheet(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $name = 'Sheet1', # Name used to identify the target value. Example: 'Sheet1'bool $withHeader = false # Input value for `$withHeader` (bool). Example: false): WorksheetData}# Provides the worksheet data class API for core operations.# Declaration: final class WorksheetData# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Core\WorksheetData{# Purpose: Creates a new WorksheetData instance.public function __construct(string $name, # Name used to identify the target value. Example: 'value'array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $columns = [], # Columns included in the operation. Example: []bool $hasHeader = false, # Input value for `$hasHeader` (bool). Example: falsearray $textColumns = [], # Input value for `$textColumns` (array). Example: []array $dateColumns = [], # Input value for `$dateColumns` (array). Example: []array $numberColumns = [], # Input value for `$numberColumns` (array). Example: []bool $freezeHeader = false, # Input value for `$freezeHeader` (bool). Example: falsebool $autoFilter = false, # Input value for `$autoFilter` (bool). Example: falsebool $escapeFormulaLikeText = true, # Input value for `$escapeFormulaLikeText` (bool). Example: truearray|string $headerStyle = [], # Input value for `$headerStyle` (array|string). Example: []array $mergeCells = [], # Input value for `$mergeCells` (array). Example: []array $columnWidths = [], # Input value for `$columnWidths` (array). Example: []array $rowHeights = [], # Input value for `$rowHeights` (array). Example: []array $images = [], # Input value for `$images` (array). Example: []public?int $headerRowIndex = null, # Input value for `$headerRowIndex` (public?int).array $namedStyles = [], # Input value for `$namedStyles` (array). Example: []array $columnStyles = [], # Input value for `$columnStyles` (array). Example: []array $rowStyles = [], # Input value for `$rowStyles` (array). Example: []array $cellStyles = [], # Input value for `$cellStyles` (array). Example: []array $rangeStyles = [], # Input value for `$rangeStyles` (array). Example: []array $hyperlinks = [], # Input value for `$hyperlinks` (array). Example: []array $comments = [], # Input value for `$comments` (array). Example: []array $sourceColumnKeys = [], # Original associative keys, in worksheet column order. Example: []int $dataRowStart = 0, # Input value for `$dataRowStart` (int). Example: 0public?int $dataRowCount = null, # Input value for `$dataRowCount` (public?int).int $freezeRows = 0, # Input value for `$freezeRows` (int). Example: 0int $freezeColumns = 0, # Input value for `$freezeColumns` (int). Example: 0public?string $freezeTopLeftCell = null, # Input value for `$freezeTopLeftCell` (public?string). Example: 'value'public?string $autoFilterRange = null, # Input value for `$autoFilterRange` (public?string). Example: 'value'array $filterColumns = [], # Input value for `$filterColumns` (array). Example: []array $conditionalFormats = [], # Input value for `$conditionalFormats` (array). Example: []array $dataValidations = [], # Input value for `$dataValidations` (array). Example: []array $charts = [], # Input value for `$charts` (array). Example: []array $pivotTables = [] # Input value for `$pivotTables` (array). Example: []): mixed# Purpose: Return rows suitable for JSON/XML export while restoring associative source keys for the workbook's data-row region.public function rowsForStructuredExport(bool $preserveAssociative = true, # Input value for `$preserveAssociative` (bool). Example: truebool $dataOnly = false # Input value for `$dataOnly` (bool). Example: false): array}# Provides the domain import preset class API for domain operations.# Declaration: final class DomainImportPreset# Package: mnb/mnb-phpexcel# Methods: 11Mnb\PHPExcel\Domain\DomainImportPreset{# Purpose: Creates a new DomainImportPreset instance.public function __construct(DomainImportType $type, # Input value for `$type` (DomainImportType).string $defaultTable, # Input value for `$defaultTable` (string). Example: 'value'string $description, # Input value for `$description` (string). Example: 'value'array $fields, # Input value for `$fields` (array). Example: []array $uniqueBy = [], # Input value for `$uniqueBy` (array). Example: []array $rowValidators = [] # Input value for `$rowValidators` (array). Example: []): mixed# Purpose: Performs the aliases operation.public function aliases(): array# Purpose: Returns the available columns.public function columns(): array# Purpose: Performs the defaults operation.public function defaults(): array# Purpose: Performs the fields operation.public function fields(): array# Purpose: Performs the required columns operation.public function requiredColumns(): array# Purpose: Performs the row validators operation.public function rowValidators(): array# Purpose: Performs the rules operation.public function rules(): array# Purpose: Performs the template columns operation.public function templateColumns(): array# Purpose: Returns the current result as an array.public function toArray(): array# Purpose: Performs the unique by operation.public function uniqueBy(): array}# Provides the domain import registry class API for domain operations.# Declaration: final class DomainImportRegistry# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Domain\DomainImportRegistry{# Purpose: Returns all matching items.public function all(): array# Purpose: Performs the get operation.public function get(DomainImportType|string $type # Input value for `$type` (DomainImportType|string). Example: 'value'): DomainImportPreset# Purpose: Performs the has operation.public function has(DomainImportType|string $type # Input value for `$type` (DomainImportType|string). Example: 'value'): bool# Purpose: Performs the names operation.public function names(): array# Purpose: Performs the register operation.public function register(DomainImportPreset $preset # Input value for `$preset` (DomainImportPreset).): self# Purpose: Returns a copy configured with built ins.public static function withBuiltIns(): self}# Provides the domain import type enum API for domain operations.# Declaration: enum DomainImportType :string# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Domain\DomainImportType{# Purpose: Creates the value from mixed.public static function fromMixed(self|string $type # Input value for `$type` (self|string). Example: 'value'): self}# Tiny framework-neutral event dispatcher. Listeners are process-local and optional.# Declaration: final class EventDispatcher# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Events\EventDispatcher{# Purpose: Performs the clear operation.public static function clear(?string $event = null # Input value for `$event` (?string). Example: 'value'): void# Purpose: Performs the dispatch operation.public static function dispatch(string $event, # Input value for `$event` (string). Example: 'value'array $payload = [] # Input value for `$payload` (array). Example: []): array# Purpose: Returns a list of en.public static function listen(string $event, # Input value for `$event` (string). Example: 'value'callable $listener # Input value for `$listener` (callable). Example: static fn ($value) => $value): void# Purpose: Dispatch import failure without allowing listener failures to hide the real exception.public static function safeDispatch(string $event, # Input value for `$event` (string). Example: 'value'array $payload = [] # Input value for `$payload` (array). Example: []): void# Purpose: Performs the summary operation.public static function summary(): array}# Provides the csv class API for format operations.# Declaration: final class Csv# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Format\Csv{# Purpose: Creates a read session for the supplied source.public static function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Writes the supplied data to the destination.public static function write(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void}# Provides the json class API for format operations.# Declaration: final class Json# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Format\Json{# Purpose: Creates a read session for the supplied source.public static function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Writes the supplied data to the destination.public static function write(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void}# Provides the ods class API for format operations.# Declaration: final class Ods# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Format\Ods{# Purpose: Creates a read session for the supplied source.public static function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession}# Provides the xls class API for format operations.# Declaration: final class Xls# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Format\Xls{# Purpose: Creates a read session for the supplied source.public static function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Writes the supplied data to the destination.public static function write(iterable|WorkbookData $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void}# Provides the xlsx class API for format operations.# Declaration: final class Xlsx# Package: mnb/mnb-phpexcel# Methods: 18Mnb\PHPExcel\Format\Xlsx{# Purpose: Returns the value of the selected cell.public static function cell(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $cell, # Worksheet cell reference. Example: 'A1'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Performs the cell details operation.public static function cellDetails(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $cell, # Worksheet cell reference. Example: 'A1'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): CellSnapshot# Purpose: Decrypts file.public static function decryptFile(string $source, # Source input used by the operation. Example: 'value'string $destination, # Destination path or target for the result. Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Encrypts file.public static function encryptFile(string $source, # Source input used by the operation. Example: 'value'string $destination, # Destination path or target for the result. Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Return agile, standard, unknown, or null when the file is not encrypted.public static function encryptionMode(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): ?string# Purpose: Performs the file info operation.public static function fileInfo(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the images operation.public static function images(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1bool $includeBytes = false, # Input value for `$includeBytes` (bool). Example: falsearray|ReaderOptions $options = [] # Configuration options for this operation. Example: []): array# Purpose: Checks whether encrypted.public static function isEncrypted(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): bool# Purpose: Performs the protection operation.public static function protection(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the range values operation.public static function rangeValues(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $range, # Worksheet cell range. Example: 'A1:D100'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): array# Purpose: Creates a read session for the supplied source.public static function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Performs the rich text operation.public static function richText(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $cell, # Worksheet cell reference. Example: 'A1'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ?RichText# Purpose: Performs the row count operation.public static function rowCount(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): int# Purpose: Performs the row counts operation.public static function rowCounts(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the sheet info operation.public static function sheetInfo(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the sheets info operation.public static function sheetsInfo(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Writes the supplied data to the destination.public static function write(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Create a styled, validated XLSX import template.public static function writeImportTemplate(array $columns, # Columns included in the operation. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void}# Provides the xml class API for format operations.# Declaration: final class Xml# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Format\Xml{# Purpose: Creates a read session for the supplied source.public static function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Writes the supplied data to the destination.public static function write(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void}# Provides the domain importer class API for import operations.# Declaration: final class DomainImporter# Package: mnb/mnb-phpexcel# Methods: 20Mnb\PHPExcel\Import\DomainImporter{# Purpose: Creates a new DomainImporter instance.public function __construct(DomainImportRegistry $domains, # Input value for `$domains` (DomainImportRegistry).ReaderRegistry $readers, # Input value for `$readers` (ReaderRegistry).ArrayValidator $validator = new ArrayValidator(), # Input value for `$validator` (ArrayValidator). Example: new ArrayValidator()SqlImporter $sqlImporter = new SqlImporter(), # Input value for `$sqlImporter` (SqlImporter). Example: new SqlImporter()ImportQualityAnalyzer $quality = new ImportQualityAnalyzer() # Input value for `$quality` (ImportQualityAnalyzer). Example: new ImportQualityAnalyzer()): mixed# Purpose: Performs the create operation.public static function create(?DomainImportRegistry $domains = null, # Input value for `$domains` (?DomainImportRegistry).?ReaderRegistry $readers = null # Input value for `$readers` (?ReaderRegistry).): self# Purpose: Imports the supplied records into the configured target.public function import(DomainImportType|string $domain, # Input value for `$domain` (DomainImportType|string). Example: 'value'string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = '', # Database table name. Example: ''array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports attendance.public function importAttendance(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'attendance', # Database table name. Example: 'attendance'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports blog posts.public function importBlogPosts(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'blog_posts', # Database table name. Example: 'blog_posts'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports categories.public function importCategories(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'categories', # Database table name. Example: 'categories'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports contacts.public function importContacts(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'contacts', # Database table name. Example: 'contacts'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports images with paths.public function importImagesWithPaths(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'media', # Database table name. Example: 'media'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports inventory.public function importInventory(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'inventory', # Database table name. Example: 'inventory'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports locations.public function importLocations(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'locations', # Database table name. Example: 'locations'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports marks.public function importMarks(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'marks', # Database table name. Example: 'marks'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports media.public function importMedia(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'media', # Database table name. Example: 'media'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports orders.public function importOrders(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'orders', # Database table name. Example: 'orders'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports products.public function importProducts(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'products', # Database table name. Example: 'products'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports students.public function importStudents(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'students', # Database table name. Example: 'students'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports users.public function importUsers(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'users', # Database table name. Example: 'users'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the preview operation.public function preview(DomainImportType|string $domain, # Input value for `$domain` (DomainImportType|string). Example: 'value'string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the registry operation.public function registry(): DomainImportRegistry# Purpose: Performs the schema operation.public function schema(DomainImportType|string $domain # Input value for `$domain` (DomainImportType|string). Example: 'value'): array# Purpose: Performs the schemas operation.public function schemas(): array}# Provides the import quality analyzer class API for import operations.# Declaration: final class ImportQualityAnalyzer# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Import\ImportQualityAnalyzer{# Purpose: Finds duplicates.public function findDuplicates(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $columns, # Columns included in the operation. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Build a safe import preview from array rows.public function preview(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Suggest map from source columns to target columns.public function suggestColumnMap(array $sourceColumns, # Input value for `$sourceColumns` (array). Example: []array $targetColumns, # Input value for `$targetColumns` (array). Example: []array $aliases = [], # Input value for `$aliases` (array). Example: []float $minConfidence = 0.55 # Input value for `$minConfidence` (float). Example: 0.55): array}# Provides the sql importer class API for import operations.# Declaration: final class SqlImporter# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Import\SqlImporter{# Purpose: Imports rows.public function importRows(PDO $pdo, # PDO connection used for database operations.string $table, # Database table name. Example: 'imports'array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): array}# Converts XLSX preflight metrics into a safe import strategy.# Declaration: final class ImportMethodAdvisor# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Large\ImportMethodAdvisor{# Purpose: Performs the decision matrix operation.public function decisionMatrix(): array# Purpose: Performs the recommend from profile operation.public function recommendFromProfile(array $profile, # A preflight profile from LargeExcelPreflightAnalyzer::analyze(). Example: []array $serverOptions = [] # server, memory_limit, max_execution_time, allow_http_large_import, prefer_cli, etc. Example: []): array# Purpose: Resolves server profile.public function resolveServerProfile(array $serverOptions = [] # Input value for `$serverOptions` (array). Example: []): array}# Streams large XLSX rows into a database using chunk validation, PDO batch inserts, failed-row CSV export, and resumable JSON progress manifests.# Declaration: final class LargeExcelDatabaseImportEngine# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Large\LargeExcelDatabaseImportEngine{# Purpose: Creates a new LargeExcelDatabaseImportEngine instance.public function __construct(?LargeXlsxStreamingReader $reader = null, # Reader implementation used by the session.?ArrayValidator $validator = null, # Input value for `$validator` (?ArrayValidator). Example: []?SqlImporter $sqlImporter = null # Input value for `$sqlImporter` (?SqlImporter).): mixed# Purpose: Imports to sql.public function importToSql(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO $pdo, # PDO connection used for database operations.string $table, # Database table name. Example: 'imports'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Import all or selected sheets from a workbook. Each sheet is imported by the same streaming engine.public function importWorkbookToSql(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO $pdo, # PDO connection used for database operations.string|array $tableMap, # Input value for `$tableMap` (string|array). Example: []array $options = [] # Configuration options for this operation. Example: []): array}# Safely inspects XLSX size/shape without loading worksheet rows into PHP arrays.# Declaration: final class LargeExcelPreflightAnalyzer# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Large\LargeExcelPreflightAnalyzer{# Purpose: Creates a new LargeExcelPreflightAnalyzer instance.public function __construct(private?XlsxWorkbookResolver $resolver = null # Input value for `$resolver` (private?XlsxWorkbookResolver).): mixed# Purpose: Performs the analyze operation.public function analyze(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # accurate_row_count, scan_features, time_budget_seconds, sheet. Example: []): array}# Writes failed large-import rows without keeping all failures in memory.# Declaration: final class LargeFailedRowsCsvWriter# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Large\LargeFailedRowsCsvWriter{# Purpose: Creates a new LargeFailedRowsCsvWriter instance.public function __construct(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'bool $reset = false, # Input value for `$reset` (bool). Example: falsearray $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Performs the append operation.public function append(array $failedRows # Input value for `$failedRows` (array). Example: []): int# Purpose: Performs the path operation.public function path(): string}# Small JSON manifest for resumable large imports.# Declaration: final class LargeImportManifest# Package: mnb/mnb-phpexcel# Methods: 7Mnb\PHPExcel\Large\LargeImportManifest{# Purpose: Creates a new LargeImportManifest instance.public function __construct(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): mixed# Purpose: Performs the data operation.public function data(): array# Purpose: Performs the default path operation.public static function defaultPath(string $sourcePath, # Input value for `$sourcePath` (string). Example: 'value'string $table = 'import', # Database table name. Example: 'import'int|string $sheet = 1 # Worksheet name or 1-based worksheet index. Example: 1): string# Purpose: Performs the load operation.public function load(): array# Purpose: Performs the path operation.public function path(): string# Purpose: Performs the start operation.public function start(array $data # Input value for `$data` (array). Example: []): void# Purpose: Performs the update operation.public function update(array $patch # Input value for `$patch` (array). Example: []): void}# Provides the large pdo cursor class API for large operations.# Declaration: final class LargePdoCursor# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Large\LargePdoCursor{# Purpose: Returns rows from the selected data source.public static function rows(PDO $pdo, # PDO connection used for database operations.string $query, # SQL query or search expression. Example: 'value'array $params = [], # Input value for `$params` (array). Example: []array $options = [] # Configuration options for this operation. Example: []): \Generator}# Shared strings cache for streaming XLSX import.# Declaration: final class LargeSharedStringCache implements SharedStringProviderInterface# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Large\LargeSharedStringCache{# Purpose: Closes the active resource and releases related state.public function close(): void# Purpose: Returns the number of matching items.public function count(): int# Purpose: Creates the value from xlsx.public static function fromXlsx(string $realPath, # Input value for `$realPath` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the get operation.public function get(int $index # Zero-based or 1-based index as documented by the method. Example: 1): string# Purpose: Performs the mode operation.public function mode(): string# Purpose: Performs the destruct operation.public function __destruct(): mixed}# Fluent large-XLSX read session. It always streams; it never returns the full workbook.# Declaration: final class LargeXlsxReadSession# Package: mnb/mnb-phpexcel# Methods: 19Mnb\PHPExcel\Large\LargeXlsxReadSession{# Purpose: Creates a new LargeXlsxReadSession instance.public function __construct(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'private?LargeXlsxStreamingReader $reader = null, # Reader implementation used by the session.array $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Performs the chunk operation.public function chunk(int $chunkSize, # Number of records processed per batch. Example: 500callable $callback # Callback invoked during this operation. Example: static fn ($value) => $value): array# Purpose: Converts dates.public function convertDates(bool $enabled = true, # Input value for `$enabled` (bool). Example: true?string $format = null # Spreadsheet or data format identifier. Example: 'xlsx'): self# Purpose: Performs the each row operation.public function eachRow(callable $callback # Callback invoked during this operation. Example: static fn ($value) => $value): array# Purpose: Alias for chunk(), useful in import controllers/jobs.public function import(int $chunkSize, # Number of records processed per batch. Example: 500callable $callback # Callback invoked during this operation. Example: static fn ($value) => $value): array# Purpose: Performs the limit rows operation.public function limitRows(int $rows # Rows supplied for reading, writing, validation, or import. Example: 1): self# Purpose: Performs the max shared strings in memory operation.public function maxSharedStringsInMemory(int $count # Input value for `$count` (int). Example: 1): self# Purpose: Performs the memory guard ratio operation.public function memoryGuardRatio(float $ratio # Input value for `$ratio` (float). Example: 1.0): self# Purpose: Performs the only columns operation.public function onlyColumns(array $columns # Columns included in the operation. Example: []): self# Purpose: Performs the options operation.public function options(): array# Purpose: Performs the password operation.public function password(string $password # Password used for protection or encryption. Example: 'secret'): self# Purpose: Performs the preserve numeric strings operation.public function preserveNumericStrings(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Performs the progress operation.public function progress(callable $callback # Callback invoked during this operation. Example: static fn ($value) => $value): self# Purpose: Returns a copy configured for the selected worksheet.public function sheet(int|string $sheet # Worksheet name or 1-based worksheet index. Example: 'Sheet1'): self# Purpose: Performs the skip rows operation.public function skipRows(int $rows # Rows supplied for reading, writing, validation, or import. Example: 1): self# Purpose: Performs the time budget seconds operation.public function timeBudgetSeconds(int $seconds # Input value for `$seconds` (int). Example: 1): self# Purpose: Performs the transform operation.public function transform(callable|string $transformer # Input value for `$transformer` (callable|string). Example: static fn ($value) => $value): self# Purpose: Performs the transformers operation.public function transformers(array $transformers # Input value for `$transformers` (array). Example: []): self# Purpose: Returns a copy configured with header.public function withHeader(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self}# Forward-only XLSX worksheet reader for large imports.# Declaration: final class LargeXlsxStreamingReader# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Large\LargeXlsxStreamingReader{# Purpose: Creates a new LargeXlsxStreamingReader instance.public function __construct(?XlsxWorkbookResolver $resolver = null # Input value for `$resolver` (?XlsxWorkbookResolver).): mixed# Purpose: Performs the chunk operation.public function chunk(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int $chunkSize, # Number of records processed per batch. Example: 500callable $callback, # Callback invoked during this operation. Example: static fn ($value) => $valuearray $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the each row operation.public function eachRow(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'callable $callback, # Callback invoked during this operation. Example: static fn ($value) => $valuearray $options = [] # Configuration options for this operation. Example: []): array}# Low-memory XLSX/CSV-ZIP writer for very large tabular exports.# Declaration: final class LargeXlsxStreamingWriter# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Large\LargeXlsxStreamingWriter{# Purpose: Saves csv zip.public function saveCsvZip(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Writes the supplied data to the destination.public function write(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array}# Fluent session for large XLSX/CSV-ZIP exports. The source iterable is streamed exactly once, so call either save() or saveCsvZip() for a session.# Declaration: final class LargeXlsxWriteSession# Package: mnb/mnb-phpexcel# Methods: 18Mnb\PHPExcel\Large\LargeXlsxWriteSession{# Purpose: Creates a new LargeXlsxWriteSession instance.public function __construct(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []private?LargeXlsxStreamingWriter $writer = null, # Writer implementation used by the operation.array $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Performs the auto filter operation.public function autoFilter(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Performs the auto split sheets operation.public function autoSplitSheets(bool $enabled = true, # Input value for `$enabled` (bool). Example: trueint $maxRowsPerSheet = 1048576 # Input value for `$maxRowsPerSheet` (int). Example: 1048576): self# Purpose: Performs the column formats operation.public function columnFormats(array $formats # Input value for `$formats` (array). Example: []): self# Purpose: Performs the csv rows per file operation.public function csvRowsPerFile(int $rows # Rows supplied for reading, writing, validation, or import. Example: 1): self# Purpose: Performs the format column operation.public function formatColumn(int|string $column, # Column name, letter, or index. Example: 'A'string $format # Spreadsheet or data format identifier. Example: 'xlsx'): self# Purpose: Performs the formula policy operation.public function formulaPolicy(string $policy # Input value for `$policy` (string). Example: 'value'): self# Purpose: Performs the freeze header operation.public function freezeHeader(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Performs the headers operation.public function headers(array $headers # Input value for `$headers` (array). Example: []): self# Purpose: Performs the max rows per sheet operation.public function maxRowsPerSheet(int $rows # Rows supplied for reading, writing, validation, or import. Example: 1): self# Purpose: Performs the options operation.public function options(): array# Purpose: Performs the progress operation.public function progress(callable $callback, # Callback invoked during this operation. Example: static fn ($value) => $valueint $everyRows = 1000 # Input value for `$everyRows` (int). Example: 1000): self# Purpose: Performs the save operation.public function save(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): array# Purpose: Saves csv zip.public function saveCsvZip(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): array# Purpose: Performs the sheet name operation.public function sheetName(string $name # Name used to identify the target value. Example: 'value'): self# Purpose: Performs the text policy operation.public function textPolicy(string $policy # Input value for `$policy` (string). Example: 'value'): self# Purpose: Validates integrity.public function validateIntegrity(bool $enabled = true # Input value for `$enabled` (bool). Example: true): self# Purpose: Returns a copy configured with header.public function withHeader(array|bool $header = true # Input value for `$header` (array|bool). Example: true): self}# Provides the mnb excel class API for phpexcel operations.# Declaration: final class MnbExcel# Package: mnb/mnb-phpexcel# Methods: 132Mnb\PHPExcel\MnbExcel{# Purpose: Return current/planned advanced workbook capability matrix.public static function advancedWorkbookCapabilities(): array# Purpose: Generate a dependency-free browser upload form and client.public static function ajaxUploader(string $endpoint, # Target URL that receives the request. Example: 'https://example.com/upload'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Analyze an XLSX file without loading all rows. Use this before importing large workbooks.public static function analyzeXlsxForImport(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # accurate_row_count, scan_features, time_budget_seconds, sheet, server. Example: []): array# Purpose: Framework-neutral spreadsheet API dispatcher for upload, preview, import, status, and export actions.public static function api(string $action, # Input value for `$action` (string). Example: 'value'array $request, # Input value for `$request` (array). Example: []PDO|array|string|null $pdo = null # PDO connection used for database operations. Example: []): array# Purpose: Complete HTTP endpoint with routing, authentication, CORS and rate limiting.public static function apiHttp(array $options = [], # Configuration options for this operation. Example: []PDO|array|string|null $pdo = null # PDO connection used for database operations. Example: []): HttpResponse# Purpose: Throw MnbExcelException when XLSX integrity validation fails.public static function assertValidXlsx(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Build an auto-import plan: preflight profile + selected method + ready-to-use routing advice.public static function autoImportPlan(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $serverOptions = [], # Input value for `$serverOptions` (array). Example: []array $analysisOptions = [] # Input value for `$analysisOptions` (array). Example: []): array# Purpose: Run an internal low-memory large XLSX writer benchmark for this package. Third-party comparison benchmarks should be run in a separate workspace with those optional packages installed.public static function benchmarkLargeWriter(int $rows, # Rows supplied for reading, writing, validation, or import. Example: 1int $columns = 10, # Columns included in the operation. Example: 10array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Return a reproducible benchmark plan for MNB PHPExcel and optional comparison libraries.public static function benchmarkPlan(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the blank operation.public static function blank(): CellValue# Purpose: Performs the bool operation.public static function bool(bool $value # Value supplied to the operation. Example: true): CellValue# Purpose: Return required real-world XLSX fixture coverage for release compatibility proof.public static function compatibilityFixtureRequirements(): array# Purpose: Return resolved CSV dialect options, useful for UI/config previews.public static function csvDialectOptions(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Show which .env/config paths would be checked for database settings.public static function databaseConfigSummary(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Alias of pdo() for readability in application code.public static function databaseConnection(PDO|array|string|null $source = null, # Source input used by the operation. Example: []array $overrides = [] # Input value for `$overrides` (array). Example: []): PDO# Purpose: Check whether optional MySQL/PostgreSQL integration-test connections are configured.public static function databaseIntegrationCheck(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Return MySQL/PostgreSQL integration-test setup guidance.public static function databaseIntegrationPlan(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the date operation.public static function date(\DateTimeInterface|string $value, # Value supplied to the operation. Example: 'value'array $options = [] # Configuration options for this operation. Example: []): CellValue# Purpose: Resolve database settings from .env, PHP config file, constants, runtime env, DSN, or array.public static function dbConfig(array|string|null $source = null, # Source input used by the operation. Example: []array $overrides = [] # Input value for `$overrides` (array). Example: []): array# Purpose: Decrypt a password-encrypted XLSX to a normal OOXML ZIP package.public static function decryptXlsx(string $source, # Source input used by the operation. Example: 'value'string $destination, # Destination path or target for the result. Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Detect character encoding for CSV/text files without loading the full file.public static function detectEncoding(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int $sampleBytes = 65536, # Input value for `$sampleBytes` (int). Example: 65536?array $candidates = null # Input value for `$candidates` (?array). Example: []): array# Purpose: Detects format.public static function detectFormat(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the dispatch operation.public static function dispatch(string $event, # Input value for `$event` (string). Example: 'value'array $payload = [] # Input value for `$payload` (array). Example: []): array# Purpose: Performs the domain import schema operation.public static function domainImportSchema(DomainImportType|string $domain # Input value for `$domain` (DomainImportType|string). Example: 'value'): array# Purpose: Performs the domain import schemas operation.public static function domainImportSchemas(): array# Purpose: Performs the domain import template operation.public static function domainImportTemplate(DomainImportType|string $domain, # Input value for `$domain` (DomainImportType|string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): WorkbookBuilder# Purpose: Detect duplicate rows by one or more columns.public static function duplicateRows(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $columns, # Columns included in the operation. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Send a generated or existing spreadsheet as a MIME email attachment.public static function emailGeneratedExcel(WorkbookBuilder|string $workbook, # Input value for `$workbook` (WorkbookBuilder|string). Example: 'value'string|array $to, # Input value for `$to` (string|array). Example: []string $subject, # Input value for `$subject` (string). Example: 'value'string $body = '', # Input value for `$body` (string). Example: ''array $options = [] # Configuration options for this operation. Example: []): bool# Purpose: Encrypt an existing XLSX with Agile AES-256 or compatibility-mode Standard AES-128.public static function encryptXlsx(string $source, # Source input used by the operation. Example: 'value'string $destination, # Destination path or target for the result. Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Return a public/developer alert when required XLSX/large-import extensions are missing.public static function environmentAlert(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Return a ready-to-print environment alert message for CLI/admin screens.public static function environmentAlertMessage(array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Report PHP extension/runtime capability for XLSX, SQL, encoding, and atomic-save workflows.public static function environmentCheck(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Convert any caught exception into an error report. Pass debug=true only for logs/admin screens.public static function errorReport(Throwable $throwable, # Input value for `$throwable` (Throwable).bool $debug = false # Input value for `$debug` (bool). Example: false): array# Purpose: Return XLSX file/package information without loading workbook cell rows.public static function fileInfo(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # password. Example: []): array# Purpose: Performs the formula operation.public static function formula(string $formula, # Input value for `$formula` (string). Example: 'value'$cachedValue = null, # Input value for `$cachedValue`.array $options = [] # Configuration options for this operation. Example: []): CellValue# Purpose: Create a workbook builder from a single sheet array.public static function fromArray(array $rows # Rows supplied for reading, writing, validation, or import. Example: []): WorkbookBuilder# Purpose: Build an Excel/CSV report from failed validation rows.public static function fromFailedRows(array $failedRows # Input value for `$failedRows` (array). Example: []): WorkbookBuilder# Purpose: Create a standalone workbook containing import summary metrics.public static function fromImportSummary(array $summary, # Input value for `$summary` (array). Example: []array $validationResult = [] # Input value for `$validationResult` (array). Example: []): WorkbookBuilder# Purpose: Create a workbook builder from a JSON file.public static function fromJson(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): WorkbookBuilder# Purpose: Export SQL query result to an array workbook builder.public static function fromSql(PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string $query, # SQL query or search expression. Example: 'value'array $params = [], # Input value for `$params` (array). Example: []array $dbOptions = [] # Input value for `$dbOptions` (array). Example: []): WorkbookBuilder# Purpose: Create a workbook builder from many sheets.public static function fromWorkbookArray(array $sheets # Input value for `$sheets` (array). Example: []): WorkbookBuilder# Purpose: Store a validated $_FILES-style upload and return an AJAX/API-ready response.public static function handleAjaxUpload(array|string $file, # File path or file value used by the operation. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports attendance.public static function importAttendance(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'attendance', # Database table name. Example: 'attendance'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports blog posts.public static function importBlogPosts(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'blog_posts', # Database table name. Example: 'blog_posts'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports categories.public static function importCategories(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'categories', # Database table name. Example: 'categories'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports contacts.public static function importContacts(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'contacts', # Database table name. Example: 'contacts'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Build an admin/API friendly dashboard response from an import manifest.public static function importDashboard(string|array $manifestOrStatus, # Input value for `$manifestOrStatus` (string|array). Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports domain.public static function importDomain(DomainImportType|string $domain, # Input value for `$domain` (DomainImportType|string). Example: 'value'string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = '', # Database table name. Example: ''array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Import multiple files through one typed domain preset.public static function importDomainFiles(DomainImportType|string $domain, # Input value for `$domain` (DomainImportType|string). Example: 'value'array $files, # Input value for `$files` (array). Example: []PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = '', # Database table name. Example: ''array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Import multiple spreadsheet files into one or dynamically resolved SQL table.public static function importFilesToSql(array $files, # Input value for `$files` (array). Example: []PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string $table, # Database table name. Example: 'imports'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports images with paths.public static function importImagesWithPaths(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'media', # Database table name. Example: 'media'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports inventory.public static function importInventory(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'inventory', # Database table name. Example: 'inventory'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports locations.public static function importLocations(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'locations', # Database table name. Example: 'locations'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports marks.public static function importMarks(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'marks', # Database table name. Example: 'marks'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports media.public static function importMedia(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'media', # Database table name. Example: 'media'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Return the method decision matrix used by the advisor.public static function importMethodMatrix(): array# Purpose: Imports orders.public static function importOrders(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'orders', # Database table name. Example: 'orders'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports products.public static function importProducts(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'products', # Database table name. Example: 'products'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports profiles.public static function importProfiles(): array# Purpose: Read a progress/status manifest for admin dashboards and job runners.public static function importStatus(string $manifestPath, # Input value for `$manifestPath` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Alias for importDashboard(), useful in controllers returning JSON.public static function importStatusResponse(string|array $manifestOrStatus, # Input value for `$manifestOrStatus` (string|array). Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports students.public static function importStudents(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'students', # Database table name. Example: 'students'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Imports users.public static function importUsers(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []string $table = 'users', # Database table name. Example: 'users'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Inspect an XLSX workbook structure without converting workbook rows to arrays.public static function inspect(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Return true when the XLSX is wrapped in an encrypted Office compound container.public static function isEncryptedXlsx(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): bool# Purpose: Create a streaming XLSX/CSV-ZIP export session for very large exports. The iterable is consumed once and rows are never buffered as a full workbook.public static function largeExport(iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): LargeXlsxWriteSession# Purpose: Create a streaming export session from a PDO cursor. The query result is not loaded into memory.public static function largeExportFromSql(PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string $query, # SQL query or search expression. Example: 'value'array $params = [], # Input value for `$params` (array). Example: []array $options = [] # Configuration options for this operation. Example: []): LargeXlsxWriteSession# Purpose: Return the default resumable manifest path for a large XLSX import job.public static function largeImportManifestPath(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $table = 'import', # Database table name. Example: 'import'int|string $sheet = 1 # Worksheet name or 1-based worksheet index. Example: 1): string# Purpose: Stream a large XLSX file into a SQL table using chunk validation, PDO batch inserts, failed-row CSV export, and a resumable JSON progress manifest.public static function largeImportToSql(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string $table, # Database table name. Example: 'imports'array $options = [] # sheet, with_header, rules, batch_size, chunk_size, manifest_path, failed_rows_csv, resume, time_budget_seconds. Example: []): array# Purpose: Import all or selected workbook sheets one by one using the large database import engine.public static function largeImportWorkbookToSql(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string|array $tableMap, # String table prefix/name or sheet-name/index => table map. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Create a streaming XLSX read session for large imports. It never loads the whole workbook.public static function largeRead(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # sheet, with_header, skip_rows, only_columns, time_budget_seconds. Example: []): LargeXlsxReadSession# Purpose: Stream rows directly to a large XLSX file.public static function largeWrite(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Stream rows directly to a split CSV ZIP fallback. Useful when XLSX is too large for practical Excel opening or row limits.public static function largeWriteCsvZip(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'iterable $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Stream a PDO cursor directly to a large XLSX file.public static function largeWriteFromSql(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string $query, # SQL query or search expression. Example: 'value'array $params = [], # Input value for `$params` (array). Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Load import profiles from an array or PHP config file.public static function loadImportProfiles(array|string $profiles # Input value for `$profiles` (array|string). Example: []): void# Purpose: Instance-based entry point recommended for long-running workers.public static function manager(): SpreadsheetManager# Purpose: Performs the number operation.public static function number(int|float|string $value # Value supplied to the operation. Example: 1): CellValue# Purpose: Performs the on operation.public static function on(string $event, # Input value for `$event` (string). Example: 'value'callable $listener # Input value for `$listener` (callable). Example: static fn ($value) => $value): void# Purpose: Create a PDO connection from .env, PHP config file, constants, runtime env, DSN, array, or existing PDO.public static function pdo(PDO|array|string|null $source = null, # Source input used by the operation. Example: []array $overrides = [] # Input value for `$overrides` (array). Example: []): PDO# Purpose: Create a transactional multi-host PDO queue.public static function pdoQueue(PDO $pdo, # PDO connection used for database operations.string $table = 'mnb_excel_queue' # Database table name. Example: 'mnb_excel_queue'): SpreadsheetQueue# Purpose: Create a transactional multi-host PDO scheduler.public static function pdoScheduler(PDO $pdo, # PDO connection used for database operations.string $table = 'mnb_excel_schedule' # Database table name. Example: 'mnb_excel_schedule'): SpreadsheetScheduler# Purpose: Register a plugin object or closure.public static function plugin(MnbExcelPluginInterface|callable $plugin # Input value for `$plugin` (MnbExcelPluginInterface|callable). Example: static fn ($value) => $value): void# Purpose: Performs the plugins operation.public static function plugins(): array# Purpose: Performs the preview domain import operation.public static function previewDomainImport(DomainImportType|string $domain, # Input value for `$domain` (DomainImportType|string). Example: 'value'string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Preview import quality before validation or SQL insert.public static function previewImport(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Start a reusable import profile.public static function profile(string $name # Name used to identify the target value. Example: 'value'): ImportProfile# Purpose: Create the built-in durable filesystem queue.public static function queue(string $directory # Input value for `$directory` (string). Example: 'value'): SpreadsheetQueue# Purpose: Create a spreadsheet queue from any backend implementation.public static function queueBackend(QueueBackendInterface $backend # Input value for `$backend` (QueueBackendInterface).): SpreadsheetQueue# Purpose: Read XLSX, CSV, JSON/JSON Lines, or XML using format auto-detection. Pass ['format' => 'xlsx|csv|json|xml'] to override detection.public static function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Read a CSV file. Options become default read options for this session.public static function readCsv(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Read a JSON file. Options become default read options for this session.public static function readJson(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Reads ods.public static function readOds(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Optional legacy XLS adapter; requires phpoffice/phpspreadsheet.public static function readXls(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Reads xlsx.public static function readXlsx(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Reads xml.public static function readXml(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Recommend the safest import method for an XLSX file and server profile.public static function recommendImportMethod(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $serverOptions = [], # server, memory_limit, max_execution_time, allow_http_large_import. Example: []array $analysisOptions = [] # accurate_row_count, scan_features, time_budget_seconds, sheet. Example: []): array# Purpose: Recommend an import method from already-known metrics. Useful for tests, UIs, and custom analyzers.public static function recommendImportMethodFromProfile(array $profile, # Input value for `$profile` (array). Example: []array $serverOptions = [] # Input value for `$serverOptions` (array). Example: []): array# Purpose: Replace one built-in preset for this process.public static function registerDomainImportPreset(DomainImportPreset $preset # Input value for `$preset` (DomainImportPreset).): void# Purpose: Register one reusable import profile.public static function registerImportProfile(string $name, # Name used to identify the target value. Example: 'value'array $profile # Input value for `$profile` (array). Example: []): void# Purpose: Performs the register reader plugin operation.public static function registerReaderPlugin(ReaderPluginInterface $plugin, # Input value for `$plugin` (ReaderPluginInterface).int $priority = 0 # Input value for `$priority` (int). Example: 0): void# Purpose: Run local package-readiness checks before Git/Packagist release.public static function releaseReadiness(string $root # Input value for `$root` (string). Example: 'value'): array# Purpose: Create a report-ready workbook builder from array rows.public static function report(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $template = 'business' # Input value for `$template` (string). Example: 'business'): WorkbookBuilder# Purpose: Performs the reset reader registry operation.public static function resetReaderRegistry(): void# Purpose: Resume an existing large import job from its manifest.public static function resumeImport(string $manifestPath, # Input value for `$manifestPath` (string). Example: 'value'PDO|array|string|null $pdo = null, # PDO connection used for database operations. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Count rows in one XLSX worksheet without converting rows to PHP arrays.public static function rowCount(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): int# Purpose: Count rows for all XLSX worksheets without converting rows to PHP arrays.public static function rowCounts(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # password, mode, include_hidden. Example: []): array# Purpose: Run a scheduler continuously with process locking and graceful shutdown.public static function runScheduler(SpreadsheetScheduler $scheduler, # Input value for `$scheduler` (SpreadsheetScheduler).array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Convert any caught exception into a public-safe response array.public static function safeError(Throwable $throwable # Input value for `$throwable` (Throwable).): array# Purpose: Performs the safe file name operation.public static function safeFileName(string $filename, # File name used by the operation. Example: 'workbook.xlsx'string $extension = '' # Input value for `$extension` (string). Example: ''): string# Purpose: Performs the safe sheet name operation.public static function safeSheetName(string $name # Name used to identify the target value. Example: 'value'): string# Purpose: Scan source rows for formula-like text, unsafe formulas, invalid cell text, long cell text, and long numeric strings that can lose precision in Excel.public static function scanCells(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Create a persistent cron-style import/export scheduler.public static function scheduler(string $storePath # Input value for `$storePath` (string). Example: 'value'): SpreadsheetScheduler# Purpose: Optional PSR-3-like logger or callable logger.public static function setLogger($logger # Input value for `$logger`.): void# Purpose: Return one XLSX worksheet's information without loading cell values.public static function sheetInfo(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # password, accurate_row_count. Example: []): array# Purpose: Performs the sheet names operation.public static function sheetNames(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Return information for every XLSX worksheet without loading cell values.public static function sheetsInfo(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Configure application storage paths for uploads, manifests, failed rows, reports, and temp files.public static function storage(array $paths = [] # Input value for `$paths` (array). Example: []): array# Purpose: Return a configured storage path by key.public static function storagePath(string $key, # Key used to identify the target value. Example: 'value'string $filename = '' # File name used by the operation. Example: ''): string# Purpose: Suggest source-to-target column mappings for import screens.public static function suggestColumnMap(array $sourceColumns, # Input value for `$sourceColumns` (array). Example: []array $targetColumns, # Input value for `$targetColumns` (array). Example: []array $aliases = [], # Input value for `$aliases` (array). Example: []float $minConfidence = 0.55 # Input value for `$minConfidence` (float). Example: 0.55): array# Purpose: Performs the text operation.public static function text($value # Value supplied to the operation.): CellValue# Purpose: Performs the transformer operation.public static function transformer(string $name, # Name used to identify the target value. Example: 'value'callable $transformer # Input value for `$transformer` (callable). Example: static fn ($value) => $value): void# Purpose: Validate associative array rows using MNB PHPExcel validation rules.public static function validateArray(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $rules, # Input value for `$rules` (array). Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Import-focused alias for validateArray().public static function validateImport(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $rules, # Input value for `$rules` (array). Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Validate an uploaded file path or $_FILES-style array before import.public static function validateUpload(array|string $file, # File path or file value used by the operation. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Validate an XLSX package for required parts, relationships, content types, XML well-formedness, and worksheet relationship ID consistency.public static function validateXlsx(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the validator operation.public static function validator(string $name, # Name used to identify the target value. Example: 'value'callable $callback # Callback invoked during this operation. Example: static fn ($value) => $value): void# Purpose: Verify real Excel/LibreOffice/Google Sheets/WPS fixture files in a directory.public static function verifyCompatibilityFixtures(string $fixtureDir, # Input value for `$fixtureDir` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Run generated and optional external XLSX compatibility fixture verification.public static function verifyXlsxCompatibility(array $fixturePaths = [], # Input value for `$fixturePaths` (array). Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the version operation.public static function version(): string# Purpose: Process queued spreadsheet jobs without requiring a framework queue package.public static function workQueue(string $directory, # Input value for `$directory` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Return agile, standard, unknown, or null when the file is not encrypted.public static function xlsxEncryptionMode(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): ?string# Purpose: Read file/workbook/worksheet protection metadata without exposing verifier material.public static function xlsxProtection(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): array}# Provides the mnb excel plugin interface interface API for plugin operations.# Declaration: interface MnbExcelPluginInterface# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Plugin\MnbExcelPluginInterface{# Purpose: Performs the register operation.abstract public function register(PluginRegistry $registry # Input value for `$registry` (PluginRegistry).): void}# Provides the plugin manager class API for plugin operations.# Declaration: final class PluginManager# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Plugin\PluginManager{# Purpose: Performs the clear operation.public static function clear(): void# Purpose: Performs the plugins operation.public static function plugins(): array# Purpose: Performs the register operation.public static function register(MnbExcelPluginInterface|callable $plugin # Input value for `$plugin` (MnbExcelPluginInterface|callable). Example: static fn ($value) => $value): void}# Provides the plugin registry class API for plugin operations.# Declaration: final class PluginRegistry# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Plugin\PluginRegistry{# Purpose: Performs the event operation.public function event(string $event, # Input value for `$event` (string). Example: 'value'callable $listener # Input value for `$listener` (callable). Example: static fn ($value) => $value): self# Purpose: Imports profile.public function importProfile(string $name, # Name used to identify the target value. Example: 'value'array $profile # Input value for `$profile` (array). Example: []): self# Purpose: Reads er.public function reader(ReaderPluginInterface $plugin, # Input value for `$plugin` (ReaderPluginInterface).int $priority = 0 # Input value for `$priority` (int). Example: 0): self# Purpose: Performs the transformer operation.public function transformer(string $name, # Name used to identify the target value. Example: 'value'callable $transformer # Input value for `$transformer` (callable). Example: static fn ($value) => $value): self# Purpose: Performs the validator operation.public function validator(string $name, # Name used to identify the target value. Example: 'value'callable $callback # Callback invoked during this operation. Example: static fn ($value) => $value): self}# Source-level projection used before row normalization and header mapping.# Declaration: final class ColumnProjection# Package: mnb/mnb-phpexcel# Methods: 7Mnb\PHPExcel\Reader\ColumnProjection{# Purpose: Performs the active operation.public function active(): bool# Purpose: Performs the compact operation.public function compact(): bool# Purpose: Creates the value from options.public static function fromOptions(array $options # Configuration options for this operation. Example: []): self# Purpose: Performs the includes index operation.public function includesIndex(int $oneBasedIndex # Input value for `$oneBasedIndex` (int). Example: 1): bool# Purpose: Performs the includes key operation.public function includesKey(string $key # Key used to identify the target value. Example: 'value'): bool# Purpose: Performs the indexes operation.public function indexes(): array# Purpose: Performs the project operation.public function project(array $row # Row value or 1-based row number. Example: []): array}# Provides the csv reader class API for reader operations.# Declaration: final class CsvReader implements IterableReaderInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\CsvReader{# Purpose: Iterates over sheet.public function iterateSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): iterable# Purpose: Reads sheet.public function readSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array}# Provides the formula evaluator factory class API for formula operations.# Declaration: final class FormulaEvaluatorFactory# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Reader\Formula\FormulaEvaluatorFactory{# Purpose: Performs the create operation.public static function create(bool $preferNative = false # Input value for `$preferNative` (bool). Example: false): FormulaEvaluatorInterface}# Provides the formula evaluator interface interface API for formula operations.# Declaration: interface FormulaEvaluatorInterface# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\Formula\FormulaEvaluatorInterface{# Purpose: Performs the calculate cell operation.abstract public function calculateCell(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'string $cell # Worksheet cell reference. Example: 'A1'): mixed# Purpose: Performs the calculate range operation.abstract public function calculateRange(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'string $range # Worksheet cell range. Example: 'A1:D100'): array}# Instance-scoped custom formula functions for application-specific formulas.# Declaration: final class FormulaFunctionRegistry# Package: mnb/mnb-phpexcel# Methods: 4Mnb\PHPExcel\Reader\Formula\FormulaFunctionRegistry{# Purpose: Performs the call operation.public function call(string $name, # Name used to identify the target value. Example: 'value'array $args # Input value for `$args` (array). Example: []): mixed# Purpose: Performs the has operation.public function has(string $name # Name used to identify the target value. Example: 'value'): bool# Purpose: Performs the names operation.public function names(): array# Purpose: Performs the register operation.public function register(string $name, # Name used to identify the target value. Example: 'value'callable $function # Input value for `$function` (callable). Example: static fn ($value) => $value): self}# Lightweight native formula evaluator for common business formulas. Unsupported functions can fall back to another evaluator when supplied.# Declaration: final class NativeFormulaEvaluator implements FormulaEvaluatorInterface# Package: mnb/mnb-phpexcel# Methods: 4Mnb\PHPExcel\Reader\Formula\NativeFormulaEvaluator{# Purpose: Creates a new NativeFormulaEvaluator instance.public function __construct(readonly?FormulaEvaluatorInterface $fallback = null, # Input value for `$fallback` (readonly?FormulaEvaluatorInterface).readonly?FormulaFunctionRegistry $functions = null # Input value for `$functions` (readonly?FormulaFunctionRegistry).): mixed# Purpose: Performs the calculate cell operation.public function calculateCell(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'string $cell # Worksheet cell reference. Example: 'A1'): mixed# Purpose: Performs the calculate range operation.public function calculateRange(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'string $range # Worksheet cell range. Example: 'A1:D100'): array# Purpose: Evaluate a formula with a custom cell resolver, useful outside XLSX files and for tests.public function evaluate(string $formula, # Input value for `$formula` (string). Example: 'value'callable $resolver # Input value for `$resolver` (callable). Example: static fn ($value) => $value): mixed}# Provides the php spreadsheet formula evaluator class API for formula operations.# Declaration: final class PhpSpreadsheetFormulaEvaluator implements FormulaEvaluatorInterface# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Reader\Formula\PhpSpreadsheetFormulaEvaluator{# Purpose: Performs the available operation.public function available(): bool# Purpose: Performs the calculate cell operation.public function calculateCell(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'string $cell # Worksheet cell reference. Example: 'A1'): mixed# Purpose: Performs the calculate range operation.public function calculateRange(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'string $range # Worksheet cell range. Example: 'A1:D100'): array}# Provides the header detector class API for reader operations.# Declaration: final class HeaderDetector# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Reader\HeaderDetector{# Purpose: Detect the most likely physical header row in a source sample.public function detect(array $rows, # keyed by zero-based source row index. Example: []int $maxRows = 25 # Input value for `$maxRows` (int). Example: 25): HeaderDetection}# Optional reader contract for forward-only row iteration.# Declaration: interface IterableReaderInterface extends ReaderInterface# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Reader\IterableReaderInterface{# Purpose: Iterates over sheet.abstract public function iterateSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): iterable}# Provides the json character stream class API for reader operations.# Declaration: final class JsonCharacterStream# Package: mnb/mnb-phpexcel# Methods: 8Mnb\PHPExcel\Reader\JsonCharacterStream{# Purpose: Creates a new JsonCharacterStream instance.public function __construct(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int $chunkBytes # Input value for `$chunkBytes` (int). Example: 1): mixed# Purpose: Closes the active resource and releases related state.public function close(): void# Purpose: Performs the column operation.public function column(): int# Purpose: Performs the get operation.public function get(): ?string# Purpose: Performs the line operation.public function line(): int# Purpose: Performs the peek operation.public function peek(): ?string# Purpose: Performs the skip whitespace operation.public function skipWhitespace(): void# Purpose: Performs the skip whitespace and bom operation.public function skipWhitespaceAndBom(): void}# Provides the json reader class API for reader operations.# Declaration: final class JsonReader implements IterableReaderInterface# Package: mnb/mnb-phpexcel# Methods: 4Mnb\PHPExcel\Reader\JsonReader{# Purpose: Streams NDJSON directly and streams standard top-level JSON arrays item by item. Workbook-shaped JSON objects intentionally fall back to materialized parsing because selecting a named sheet requires document-level structure.public function iterateSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): iterable# Purpose: Reads sheet.public function readSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Reads workbook.public function readWorkbook(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the sheet names operation.public function sheetNames(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array}# Provides the merged cell map class API for reader operations.# Declaration: final class MergedCellMap# Package: mnb/mnb-phpexcel# Methods: 4Mnb\PHPExcel\Reader\MergedCellMap{# Purpose: Performs the active operation.public function active(): bool# Purpose: Performs the expand row operation.public function expandRow(int $rowNumber, # Input value for `$rowNumber` (int). Example: 1array $row, # Row value or 1-based row number. Example: []array &$anchors # Input value for `$anchors` (array). Example: []): array# Purpose: Creates the value from xlsx.public static function fromXlsx(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $sheetEntry, # Input value for `$sheetEntry` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): self# Purpose: Performs the ranges operation.public function ranges(): array}# Forward-only OpenDocument Spreadsheet (.ods) reader.# Declaration: final class OdsReader implements IterableReaderInterface# Package: mnb/mnb-phpexcel# Methods: 4Mnb\PHPExcel\Reader\OdsReader{# Purpose: Iterates over sheet.public function iterateSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): iterable# Purpose: Reads sheet.public function readSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Reads workbook.public function readWorkbook(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the sheet names operation.public function sheetNames(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array}# Immutable, typed read configuration.# Declaration: final class ReaderOptions# Package: mnb/mnb-phpexcel# Methods: 13Mnb\PHPExcel\Reader\Options\ReaderOptions{# Purpose: Performs the defaults operation.public static function defaults(): self# Purpose: Creates the value from array.public static function fromArray(array $values = [] # Values supplied to the operation. Example: []): self# Purpose: Performs the get operation.public function get(string $key, # Key used to identify the target value. Example: 'value'$default = null # Input value for `$default`.): mixed# Purpose: Returns the current result as an array.public function toArray(): array# Purpose: Performs the with operation.public function with(array $values # Values supplied to the operation. Example: []): self# Purpose: Detect the most likely physical header row from the first source rows.public function withAutoHeader(int $sampleRows = 25, # Input value for `$sampleRows` (int). Example: 25float $minimumConfidence = 0.35 # Input value for `$minimumConfidence` (float). Example: 0.35): self# Purpose: Returns a copy configured with columns.public function withColumns(array $columns, # Columns included in the operation. Example: []bool $compact = true # Input value for `$compact` (bool). Example: true): self# Purpose: Returns a copy configured with formula mode.public function withFormulaMode(string $mode # Input value for `$mode` (string). Example: 'value'): self# Purpose: Returns a copy configured with mode.public function withMode(ReadMode|string $mode # Input value for `$mode` (ReadMode|string). Example: 'value'): self# Purpose: Supply the password used to open an encrypted XLSX workbook.public function withPassword(string $password # Password used for protection or encryption. Example: 'secret'): self# Purpose: Returns a copy configured with progress.public function withProgress(callable $callback, # Callback invoked during this operation. Example: static fn ($value) => $valueint $everyRows = 1000 # Input value for `$everyRows` (int). Example: 1000): self# Purpose: Returns a copy configured with range.public function withRange(?int $startRow = null, # Input value for `$startRow` (?int).?int $endRow = null, # Input value for `$endRow` (?int).int|string|null $startColumn = null, # Input value for `$startColumn` (int|string|null). Example: 1int|string|null $endColumn = null # Input value for `$endColumn` (int|string|null). Example: 1): self# Purpose: Returns a copy configured with row error policy.public function withRowErrorPolicy(RowErrorPolicy|string $policy, # Input value for `$policy` (RowErrorPolicy|string). Example: 'value'?callable $handler = null # Handler invoked by the operation. Example: static fn ($value) => $value): self}# Provides the read mode enum API for options operations.# Declaration: enum ReadMode :string# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Reader\Options\ReadMode{# Purpose: Creates the value from mixed.public static function fromMixed(self|string|null $value # Value supplied to the operation. Example: 'value'): self}# Provides the row error policy enum API for options operations.# Declaration: enum RowErrorPolicy :string# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Reader\Options\RowErrorPolicy{# Purpose: Creates the value from mixed.public static function fromMixed(self|string|null $value # Value supplied to the operation. Example: 'value'): self}# Provides the plugin reader adapter class API for plugin operations.# Declaration: final class PluginReaderAdapter implements IterableReaderInterface# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Reader\Plugin\PluginReaderAdapter{# Purpose: Creates a new PluginReaderAdapter instance.public function __construct(ReaderPluginInterface $plugin # Input value for `$plugin` (ReaderPluginInterface).): mixed# Purpose: Iterates over sheet.public function iterateSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): iterable# Purpose: Reads sheet.public function readSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array}# Provides the reader interface interface API for reader operations.# Declaration: interface ReaderInterface# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Reader\ReaderInterface{# Purpose: Reads sheet.abstract public function readSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Sheet index starting at 1, or sheet name when supported by the reader. Example: 1array $options = [] # Configuration options for this operation. Example: []): array}# Instance-scoped reader registry for long-running workers and plugins.# Declaration: final class ReaderRegistry# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Reader\ReaderRegistry{# Purpose: Performs the formats operation.public function formats(): array# Purpose: Performs the has operation.public function has(string $format # Spreadsheet or data format identifier. Example: 'xlsx'): bool# Purpose: Performs the register operation.public function register(string $format, # Spreadsheet or data format identifier. Example: 'xlsx'callable|ReaderInterface $reader # Reader implementation used by the session. Example: static fn ($value) => $value): self# Purpose: Performs the register plugin operation.public function registerPlugin(ReaderPluginInterface $plugin, # Input value for `$plugin` (ReaderPluginInterface).int $priority = 0 # Input value for `$priority` (int). Example: 0): self# Purpose: Performs the resolve operation.public function resolve(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): ReaderInterface# Purpose: Returns a copy configured with built ins.public static function withBuiltIns(): self}# Provides the read session class API for reader operations.# Declaration: final class ReadSession# Package: mnb/mnb-phpexcel# Methods: 61Mnb\PHPExcel\Reader\ReadSession{# Purpose: Creates a new ReadSession instance.public function __construct(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'ReaderInterface $reader, # Reader implementation used by the session.array|ReaderOptions $defaultOptions = [] # Input value for `$defaultOptions` (array|ReaderOptions). Example: []): mixed# Purpose: Detect the most likely source header row before reading data.public function autoDetectHeader(int $sampleRows = 25, # Input value for `$sampleRows` (int). Example: 25float $minimumConfidence = 0.35 # Input value for `$minimumConfidence` (float). Example: 0.35): self# Purpose: Performs the calculated cell operation.public function calculatedCell(string $cell # Worksheet cell reference. Example: 'A1'): mixed# Purpose: Performs the calculated range operation.public function calculatedRange(string $range # Worksheet cell range. Example: 'A1:D100'): array# Purpose: Read one XLSX cell directly by Excel reference, for example A1.public function cell(string $cell, # Worksheet cell reference. Example: 'A1'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Return value, formula, calculated/cached values, rich text, style, comments and hyperlinks for a cell.public function cellDetails(string $cell, # Worksheet cell reference. Example: 'A1'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): CellSnapshot# Purpose: Performs the cells operation.public function cells(array $cells, # Input value for `$cells` (array). Example: []array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the cell style operation.public function cellStyle(string $cell # Worksheet cell reference. Example: 'A1'): array# Purpose: Performs the chunk operation.public function chunk(int $size, # Input value for `$size` (int). Example: 1callable $callback, # Callback invoked during this operation. Example: static fn ($value) => $valuearray $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the chunks operation.public function chunks(int $size, # Input value for `$size` (int). Example: 1array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): \Generator# Purpose: Returns the number of rows.public function countRows(array $options = [] # Configuration options for this operation. Example: []): int# Purpose: Inspect a source sample and return the most likely physical header row.public function detectHeader(array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): HeaderDetection# Purpose: Build an SQL import plan without inserting data.public function dryRunImportToSql(PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string $table, # Database table name. Example: 'imports'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Detect duplicate rows after reading the selected sheet.public function duplicateRows(array $columns, # Columns included in the operation. Example: []array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $duplicateOptions = [] # Input value for `$duplicateOptions` (array). Example: []): array# Purpose: Performs the each row operation.public function eachRow(callable $callback, # Callback invoked during this operation. Example: static fn ($value) => $valuearray $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the extract images operation.public function extractImages(string $directory, # Input value for `$directory` (string). Example: 'value'bool $overwrite = false # Input value for `$overwrite` (bool). Example: false): array# Purpose: Returns the first matching item.public function first(array $options = [] # Configuration options for this operation. Example: []): ?array# Purpose: Use the first non-empty source row as column headers.public function firstNonEmptyRowAsHeader(): self# Purpose: Treat the selected 1-based normalized data row as column headers.public function headerAtDataRow(int $row = 1 # Row value or 1-based row number. Example: 1): self# Purpose: Treat the exact 1-based physical source row as column headers.public function headerAtPhysicalRow(int $row # Row value or 1-based row number. Example: 1): self# Purpose: Performs the images operation.public function images(bool $includeBytes = false # Input value for `$includeBytes` (bool). Example: false): array# Purpose: Imports to sql.public function importToSql(PDO|array|string|null $pdo, # PDO connection used for database operations. Example: []string $table, # Database table name. Example: 'imports'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the inspect operation.public function inspect(): array# Purpose: Limit normalized data rows returned by rows(), eachRow(), chunk(), or first().public function limit(int $rows # Rows supplied for reading, writing, validation, or import. Example: 1): self# Purpose: Performs the mode operation.public function mode(ReadMode|string $mode # Input value for `$mode` (ReadMode|string). Example: 'value'): self# Purpose: Performs the normal operation.public function normal(): self# Purpose: Performs the on progress operation.public function onProgress(callable $callback, # Callback invoked during this operation. Example: static fn ($value) => $valueint $everyRows = 1000 # Input value for `$everyRows` (int). Example: 1000): self# Purpose: Performs the on row error operation.public function onRowError(RowErrorPolicy|string $policy, # Input value for `$policy` (RowErrorPolicy|string). Example: 'value'?callable $handler = null # Handler invoked by the operation. Example: static fn ($value) => $value): self# Purpose: Performs the options operation.public function options(): array# Purpose: Preview rows before validation/import. Usually pass header_row => true.public function previewImport(array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $previewOptions = [] # Input value for `$previewOptions` (array). Example: []): array# Purpose: Performs the project columns operation.public function projectColumns(array $columns, # Columns included in the operation. Example: []bool $compact = true # Input value for `$compact` (bool). Example: true): self# Purpose: Return file, workbook, and selected worksheet protection metadata.public function protection(): array# Purpose: Returns a copy configured for the selected row and column range.public function range(?int $startRow = null, # Input value for `$startRow` (?int).?int $endRow = null, # Input value for `$endRow` (?int).int|string|null $startColumn = null, # Input value for `$startColumn` (int|string|null). Example: 1int|string|null $endColumn = null # Input value for `$endColumn` (int|string|null). Example: 1): self# Purpose: Performs the range styles operation.public function rangeStyles(string $range # Worksheet cell range. Example: 'A1:D100'): array# Purpose: Read a rectangular XLSX range as a two-dimensional row array.public function rangeValues(string $range, # Worksheet cell range. Example: 'A1:D100'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the rich text operation.public function richText(string $cell # Worksheet cell reference. Example: 'A1'): ?RichText# Purpose: Performs the row errors operation.public function rowErrors(): array# Purpose: Iterate normalized rows. CSV and XLSX readers are forward-only here; JSON and XML may buffer their document structure before yielding rows.public function rows(array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): \Generator# Purpose: Performs the row states operation.public function rowStates(array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): \Generator# Purpose: Save selected sheet rows as JSON after normal read normalization.public function saveJson(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $jsonOptions = [] # Input value for `$jsonOptions` (array). Example: []): string# Purpose: Saves structured json.public function saveStructuredJson(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $jsonOptions = [] # Input value for `$jsonOptions` (array). Example: []): string# Purpose: Save structured workbook/sheet output as an XML file.public function saveStructuredXml(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $xmlOptions = [] # Input value for `$xmlOptions` (array). Example: []): string# Purpose: Save selected sheet rows as XML after normal read normalization.public function saveXml(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $xmlOptions = [] # Input value for `$xmlOptions` (array). Example: []): string# Purpose: Performs the select columns operation.public function selectColumns(array $columns # Columns included in the operation. Example: []): self# Purpose: Returns a copy configured for the selected worksheet.public function sheet(int|string $sheetNumber # Worksheet name or 1-based worksheet index. Example: 1): self# Purpose: Return XLSX-only cell metadata for the selected sheet: rich text runs, comments, hyperlinks, and advanced object inventory. CSV/JSON readers return an empty metadata shape.public function sheetMetadata(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the sheet names operation.public function sheetNames(): array# Purpose: Skip normalized data rows after an optional header row.public function skip(int $rows # Rows supplied for reading, writing, validation, or import. Example: 1): self# Purpose: Streams ing.public function streaming(): self# Purpose: Returns the current result as an array.public function toArray(array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): array# Purpose: Convert selected sheet rows to a JSON string after normal read normalization.public function toJson(array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $jsonOptions = [] # Input value for `$jsonOptions` (array). Example: []): string# Purpose: Return a professional workbook-level structure instead of only row arrays.public function toStructuredArray(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Converts the value to structured json.public function toStructuredJson(array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $jsonOptions = [] # Input value for `$jsonOptions` (array). Example: []): string# Purpose: Return selected-sheet structured output.public function toStructuredSheetArray(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Return workbook-level structured output with all sheets.public function toStructuredWorkbookArray(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Return structured workbook/sheet output as an XML string without saving. Use this for API responses, browser output, logs, or assigning XML to a variable.public function toStructuredXml(array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $xmlOptions = [] # Input value for `$xmlOptions` (array). Example: []): string# Purpose: Convert selected sheet rows to an XML string after normal read normalization.public function toXml(array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $xmlOptions = [] # Input value for `$xmlOptions` (array). Example: []): string# Purpose: Validate rows read from the selected sheet.public function validateImport(array $rules, # Input value for `$rules` (array). Example: []array $readOptions = [], # Input value for `$readOptions` (array). Example: []array $validationOptions = [] # Input value for `$validationOptions` (array). Example: []): array# Purpose: Treat the selected 1-based normalized data row as column headers. Empty rows are excluded when skip_empty_rows=true (the default).public function withHeaderRow(int $row = 1 # Row value or 1-based row number. Example: 1): self# Purpose: Returns a copy configured with options.public function withOptions(array|ReaderOptions $options # Configuration options for this operation. Example: []): self# Purpose: Returns a copy configured with out header row.public function withoutHeaderRow(): self}# Provides the in memory shared string provider class API for shared strings operations.# Declaration: final class InMemorySharedStringProvider implements SharedStringProviderInterface# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Reader\SharedStrings\InMemorySharedStringProvider{# Purpose: Creates a new InMemorySharedStringProvider instance.public function __construct(array $strings = [] # Input value for `$strings` (array). Example: []): mixed# Purpose: Closes the active resource and releases related state.public function close(): void# Purpose: Returns the number of matching items.public function count(): int# Purpose: Performs the get operation.public function get(int $index # Zero-based or 1-based index as documented by the method. Example: 1): string# Purpose: Performs the mode operation.public function mode(): string}# Provides the shared string provider interface interface API for shared strings operations.# Declaration: interface SharedStringProviderInterface# Package: mnb/mnb-phpexcel# Methods: 4Mnb\PHPExcel\Reader\SharedStrings\SharedStringProviderInterface{# Purpose: Closes the active resource and releases related state.abstract public function close(): void# Purpose: Returns the number of matching items.abstract public function count(): int# Purpose: Performs the get operation.abstract public function get(int $index # Zero-based or 1-based index as documented by the method. Example: 1): string# Purpose: Performs the mode operation.abstract public function mode(): string}# Provides the cell snapshot class API for state operations.# Declaration: final class CellSnapshot implements \JsonSerializable# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\State\CellSnapshot{# Purpose: Creates a new CellSnapshot instance.public function __construct(string $cell, # Worksheet cell reference. Example: 'A1'$value, # Value supplied to the operation.readonly?string $formula = null, # Input value for `$formula` (readonly?string). Example: 'value'$cachedValue = null, # Input value for `$cachedValue`.$calculatedValue = null, # Input value for `$calculatedValue`.readonly?RichText $richText = null, # Input value for `$richText` (readonly?RichText).array $style = [], # Input value for `$style` (array). Example: []array $comments = [], # Input value for `$comments` (array). Example: []array $hyperlinks = [], # Input value for `$hyperlinks` (array). Example: []array $images = [] # Input value for `$images` (array). Example: []): mixed# Purpose: Performs the json serialize operation.public function jsonSerialize(): array}# Provides the formula result class API for state operations.# Declaration: final class FormulaResult implements \JsonSerializable# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\State\FormulaResult{# Purpose: Creates a new FormulaResult instance.public function __construct(string $formula, # Input value for `$formula` (string). Example: 'value'$cachedValue, # Input value for `$cachedValue`.string $resultType = 'unknown', # Input value for `$resultType` (string). Example: 'unknown'array $metadata = [] # Input value for `$metadata` (array). Example: []): mixed# Purpose: Performs the json serialize operation.public function jsonSerialize(): array}# Provides the header detection class API for state operations.# Declaration: final class HeaderDetection implements \JsonSerializable# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\State\HeaderDetection{# Purpose: Creates a new HeaderDetection instance.public function __construct(int $row, # Row value or 1-based row number. Example: 1float $confidence, # Input value for `$confidence` (float). Example: 1.0array $candidates = [] # Input value for `$candidates` (array). Example: []): mixed# Purpose: Performs the json serialize operation.public function jsonSerialize(): array}# Provides the read progress class API for state operations.# Declaration: final class ReadProgress implements \JsonSerializable# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\State\ReadProgress{# Purpose: Creates a new ReadProgress instance.public function __construct(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'int $sourceRows, # Input value for `$sourceRows` (int). Example: 1int $outputRows, # Input value for `$outputRows` (int). Example: 1int $errorRows, # Input value for `$errorRows` (int). Example: 1float $elapsedSeconds, # Input value for `$elapsedSeconds` (float). Example: 1.0bool $completed = false # Input value for `$completed` (bool). Example: false): mixed# Purpose: Performs the json serialize operation.public function jsonSerialize(): array}# Provides the row state class API for state operations.# Declaration: final class RowState implements \JsonSerializable# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\State\RowState{# Purpose: Creates a new RowState instance.public function __construct(int $sourceRow, # Input value for `$sourceRow` (int). Example: 1int $outputRow, # Input value for `$outputRow` (int). Example: 1int|string $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'array $values, # Values supplied to the operation. Example: []array $errors = [], # Input value for `$errors` (array). Example: []bool $skipped = false # Input value for `$skipped` (bool). Example: false): mixed# Purpose: Performs the json serialize operation.public function jsonSerialize(): array}# Forward-only parser for a standard JSON document whose root value is an array. Each array item is decoded independently, so the complete document is never held in memory.# Declaration: final class StreamingJsonArrayParser# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\StreamingJsonArrayParser{# Purpose: Checks whether top level array.public function isTopLevelArray(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): bool# Purpose: Performs the parse operation.public function parse(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): \Generator}# Provides the xlsx image extractor class API for reader operations.# Declaration: final class XlsxImageExtractor# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Reader\XlsxImageExtractor{# Purpose: Creates a new XlsxImageExtractor instance.public function __construct(readonly?XlsxWorkbookResolver $resolver = null # Input value for `$resolver` (readonly?XlsxWorkbookResolver).): mixed# Purpose: Performs the extract operation.public function extract(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $directory, # Input value for `$directory` (string). Example: 'value'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1bool $overwrite = false # Input value for `$overwrite` (bool). Example: false): array# Purpose: Performs the images operation.public function images(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1bool $includeBytes = false # Input value for `$includeBytes` (bool). Example: false): array}# Provides the xlsx inspector class API for reader operations.# Declaration: final class XlsxInspector# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Reader\XlsxInspector{# Purpose: Creates a new XlsxInspector instance.public function __construct(?XlsxWorkbookResolver $resolver = null # Input value for `$resolver` (?XlsxWorkbookResolver).): mixed# Purpose: Inspect workbook structure without converting the workbook to arrays. status:string, file:string, size_bytes:int, encrypted:bool, sheets:list<array<string,mixed>>, warnings:list<string>, errors:list<string> }.public function inspect(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the sheet names operation.public function sheetNames(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array}# Provides the xlsx metadata extractor class API for reader operations.# Declaration: final class XlsxMetadataExtractor# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\XlsxMetadataExtractor{# Purpose: Creates a new XlsxMetadataExtractor instance.public function __construct(?XlsxWorkbookResolver $resolver = null # Input value for `$resolver` (?XlsxWorkbookResolver).): mixed# Purpose: Extract rich XLSX metadata that is intentionally separate from plain cell values. rich_text:list<array<string,mixed>>, comments:list<array<string,mixed>>, hyperlinks:list<array<string,mixed>>, advanced_objects:array<string,mixed>, summary:array<string,int> }.public function readSheetMetadata(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1 # Worksheet name or 1-based worksheet index. Example: 1): array}# Provides the xlsx protection reader class API for reader operations.# Declaration: final class XlsxProtectionReader# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\XlsxProtectionReader{# Purpose: Creates a new XlsxProtectionReader instance.public function __construct(XlsxWorkbookResolver $resolver = new XlsxWorkbookResolver() # Input value for `$resolver` (XlsxWorkbookResolver). Example: new XlsxWorkbookResolver()): mixed# Purpose: Creates a read session for the supplied source.public function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array}# Lightweight XLSX package information without hydrating worksheet cell rows.# Declaration: final class XlsxQuickInfo# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Reader\XlsxQuickInfo{# Purpose: Creates a new XlsxQuickInfo instance.public function __construct(private?XlsxWorkbookResolver $resolver = null # Input value for `$resolver` (private?XlsxWorkbookResolver).): mixed# Purpose: Return file/package information without loading workbook cells.public function fileInfo(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # password. Example: []): array# Purpose: Return a row count without converting worksheet rows to PHP arrays.public function rowCount(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): int# Purpose: Return row counts for all worksheets without loading cell values.public function rowCounts(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # password, mode, include_hidden. Example: []): array# Purpose: Return one worksheet's information without loading cell values.public function sheetInfo(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # password, accurate_row_count. Example: []): array# Purpose: Return information for every worksheet without loading cell values.public function sheetsInfo(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array}# Provides the xlsx reader class API for reader operations.# Declaration: final class XlsxReader implements IterableReaderInterface# Package: mnb/mnb-phpexcel# Methods: 16Mnb\PHPExcel\Reader\XlsxReader{# Purpose: Creates a new XlsxReader instance.public function __construct(?XlsxWorkbookResolver $resolver = null # Input value for `$resolver` (?XlsxWorkbookResolver).): mixed# Purpose: Performs the calculate cell operation.public function calculateCell(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $cell, # Worksheet cell reference. Example: 'A1'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Performs the calculate range operation.public function calculateRange(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $range, # Worksheet cell range. Example: 'A1:D100'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the extract images operation.public function extractImages(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $directory, # Input value for `$directory` (string). Example: 'value'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1bool $overwrite = false, # Input value for `$overwrite` (bool). Example: falsearray $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the images operation.public function images(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1bool $includeBytes = false, # Input value for `$includeBytes` (bool). Example: falsearray $options = [] # Configuration options for this operation. Example: []): array# Purpose: Iterates over sheet.public function iterateSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): iterable# Purpose: Reads cell.public function readCell(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $cell, # Worksheet cell reference. Example: 'A1'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Reads cell details.public function readCellDetails(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $cell, # Worksheet cell reference. Example: 'A1'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): CellSnapshot# Purpose: Reads cells.public function readCells(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $cells, # Input value for `$cells` (array). Example: []int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Reads cell style.public function readCellStyle(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $cell, # Worksheet cell reference. Example: 'A1'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Reads protection.public function readProtection(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Reads range.public function readRange(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $range, # Worksheet cell range. Example: 'A1:D100'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Reads range styles.public function readRangeStyles(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $range, # Worksheet cell range. Example: 'A1:D100'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Reads rich text cell.public function readRichTextCell(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $cell, # Worksheet cell reference. Example: 'A1'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): ?RichText# Purpose: Reads sheet.public function readSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Read non-tabular XLSX metadata for a sheet: rich text runs, comments, hyperlinks, and advanced object inventory.public function readSheetMetadata(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array}# Provides the xlsx style map class API for reader operations.# Declaration: final class XlsxStyleMap# Package: mnb/mnb-phpexcel# Methods: 8Mnb\PHPExcel\Reader\XlsxStyleMap{# Purpose: Performs the all styles operation.public function allStyles(): array# Purpose: Performs the builtin number format code operation.public static function builtinNumberFormatCode(int $numFmtId # Identifier used by the operation. Example: 1): ?string# Purpose: Creates the value from xml.public static function fromXml(?string $stylesXml # Input value for `$stylesXml` (?string). Example: 'value'): self# Purpose: Checks whether builtin date number format.public static function isBuiltinDateNumberFormat(int $numFmtId # Identifier used by the operation. Example: 1): bool# Purpose: Checks whether date style.public function isDateStyle(?int $styleIndex # Input value for `$styleIndex` (?int).): bool# Purpose: Performs the looks like date format operation.public static function looksLikeDateFormat(string $formatCode # Input value for `$formatCode` (string). Example: 'value'): bool# Purpose: Performs the number format code operation.public function numberFormatCode(?int $styleIndex # Input value for `$styleIndex` (?int).): ?string# Purpose: Performs the style for index operation.public function styleForIndex(?int $styleIndex # Input value for `$styleIndex` (?int).): array}# Provides the xlsx workbook resolver class API for reader operations.# Declaration: final class XlsxWorkbookResolver# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Reader\XlsxWorkbookResolver{# Purpose: Resolves sheet path.public function resolveSheetPath(string $realPath, # Input value for `$realPath` (string). Example: 'value'int|string $sheet # Worksheet name or 1-based worksheet index. Example: 'Sheet1'): string# Purpose: Performs the sheets operation.public function sheets(string $realPath # Input value for `$realPath` (string). Example: 'value'): array}# Secure, forward-only XML row reader with optional schema mapping.# Declaration: final class XmlReader implements IterableReaderInterface# Package: mnb/mnb-phpexcel# Methods: 4Mnb\PHPExcel\Reader\XmlReader{# Purpose: Iterates over sheet.public function iterateSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): iterable# Purpose: Reads sheet.public function readSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int|string $sheet = 1, # Worksheet name or 1-based worksheet index. Example: 1array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Reads workbook.public function readWorkbook(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the sheet names operation.public function sheetNames(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array}# Lightweight streaming XML schema map. It intentionally supports a safe, deterministic subset of XPath: child paths (`customer/name`), row attributes (`@id`), and row text (`text()`).# Declaration: final class XmlSchemaMapping# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Reader\XmlSchemaMapping{# Purpose: Performs the from operation.public static function from(array|self|null $schema, # Input value for `$schema` (array|self|null). Example: []array $fallbackOptions = [] # Input value for `$fallbackOptions` (array). Example: []): ?self# Purpose: Performs the map operation.public function map(array $row, # Row value or 1-based row number. Example: []array $attributes = [], # Input value for `$attributes` (array). Example: []string $rowText = '' # Input value for `$rowText` (string). Example: ''): array# Purpose: Performs the row tag operation.public function rowTag(): string# Purpose: Performs the sheet name attribute operation.public function sheetNameAttribute(): string# Purpose: Performs the sheet tag operation.public function sheetTag(): string}# Standards-compatible ECMA-376 Agile Encryption for OOXML packages.# Declaration: final class AgileXlsxEncryption# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Security\AgileXlsxEncryption{# Purpose: Performs the decrypt operation.public function decrypt(string $container, # Input value for `$container` (string). Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the encrypt operation.public function encrypt(string $package, # Input value for `$package` (string). Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Checks whether encrypted.public function isEncrypted(string $binary # Input value for `$binary` (string). Example: 'value'): bool}# Provides the cell safety scanner class API for security operations.# Declaration: final class CellSafetyScanner# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Security\CellSafetyScanner{# Purpose: Scan array rows before export/import for common cell risks.public function scan(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): array}# Minimal Compound Binary File (OLE/CFB) reader/writer used for encrypted OOXML packages. Supports CFB v3/v4 reading and emits interoperable CFB v3 containers.# Declaration: final class CompoundFile# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Security\CompoundFile{# Purpose: Creates a read session for the supplied source.public static function read(string $binary # Input value for `$binary` (string). Example: 'value'): array# Purpose: Writes the supplied data to the destination.public static function write(array $streams # Input value for `$streams` (array). Example: []): string}# Generates OOXML workbook/worksheet protection credentials and attributes.# Declaration: final class DocumentProtection# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Security\DocumentProtection{# Purpose: Legacy XOR hash retained for older spreadsheet applications.public static function legacyHash(string $password # Password used for protection or encryption. Example: 'secret'): string# Purpose: Performs the sheet attributes operation.public static function sheetAttributes(string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the workbook attributes operation.public static function workbookAttributes(string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): array}# Provides the formula guard class API for security operations.# Declaration: final class FormulaGuard# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Security\FormulaGuard{# Purpose: Validate explicit formulas before XLSX writing.public static function assertSafe(string $formula, # Input value for `$formula` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Performs the risk operation.public static function risk(string $formula, # Input value for `$formula` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): array}# ECMA-376 Standard Encryption (AES-128/SHA-1), retained for broad viewer compatibility.# Declaration: final class StandardXlsxEncryption# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Security\StandardXlsxEncryption{# Purpose: Performs the decrypt operation.public function decrypt(string $container, # Input value for `$container` (string). Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the encrypt operation.public function encrypt(string $package, # Input value for `$package` (string). Example: 'value'string $password # Password used for protection or encryption. Example: 'secret'): string}# Provides the xlsx encryption class API for security operations.# Declaration: final class XlsxEncryption# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Security\XlsxEncryption{# Purpose: Creates a new XlsxEncryption instance.public function __construct(AgileXlsxEncryption $agile = new AgileXlsxEncryption(), # Input value for `$agile` (AgileXlsxEncryption). Example: new AgileXlsxEncryption()StandardXlsxEncryption $standard = new StandardXlsxEncryption() # Input value for `$standard` (StandardXlsxEncryption). Example: new StandardXlsxEncryption()): mixed# Purpose: Decrypts file.public function decryptFile(string $source, # Source input used by the operation. Example: 'value'string $destination, # Destination path or target for the result. Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Decrypts to temporary.public function decryptToTemporary(string $source, # Source input used by the operation. Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Encrypts file.public function encryptFile(string $source, # Source input used by the operation. Example: 'value'string $destination, # Destination path or target for the result. Example: 'value'string $password, # Password used for protection or encryption. Example: 'secret'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Return agile, standard, unknown, or null for an unencrypted file.public function encryptionMode(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): ?string# Purpose: Checks whether encrypted file.public function isEncryptedFile(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): bool}# Lightweight, instance-based entry point for modular installations.# Declaration: final class SpreadsheetManager# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\SpreadsheetManager{# Purpose: Creates a new SpreadsheetManager instance.public function __construct(ReaderRegistry $readers # Input value for `$readers` (ReaderRegistry).): mixed# Purpose: Performs the create operation.public static function create(?ReaderRegistry $readers = null # Input value for `$readers` (?ReaderRegistry).): self# Purpose: Performs the formats operation.public function formats(): array# Purpose: Creates a read session for the supplied source.public function read(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ReadSession# Purpose: Performs the register reader operation.public function registerReader(string $format, # Spreadsheet or data format identifier. Example: 'xlsx'callable|\Mnb\PHPExcel\Reader\ReaderInterface $reader # Reader implementation used by the session. Example: static fn ($value) => $value): self# Purpose: Performs the register reader plugin operation.public function registerReaderPlugin(ReaderPluginInterface $plugin, # Input value for `$plugin` (ReaderPluginInterface).int $priority = 0 # Input value for `$priority` (int). Example: 0): self}# Centralized storage paths for real applications. Keeps temp/manifests/failed uploads out of vendor.# Declaration: final class StorageManager# Package: mnb/mnb-phpexcel# Methods: 7Mnb\PHPExcel\Storage\StorageManager{# Purpose: Performs the configure operation.public static function configure(array $paths = [] # Input value for `$paths` (array). Example: []): array# Purpose: Performs the ensure directories operation.public static function ensureDirectories(): void# Purpose: Performs the failed rows path operation.public static function failedRowsPath(string $name # Name used to identify the target value. Example: 'value'): string# Purpose: Performs the manifest path operation.public static function manifestPath(string $name # Name used to identify the target value. Example: 'value'): string# Purpose: Performs the path operation.public static function path(string $key, # Key used to identify the target value. Example: 'value'string $filename = '' # File name used by the operation. Example: ''): string# Purpose: Performs the paths operation.public static function paths(): array# Purpose: Performs the temp path operation.public static function tempPath(string $name # Name used to identify the target value. Example: 'value'): string}# Provides the advanced workbook capabilities class API for support operations.# Declaration: final class AdvancedWorkbookCapabilities# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Support\AdvancedWorkbookCapabilities{# Purpose: Performs the matrix operation.public static function matrix(): array}# Provides the arr class API for support operations.# Declaration: final class Arr# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Support\Arr{# Purpose: Checks whether assoc.public static function isAssoc(array $row # Row value or 1-based row number. Example: []): bool# Purpose: Performs the string keys operation.public static function stringKeys(array $row # Row value or 1-based row number. Example: []): array}# Provides the atomic file writer class API for support operations.# Declaration: final class AtomicFileWriter# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Support\AtomicFileWriter{# Purpose: Performs the ensure directory for operation.public static function ensureDirectoryFor(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): string# Purpose: Writes string.public static function writeString(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $contents, # Input value for `$contents` (string). Example: 'value'string $errorCode = ErrorCode::FILE_WRITE_FAILED # Input value for `$errorCode` (string). Example: ErrorCode::FILE_WRITE_FAILED): void# Purpose: Writes via temp.public static function writeViaTemp(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'callable $writer, # Writer implementation used by the operation. Example: static fn ($value) => $value?callable $validator = null # Input value for `$validator` (?callable). Example: static fn ($value) => $value): void}# Provides the benchmark suite class API for support operations.# Declaration: final class BenchmarkSuite# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Support\BenchmarkSuite{# Purpose: Performs the plan operation.public static function plan(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Run an internal MNB large writer benchmark. This intentionally benchmarks only the local package; third-party libraries are optional external comparisons.public static function runLargeWriter(int $rows, # Rows supplied for reading, writing, validation, or import. Example: 1int $columns = 10, # Columns included in the operation. Example: 10array $options = [] # Configuration options for this operation. Example: []): array}# Provides the compatibility fixture suite class API for support operations.# Declaration: final class CompatibilityFixtureSuite# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Support\CompatibilityFixtureSuite{# Purpose: Performs the requirements operation.public static function requirements(): array# Purpose: Performs the verify operation.public static function verify(string $fixtureDir, # Input value for `$fixtureDir` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): array}# Provides the coordinate class API for support operations.# Declaration: final class Coordinate# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Support\Coordinate{# Purpose: Performs the column index to name operation.public static function columnIndexToName(int $index # Zero-based or 1-based index as documented by the method. Example: 1): string# Purpose: Performs the column name to index operation.public static function columnNameToIndex(string $name # Name used to identify the target value. Example: 'value'): int# Purpose: Performs the split cell ref operation.public static function splitCellRef(string $cellRef # Input value for `$cellRef` (string). Example: 'value'): array}# CSV dialect presets for Excel-friendly and locale-friendly CSV files.# Declaration: final class CsvDialect# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Support\CsvDialect{# Purpose: Detect the most likely delimiter by comparing field-count consistency across a small sample of non-empty records.public static function detectDelimiter(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'?array $candidates = null, # Input value for `$candidates` (?array). Example: []int $sampleLines = 12, # Input value for `$sampleLines` (int). Example: 12string $enclosure = '"', # Input value for `$enclosure` (string). Example: '"'string $escape = '' # Input value for `$escape` (string). Example: ''): string# Purpose: Performs the resolve operation.public static function resolve(array $options = [] # Configuration options for this operation. Example: []): array}# Resolves database connection details from common application sources without requiring a framework or dotenv dependency.# Declaration: final class DatabaseConfigResolver# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Support\DatabaseConfigResolver{# Purpose: Return all candidate .env/config paths checked during auto discovery.public static function discoveredPaths(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Resolve database configuration from an array, .env file, PHP config file, DSN string, constants, getenv()/$_ENV, or the nearest app .env.public static function resolve(array|string|null $source = null, # Source input used by the operation. Example: []array $overrides = [] # Input value for `$overrides` (array). Example: []): array# Purpose: Performs the summary operation.public static function summary(array $options = [] # Configuration options for this operation. Example: []): array}# Provides the database connection factory class API for support operations.# Declaration: final class DatabaseConnectionFactory# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Support\DatabaseConnectionFactory{# Purpose: Create or return a PDO connection from an existing PDO, .env path, PHP config file, DSN string, config array, constants, or runtime environment variables.public static function make(PDO|array|string|null $source = null, # Source input used by the operation. Example: []array $overrides = [] # Input value for `$overrides` (array). Example: []): PDO}# Provides the database integration suite class API for support operations.# Declaration: final class DatabaseIntegrationSuite# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Support\DatabaseIntegrationSuite{# Purpose: Performs the check operation.public static function check(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the plan operation.public static function plan(array $options = [] # Configuration options for this operation. Example: []): array}# Lightweight character-encoding detector and converter for CSV/text workflows.# Declaration: final class EncodingDetector# Package: mnb/mnb-phpexcel# Methods: 7Mnb\PHPExcel\Support\EncodingDetector{# Purpose: Performs the convert operation.public static function convert(string $value, # Value supplied to the operation. Example: 'value'string $targetEncoding = 'UTF-8', # Input value for `$targetEncoding` (string). Example: 'UTF-8'string $sourceEncoding = 'auto' # Input value for `$sourceEncoding` (string). Example: 'auto'): string# Purpose: Convert a text file to UTF-8 temporary file and return the temp path. The caller should unlink the returned file when done.public static function convertFileToUtf8(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $sourceEncoding = 'auto' # Input value for `$sourceEncoding` (string). Example: 'auto'): string# Purpose: Performs the default candidates operation.public static function defaultCandidates(): array# Purpose: Detect text encoding from a binary sample.public static function detect(string $bytes, # Input value for `$bytes` (string). Example: 'value'?array $candidates = null # Input value for `$candidates` (?array). Example: []): array# Purpose: Detect file encoding from a sample without loading the full file.public static function detectFile(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'int $sampleBytes = 65536, # Input value for `$sampleBytes` (int). Example: 65536?array $candidates = null # Input value for `$candidates` (?array). Example: []): array# Purpose: Checks whether utf16 or32.public static function isUtf16Or32(string $encoding # Text character encoding. Example: 'UTF-8'): bool# Purpose: Normalizes encoding name.public static function normalizeEncodingName(string $encoding # Text character encoding. Example: 'UTF-8'): string}# Provides the environment diagnostics class API for support operations.# Declaration: final class EnvironmentDiagnostics# Package: mnb/mnb-phpexcel# Methods: 3Mnb\PHPExcel\Support\EnvironmentDiagnostics{# Purpose: Return a compact alert payload that applications can show before running XLSX/SQL workflows.public static function alert(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the alert message operation.public static function alertMessage(array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Return a developer-friendly capability report for the current PHP runtime.public static function check(array $options = [] # Configuration options for this operation. Example: []): array}# Provides the error code class API for support operations.# Declaration: final class ErrorCode# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Support\ErrorCode{# Purpose: Performs the category for operation.public static function categoryFor(string $code # Input value for `$code` (string). Example: 'value'): string# Purpose: Performs the safe message for operation.public static function safeMessageFor(string $code # Input value for `$code` (string). Example: 'value'): string}# Provides the error reporter class API for support operations.# Declaration: final class ErrorReporter# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Support\ErrorReporter{# Purpose: Performs the report operation.public static function report(Throwable $throwable, # Input value for `$throwable` (Throwable).bool $debug = false # Input value for `$debug` (bool). Example: false): array# Purpose: Performs the safe operation.public static function safe(Throwable $throwable # Input value for `$throwable` (Throwable).): array}# Provides the file format detector class API for support operations.# Declaration: final class FileFormatDetector# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Support\FileFormatDetector{# Purpose: Detect a supported reader format from an explicit option, extension, and file signature.public static function detect(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): string}# Provides the json array normalizer class API for support operations.# Declaration: final class JsonArrayNormalizer# Package: mnb/mnb-phpexcel# Methods: 4Mnb\PHPExcel\Support\JsonArrayNormalizer{# Purpose: Read JSON from disk and convert it to a workbook array suitable for WorkbookBuilder.public function readWorkbook(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Convert workbook arrays into raw table rows, optionally adding headers for associative rows.public function rowsToTable(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the workbook from decoded operation.public function workbookFromDecoded($decoded, # Input value for `$decoded`.array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Performs the workbook from json string operation.public function workbookFromJsonString(string $json, # Input value for `$json` (string). Example: 'value'array $options = [] # Configuration options for this operation. Example: []): array}# Small locale helper for CSV/array imports where decimal and date formats differ.# Declaration: final class LocaleNormalizer# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Support\LocaleNormalizer{# Purpose: Performs the options operation.public static function options(array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Parse an already-normalized numeric string without silently overflowing PHP integers.public static function parseCanonicalNumber(string $value, # Value supplied to the operation. Example: 'value'array $options = [], # Configuration options for this operation. Example: []bool $integerOnly = false, # Input value for `$integerOnly` (bool). Example: false$originalValue = null, # Value returned when invalid_cast=preserve.bool $preserveLeadingZeros = false # Input value for `$preserveLeadingZeros` (bool). Example: false): mixed# Purpose: Parses date.public static function parseDate($value, # Value supplied to the operation.string $outputFormat = 'Y-m-d', # Input value for `$outputFormat` (string). Example: 'Y-m-d'array $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Parses localized integer.public static function parseLocalizedInteger($value, # Value supplied to the operation.array $options = [] # Configuration options for this operation. Example: []): mixed# Purpose: Parses localized number.public static function parseLocalizedNumber($value, # Value supplied to the operation.array $options = [] # Configuration options for this operation. Example: []): mixed}# Provides the mnb excel exception class API for support operations.# Declaration: class MnbExcelException extends RuntimeException# Package: mnb/mnb-phpexcel# Methods: 8Mnb\PHPExcel\Support\MnbExcelException{# Purpose: Backward-compatible constructor.public function __construct(string $message = '', # Input value for `$message` (string). Example: ''string|int $codeOrErrorCode = ErrorCode::RUNTIME_ERROR, # Input value for `$codeOrErrorCode` (string|int). Example: ErrorCode::RUNTIME_ERRORstring|Throwable|null $categoryOrPrevious = null, # Input value for `$categoryOrPrevious` (string|Throwable|null). Example: 'value'array $context = [], # Input value for `$context` (array). Example: []?Throwable $previous = null, # Input value for `$previous` (?Throwable).?string $safeMessage = null # Input value for `$safeMessage` (?string). Example: 'value'): mixed# Purpose: Performs the category operation.public function category(): string# Purpose: Performs the context operation.public function context(): array# Purpose: Performs the error code operation.public function errorCode(): string# Purpose: Returns error code.public function getErrorCode(): string# Purpose: Performs the safe message operation.public function safeMessage(): string# Purpose: Converts the value to error array.public function toErrorArray(bool $debug = false # Input value for `$debug` (bool). Example: false): array# Purpose: Returns a copy configured with code.public static function withCode(string $message, # Input value for `$message` (string). Example: 'value'string $errorCode, # Input value for `$errorCode` (string). Example: 'value'array $context = [], # Input value for `$context` (array). Example: []?Throwable $previous = null, # Input value for `$previous` (?Throwable).?string $safeMessage = null, # Input value for `$safeMessage` (?string). Example: 'value'?string $category = null # Input value for `$category` (?string). Example: 'value'): self}# Lightweight package-readiness checks for the public Composer release. This intentionally avoids network access and does not require vendor/.# Declaration: final class ReleaseReadiness# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Support\ReleaseReadiness{# Purpose: Performs the check operation.public static function check(string $root # Input value for `$root` (string). Example: 'value'): array}# Produces valid, unique Excel worksheet names.# Declaration: final class SheetNameAllocator# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Support\SheetNameAllocator{# Purpose: Performs the allocate operation.public function allocate(string $name # Name used to identify the target value. Example: 'value'): string# Purpose: Performs the sanitize operation.public static function sanitize(string $name # Name used to identify the target value. Example: 'value'): string}# Provides the value sanitizer class API for support operations.# Declaration: final class ValueSanitizer# Package: mnb/mnb-phpexcel# Methods: 10Mnb\PHPExcel\Support\ValueSanitizer{# Purpose: Performs the contains invalid xml characters operation.public static function containsInvalidXmlCharacters(string $value # Value supplied to the operation. Example: 'value'): bool# Purpose: Performs the escape formula like text operation.public static function escapeFormulaLikeText($value # Value supplied to the operation.): mixed# Purpose: Checks whether formula like text.public static function isFormulaLikeText(string $value # Value supplied to the operation. Example: 'value'): bool# Purpose: Checks whether large integer string.public static function isLargeIntegerString(string $value, # Value supplied to the operation. Example: 'value'int $maxDigits = 15 # Input value for `$maxDigits` (int). Example: 15): bool# Purpose: Normalizes scalar.public static function normalizeScalar($value # Value supplied to the operation.): string|int|float|bool|null|CellValue# Purpose: Performs the sanitize cell text operation.public static function sanitizeCellText(string $value, # Value supplied to the operation. Example: 'value'array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the sanitize formula like text operation.public static function sanitizeFormulaLikeText($value, # Value supplied to the operation.string $policy = 'escape' # Input value for `$policy` (string). Example: 'escape'): mixed# Purpose: Performs the strip invalid xml characters operation.public static function stripInvalidXmlCharacters(string $value # Value supplied to the operation. Example: 'value'): string# Purpose: Performs the substring operation.public static function substring(string $value, # Value supplied to the operation. Example: 'value'int $start, # Input value for `$start` (int). Example: 1int $length # Maximum length or number of items. Example: 1): string# Purpose: Performs the text length operation.public static function textLength(string $value # Value supplied to the operation. Example: 'value'): int}# Provides the xlsx compatibility verifier class API for support operations.# Declaration: final class XlsxCompatibilityVerifier# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Support\XlsxCompatibilityVerifier{# Purpose: Verify generated and optional external XLSX fixtures with the integrity validator.public function verify(array $fixturePaths = [], # Input value for `$fixturePaths` (array). Example: []array $options = [] # Configuration options for this operation. Example: []): array}# Provides the xlsx integrity validator class API for support operations.# Declaration: final class XlsxIntegrityValidator# Package: mnb/mnb-phpexcel# Methods: 2Mnb\PHPExcel\Support\XlsxIntegrityValidator{# Purpose: Throw when validation fails. Intended for save-time protection.public function assertValid(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Validate an XLSX package for the corruption causes that most often trigger Excel's "We found a problem with some content" repair dialog.public function validate(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array}# XMLReader-compatible adapter with a native streaming path and pure-PHP fallback.# Declaration: final class XmlReader# Package: mnb/mnb-phpexcel# Methods: 11Mnb\PHPExcel\Support\Xml\XmlReader{# Purpose: Creates a new XmlReader instance.public function __construct(): mixed# Purpose: Closes the active resource and releases related state.public function close(): bool# Purpose: Returns attribute.public function getAttribute(string $name # Name used to identify the target value. Example: 'value'): ?string# Purpose: Performs the move to element operation.public function moveToElement(): bool# Purpose: Performs the move to first attribute operation.public function moveToFirstAttribute(): bool# Purpose: Performs the move to next attribute operation.public function moveToNextAttribute(): bool# Purpose: Performs the native available operation.public static function nativeAvailable(): bool# Purpose: Performs the open operation.public function open(string $uri, # URI used by the operation. Example: 'https://example.com/resource'?string $encoding = null, # Text character encoding. Example: 'UTF-8'int $flags = 0 # Input value for `$flags` (int). Example: 0): bool# Purpose: Creates a read session for the supplied source.public function read(): bool# Purpose: Reads outer xml.public function readOuterXml(): string# Purpose: Performs the xml operation.public function XML(string $source, # Source input used by the operation. Example: 'value'?string $encoding = null, # Text character encoding. Example: 'UTF-8'int $flags = 0 # Input value for `$flags` (int). Example: 0): bool}# ZipArchive-compatible adapter. It delegates to ext-zip when available and falls back to a pure-PHP ZIP reader/writer for stored and deflated entries.# Declaration: final class ZipArchive# Package: mnb/mnb-phpexcel# Methods: 11Mnb\PHPExcel\Support\Zip\ZipArchive{# Purpose: Adds file.public function addFile(string $filepath, # Path to the workbook or data file. Example: __DIR__ . '/workbook.xlsx'string $entryname = '' # Input value for `$entryname` (string). Example: ''): bool# Purpose: Adds from string.public function addFromString(string $name, # Name used to identify the target value. Example: 'value'string $content # Input value for `$content` (string). Example: 'value'): bool# Purpose: Closes the active resource and releases related state.public function close(): bool# Purpose: Returns from name.public function getFromName(string $name # Name used to identify the target value. Example: 'value'): string|false# Purpose: Returns name index.public function getNameIndex(int $index, # Zero-based or 1-based index as documented by the method. Example: 1int $flags = 0 # Input value for `$flags` (int). Example: 0): string|false# Purpose: Returns stream.public function getStream(string $name # Name used to identify the target value. Example: 'value'): resource|false# Purpose: Performs the locate name operation.public function locateName(string $name, # Name used to identify the target value. Example: 'value'int $flags = 0 # Input value for `$flags` (int). Example: 0): int|false# Purpose: Performs the native available operation.public static function nativeAvailable(): bool# Purpose: Performs the open operation.public function open(string $filename, # File name used by the operation. Example: 'workbook.xlsx'int $flags = 0 # Input value for `$flags` (int). Example: 0): bool|int# Purpose: Performs the stat index operation.public function statIndex(int $index, # Zero-based or 1-based index as documented by the method. Example: 1int $flags = 0 # Input value for `$flags` (int). Example: 0): array|false# Purpose: Performs the stat name operation.public function statName(string $name, # Name used to identify the target value. Example: 'value'int $flags = 0 # Input value for `$flags` (int). Example: 0): array|false}# Provides the array validator class API for validation operations.# Declaration: final class ArrayValidator# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Validation\ArrayValidator{# Purpose: Validates the supplied input and returns the validation result.public function validate(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $rules, # Input value for `$rules` (array). Example: []array $options = [] # Configuration options for this operation. Example: []): array}# Provides the custom validator registry class API for validation operations.# Declaration: final class CustomValidatorRegistry# Package: mnb/mnb-phpexcel# Methods: 6Mnb\PHPExcel\Validation\CustomValidatorRegistry{# Purpose: Performs the check operation.public static function check(string $column, # Column name, letter, or index. Example: 'A'$value, # Value supplied to the operation.string $rule, # Input value for `$rule` (string). Example: 'value'array $row, # Row value or 1-based row number. Example: []array $rows, # Rows supplied for reading, writing, validation, or import. Example: []?int $rowNumber # Input value for `$rowNumber` (?int).): ?string# Purpose: Performs the clear operation.public static function clear(): void# Purpose: Performs the has operation.public static function has(string $rule # Input value for `$rule` (string). Example: 'value'): bool# Purpose: Performs the names operation.public static function names(): array# Purpose: Performs the parse operation.public static function parse(string $rule # Input value for `$rule` (string). Example: 'value'): array# Purpose: Performs the register operation.public static function register(string $name, # Name used to identify the target value. Example: 'value'callable $callback # Callback invoked during this operation. Example: static fn ($value) => $value): void}# Provides the csv writer class API for writer operations.# Declaration: final class CsvWriter# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Writer\CsvWriter{# Purpose: Writes the supplied data to the destination.public function write(WorksheetData $sheet, # Worksheet name or 1-based worksheet index. Example: 'Sheet1'string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void}# Provides the json writer class API for writer operations.# Declaration: final class JsonWriter# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Writer\JsonWriter{# Purpose: Encode any JSON-safe payload and return the JSON string.public function payloadToString($payload, # Input value for `$payload`.array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the rows to string operation.public function rowsToString(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the workbook to string operation.public function workbookToString(WorkbookData $workbook, # Input value for `$workbook` (WorkbookData).array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Writes rows.public function writeRows(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Writes workbook.public function writeWorkbook(WorkbookData $workbook, # Input value for `$workbook` (WorkbookData).string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void}# Provides the xlsx writer class API for writer operations.# Declaration: final class XlsxWriter# Package: mnb/mnb-phpexcel# Methods: 1Mnb\PHPExcel\Writer\XlsxWriter{# Purpose: Writes the supplied data to the destination.public function write(WorkbookData $workbook, # Input value for `$workbook` (WorkbookData).string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): void}# Provides the xml writer class API for writer operations.# Declaration: final class XmlWriter# Package: mnb/mnb-phpexcel# Methods: 5Mnb\PHPExcel\Writer\XmlWriter{# Purpose: Encode any XML-safe payload and return the XML string.public function payloadToString($payload, # Input value for `$payload`.array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the rows to string operation.public function rowsToString(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Performs the workbook to string operation.public function workbookToString(WorkbookData $workbook, # Input value for `$workbook` (WorkbookData).array $options = [] # Configuration options for this operation. Example: []): string# Purpose: Writes rows.public function writeRows(array $rows, # Rows supplied for reading, writing, validation, or import. Example: []string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Writes workbook.public function writeWorkbook(WorkbookData $workbook, # Input value for `$workbook` (WorkbookData).string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): void}No matching API found.Try a class name, method, parameter, or return type.
Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.
Open an issue