pandas.ExcelWriter.write_cells#

ExcelWriter.write_cells(cells, sheet_name=None, startrow=0, startcol=0, freeze_panes=None)[source]#

Write given formatted cells into Excel an excel sheet

Deprecated since version 1.5.0.

Parameters
cellsgenerator

cell of formatted data to save to Excel sheet

sheet_namestr, default None

Name of Excel sheet, if None, then use self.cur_sheet

startrowupper left cell row to dump data frame
startcolupper left cell column to dump data frame
freeze_panes: int tuple of length 2

contains the bottom-most row and right-most column to freeze