Hey Khan, Also, if you only care about inserting rows positionally, you could use the cells feed to set the row, and the worksheets feed to extend the sheet as needed.
@David, thank you, I appreciate your answer. -Vic On Fri, Dec 17, 2010 at 9:25 AM, David Bullock <[email protected]> wrote: > Khan, inserting a record via the Records API is given in this example [1]: > > <entry xmlns="http://www.w3.org/2005/Atom"; > > xmlns:gs="http://schemas.google.com/spreadsheets/2006";> > <title>Darcy</title> > <gs:field name='Birthday'>2/10/1785</gs:field> > <gs:field name='Age'>28</gs:field> > <gs:field name='Name'>Darcy</gs:field> > <gs:field name='CanVote'>No</gs:field> > </entry> > > > "Bah!" you say, "you are using column names". > > Ah yes, but you can bind the names to column-letters at whim, using the > Tables API [2]. You may even be able to use <gs:field > index="">value</gs:field> ... but I will leave that exciting enquiry to you > and the reference guide. > > Note that, just because the documentation says you should be able to do it, > doesn't mean I'm necessarily claiming the Tables/Records API will actually > work for you. But I'll be following your efforts with interest. > > > Also, if your original code were to work at all, it'd stand the best chance > if you used letters for column indexes instead of numbers. That's the clue > I pick up from the Tables API's naming conventions anyhow. > > > [1] > http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#CreatingTableRecords > [2] > http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#CreatingTables > >
