PhpSpreadsheet
A pure PHP library for reading and writing spreadsheet files (by PHPOffice)
Spout
Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way (by box)
Our great sponsors
| PhpSpreadsheet | Spout | |
|---|---|---|
| 17 | 8 | |
| 12,959 | 4,116 | |
| 1.0% | - | |
| 9.5 | 6.1 | |
| 5 days ago | almost 2 years ago | |
| PHP | PHP | |
| MIT License | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
PhpSpreadsheet
Posts with mentions or reviews of PhpSpreadsheet.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-05-25.
-
Exporting data to Excel
We have used a PHP Script to do this https://github.com/PHPOffice/PhpSpreadsheet
-
Exporting large amount of data to Excel
If I need the data to be well-formatted in Excel, directly from the export, then I use PhpSpreadsheet. Otherwise, I'll just write to a CSV file.
-
Looking for Recommendations: Class to create Excel (XLSX) files
here
-
Storing an Excel column's values in a simple, flat array w/ PhpSpreadsheet?
I'm using PhpSpreadsheet to generate an Excel file. It works really well, but now I'd like to reopen the file it created downstream and assign every cell value in one specific column to a simple, flat array where, say, the 1 key of this array might be the name of the column and the values are the column's cell values? Or even just a simple array with only the values...?
- Is there any laravel package to modify existing excel files
- Aiuto PHPSpreadsheet
-
Retrieving output of .php ... with php
For the library, there is PhpOffice
- is there a version of datatables or another package for in cell editing
-
Excel/PDF Report Generation in Laravel
a full list of sizes is in this file, https://github.com/PHPOffice/PhpSpreadsheet/blob/master/src/PhpSpreadsheet/Worksheet/PageSetup.php
-
Graphs in Excel generated from Laravel
You can use phpspreadsheet. It's the library that LaravelExcel relies on. Here's samples from their git repo: https://github.com/PHPOffice/PhpSpreadsheet/blob/master/samples/Chart/33_Chart_create_pie.php
Spout
Posts with mentions or reviews of Spout.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-08-28.
-
How to read a csv file in PHP?
"This project has been archived and is no longer maintained. No bug fix and no additional features will be added. You won't be able to submit new issues or pull requests, and no additional features will be added" https://github.com/box/spout
- Import data from excel file to laravel
-
Best Excel creation lib for PHP
We were testing PHP Spreadsheet and Spout (https://github.com/box/spout). We chose Spout because of its low memory footprint. It is using streams so it is much lighter than PHP Spreadsheet, although it is missing quite a bit of features that PHP Spreadsheet has.
-
Creating multi-worksheet Excel files with Simple Excel
The Simple Excel package uses the box/spout package under the hood. In the readme it states that you can get to the underlying writer using ->getWriter().
-
PHP libraries and tools
box/spout: Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way
-
What's the best practice in modifying/inserting values in specific cells of an existing excel file?
If you don't have a lot of formatting requirements beyond just the placement of the data in the correct fields, I really enjoy Box/Spout (https://opensource.box.com/spout/), and they have a way to install it without composer.
-
Packing for importing/exporting csv files
I've also had good experiences with https://github.com/box/spout
-
How to test CSV in Drupal without losing your mind
to add to this, this library is really good when wanting to parse CSV files https://github.com/box/spout
What are some alternatives?
When comparing PhpSpreadsheet and Spout you can also consider the following projects:
PHPExcel
PHPWord - A pure PHP library for reading and writing word processing documents
fast-excel - 🦉 Fast Excel import/export for Laravel
ExcelAnt - Simple yet powerful Excel manipulation library for PHP 5.4+
WordPress Packagist - WordPress Packagist — manage your plugins with Composer
PHPPowerPoint - A pure PHP library for reading and writing presentations documents
local-php-security-checker - PHP security vulnerabilities checker
Luckysheet - Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.
GrumPHP - A PHP code-quality tool
gotenberg - A developer-friendly API for converting numerous document formats into PDF files, and more!
PHPGGC - PHPGGC is a library of PHP unserialize() payloads along with a tool to generate them, from command line or programmatically.
PhpSpreadsheet vs PHPExcel
Spout vs PHPExcel
PhpSpreadsheet vs PHPWord
Spout vs fast-excel
PhpSpreadsheet vs ExcelAnt
Spout vs WordPress Packagist
PhpSpreadsheet vs PHPPowerPoint
Spout vs local-php-security-checker
PhpSpreadsheet vs Luckysheet
Spout vs GrumPHP
PhpSpreadsheet vs gotenberg
Spout vs PHPGGC