Write data in excel file from database using PHP
Posted in MySQL PHP

Write data in excel file from database using PHP

In this article, I will show you how to use PHPExcel library to write data in excel file. The data which will be written in the excel file will be fetched from the database. In this tutorial we will use…

Read excel file and import data into MySQL database using PHPExcel
Posted in MySQL PHP

Read excel file and import data into MySQL database using PHPExcel

Sometimes, we need to read a huge amount of data from excel files (.xls or .xlsx in extension) and have to store these data into a database for future use. We can achieve this by using PHP, PHPExcel library, and…