HI,
On Mon, Oct 5, 2015 at 3:09 PM, Syed Mudassir Ahmed <[email protected]> wrote: > I wanted to insert one million rows. And each row has hundreds of > columns. As per API documentation, I have seen list-based (one row at a > time) and cell-based (one column at a time) approaches. > I want to speed up the process. Is there a way I can insert a bunch of > rows at a time to save time? This is high-priority. Anyone's help will be > greatly appreciated. > > as I know, only the update (and query) function(s) works in batch mode - insert (and delete) not: https://developers.google.com/google-apps/spreadsheets/ "Updating multiple cells with a batch request ... A number of batch operations can be combined into a single request. The two types of batch operations supported are query and update. insert and delete are not supported because the cells feed cannot be used to insert or delete cells. Remember that the worksheets feed must be used to do that." Hope this help, a. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
