Use Php To Read Data From An Excel Spreadsheet How to do it ?

[soleimanian 0]

if there were a an Excel spreadsheet on and INTRAnet network page, How would a guy go about reading a certain cell in that spreadsheet for a specfic numerical value? Is there a specific family of language that deals with this type of issue?what i want to do is have a webpage (on an INTRAnet-Network) that looks at an Excel spreadsheet (on the Network) and then displays a graphic if the value meets certain criteria. (?) Lets say I have a spreadsheet that has 10 cells, and I want a webpage that looks at the value in one of those cells and says 'if the value = 9, then display a picture of a 'face' or basicly a graphic image and if it does not equal 9, then display an image of a say 'chair'.And I want another part of the webpage to do the same thing with another cell value and says 'if that cell value = 2, then display a different image graphic of a 'tree' and so on until all cell values display according to a condition, on some area on a web page.(i hope i asked this in the correct manner to explain properly what i want to do)Best regards

Edited April 18, 2005 by microscopic^earthling (see edit history)

[miCRoSCoPiC^eaRthLinG 0]

First of all, Excel files come in a very proprietary format which means you would need to create extremely excel-specific functions. A better method is to save the sheet as comma-separated text (CSV) files, then find common csv import/export functions.

However, if you still want to go ahead and do it, try using these PHP-Excel parsers:

1. http://www.hotscripts.com/category/scripts/php/scripts-programs/database-tools/,
2. http://www.sitepoint.com/forums/showthread.php?250772-reading-from-an-xls(excel)-file

[rapco 0]

very interesting...i think i encounter the same question before....if i'm not mistaken there's a way of exporting excel tables to mysql tables... taht way you can handle you dat using php very easly...Why do u want to read data form an excel file adn pu it into an intranet, have you considered using a cms?????