Coding to convert spreadsheet to csv in PHP

Asked By mantos mantos 0 points N/A Posted on - 01/31/2013

 

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

• Status: Open
• Question Views: 824
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: PHP

Answered By Williamson Mellisa 5 points N/A #157663

Coding to convert spreadsheet to csv in PHP

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

About Williamson Mellisa

Questions
2

Answers
201

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 02/03/2013
• Question Category: PHP