openspout/openspout

PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

v4.23.0 2024-01-09 09:30 UTC

Requires

• php: ~8.1.0 || ~8.2.0 || ~8.3.0
• ext-dom: *
• ext-fileinfo: *
• ext-filter: *
• ext-libxml: *
• ext-xmlreader: *
• ext-zip: *

Requires (Dev)

• ext-zlib: *
• friendsofphp/php-cs-fixer: ^3.46.0
• infection/infection: ^0.27.9
• phpbench/phpbench: ^1.2.15
• phpstan/phpstan: ^1.10.55
• phpstan/phpstan-phpunit: ^1.3.15
• phpstan/phpstan-strict-rules: ^1.5.2
• phpunit/phpunit: ^10.5.5

Suggests

• ext-iconv: To handle non UTF-8 CSV files (if "php-mbstring" is not already installed or is too limited)
• ext-mbstring: To handle non UTF-8 CSV files (if "iconv" is not already installed)

MIT

• Adrien Loison

• php
• excel
• spreadsheet
• odf
• xlsx
• csv
• stream
• memory
• open
• read
• write
• scale
• ods
• office
• OOXML

README

OpenSpout is a community driven fork of box/spout, a PHP library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way. Unlike other file readers or writers, it is capable of processing very large files, while keeping the memory usage really low (less than 3MB).

Documentation

Documentation can be found at docs/.

Upgrade from box/spout:v3 to openspout/openspout:v3

1. Replace box/spout with openspout/openspout in your composer.json
2. Replace Box\Spout with OpenSpout in your code

Upgrade guide

Version 4 introduced new functionality but also some breaking changes. If you want to upgrade your OpenSpout codebase please consult the Upgrade guide.

Copyright and License

This is a fork of Box's Spout library: https://github.com/box/spout

Code until and directly descending from commit cc42c1d is copyright of Box, Inc. and licensed under the Apache License, Version 2.0:

https://github.com/openspout/openspout/blob/cc42c1d29fc5d29f07caeace99bd29dbb6d7c2f8/LICENSE

Code created, edited and released after the commit mentioned above is copyright of openspout Github organization and licensed under MIT License.

https://github.com/openspout/openspout/blob/main/LICENSE