Valhalla Legends Forums Archive | Web Development | [PHP] Excel to CVS

AuthorMessageTime
PaiD
[u]Situation[/u]:
My Suppliers have the inventory list in an excel file (.xls) and some also have them listed under .cvs.

[u]Problem[/u]:
I am looking at a way to automate the website and have it updated from the suppliers on the products/quantities. Not all my suppliers have .cvs files for download and I was hoping there is a way to have my website check the suppliers and read those files. Any ideas?
January 15, 2006, 12:56 AM
shadypalm88
I assume you mean CSV (Comma-Separated Values), not CVS (Concurrent Versions System).

You can try using PHP Excel Reader.  Never used it myself though.

Alternatively, if you have access to a Windows machine with Excel installed you could probably use JScript or VBScript to automate the process of opening the Excel spreadsheet and saving it as a CSV file.
January 15, 2006, 5:44 PM

Search