Re: Google spreadsheet curl
| From: | ioannes@btinternet.com | Date: | Sun, 08 Aug 2010 13:57:07 +0000 |
| Subject: | Re: Google spreadsheet curl | ||
| References: | 1 2 3 4 5 6 7 8 9 10 11 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-307369@lists.php.net to get a copy of this message | ||
Using this code I get error message:
"The spreadsheet at this URL could not be found. Make sure that you have the right URL and that the owner of the spreadsheet hasn't deleted it." I have set up a test spreadsheet and it exists. Any ideas on why this might be? <?php $key="[key from google spreadsheet URL"; $url = "[well known protocol][colon][[forwardslash]forwardslash]spreadsheets.google.com/feeds/cells/$key/1/public/values"; $ch = curl_init(); // set URL and other appropriate options curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); // grab URL and pass it to the browser $google_sheet = curl_exec($ch); print("<br>google_sheet: $url"); print($google_sheet); etc ?>