Moved from <a href="http://www.google.com/support/forum/p/apps-apis/thread?tid=608664f1edbdbc44&hl=en";>the old forum</a> (thanks for the pointer, Vic):
When I'm manually handling a worksheet, there is a finite set of rows (100 on a new sheet) with a button at the bottom to add a number (20 by default) empty rows to the bottom. I have code that uses cell-based feeds to read and write cell (CellEntry) values -- this all works fine. When I attempt to write to the next row, off the bottom of the sheet, I get an error. I guess I was expecting it to just generate the row dynamically, but it makes some sense that that's not how it works. I spent time looking for how to make the CellFeed create new rows before figuring out that it's supposed to be done at the worksheet-feed level. But now, I'm at another impasse. I find stuff like "To change the metadata of a worksheet, begin by getting the desired worksheet from the worksheet feed. Then send a PUT request with the desired entry contents to the URL provided in an edit link. The edit URL is highlighted in the XML below." but I'm not sure how to translate that into using the .NET DLLs. It looks like changing the rowCount should be just like changing the title, but I'm not seeing properties and methods to enable that. E.g., I can do the following (wso.Worksheet is an AtomEntry from the WorksheetFeed): wso.Worksheet.Title = New AtomTextConstruct(AtomTextConstructElementType.Title, "rename back to Sheet1") wso.Worksheet.Update() But there is nothing analogous for rowCount. Getting to this point has involved *a lot* of trial and error; moving up or down a level in the feed/object hierarchy in order to find the right place to hook the data, but I'm just not finding what I need this time. I appreciate any help you can provide!
