1 (edited by ameenullah 2005-12-24 07:38)

Topic: How to read XLS file using PHP

Hi All,

  Do anyone help me in reading .xls(MS Excel Sheet) using PHP and store the info to MySQL/display it in HTML format. I would like to read around 1000 lines of data from excel sheet and display it on the screen as a list in html format. also want to store the same to the database. Could anyone know about some library to read and write the data from /to excel sheet.

I tried http://www.paggard.com/projects/xls.reader/ its good, but i want it free. Any suggession, any help?

Thanks

God wisely designed the human body so that we can neither pat our own backs nor kick ourselves too easily

Re: How to read XLS file using PHP

For reading, use http://sourceforge.net/projects/phpexcelreader/

For writing, use the PEAR package Spreadsheet_Excel_Writer