How do I rename a (work)sheet in a Google Sheets spreadsheet using the API in Python? -

-

i have been trying/looking solve problem long while. have read documentation gspread , cannot find there way rename worksheet. of know how to? massively appreciate it! there indeed worksheet.title gives name of worksheet, cannot find way rename actual sheet.

thank in advance!

this extraction of library i've coded personally:

def _batch(self, requests):     body = {         'requests': requests     }     return self._service.spreadsheets().batchupdate(spreadsheetid=self.spreadsheetid, body=body).execute()  def renamesheet(self, sheetid, newname):     return self._batch({         "updatesheetproperties": {             "properties": {                 "sheetid": sheetid,                 "title": newname,             },             "fields": "title",         }     })

i think little effort, can implement code , obtain want. in order make batchupdate call, need spreadsheetid initialized service explained in python quickstart - google sheet api


Comments

Post a Comment

Popular posts from this blog

testing - Detect whether test has failed within fixture -

-
i debugging intermittent test failure. purposes want dump lot of debug information if test failed. dumping debug stuff quite slow process produces lot of data, not want every test. i using pytest , yield autouse fixture should work great @pytest.yield_fixture(scope="function", autouse=true) def dump_on_failue(request): prepare_debug_dump() yield if test_failed(request): debug_dump() the problem can't figure out how detect whether test has failed or not. there a questions already , note on pytest website : if request.node.rep_setup.failed: print ("setting test failed!", request.node.nodeid) elif request.node.rep_setup.passed: if request.node.rep_call.failed: print ("executing test failed", request.node.nodeid) unfortunately code not work anymore. there no rep_setup , rep_calls symbols in node object. tried dig request , node object, no luck. anybody knows how detect whether test ...
Read more

Android: SharingActionView on swipe from bottom -

-
Image
i share data other apps, don't want standard popup appears bottom tool bar; want kind of view: i followed official document: https://developer.android.com/training/sharing/shareaction.html so there native component in android sdk? or there library that? thank guys! you can : first create menu item : <menu xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" xmlns:tools="http://schemas.android.com/tools" tools:context="com.example.rashish.myapplication.mainactivity"> <item android:id="@+id/action_share" android:orderincategory="100" android:title="@string/action_settings" android:icon="@android:drawable/ic_menu_share" app:showasaction="always" /> </menu> then create method show intent chooser dialog, : private void share() { string te...
Read more

AbotX : How do you create a parallel crawler that stays on and can be added to at run time from new requests -

-
i have parallelcrawlerengine setup singleton , have alwaysonsitetocrawlprovider set singleton , passed parallelcrawlerengine. i can instantiate , leave nothing ok. can add site , crawl ok. if add site not crawl second site. i have looked @ example on site doesn't appear show how work , have new items added after initial execution. using .addsitestocrawl() adds them list seems stay in purgatory state of not being read. looking through logs 'site completed' message though site has not been recrawled [2016-07-11 11:17:18,361] [20 ] [info ] - crawl domain [http://www.existingsite.com/] completed in [0.0001118] seconds, crawled [361] pages and error if add new site [2016-07-11 11:17:33,365] [23 ] [error] - crawl domain [http://www.newsite.com/] failed after [0.0066498] seconds, crawled [361] pages [2016-07-11 11:17:33,365] [23 ] [error] - system.invalidoperationexception: cannot call dowork() after abortall() or dispose() have been called. @ abot.util.thre...
Read more