Coding to convert spreadsheet to csv in PHP

Asked By 0 points N/A Posted on -
qa-featured

 

Hello Friends,
I am fresh to PHP and is studying by my own, I need a coding to convert spreadsheet to csv in PHP to understand a simple conversion method using PHP.
Thanks & Regards,
Anthony
SHARE
Answered By 0 points N/A #157663

Coding to convert spreadsheet to csv in PHP

qa-featured

Hello,

First you need to do is to convert your excel file from .xls or .xlsx to .csv format. With this procedure you can migrate large data from Excel to MySql database. In this link: http://php-drops.blogspot.in/2011/04/read-excel-sheet-xls-file-with-php.html you will find detailed explanation how to read .xls files with PHP. Also there is a source code that will help you.
Other way that you can do that is to go on this link: http://phpexcel.codeplex.com/ and use their php library for reading the .xls file. Then loop over cells and write to csv file the data.

Regards,

Williamson Mellisa

Login/Register to Answer

Related Questions