zend-frameworkspreadsheetgdatazend-gdata

How to create an empty spreadsheet using Zend GData


How to create a new, empty spreadsheet using Zends GData Library?


Solution

  • According to the Google Documents List API, to create a new, empty spreadsheet: follow the instructions in Creating a new document or file with metadata only. When doing so, use a category term of http://schemas.google.com/docs/2007#spreadsheet.

    With Zend GData library, it may look like this:

    // Load Zend library
    require_once('Zend/Loader.php');
    Zend_Loader::loadClass('Zend_Gdata');
    Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
    Zend_Loader::loadClass('Zend_Gdata_Docs');
    
    // Authentication
    $client = Zend_Gdata_ClientLogin::getHttpClient('you@there.com', 'sunshine-', Zend_Gdata_Docs::AUTH_SERVICE_NAME);
    
    // Get interface to Documents List API
    $docs = new Zend_Gdata_Docs($client);
    
    // Create new document
    $data = new Zend_Gdata_Docs_DocumentListEntry();
    $data->setCategory(
          array(new Zend_Gdata_App_Extension_Category(
                  "http://schemas.google.com/docs/2007#spreadsheet",
                  "http://schemas.google.com/g/2005#kind"
    )));
    $data->setTitle(new Zend_Gdata_App_Extension_Title("My brand new spreadsheet", null));
    
    // Add document to your list
    $doc = $docs->insertDocument($data, Zend_Gdata_Docs::DOCUMENTS_LIST_FEED_URI);
    
    // Display document ID
    print($doc->getId());