PhpSpreadsheet
php-ext-xlswriter
Our great sponsors
PhpSpreadsheet | php-ext-xlswriter | |
---|---|---|
17 | 1 | |
12,959 | 2,190 | |
1.0% | - | |
9.5 | 4.6 | |
4 days ago | 4 months ago | |
PHP | C | |
MIT License | BSD 2-clause "Simplified" License |
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
php-ext-xlswriter
-
Excel/PDF Report Generation in Laravel
for excel part, if you have large amount of data to export/import, i would recommanded viest/php-ext-xlswriter.
What are some alternatives?
Spout - Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way
XlsxWriter - A Python module for creating Excel XLSX files.
PHPExcel
laravel-report-generator - Rapidly Generate Simple Pdf, CSV, & Excel Report Package on Laravel
PHPWord - A pure PHP library for reading and writing word processing documents
fast_excel - Ultra Fast Excel Writer for Ruby
ExcelAnt - Simple yet powerful Excel manipulation library for PHP 5.4+
ext-ds - An extension providing efficient data structures for PHP 7
PHPPowerPoint - A pure PHP library for reading and writing presentations documents
writexl - Portable, light-weight data frame to xlsx exporter for R
Luckysheet - Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.
xlsxwriter-rs - Excel file writer for Rust