DB + XLSX classes and methods.
Browse this library and the shared dependency classes returned by its public API. Package ownership remains visible beside each class.
Updated
# 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-database-xlsx# 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}# Provides the database target interface interface API for contracts operations.# Declaration: interface DatabaseTargetInterface# Package: mnb/mnb-phpexcel-database# 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 domain import preset class API for domain operations.# Declaration: final class DomainImportPreset# Package: mnb/mnb-phpexcel-database# 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-database# 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-database# 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}# Provides the domain importer class API for import operations.# Declaration: final class DomainImporter# Package: mnb/mnb-phpexcel-database# 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-database# 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-database# 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}# Writes failed large-import rows without keeping all failures in memory.# Declaration: final class LargeFailedRowsCsvWriter# Package: mnb/mnb-phpexcel-database# 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-database# 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-database# 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}# Resolves database connection details from common application sources without requiring a framework or dotenv dependency.# Declaration: final class DatabaseConfigResolver# Package: mnb/mnb-phpexcel-database# 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-database# 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-database# 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}# Provides the upload safety validator class API for application operations.# Declaration: final class UploadSafetyValidator# Package: mnb/mnb-phpexcel-xlsx# 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}# Provides the xlsx class API for format operations.# Declaration: final class Xlsx# Package: mnb/mnb-phpexcel-xlsx# Methods: 13Mnb\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 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: 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}# Converts XLSX preflight metrics into a safe import strategy.# Declaration: final class ImportMethodAdvisor# Package: mnb/mnb-phpexcel-xlsx# 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}# Safely inspects XLSX size/shape without loading worksheet rows into PHP arrays.# Declaration: final class LargeExcelPreflightAnalyzer# Package: mnb/mnb-phpexcel-xlsx# 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}# Shared strings cache for streaming XLSX import.# Declaration: final class LargeSharedStringCache implements SharedStringProviderInterface# Package: mnb/mnb-phpexcel-xlsx# 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-xlsx# 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-xlsx# 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-xlsx# 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-xlsx# 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 formula evaluator factory class API for formula operations.# Declaration: final class FormulaEvaluatorFactory# Package: mnb/mnb-phpexcel-xlsx# Methods: 1Mnb\PHPExcel\Reader\Formula\FormulaEvaluatorFactory{# Purpose: Performs the create operation.public static function create(bool $preferNative = true # Input value for `$preferNative` (bool). Example: true): FormulaEvaluatorInterface}# Provides the formula evaluator interface interface API for formula operations.# Declaration: interface FormulaEvaluatorInterface# Package: mnb/mnb-phpexcel-xlsx# 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-xlsx# 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-xlsx# 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-xlsx# 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 merged cell map class API for reader operations.# Declaration: final class MergedCellMap# Package: mnb/mnb-phpexcel-xlsx# 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}# Provides the in memory shared string provider class API for shared strings operations.# Declaration: final class InMemorySharedStringProvider implements SharedStringProviderInterface# Package: mnb/mnb-phpexcel-xlsx# 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-xlsx# 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 xlsx image extractor class API for reader operations.# Declaration: final class XlsxImageExtractor# Package: mnb/mnb-phpexcel-xlsx# 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-xlsx# Methods: 4Mnb\PHPExcel\Reader\XlsxInspector{# Purpose: Creates a new XlsxInspector instance.public function __construct(?XlsxWorkbookResolver $resolver = null # Input value for `$resolver` (?XlsxWorkbookResolver).): mixed# Purpose: Performs the active sheet operation.public function activeSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array# Purpose: Inspect workbook structure without converting the workbook to arrays. status:string, file:string, size_bytes:int, encrypted:bool, sheets:list<array<string,mixed>>, active_sheet:array{index:int,name:string}|null, 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-xlsx# 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-xlsx# 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-xlsx# 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 AdvancedReaderInterface, ActiveSheetReaderInterface# Package: mnb/mnb-phpexcel-xlsx# Methods: 20Mnb\PHPExcel\Reader\XlsxReader{# Purpose: Creates a new XlsxReader instance.public function __construct(?XlsxWorkbookResolver $resolver = null # Input value for `$resolver` (?XlsxWorkbookResolver).): mixed# Purpose: Performs the active sheet operation.public function activeSheet(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 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 format operation.public function format(): string# 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: Performs the inspect operation.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: 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# 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 style map class API for reader operations.# Declaration: final class XlsxStyleMap# Package: mnb/mnb-phpexcel-xlsx# 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-xlsx# Methods: 3Mnb\PHPExcel\Reader\XlsxWorkbookResolver{# Purpose: Performs the active sheet operation.public function activeSheet(string $realPath # Input value for `$realPath` (string). Example: 'value'): array# 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}# Standards-compatible ECMA-376 Agile Encryption for OOXML packages.# Declaration: final class AgileXlsxEncryption# Package: mnb/mnb-phpexcel-xlsx# 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-xlsx# 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-xlsx# 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-xlsx# 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-xlsx# 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-xlsx# 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-xlsx# 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}# Provides the advanced workbook capabilities class API for support operations.# Declaration: final class AdvancedWorkbookCapabilities# Package: mnb/mnb-phpexcel-xlsx# Methods: 1Mnb\PHPExcel\Support\AdvancedWorkbookCapabilities{# Purpose: Performs the matrix operation.public static function matrix(): array}# Provides the compatibility fixture suite class API for support operations.# Declaration: final class CompatibilityFixtureSuite# Package: mnb/mnb-phpexcel-xlsx# 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}# Internal native fixture builder used by the package compatibility verifier.# Declaration: final class XlsxCompatibilityFixtureFactory# Package: mnb/mnb-phpexcel-xlsx# Methods: 4Mnb\PHPExcel\Support\XlsxCompatibilityFixtureFactory{# Purpose: Performs the basic operation.public function basic(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): void# Purpose: Performs the comments hyperlinks operation.public function commentsHyperlinks(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): void# Purpose: Performs the formulas styles merged cells operation.public function formulasStylesMergedCells(string $path # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'): void# Purpose: Performs the preserved advanced objects operation.public function preservedAdvancedObjects(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'string $template # Input value for `$template` (string). Example: 'value'): void}# Provides the xlsx compatibility verifier class API for support operations.# Declaration: final class XlsxCompatibilityVerifier# Package: mnb/mnb-phpexcel-xlsx# 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-xlsx# 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}# Builds XLSX import templates without depending on the application facade.# Declaration: final class XlsxImportTemplateFactory# Package: mnb/mnb-phpexcel-xlsx# Methods: 1Mnb\PHPExcel\Template\XlsxImportTemplateFactory{# Purpose: Performs the create operation.public function create(array $columns, # Columns included in the operation. Example: []array $options = [] # Configuration options for this operation. Example: []): WorkbookData}# Provides the xlsx writer class API for writer operations.# Declaration: final class XlsxWriter# Package: mnb/mnb-phpexcel-xlsx# 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}# Optional logger bridge. Accepts PSR-3-like objects or callables.# Declaration: final class LoggerBridge# Package: mnb/mnb-phpexcel-core# 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}# Ordered row transformations for application imports.# Declaration: final class RowTransformerPipeline# Package: mnb/mnb-phpexcel-core# 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 reader plugin interface interface API for contracts operations.# Declaration: interface ReaderPluginInterface# Package: mnb/mnb-phpexcel-core# 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-core# 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-core# 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-core# 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-core# 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 data class API for core operations.# Declaration: final class WorkbookData# Package: mnb/mnb-phpexcel-core# 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-core# 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-core# 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}# Tiny framework-neutral event dispatcher. Listeners are process-local and optional.# Declaration: final class EventDispatcher# Package: mnb/mnb-phpexcel-core# 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}# Optional capability for formats that expose the workbook's active worksheet.# Declaration: interface ActiveSheetReaderInterface extends ReaderInterface# Package: mnb/mnb-phpexcel-core# Methods: 1Mnb\PHPExcel\Reader\ActiveSheetReaderInterface{# Purpose: Return the active worksheet using a 1-based index.abstract public function activeSheet(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $options = [] # Configuration options for this operation. Example: []): array}# Optional advanced workbook capability used by XLSX and future rich formats. Core depends only on this contract; concrete format packages provide the implementation.# Declaration: interface AdvancedReaderInterface extends IterableReaderInterface, FormatAwareReaderInterface, SheetNamesReaderInterface, InspectableReaderInterface# Package: mnb/mnb-phpexcel-core# Methods: 13Mnb\PHPExcel\Reader\AdvancedReaderInterface{# Purpose: Performs the calculate cell operation.abstract 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.abstract 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.abstract 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.abstract 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: Reads cell.abstract 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.abstract 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.abstract 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.abstract 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.abstract 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.abstract 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.abstract 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.abstract 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 metadata.abstract 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}# Source-level projection used before row normalization and header mapping.# Declaration: final class ColumnProjection# Package: mnb/mnb-phpexcel-core# 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}# Optional capability exposing the normalized format name handled by a reader.# Declaration: interface FormatAwareReaderInterface extends ReaderInterface# Package: mnb/mnb-phpexcel-core# Methods: 1Mnb\PHPExcel\Reader\FormatAwareReaderInterface{# Purpose: Performs the format operation.abstract public function format(): string}# Provides the header detector class API for reader operations.# Declaration: final class HeaderDetector# Package: mnb/mnb-phpexcel-core# 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 capability for format-specific workbook inspection.# Declaration: interface InspectableReaderInterface extends ReaderInterface# Package: mnb/mnb-phpexcel-core# Methods: 1Mnb\PHPExcel\Reader\InspectableReaderInterface{# Purpose: Performs the inspect operation.abstract 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}# Optional reader contract for forward-only row iteration.# Declaration: interface IterableReaderInterface extends ReaderInterface# Package: mnb/mnb-phpexcel-core# 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}# Immutable, typed read configuration.# Declaration: final class ReaderOptions# Package: mnb/mnb-phpexcel-core# 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-core# 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-core# 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-core# 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-core# 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-core# 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-core# Methods: 75Mnb\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: Select the workbook's active worksheet.public function activeSheet(): self# Purpose: Return the active worksheet number using the library's 1-based indexing.public function activeSheetIndex(): int# Purpose: Performs the active sheet info operation.public function activeSheetInfo(): array# Purpose: Performs the active sheet name operation.public function activeSheetName(): string# Purpose: Require at least one normalized data row and keep the session fluent.public function assertHasRows(array|ReaderOptions $options = [], # Configuration options for this operation. Example: []?string $message = null # Input value for `$message` (?string). Example: 'value'): self# Throws: EmptyWorksheetException# 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|ReaderOptions $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|ReaderOptions $options = [] # Configuration options for this operation. Example: []): ?array# Purpose: Use the first non-empty source row as column headers.public function firstNonEmptyRowAsHeader(): self# Purpose: Return true when at least one normalized data row remains after all current options.public function hasRows(array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): bool# Purpose: Return true when a 1-based worksheet number or worksheet name exists.public function hasSheet(int|string|null $sheet # Worksheet name or 1-based worksheet index. Example: 'Sheet1'): bool# 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: Return true when zero normalized data rows remain after all current options.public function isEmpty(array|ReaderOptions $options = [] # Configuration options for this operation. Example: []): bool# 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: Alias for assertHasRows().public function requireRows(array|ReaderOptions $options = [], # Configuration options for this operation. Example: []?string $message = null # Input value for `$message` (?string). Example: 'value'): self# 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: Alias for sheetOrActive().public function selectSheetOrActive(int|string|null $sheet = null # Worksheet name or 1-based worksheet index. Example: 'Sheet1'): self# Purpose: Returns a copy configured for the selected worksheet.public function sheet(int|string|null $sheetNumber = null # Worksheet name or 1-based worksheet index. Example: 1): self# Purpose: Alias for hasSheet() for discoverable conditional-selection code.public function sheetExists(int|string|null $sheet # Worksheet name or 1-based worksheet index. Example: 'Sheet1'): bool# Purpose: Return a selected session when the worksheet exists, otherwise null.public function sheetIfExists(int|string|null $sheet # Worksheet name or 1-based worksheet index. Example: 'Sheet1'): ?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: Select an optional worksheet value, falling back to the workbook's active worksheet when the value is null or an empty string.public function sheetOrActive(int|string|null $sheet = null # Worksheet name or 1-based worksheet index. Example: 'Sheet1'): self# 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: Alias for activeSheet() when used as a fluent selection operation.public function useActiveSheet(): self# 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}# Optional capability for formats that can expose workbook sheet names.# Declaration: interface SheetNamesReaderInterface extends ReaderInterface# Package: mnb/mnb-phpexcel-core# Methods: 1Mnb\PHPExcel\Reader\SheetNamesReaderInterface{# Purpose: Performs the sheet names operation.abstract 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 cell snapshot class API for state operations.# Declaration: final class CellSnapshot implements \JsonSerializable# Package: mnb/mnb-phpexcel-core# 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-core# 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-core# 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-core# 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-core# 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}# Native XLS capability contract retained as a format-specific marker.# Declaration: interface XlsReaderInterface extends IterableReaderInterface, FormatAwareReaderInterface, SheetNamesReaderInterface# Package: mnb/mnb-phpexcel-core# Methods: 0Mnb\PHPExcel\Reader\XlsReaderInterface{# This interface declares no public methods.}# Lightweight, instance-based entry point for modular installations.# Declaration: final class SpreadsheetManager# Package: mnb/mnb-phpexcel-core# 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}# Provides the arr class API for support operations.# Declaration: final class Arr# Package: mnb/mnb-phpexcel-core# 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-core# 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 coordinate class API for support operations.# Declaration: final class Coordinate# Package: mnb/mnb-phpexcel-core# 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}# Raised when a caller explicitly requires at least one normalized data row.# Declaration: final class EmptyWorksheetException extends MnbExcelException# Package: mnb/mnb-phpexcel-core# Methods: 1Mnb\PHPExcel\Support\EmptyWorksheetException{# Purpose: Performs the for sheet operation.public static function forSheet(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'array $options = [], # Configuration options for this operation. Example: []?string $customMessage = null # Input value for `$customMessage` (?string). Example: 'value'): self}# Provides the environment diagnostics class API for support operations.# Declaration: final class EnvironmentDiagnostics# Package: mnb/mnb-phpexcel-core# 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-core# 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-core# 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-core# 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}# Small locale helper for CSV/array imports where decimal and date formats differ.# Declaration: final class LocaleNormalizer# Package: mnb/mnb-phpexcel-core# 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}# Optional global exception renderer for applications that want clean MNB PHPExcel errors without PHP's uncaught-exception stack trace.# Declaration: final class MnbExcelErrorHandler# Package: mnb/mnb-phpexcel-core# Methods: 6Mnb\PHPExcel\Support\MnbExcelErrorHandler{# Purpose: Performs the handle operation.public static function handle(Throwable $throwable # Input value for `$throwable` (Throwable).): void# Purpose: Checks whether registered.public static function isRegistered(): bool# Purpose: Register a clean global exception handler.public static function register(array $options = [] # Configuration options for this operation. Example: []): void# Purpose: Register the handler with actionable developer messages enabled.public static function registerDeveloperMode(string $format = 'auto', # Spreadsheet or data format identifier. Example: 'auto'?callable $renderer = null # Input value for `$renderer` (?callable). Example: static fn ($value) => $value): void# Purpose: Render an exception without registering or terminating the process.public static function render(Throwable $throwable, # Input value for `$throwable` (Throwable).bool $debug = false, # Input value for `$debug` (bool). Example: falsestring $format = 'auto' # Spreadsheet or data format identifier. Example: 'auto'): string# Purpose: Restore the exception handler that was active before registration.public static function unregister(): void}# Provides the mnb excel exception class API for support operations.# Declaration: class MnbExcelException extends RuntimeException# Package: mnb/mnb-phpexcel-core# 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}# Produces valid, unique Excel worksheet names.# Declaration: final class SheetNameAllocator# Package: mnb/mnb-phpexcel-core# 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}# Developer-facing worksheet selection error with actionable context.# Declaration: final class SheetSelectionException extends MnbExcelException# Package: mnb/mnb-phpexcel-core# Methods: 5Mnb\PHPExcel\Support\SheetSelectionException{# Purpose: Performs the ambiguous name operation.public static function ambiguousName(string $requested, # Input value for `$requested` (string). Example: 'value'string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $availableSheets = [] # Input value for `$availableSheets` (array). Example: []): self# Purpose: Performs the empty name operation.public static function emptyName(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $availableSheets = [] # Input value for `$availableSheets` (array). Example: []): self# Purpose: Performs the invalid index operation.public static function invalidIndex(int $requested, # Input value for `$requested` (int). Example: 1string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $availableSheets = [] # Input value for `$availableSheets` (array). Example: []): self# Purpose: Performs the missing operation.public static function missing(string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $availableSheets = [] # Input value for `$availableSheets` (array). Example: []): self# Purpose: Performs the not found operation.public static function notFound(int|string $requested, # Input value for `$requested` (int|string). Example: 1string $path, # Path to the source or destination file. Example: __DIR__ . '/workbook.xlsx'array $availableSheets = [] # Input value for `$availableSheets` (array). Example: []): self}# Provides the value sanitizer class API for support operations.# Declaration: final class ValueSanitizer# Package: mnb/mnb-phpexcel-core# 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}# XMLReader-compatible adapter with a native streaming path and pure-PHP fallback.# Declaration: final class XmlReader# Package: mnb/mnb-phpexcel-core# 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-core# 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-core# 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-core# 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}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