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/od6/private/full
}
}
Please somebody help!
}
