Write data in excel file from database using PHP

Write data in excel file from database using PHP

  •  
  •  
  •  
  •  
  •  
  •  

  Tweet    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 MySQL database, you can choose another database if you want. You can also check my […]

Read excel file and import data into MySQL database using PHPExcel

Read excel file and import data into MySQL database using PHPExcel

  •  
  •  
  •  
  •  
  •  
  •  

  Tweet    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 MySQL. this So, in this tutorial, I will explain to you how to read excel […]