Question - last row in sheet

[ragardner]

Question - last row in sheet

[ragardner]

If your sheet widget is named sheet

For the last row, as the sheet stores data as a list of lists
print (self.sheet.get_sheet_data()[-1])

For the total number of data rows
print (len(self.sheet.get_sheet_data()))

And just in case for some unlikely reason there is a difference between the two, for the total number of displayed rows
print (len(self.sheet.get_row_heights()))

or more performance friendly:
print (len(self.sheet.get_row_heights(canvas_positions = True) - 1))

To set the data of the last row

self.sheet.set_row_data(len(self.sheet.get_sheet_data()) - 1,
                                ["changed " + str(i) for i in range(len(self.sheet.get_sheet_data()[-1]))])
self.sheet.refresh()

You will find these functions demonstrated in the readme file or the front page of this repository