rap2hpoutre/fast-excel

rightToLeft()

XLSX exports can now open as proper right-to-left sheets. Column order, scroll direction and the grid all run right to left, which is what Arabic business documents expect.

(new FastExcel($report))->rightToLeft()->export('report.xlsx');

Multi-sheet exports are covered too: every sheet in a SheetCollection gets the setting, not just the first. Pass rightToLeft(false) to turn it back off. CSV and ODS ignore it, since neither format has an equivalent.

Thanks to @moemadeldin for this one. He opened #420 explaining why configureWriterUsing() couldn't reach the setting (the sheet doesn't exist yet when that hook runs), then sent #421 with the fix and tests covering both the single-sheet and multi-sheet paths. The issue write-up did half the work.

withSheetContext()

importSheets() can now pass the sheet name to your callback, so the same field names can be treated differently depending on which sheet they came from.

$sheets = (new FastExcel)
    ->withSheetContext()
    ->importSheets('file.xlsx', function ($sheetName, $row) {
        return $row + ['_sheet' => $sheetName];
    });

Requested in #369 by @StarkOne, whose earlier patch shaped the final version.

Full changelog: v5.14.0...v5.15.0

What's Changed

• feat: select import sheet by name (#273) by @elminson in #409 — originally proposed by @ElRochito in #285
• fix: close reader on exception during import (#241) by @elminson in #410

Full Changelog: v5.13.0...v5.14.0

What's Changed

• feat: limit imported rows with limitRows() (#248) by @elminson in #413
• docs: refresh benchmarks (2026 numbers + comparison chart) by @elminson in #415
• bench: measure streaming export/import paths (fix peak-memory reporting) by @elminson in #416
• feat: exclude underscore-prefixed columns from export (#341) by @elminson in #412

Full Changelog: v5.12.0...v5.13.0

What's Changed

• ci: benchmark PRs against base (time + peak memory) by @elminson in #407
• fix(ci): benchmark base run and compare steps were silently failing by @elminson in #408
• perf: stream exports, faster transpose, simplified internals (-87% peak memory) by @elminson in #406
• feat: add importLazy() for memory-efficient streaming imports (#374) by @elminson in #404

Full Changelog: v5.11.0...v5.12.0

What's Changed

• test: cover multi-sheet export with a Traversable per sheet (#252) by @elminson in #402
• feat: style header columns individually (setHeaderColumnStyles) (#367) by @elminson in #403

Full Changelog: v5.10.0...v5.11.0

What's Changed

• ci: exclude tests/ from Codacy analysis by @elminson in #392
• chore: remove dead .travis.yml by @elminson in #393
• Add .gitattributes by @klimov-paul in #253
• chore: modernize .gitattributes export-ignore list by @elminson in #394
• ci: align phpcs.xml with the codebase's concatenation style by @elminson in #396
• Clarify export options by @xwiz in #195
• Handle duplicate and empty header names on import by @elminson in #395
• docs: low-memory streaming imports for large files (#162) by @elminson in #391
• Accept any Traversable as export data by @elminson in #397
• fix: write placeholder row for empty sheets in multi-sheet exports by @dannyyol in #401
• Fail clearly when exporting multiple sheets to a single-sheet format (#244) by @elminson in #398
• Make string vs number export configurable (#193) by @elminson in #400

New Contributors

• @klimov-paul made their first contribution in #253
• @xwiz made their first contribution in #195

Full Changelog: v5.9.0...v5.10.0

What's Changed

• docs: show that export() returns the written file path by @elminson in #390
• docs: add issue templates, PR template, and CONTRIBUTING guide by @elminson in #387
• Feature/configure writer using by @dannyyol in #384
• test: cover Eloquent model export/import (#12) by @elminson in #388
• docs: add security policy (SECURITY.md) by @elminson in #389
• Fix #185: import uploaded / extension-less CSV & ODS files by @elminson in #385

Full Changelog: v5.8.0...v5.9.0

What's Changed

• Fix php84 deprecations by @dannyyol in #383
• ci: add PHP 8.5 to the test matrix by @elminson in #386

New Contributors

• @dannyyol made their first contribution in #383
• @elminson made their first contribution in #386

Full Changelog: v5.7.0...v5.8.0

• Move from box/spout to openspout/openspout v3 | https://github.com/openspout/openspout
• Fix phpunit tests
• Add support to php 8.1
• Integrated with Github Actions
• Add auto dependabot merge

• add support for PHP 8
• update PHPUnit to 6.4 to 9.5
• update Spout from 2 to 3
• (breaking change) drop support for PHP 7.1
• (breaking change) remove setEndOfLineCharacter support for CSV