Hi all Hopefully someone can help a rather rusty programmer...
I'm trying to build an application that opens specific published google spreadsheets by key, parses the contents and then pushes the data into a database to facilitate multiple reports (please see http://groups.google.com/group/Google-Base-data-API/browse_thread/thread/acdbd4683cbff1ff#) for a more detailed explanation. ......... Sub test(ByVal key As String, ByVal worksheetname As String) Dim strURL As String strURL = "http://spreadsheets.google.com/feeds/worksheets/"; & key & "/public/basic" Dim GService As SpreadsheetsService Dim Google_Worksheet_Available As Boolean = False GService = New SpreadsheetsService("STS") Dim query As WorksheetQuery = New WorksheetQuery(strURL) Dim feed As WorksheetFeed = GService.Query(query) Dim GWorksheet As WorksheetEntry For Each worksheet As WorksheetEntry In feed.Entries If worksheet.Title.Text = worksheetname Then GWorksheet = worksheet Google_Worksheet_Available = True Exit For End If Next worksheet ........... >From here, is it possible to iterate through the cells associated with the above GWorksheet object? Essentially I need to return reference (localName?) and values for all used cells within the "15 heat" worksheets. Example.. test("ptpN6QQMm4zzkv-CxgKJ-Dw", "15 heat") Thanks in advance! Andy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---
