Same problem here. I need to clear an existing sheet, set column headers and add new data rows. I Don't get why it has to be so complicated.
Usually I'm a big fan of Google products and APIs but this API is terrible. What I would expect is something like: spreadsheets["foo"].worksheets[0].rows[1].columns[2].value = "bar"; Instead, we get an API that is too generic, with feeds and entities all over. On Jun 24, 12:38 pm, Szimandl Béla <[email protected]> wrote: > Hi! > > I have the same problem when trying to add a row to a blank spreedsheet. > The way how i do that: > > SpreadsheetsService service = new SpreadsheetsService("Jogok"); > service.setUserCredentials(Program.email, Program.password); > > SpreadsheetQuery sp_query = new SpreadsheetQuery(); > SpreadsheetFeed sp_feed = service.Query(sp_query); > > foreach (SpreadsheetEntry entry in sp_feed.Entries) > { > if (entry.Title.Text == "existFileName") > { > //Worksheet-- > AtomLink wlink = > entry.Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null); > > WorksheetQuery w_query = new WorksheetQuery(wlink.HRef.ToString()); > WorksheetFeed w_feed = service.Query(w_query); > > if (w_feed.Entries.Count > 0) > { > WorksheetEntry w_entry = (WorksheetEntry)w_feed.Entries[0]; > > //ListFeed-- > AtomLink listFeedLink = > w_entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); > > ListQuery l_query = new ListQuery(listFeedLink.HRef.ToString()); > ListFeed l_feed = service.Query(l_query); > > ListEntry newRow = new ListEntry(); > ListEntry.Custom ce = new ListEntry.Custom(); > > ce.Value = Program.regcode; > newRow.Elements.Add(ce); > > ListEntry insRow = l_feed.Insert<ListEntry>(newRow); > > //The Failure: > //Execution of request > failed:https://spreadsheets.google.com/feeds/list/toIwHRycmiBbLKNh2ktFZAQ/od... > > } > } > > Please somebody help! > > > > > > > > }
