Author | Message | Time |
---|---|---|
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 |