Posted by Toby Inkster on 06/15/06 06:38

elyob wrote:

> I want to read the BT hotspots xls to a readable format...
> http://www.btopenzone.com/downloads/BT_Openzone_Hotspot_List.xls

Use PHP's curl[1] stuff to download and save the file, use system()[2] to
pass it through xls2csv[3], read the result into a PHP array using
file()[4] and then explode()[5] each element of the array on comma.

____
1. http://uk2.php.net/manual/en/ref.curl.php
2. http://uk2.php.net/manual/en/function.system.php
3. http://www.45.free.net/~vitus/software/catdoc/
4. http://uk2.php.net/manual/en/function.file.php
5. http://uk2.php.net/manual/en/function.explode.php

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

• Next in forum: htaccess alternative
• Prev in forum: Re: Any good CAPTCHA to recommend?
• Thread view: Re: Reading Excel to MySql or Comma delimited ...

[Reply to this message]