Changing data source to Google Spreadsheet

One of the powerful features of working with the Google API is the deep relationship between the product lines. In this recipe, based on the last recipe, we will create a Google Spreadsheet and then integrate it into our application.

Getting ready

Have a copy around you of the source files from the last recipe (Creating charts using the ChartWrapper).

How to do it...

The steps involved with creating a new Google document are simple, but are needed to be able to integrate our work; as such we will run through them quickly.

1. Go to http://drive.google.com/ (formally known as Google Docs) and register/login.

2. Create a new spreadsheet.

3. Add data to the spreadsheet.

   

4. Click on the Share button and set the view to public:

   

5. Create an API URL based on the document ID:

   • Document link:

     https://docs.google.com/spreadsheet/ccc?key=0Aldzs55s0XbDdFJfUTNVSVltTS1ZQWQ0bWNsX2xSbVE

   • API link:

     https://spreadsheets.google.com/tq?key=0Aldzs55s0XbDdFJfUTNVSVltTS1ZQWQ0bWNsX2xSbVE

6. Now, it's time...