Reading Excel to MySql or Comma delimited ...

[newsprofile@gmail.com]

Can anyone point me in the right direction on how to deal with an xls
flie.

Sorry to be basic in my request, but the only other file I have to work
with is pdf.

I'm not sure, is xls the better of two evils?

Nick

[elyob]

Re: Reading Excel to MySql or Comma delimited ...

Hi, I'm back,

I want to read the BT hotspots xls to a readable format...

http://www.btopenzone.com/downloads/BT_Openzone_Hotspot_List.xls

Thanks

[Toby Inkster]

Re: Reading Excel to MySql or Comma delimited ...

elyob wrote:
[color=blue]
> I want to read the BT hotspots xls to a readable format...
> http://www.btopenzone.com/downloads/...tspot_List.xls[/color]

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

[lorento]

Re: Reading Excel to MySql or Comma delimited ...

Save your excel file into csv format.

Then use mysql command to automattically insert from file.

Otherwise use php function fgetcsv() to read the csv file.

--

http://blog.deshot.com

http://www.deshot.com

newsprofile@gma il.com wrote:[color=blue]
> Can anyone point me in the right direction on how to deal with an xls
> flie.
>
> Sorry to be basic in my request, but the only other file I have to work
> with is pdf.
>
> I'm not sure, is xls the better of two evils?
>
> Nick[/color]

[elyob]

Re: Reading Excel to MySql or Comma delimited ...


"Toby Inkster" <usenet200606@t obyinkster.co.u k> wrote in message
news:usb7m3-v6l.ln1@ophelia .g5n.co.uk...[color=blue]
> elyob wrote:
>[color=green]
>> I want to read the BT hotspots xls to a readable format...
>> http://www.btopenzone.com/downloads/...tspot_List.xls[/color]
>
> 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
>[/color]

Thanks all for the replies. I've been busy just testing the work, and
manually converting to csv to start with and uploading the file via
phpmyadmin.

However, am getting an error ... Invalid field count in CSV input on line
748

I'm looking at the file, and cannot see any problems with this middle line
....

Oulu airport,Airport ,Oulu airport,,Ouluns alo,90460,Finla nd,Sonera Homerun
Hotel Rantasipi Eden,Hotel,Para tiisikatu
2,,Paratiisikat u,37120,Finland ,Sonera Homerun
Stadshotellet Jakobstad,Hotel ,Kanalesplanade n
13,,Pietarsaari ,68600,Finland, Sonera Homerun

I've just removed that single line, and the file now uploads fine. However,
it's eight fields etc, and all looks fine.

<scratches head>