By click on below link you can download complete source code file of How to Import Excel File in Codeigniter. Here you can find complete source code file with Codeigniter framework with PHPExcel library loaded. So you have to just make customer table and make database connection. After making of database connection you have to change base_url() of codegniter application. And lastly you have to go to browser and write base url slash excel import controller then you have see file tag and import button on web page. So you can select excel sheet and start importing excel sheet data into mysql database.
Helpful code indeed..
ReplyDeleteOn downloading the source code then, creating the customer table and making database connection, It doesn't seem to work yet.
ReplyDeleteI get this error:
"
An uncaught Exception was encountered
Type: Error
Message: Call to undefined method Main_model::fetch_data()
Filename: C:\xampp\htdocs\ExcelToMySQL\application\controllers\main.php
Line Number: 9
Backtrace:
File: C:\xampp\htdocs\ExcelToMySQL\index.php
Line: 315
Function: require_once
"
Please view my comment
Deletechange default controller in route to excel_import
Deletethen change the config in base url like your folder name
try it.
go to Route File and then change $route['default_controller'] = 'excel_import' ;
DeleteYou can simply add to drive, after login into gmail you will get that at the top right corner.
ReplyDeletei cant importing
ReplyDeletei can't download. pls help me
ReplyDelete