Hey Daniel, Can you ask this in the Gadgets forum? http://code.google.com/googleapps/support/gadgets/
Thanks, -Vic On Thu, Jan 13, 2011 at 6:50 AM, Daniel Cuschieri <[email protected] > wrote: > 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!
