Using DeleteRow(), I was able to delete all the rows in a worksheet except for a single header row above the freeze bar. The web interface doesn't seem to allow you to get a worksheet into this state. When trying to add some blank rows by setting row_count.text, I encountered a fun error message:
gdata.service.RequestError: {'status': 503, 'body': 'You can't insert a row here right now. Try dragging the freeze bar to the top, then insert the row.', 'reason': 'Service Unavailable'} Regards, Chris --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com To unsubscribe from this group, send email to google-docs-data-apis+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---