I have a google spreadsheet, and i need to read data from it, use it to
populate a number of html text boxes, and then save the changes back to the
spreadsheet. I want to write my own gadget to use in Google Sites, to do
this.
I had already some something similar in C# ASP.NET using the google API
Dlls. It started as follows:
>> SpreadsheetsService service = new
> SpreadsheetsService("*********-*************-1");
> >> service.setUserCredentials("**************", "****************");
> >> SpreadsheetQuery query = new
> SpreadsheetQuery("http://spreadsheets.google.com/feeds/spreadsheets/private/full/********************";);
> >> SpreadsheetFeed feed = service.Query(query);
> >> SpreadsheetEntry spreadsheet = (SpreadsheetEntry)feed.Entries[0];
> >> WorksheetEntry rawDataWorksheet =
> (WorksheetEntry)spreadsheet.Worksheets.Entries[0];
I would not like to convert my code to a gadget. I am familiar with how to
create simple hello world type gadgets. But can someone get me started with
how to get a worksheet and read cells from a spreadsheet that requires
authentication? I cannot seem to be able to find a spreadsheet API guide
that I can use in my google gadget scripts, and maybe a simple example to
follow!
