Wow, I hadn't expected you to give me such a perfect example of difficulty with the Spreadsheets API :D
It's difficult because there is no concept of "create" on a cell, so there is no insert mode for the cells feed in batch mode. Cells always exist if the worksheet is big enough, and thus already have a value (even though the value is empty). Essentially, what you'd have to do is this: 1. Grab all the rows you want from the lists feed 2. Iterate over each row, and assign each cell a position 3. Grab all the same cells from the cells feed 4. Iterate over each cell, look up its value by position in your other data structure with the lists feed data 5. Take that value, and set it to the value of the current cell 6. Issue the batch update request to the cells feed -Vic On Fri, Mar 23, 2012 at 2:36 PM, David Hodge <[email protected]>wrote: > Vic, > > Thanks. The first answer makes sense. The second question is more > complicated, I think. > > So, I wanted to sort a spreadsheet, which as far as I can tell, you would > be dealing with the ListFeed. Once sorted, I wanted to write batch rows to > another spreadsheet using Cell Based method since you cannot do a batch > insert with List based objects. > > > Regards, > > > On Friday, March 23, 2012 2:22:14 PM UTC-4, Vic Fryzel wrote: >> >> On Thu, Mar 22, 2012 at 3:23 PM, David Hodge < >> [email protected]> wrote: >> >>> I want to get x number of worksheets in different spreadsheets, combine >>> the entries and sort on a certain column and loop thru each cell and >>> perform some logic. What is the best way to do this? >>> >>> I want to know if it is possible to: >>> >>> 1) Combine ListEntries from multiple worksheets in memory >>> >> This should be pretty straight forward. Just grab append the entries >> from each feed result into a single collection. Almost everything you need >> is here: >> >> https://developers.google.com/google-apps/spreadsheets/#retrieving_a_list-based_feed<https://developers.google.com/google-apps/spreadsheets/#retrieving_a_list-based_feed> >> >> >>> 2) Convert a ListFeed to a CellFeed >>> >> Can you explain why you want to do this? I suspect there is an easier >> way to achieve your ultimate goal. >> >> >>> >>> Regards, >>> >>> Dave >>> >>> >>
