183 responses to “Saving Form Data to Google Spreadsheets Using PHP and the Google Docs API”

  1. Patrick Taylor

    Hi, first off, great tutorial. It was really helpful and very well written. However, I would also like to know how to addColumn rather than a row. Cheers

  2. Vlajke

    How to add auto increment ID (with numbers only) and timestamp to spreadsheet ? Is it possible? THanks in advance!

  3. Donnie Ashok

    Hi!
    I need to make this thing work..
    But I get this error:

    Warning: require_once(Zend/Loader.php) [function.require-once]: failed to open stream: No such file or directory in /home/mydomain/public_html/mydomain.in/register/Google_Spreadsheet.php on line 216

    Fatal error: require_once() [function.require]: Failed opening required ‘Zend/Loader.php’ (include_path=’.:/usr/lib/php:/usr/local/lib/php:zend/library’) in /home/mydomain/public_html/mydomain.in/register/Google_Spreadsheet.php on line 216

    I guess I haven’t installed ZEND properly, can you suggest how to install it?

  4. Amar Ranjan Das

    Thanks for such a great tutorial and helper class !

    I have used this and it works fine for me. I am using PHP: 5.3.5. One problem is that it is giving one warning like

    Strict Standards: Only variables should be passed by reference in C:\xampp\htdocs\usolver\Google_Spreadsheet.php on line 258

    Strict Standards: Only variables should be passed by reference in C:\xampp\htdocs\usolver\Google_Spreadsheet.php on line 289

    I am unable to hide this warning or solve this or solve this warning. Please help me for this warning.

  5. david

    Can you provide an example of this code with oauth 2.0? I don’t want to use google user name password

  6. JT

    Hey,

    I use this in some use cases. But went to a problem, when the Spreadsheet is bigger then some size, the memory on server for PHP is out. Is there any option to work with Google Spreadsheet in more memory efficient way? Any ideas? I think that Zend GData works with Spreadsheet in memory…and the spreadsheet is (for sure) constantly increasing…

  7. Pierre Saikali

    Very interesting and useful article, thanks a lot for this helper!

    I’m using it on a French site and unfortunately, the cleanKey() function removes the accentued characters (é à è ï…), any idea how to avoid that?
    I do have some columns with accent in their headers, so I can’t get to write in them properly :/

    Anyway, thanks again!

  8. Pierre Saikali

    Actually, please ignore my comment, I found a solution to allow accents ;)

    function cleanKey($k)
    {
    return strtolower(preg_replace(‘/[^A-Za-z0-9àáâãäåçèéêëìíîïðòóôõöùúûüýÿ\-\.]+/’,”,$k));
    }

1 6 7 8