ExcelAnt vs PhpSpreadsheet

ExcelAnt

Simple yet powerful Excel manipulation library for PHP 5.4+ (by Wisembly)

#Office

Source Code

wisembly.github.io

PhpSpreadsheet

A pure PHP library for reading and writing spreadsheet files (by PHPOffice)

#Office #PHP #Spreadsheet #Excel #Libreoffice #XLSX #ODS #XLS #phpexcel #sylk #msexcel #gnumeric #HacktoberFest

Source Code

phpspreadsheet.readthedocs.io

Our great sponsors

Cloudways - Managed Cloud Hosting Platform

Scout APM - Less time debugging, more time building

SonarQube - Static code analysis for 29 languages.

Our great sponsors

ExcelAnt		PhpSpreadsheet
	Project
0	Mentions	9
67	Stars	11,279
-	Growth	1.1%
0.0	Activity	9.7
about 8 years ago	Latest Commit	1 day ago
PHP	Language	PHP
GNU General Public License v3.0 or later	License	MIT License

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.

ExcelAnt

Posts with mentions or reviews of ExcelAnt. We have used some of these posts to build our list of alternatives and similar projects.

We haven't tracked posts mentioning ExcelAnt yet.
Tracking mentions began in Dec 2020.

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 2022-05-02.

Excel/PDF Report Generation in Laravel
3 projects | reddit.com/r/laravel | 2 May 2022

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
2 projects | reddit.com/r/laravel | 22 Mar 2022

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
Best Excel lib for PHP
1 project | reddit.com/r/PHPhelp | 18 Nov 2021

Well, that depends on your experience and how fast you learn new things. I don't think it's very complicated, and there is documentation and a lot of examples. So, if you follow those, it should work nicely.
Best Excel creation lib for PHP
4 projects | reddit.com/r/PHP | 18 Nov 2021

I think https://github.com/PHPOffice/PhpSpreadsheet is what you're looking for. I've been using it for many years for an export generator, well maintained and working nicely.
Laravel development & production ready Docker build - help needed
9 projects | reddit.com/r/laravel | 11 Nov 2021

But xlsx to csv sounds like a really simple task. You should consider if you could do the task using PHP, for example the PHPSpreadsheet package or it's wrapper Laravel-Excel.
Laravel 8 Export Data as Excel File with Example
1 project | reddit.com/r/laravel | 19 Oct 2021

And be ready to dive into PhpSpreadsheet package because anything beyond simple export need custom config of this package
What's the best practice in modifying/inserting values in specific cells of an existing excel file?
3 projects | reddit.com/r/PHPhelp | 1 Sep 2021

The docs directory on their github repository contains a lot of examples on how to read, modify and save spreadsheet files. They also have some documentation on their website.

3 projects | reddit.com/r/PHPhelp | 1 Sep 2021

You may want to look into this library: https://github.com/PHPOffice/PhpSpreadsheet
Most Useful GitHub repositories for Laravel
9 projects | dev.to | 21 Jan 2021

PhpSpreadsheet is a library written in pure PHP and offers a set of classes that allow you to read and write various spreadsheet file formats such as Excel and LibreOffice Calc.