def freeze(self, rows=None, cols=None, sheet=None):
"""
Freeze rows and/or columns for the open worksheet.
Parameters
----------
rows : int
number of rows to freeze, use 0 to 'unfreeze' (default None)
cols : int
number of columns to freeze, use 0 to 'unfreeze' (default None)
sheet : str,int,Worksheet
optional, if you want to open or create a
different sheet before freezing,
see :meth:`open_sheet <gspread_pandas.spread.Spread.open_sheet>`
(default None)
Returns
-------
None
"""
self._ensure_sheet(sheet)
if rows is None and cols is None:
return
self.spread.batch_update(
{"requests": create_frozen_request(self.sheet.id, rows, cols)})
self.refresh_spread_metadata()
def freeze(self, rows=None, cols=None, sheet=None):
"""
Freeze rows and/or columns for the open worksheet.
:param int rows: the DataFrame to save
:param int cols: whether to include the index in worksheet (default True)
:param str,int,Worksheet sheet: optional, if you want to open or create a different sheet
before freezing,
see :meth:`open_sheet <gspread_pandas.client.Spread.open_sheet>` (default None)
"""
if sheet:
self.open_sheet(sheet, create=True)
if not self.sheet:
raise Exception("No open worksheet")
if rows is None and cols is None:
return
sheet_id = self._sheet_metadata['properties']['sheetId']
req = {'requests': [create_frozen_request(sheet_id, rows, cols)]}
self.clientv4.batchUpdate(spreadsheetId=self.spread.id, body=req)\
.execute()
def freeze(self, rows=None, cols=None, sheet=None):
"""Freeze rows and/or columns for the open worksheet.
Parameters
----------
rows : int
the DataFrame to save (Default value = None)
cols : int
whether to include the index in worksheet (default True)
sheet : str,int,Worksheet
optional, if you want to open or create a
different sheet before freezing,
see :meth:`open_sheet <gspread_pandas.client.Spread.open_sheet>`
(default None)
Returns
-------
None
"""
if sheet:
self.open_sheet(sheet, create=True)
if not self.sheet:
raise NoWorksheetException("No open worksheet")
if rows is None and cols is None:
return
self.spread.batch_update(
{"requests": create_frozen_request(self.sheet.id, rows, cols)})
self.refresh_spread_metadata()
def test_create_frozen_request():
ret = util.create_frozen_request("", 1, 2)
assert isinstance(ret, dict)