How to Import Excel File in Codeigniter

it work on local is fine but it is not working in live server how can i fix this

excuess me their as issue of duplicate key error can you tell me the solution for it

thanks a lot bro, really helpful

i have a function fetch issue not importin data can you help me

can make how skipp if row value empty please

Display no direct script access allowed

Thanks 👍

thanks

I am getting this error
Message: Class 'PHPExcel_Shared_String' not found

I'm taking like this error please help me

A PHP Error was encountered
Severity: 8192

Message: Array and string offset access syntax with curly braces is deprecated

Filename: Worksheet/AutoFilter.php

Line Number: 720

Backtrace:

File: C:\xampp\htdocs\deneme\application\libraries\PHPExcel\Autoloader.php
Line: 79
Function: _error_handler

File: C:\xampp\htdocs\deneme\application\libraries\PHPExcel\Autoloader.php
Line: 79
Function: require

File: C:\xampp\htdocs\deneme\application\libraries\PHPExcel\Worksheet.php
Line: 361
Function: spl_autoload_call

File: C:\xampp\htdocs\deneme\application\libraries\PHPExcel.php
Line: 371
Function: __construct

File: C:\xampp\htdocs\deneme\application\libraries\Excel.php
Line: 9
Function: __construct

File: C:\xampp\htdocs\deneme\application\controllers\Excel_import.php
Line: 9
Function: library

File: C:\xampp\htdocs\deneme\index.php
Line: 315
Function: require_once

Hi Sir its humble request please accet .
Can We code in This video also in Codeligniter 4

Friend, thank you, it worked, greetings from Santa Marta Colombia. I did it directly from the form. in the view put <form method = "post" enctype = "multipart / form-data" action = "<? php echo base_url ();?> Excel_import / import"> don't use ajax, soon someone will use the data.

OBSOLETE!!!

Thanks

sir please tell me about read and write docx file in codeigniter

how to update only the existing row with same id in import?

Class 'ZipArchive' not found file => application/libraries/PHPExcel/Reader/Excel2007.php on line 85

I got an ziparchieve error. Is says something wrong with excel2007.php

value fetch successfully done but not in insert or importing data into database. hope anyone will help @Webslesson

life saver👍🏽

Execllent

save permission

Gracias por la ayuda Saludos desde BOLIVIA

An uncaught Exception was encountered
Type: Error

Message: Call to undefined method Main_model::fetch_data()

Filename: C:\xampp\htdocs\prologin\how-to-import-excel-file-in-codeigniter\application\controllers\main.php

Line Number: 9

Backtrace:

File: C:\xampp\htdocs\prologin\how-to-import-excel-file-in-codeigniter\index.php
Line: 315
Function: require_once

Your tutorial is good .I need react tutorial .This type tutorial will be help full to everybody........

i like your video .. but i am face a issue it's php liabrary run properly my localhost ...but it is not run my server
Note : this error show
Severity: 8192

Message: Array and string offset access syntax with curly braces is deprecated

Filename: Shared/String.php

Line Number: 529

Backtrace:

File: D:\xampp\htdocs\TMS4041\application\libraries\PHPExcel\Autoloader.php
Line: 82
Function: _error_handler

File: D:\xampp\htdocs\TMS4041\application\libraries\PHPExcel\Autoloader.php
Line: 82
Function: require

File: D:\xampp\htdocs\TMS4041\application\libraries\PHPExcel\Autoloader.php
Line: 36
Function: spl_autoload_call

File: D:\xampp\htdocs\TMS4041\application\libraries\PHPExcel.php
Line: 6

Function: require

what if the date format?

The action you have requested is not allowed.

this did not work for me Im getting an error on the main.php file on line 9 and i didnt change anything. can you help me mr ?

This Error :

An uncaught Exception was encountered

Type: Error

Message: Call to undefined method Main_model::fetch_data()

Filename: C:\xampp2\htdocs\testing\application\controllers\main.php

Line Number: 9

Backtrace:

File: C:\xampp2\htdocs\testing\index.php
Line: 315
Function: require_once

This did not work for me. Im getting an error on the main.php file on line 9 and i didnt change anything

Yeah That's worked for me. Thank you so much dear. Hope you post more useful videos in future

Why this is not working?? And the css not applied. Can you help me?

how import dates? please

How to know that which row is inserted successful or not?

Thankyou so so much. You're my hero!

An uncaught Exception was encountered
Type: Error

Message: Call to undefined method Main_model::fetch_data()

Filename: C:\xampp\htdocs\andreanrahmansyahputra\how-to-import-excel-file-in-codeigniter\application\controllers\main.php

Line Number: 9

Backtrace:

File: C:\xampp\htdocs\andreanrahmansyahputra\how-to-import-excel-file-in-codeigniter\index.php
Line: 315
Function: require_once

Does this still work with the new PHPspreasheet extion?

.sql file is not available in source code

plz give me Excel folder all files code like phpexcel.php, excel.php, IOFactory

500 internal server error

db fetch successfully done but not in insert or importing data into database. hope anyone will help

i've got some error, please help me.

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

index name undefined :'v helpmeeeeeeeee

Really helpful.

It is working completely. thank you keep it up.

Hi Friends

It's worked for me. But, it's seems like receive any file as long it's excel file and insert into db. I have been trying to import file that didn't match with the column requirement at column table but it's still success insert that data. How to add validation so just file that have save column with the table at db inserted. So, i can return an error message. Thanks.

i had watch this tutorial, very helpfully, i succeeded to display the data from the db , but the insert part is not working, is someone can provide assistance ?

Hello Webslesson can you make a tutorial about editing and deleting imported data via mysql and then display it in excel after exporting?