How to insert excel file in hindi font to mysql using php

PHP
2

Hi @nehadangivds8 and welcome to the forum.

I have just completed a similar project:

I used the following library to convert the XLS to a CVS file:

https://github.com/PHPOffice/PHPExcel

Then this PHP function to convert the file to an array:

http://php.net/manual/en/function.fgetcsv.php

Next I extracted each CVS line from the array and inserted the data into a dbase table.

More details can be found here:

https://www.sitepoint.com/community/t/how-to-improve-the-performance-of-this-query/282001

1 Like