PHPackages                             phpsoftbox/spreadsheet-parser - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. phpsoftbox/spreadsheet-parser

ActiveLibrary[Utility & Helpers](/categories/utility)

phpsoftbox/spreadsheet-parser
=============================

Tabular file import component for the PhpSoftBox framework

04↓100%PHP

Since May 15Pushed 3w agoCompare

[ Source](https://github.com/phpsoftbox/spreadsheet-parser)[ Packagist](https://packagist.org/packages/phpsoftbox/spreadsheet-parser)[ RSS](/packages/phpsoftbox-spreadsheet-parser/feed)WikiDiscussions master Synced 1w ago

READMEChangelogDependenciesVersions (1)Used By (0)

PhpSoftBox SpreadsheetParser
============================

[](#phpsoftbox-spreadsheetparser)

`SpreadsheetParser` — компонент импорта табличных файлов `CSV/XLSX` для PhpSoftBox.

Возможности
-----------

[](#возможности)

- `parse(...)` по definition с явным выбором драйвера (`CSV`/`XLSX`);
- в `parse(...)` тип не определяется автоматически: драйвер задаётся definition;
- источник импорта как путь к файлу или сырой контент;
- чтение CSV/XLSX;
- выбор листа Excel (по умолчанию первый, по индексу, по имени);
- определение заголовков и маппинг строк в ассоциативные массивы;
- пропуск пустых строк;
- проверка обязательных колонок;
- валидация строк через `ApiSchema`/`Validator`;
- ошибки по строкам;
- лимиты на размер файла, число строк и колонок;
- поддержка CSV кодировок `UTF-8`, `Windows-1251`, автоопределение;
- безопасное чтение XLSX без выполнения формул;
- логирование через `Psr\Log\LoggerInterface`.

Быстрый старт (definition API)
------------------------------

[](#быстрый-старт-definition-api)

```
use PhpSoftBox\SpreadsheetParser\AbstractImportDefinition;
use PhpSoftBox\SpreadsheetParser\CsvOptions;
use PhpSoftBox\SpreadsheetParser\ImportDriver;
use PhpSoftBox\SpreadsheetParser\ImportOptions;
use PhpSoftBox\SpreadsheetParser\ImportSource;
use PhpSoftBox\SpreadsheetParser\RowMapResult;
use PhpSoftBox\SpreadsheetParser\SpreadsheetParser;

$definition = new class extends AbstractImportDefinition {
    public function driver(): ImportDriver
    {
        return ImportDriver::CSV;
    }

    public function options(): ImportOptions
    {
        return new ImportOptions(
            csv: new CsvOptions(delimiters: [';', ',']),
            requiredColumns: ['email', 'name'],
        );
    }

    public function mapRow(array $row, int $lineNumber): RowMapResult
    {
        return RowMapResult::ok([
            'email' => (string) ($row['email'] ?? ''),
            'name' => (string) ($row['name'] ?? ''),
        ]);
    }
};

$parser = new SpreadsheetParser(logger: $logger);
$result = $parser->parse(ImportSource::fromPath('/path/to/users.csv'), $definition);
```

Пример: headerless CSV
----------------------

[](#пример-headerless-csv)

```
public function allowHeaderless(): bool
{
    return true;
}

public function mapRow(array $row, int $lineNumber): RowMapResult
{
    $value = trim((string) ($row['column_1'] ?? ''));
    return $value === ''
        ? RowMapResult::error('Строка не содержит значения.', 'raw_value')
        : RowMapResult::ok(['raw_value' => $value, 'line_number' => $lineNumber]);
}
```

Если `allowHeaderless()` возвращает `true`, первая непустая строка считается данными, а заголовки генерируются автоматически (`column_1`, `column_2`, ...).

Пример: импорт из контента
--------------------------

[](#пример-импорт-из-контента)

```
$content = "email;name\nuser@example.com;Ivan\n";
$result = $parser->parse(ImportSource::fromContent($content, 'users.csv'), $definition);
```

Оглавление
----------

[](#оглавление)

- [Документация](docs/index.md)
- [Quick Start](docs/02-quick-start.md)
- [Definitions](docs/08-definitions.md)
- [CSV](docs/03-csv.md)
- [XLSX](docs/04-xlsx.md)
- [Validation](docs/05-validation.md)
- [Limits & Errors](docs/06-limits-and-errors.md)
- [Logging](docs/07-logging.md)

###  Health Score

21

—

LowBetter than 18% of packages

Maintenance62

Regular maintenance activity

Popularity4

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity11

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/0279d150240c97d210034878b0467462246dc14d29b5618157ff6a8be49a50e3?d=identicon)[inspector-who](/maintainers/inspector-who)

---

Top Contributors

[![inspector-who](https://avatars.githubusercontent.com/u/6973963?v=4)](https://github.com/inspector-who "inspector-who (1 commits)")

### Embed Badge

![Health badge](/badges/phpsoftbox-spreadsheet-parser/health.svg)

```
[![Health](https://phpackages.com/badges/phpsoftbox-spreadsheet-parser/health.svg)](https://phpackages.com/packages/phpsoftbox-spreadsheet-parser)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)