• Welcome to Valhalla Legends Archive.
 

[PHP] Excel to CVS

Started by PaiD, January 14, 2006, 06:56 PM

Previous topic - Next topic

PaiD

Situation:
My Suppliers have the inventory list in an excel file (.xls) and some also have them listed under .cvs.

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

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.