PHPSpreadsheet – Bittenbook

Using Spout to read MS Excel sheet

August 13, 2021 by Bittenbook

In this tutorial we’ll use Spout PHP library to read MS Excel sheet and insert sheet’s data into database. But the first question is why Spout PHP library instead of ubiquitous PhpSpreadsheet. The simple answer is read speed. There is no doubt that for handling MS Excel or other spreadsheet files in PHP based app … Read more

Comprehensive tutorial on PHPSpreadsheet

August 10, 2021 by Bittenbook

In this tutorial we’ll look into using PhpSpreadsheet library, a pure php library to read and write spreadsheets including MS Excel. You can start by creating a fresh laravel 8 app by entering following command: Now install phpspreadsheet by executing the following command inside project directory: Next, setup database and Laravel environment file as usual. … Read more