PhpSpreadsheet
PHPExcel
PhpSpreadsheet | PHPExcel | |
---|---|---|
17 | 1 | |
13,220 | 11,365 | |
0.5% | - | |
9.6 | 0.0 | |
7 days ago | over 5 years ago | |
PHP | PHP | |
MIT License | GNU Lesser General Public License v2.1 only |
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
-
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
PHPExcel
-
Best Excel creation lib for PHP
https://github.com/PHPOffice/PHPExcel is unmaintained / archived
What are some alternatives?
Spout - Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way
PHPWord - A pure PHP library for reading and writing word processing documents
ExcelAnt - Simple yet powerful Excel manipulation library for PHP 5.4+
PHPPowerPoint - A pure PHP library for reading and writing presentations documents
ONLYOFFICE - ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
Luckysheet - Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.
ownCloud documents
gotenberg - A developer-friendly API for converting numerous document formats into PDF files, and more!
CryptPad - Collaborative office suite, end-to-end encrypted and open-source.