Jump to content
xisto Community
soleimanian

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

Recommended Posts

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 by microscopic^earthling (see edit history)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?????

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.