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

  • From: India
  • Registered: 2004-06-03
  • Posts: 435

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
  • From: UK
  • Registered: 2004-07-24
  • Posts: 97

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

Nibbler(cpg)'s Website