Hello Erwin
I had the same issue and made up this (c#):
cellList is my own c# list with the cell of the first row. I have Cell
objects like this:
public class Cell
{
public Cell()
public string cellName;
public string cellValue;
}
worksheet is the empty workshet, i think maybe you have to set the cols and
rows number first:
worksheet.Cols = cellList.Count;
worksheet.Rows = numberOfInitalRows.
worksheet.Update();
Then:
AtomLink cellFeedLink =
worksheet.Links.FindService(GDataSpreadsheetsNameTable.CellRel, null);
CellQuery cellQuery = new CellQuery(cellFeedLink.HRef.ToString());
CellFeed cellFeed = service.Query(cellQuery);
if (cellFeed.Entries.Count == 0)
{
for (uint i = 0; i < cellList.Count; i++)
{
uint row = i + 1;
CellEntry newCellEntry = new CellEntry((uint)1, row,
cellList[(int)i].cellName);
cellFeed.Insert(newCellEntry);
newCellEntry = new CellEntry((uint)2, row, cellList[(int)i].cellValue);
cellFeed.Insert(newCellEntry);
}
}
I insert data for the first row in the same time, but it could be made up
only with the header.
Best regards,
Anders, Denmark.
http://www.basechat.com
More info in theese threads:
https://groups.google.com/forum/embed/?place=forum/google-spreadsheets-api&showsearch=true&showpopout=true&parenturl=http://code.google.com/intl/da/apis/spreadsheets/forum.html#!topic/google-spreadsheets-api/OhRrixnKtRs
https://groups.google.com/forum/embed/?place=forum/google-spreadsheets-api&showsearch=true&showpopout=true&parenturl=http://code.google.com/intl/da/apis/spreadsheets/forum.html#!searchin/google-spreadsheets-api/blank$20c$20insert$20row/google-spreadsheets-api/VyCblqApfz8/80brvOnsk8MJ
https://groups.google.com/forum/embed/?place=forum/google-spreadsheets-api&showsearch=true&showpopout=true&parenturl=http://code.google.com/intl/da/apis/spreadsheets/forum.html#!searchin/google-spreadsheets-api/insert$20row/google-spreadsheets-api/Ew44SXYOwXg/2LtodCGJJ34J
