Displaying Google Spreadsheet using Zend_Gdata_Spreadsheet

This article shows code to display google spreadsheet that was created in the previous article using Zend_Gdata_Spreadsheet.
Please see Google Spreadsheet Data API for more detail information.
To execute the following code, you need to have a google account that can use google document.
You can check the screen from demonstration site(though I don’t know about security).

1.Create Controller
Create the file application/constorllers/GsheetController.php with the following content.

In the controller, the scope of AuthSub is specified like the following content.
2.Create View
Create the file application/views/scripts/gsheets/index.phtml with the following content.

Create the file application/views/scripts/gsheets/view.phtml with the following content.

Access the web server and execute reading of google spreadsheet after you logged in from google’s login screen.
Date Content
2008/5/3 Published


  1. Do you have an example in simple PHP, in one file, instead of this view and controller crap happening? I don’t want to use the whole Zend framework MVC stuff, just the Zend Gdata libraries. Thanks!

Leave a Reply

Your email address will not be published.