Hello,
Thank you for your response.
But I don't get my answer "In your case, you want to insert entries into
the feed which specify values for the cells 'R1C1', 'R1C2', 'R1C3', etc"
but how to??
All I want to do is:
1. Create a worksheet
2. Add a worksheet
3. Add a header row
4. Populate with values i.e remaining data rows
Thats it!!
On Monday, October 29, 2012 6:05:59 PM UTC+1, David Bullock wrote:
>
> Hi Mandar,
>
> This is part of the (interesting) way the spreadsheet concepts have been
> mapped onto "feeds and entries". In the cells feed, an empty spreadsheet
> really does have 0 cells, despite the fact that (for display purposes,
> mainly) the worksheet feels that it has a height and width. You've got to
> 'insert' entries into the feed which represent cells.
>
> In your case, you want to insert entries into the feed which specify
> values for the cells 'R1C1', 'R1C2', 'R1C3', etc. Once you've done this,
> you'll be able to use the 'List' feed. The List feed assumes that whatever
> values appear in the first row (the 'header row') of the spreadsheet are
> 'column names'. When you use the List feed to append rows, you'll
> implicitly generate entries in the Cell feed.
>
> I hope that helps. You might be interested in the links to the old
> 'Protocol Reference' in this issue raised prospectively on your behalf some
> months ago
> http://code.google.com/a/google.com/p/apps-api-issues/issues/detail?id=3075&q=label%3AAPI-Spreadsheets&colspec=API%20ID%20Type%20Status%20Priority%20Stars%20Opened%20Summary
> (please
> vote for the issue if you find that old doc useful, thanks). At the end of
> the day, understanding what's going on at the ATOM/REST/XML level is the
> only key to insight.
>
> cheers,
> David.
>
>
>
>
> On Tue, Oct 30, 2012 at 1:17 AM, Mandar <[email protected]
> <javascript:>>wrote:
>
>> Hello,
>> Even if I try to use Cell based feed and add this code:
>> // Fetch the cell feed of the worksheet.
>>
>> CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);
>>
>>
>> CellFeed cellFeed = service.Query(cellQuery);
>>
>>
>> // Iterate through each cell, updating its value if necessary.
>>
>>
>> foreach (CellEntry cell in cellFeed.Entries)
>>
>>
>> {
>> if (cell.Title.Text == "A1")
>>
>>
>> {
>> cell.InputValue = "200";
>>
>>
>> cell.Update();
>>
>>
>> }
>> else if (cell.Title.Text == "B1")
>>
>>
>> {
>> cell.InputValue = "=SUM(A1, 200)";
>>
>>
>> cell.Update();
>>
>>
>> }
>> }
>>
>> I get the count of cellFeed.Entries as 0, so the control never enters
>> the foreach loop to update (i.e add) cell values at locations A1,B1 and so
>> on.
>> As mentioned before,I have already added rows and columns into the
>> worksheet.
>> Again big question how do I add a simple header row values at position
>> A1,B1,C1,D1. Why it is so unclear in the programmer's mind that if a
>> application is build using this API, everything will be via code.
>> I wait (desperately) for your next explanation on my above problem!!
>>
>> Thankx in advance.
>>
>>
>> On Thursday, October 25, 2012 6:16:58 PM UTC+2, Claudio Cherubino wrote:
>>
>>> When working with the list-based feed, the assumption is that the header
>>> row is already created. If you need to do everything from the script,
>>> including the spreadsheet creation, you should probably use the cell-based
>>> feed instead:
>>>
>>> https://developers.google.com/**google-apps/spreadsheets/#**
>>> working_with_cell-based_feeds<https://developers.google.com/google-apps/spreadsheets/#working_with_cell-based_feeds>
>>>
>>> Claudio
>>>
>>>
>>> On Thu, Oct 25, 2012 at 3:11 AM, Mandar <[email protected]> wrote:
>>>
>>>> Hello,
>>>> Thank you for your reply.
>>>> As per your post, I modified the structure of
>>>> my spreadsheet's worksheet while its creation. But, I still get the same
>>>> error.
>>>> Perhaps, if I manually add the header row and then add the row (as
>>>> provided in the documentation), then it is adding the row successfully;
>>>> But this is completely buggy, as I cannot manually insert a header
>>>> row after I create a worksheet. In programming terms the flow should be
>>>>
>>>> 1. Creating a spreadsheet
>>>> 2. Adding a worksheet
>>>> 3. Adding a row to worksheet
>>>>
>>>> I cannot add a header column in between manually!!!
>>>>
>>>> Kindly specify if I am doing something wrong or that is the way the API
>>>> is build?
>>>>
>>>> Thankx in Advance!!
>>>>
>>>> On Wednesday, October 24, 2012 8:37:34 PM UTC+2, Claudio Cherubino
>>>> wrote:
>>>>>
>>>>> As reported in the documentation, the list feed makes some assumptions
>>>>> about how the data is laid out in the spreadsheet. In particular, the
>>>>> list
>>>>> feed treats the first row of the worksheet as a header row:
>>>>>
>>>>> https://developers.google.com/****google-apps/spreadsheets/#**work**
>>>>> ing_with_list-based_feeds<https://developers.google.com/google-apps/spreadsheets/#working_with_list-based_feeds>
>>>>>
>>>>> In your code you are trying to add a row with four values: firstname,
>>>>> lastname, age and height. If the first row of the worksheet doesn't
>>>>> define
>>>>> those headers, your request will be invalid and your code throw an
>>>>> exception.
>>>>>
>>>>> Please make sure that your code matches the structure of the
>>>>> spreadsheet or use the Cell feed if you need to dynamically determine the
>>>>> contents of the header row.
>>>>>
>>>>> On Wednesday, October 24, 2012 8:27:56 AM UTC-7, Mandar wrote:
>>>>>>
>>>>>> Hello,
>>>>>> Is this forum alive? I am continuing to get 400 response error for
>>>>>> adding a row via google spreadsheet api and their isn't any support from
>>>>>> on
>>>>>> this from google admins. Is this API a release version or in alpha phase.
>>>>>> We are using this api for commercial purposes so answer is
>>>>>> expected after similar posts (of error messages) from other users as
>>>>>> well.
>>>>>>
>>>>>> Thankx in advance.
>>>>>>
>>>>>>
>>>>>> Le mercredi 24 octobre 2012 12:11:29 UTC+2, Mandar a écrit :
>>>>>>>
>>>>>>> Hello All,
>>>>>>> I am new to this forum.
>>>>>>> I am recently using Google spreadsheet API **f**or creating
>>>>>>> spreadsheets and store data on them.
>>>>>>> I have followed the entire tut with specifying oAuth scopes and
>>>>>>> enabling drive sdk.
>>>>>>> I am successfully able to create a spreadsheet and add a worksheet
>>>>>>> too, but when I try to add a new row its gives me a exception : {"The
>>>>>>> remote server returned an error: (400) Bad Request."}
>>>>>>> Moreover, I am also able to delete and update a row if I add one
>>>>>>> manually on the spreadsheets, so I don't understand what is wrong
>>>>>>> in my code (or if their is error on google server side?).
>>>>>>> Also,the version 3 of API is just released and their isn't any
>>>>>>> support on the bugs from Google admins/developers.
>>>>>>>
>>>>>>> Anyone knowing plz help!!
>>>>>>> Thankx in advance.
>>>>>>>
>>>>>>
>>>
>
