Download google spreadsheet

I would like to get the information in a google spreadsheet (of a
client) programatically into my database. I was thinking of using cURL,
downloading the file into Excel, then uploading it into my database
using a scheduled task, then cronjob some code to make it useful.
However, the google spreadsheet displayed is not Excel though it has the
option to download as Excel in a menu item. Can someone point me in the
right direction on this, via Excel or otherwise?

Thanks,

John

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Download google spreadsheet

You might check the google documents api:
http://code.google.com/apis/documents/overview.html

-TG

----- Original Message -----
From: ioannes
To: php-db@lists.php.net
Date: Wed, 26 Dec 2007 23:59:12 +0000
Subject: [PHP-DB] Download google spreadsheet

> I would like to get the information in a google spreadsheet (of a
> client) programatically into my database. I was thinking of using cURL,
> downloading the file into Excel, then uploading it into my database
> using a scheduled task, then cronjob some code to make it useful.
> However, the google spreadsheet displayed is not Excel though it has the
> option to download as Excel in a menu item. Can someone point me in the
> right direction on this, via Excel or otherwise?
>
> Thanks,
>
> John
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Download google spreadsheet

A lot of xml, I gather. My bank also allows me to download my account
details in various formats, eg csv, 'spreadsheet' etc. I take it they
generate this on the hoof which means I don't have a static address from
which to download a file.

TG wrote:
> You might check the google documents api:
> http://code.google.com/apis/documents/overview.html
>
> -TG
>
> ----- Original Message -----
> From: ioannes
> To: php-db@lists.php.net
> Date: Wed, 26 Dec 2007 23:59:12 +0000
> Subject: [PHP-DB] Download google spreadsheet
>
>
>> I would like to get the information in a google spreadsheet (of a
>> client) programatically into my database. I was thinking of using cURL,
>> downloading the file into Excel, then uploading it into my database
>> using a scheduled task, then cronjob some code to make it useful.
>> However, the google spreadsheet displayed is not Excel though it has the
>> option to download as Excel in a menu item. Can someone point me in the
>> right direction on this, via Excel or otherwise?
>>
>> Thanks,
>>
>> John
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php