Any type of help will be appreciated.
Thanks in advance
On Thursday, May 10, 2012 1:41:09 PM UTC+5:30, Pallavi Vasishta wrote:
>
> 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.
>
