Inserting a record into spreadsheet with javascript

[Pallavi Vasishta]

Hi ,

We are trying to insert a record into spreadsheet's worksheet through 
javascript.

Please have a look at the code snippet below we are using where id,name etc 
are the column names,

function InsertRow()
{
 var service = new google.gdata.client.GoogleService('drutas');
 var entryObject = new google.gdata.atom.Entry();
 var contentTextObject = new google.gdata.atom.Text();
 var content = <entry xmlns="http://www.w3.org/2005/Atom";
                         
xmlns:gsx="http://schemas.google.com/spreadsheets/2006/extended";>
<gsx:id>1312</gsx:id>
<gsx:name>Elizabeth Bennet</gsx:name>
<gsx:time>02:00:00</gsx:time>
<gsx:company>paxcel</gsx:company>
<gsx:date>27/04/1990</gsx:date>
</entry>
   contentTextObject.setText(content);
 entryObject.setContent(contentTextObject);
 
service.insertEntry('https://spreadsheets.google.com/feeds/list/<spreadsheetId>/od6/private/full',entryObject,root,error);

}


We get error "Blank Rows cannot be inserted . Please use delete instead." 
Any help would be much appreciated.