PHP and M$ Excel

L

Lord-Nikon

Expert Member
Joined
Jul 22, 2008
Messages
2,511
Reaction score
0
I need to know if its possible to get PHP to search through an Excel file, lets say Column A, if a match is found in row 20 return column H Row 20.

Is that remotely possible? I've searched the web, even php.net but without any success.

If you have any scripts on how to do this or know of any sites where I can get resources into doing this, it would be much appreciated.

Any other suggestions to work around this (except transfer the Excel spreadsheet to a SQL server ---- don't have the time to do that or write a program to manage it from there on) are more than welcome! :D
 
Old style binary xls documents or new OOXML documents?

Either way your are in for an uncomfortable time. Perhaps you should consider alternatives such as exporting the xls to csv before processing.

Or using a proper open document standard.
 
New XLS document (2003).

The problem I'm having is that the spreadsheet gets used almost everywhere. I've got so many reports and systems linking to the spreadsheet and now I need to get my PHP System doing that as well. Is there a simple way of converting to CSV using PHPso that I don't need to do it on a daily basis as this is a live system that is being used across the globe? :confused:

Aren't there any modules you know about that can have PHP access Excel documents? I've opened the document using a text editor but as you have allready guessed: its garble. :sick:

It would be really simple to make way with the spreadsheet and rather have it managed in a prober db environment, but to do that is basically changing our whole setup... hopefully there is a way to get PHP to access the Excel document...:eek:
 
I managed to get the classes and Objects working (after a great deal of struggle) but this seems to be what I'm looking for.

Again thanks for your help icyrus!
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X