Upload XLS sheet and Update Column name "Smart ID" and download the Updated XLS sheet
As you know the CodeIgniter framework follows the MVC(Model/View/Controller) architecture and we explain all the three section along with PHPExcel library which will help to read/write XLS sheet. To start the development you need to first download the PHPExcel library ZIP files from <a href="">HERE</a>. After the download and extract the ZIP files put into the library directory which is already created by the "CodeIgniter" Framework. We are here to explain how to update a particular column in the uploaded XLS sheet and provided the updated sheet to download. This script is written in CodeIgniter framework and explain every thing how to create & manage the script. Below is the Controller methods create a file (pimsheet.php) into the Controller Directory copy and paste all the code into the files and put into the "Controller" directory. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed...