How to modify Grid cells from a Frame Class?

Question

I'm trying to reset a grid table to its initial state after some modifications made on it (some texts added and background changed). My first thought was to do a ForceRefresh() but it didn't seem to work. After that, I thought that I just have to set background to white and SetCellValue to blank in order to simulate a refresh but it didn't work too.

When I use:

self.SetCellBackgroundColour(0, 16, "#ffffff")

I got this error:

AttributeError: 'TestFrame' object has no attribute 'SetCellBackgroundColour'

My main problem is how to modify something in my Grid from a Frame class. I'm sure that I'm not doing it right hence my question here.

I would appreciate if someone can help me solve my problem.

Here is the part of my code that is problematic (see the last def):

import wx
import wx.grid as gridlib

class SimpleGrid(gridlib.Grid): ##, mixins.GridAutoEditMixin):
    def __init__(self, parent, log):
        gridlib.Grid.__init__(self, parent, -1)

        [... Some Code to Create the grid]

class TestFrame(wx.Frame):
    def __init__(self, parent, log):
        wx.Frame.__init__(self, parent, 0, "Native Ads Reports V1.0", size=(1400,800))
        self.grid = SimpleGrid(self, log)

        # Create a status-Bar
        status = self.CreateStatusBar()

        # Create menu & Items
        menubar = wx.MenuBar()
        first = wx.Menu()
        applyItem = first.Append(wx.ID_ANY, "Apply Changes", "This apply all changes to the campaigns" )
        resetItem = first.Append(wx.ID_ANY, "Reset Changes", "This Reset all changes to the campaigns" )
        menubar.Append(first, "Action")
        self.SetMenuBar(menubar)

        # Associate a handler function with the EVT_MENU
        self.Bind(wx.EVT_MENU, self.OnApply, applyItem)
        self.Bind(wx.EVT_MENU, self.OnReset, resetItem)

    def OnApply(self, event):
            """Apply all changes"""
            dlg = wx.MessageDialog(None, "Do you want to apply changes?",'Updater',wx.YES_NO | wx.ICON_QUESTION)
            result = dlg.ShowModal()
            if result == wx.ID_YES:
                self.count()
                from changeBid import changeBid
                changeBidTbBulk()

    #My problem is situated here. If the user clicks "Yes" in the dialog box the table should reset and all modifications should be deleted
    def OnReset(self, event):
            """Apply all changes"""
            dlg = wx.MessageDialog(None, "Do you want to reset all changes?",'Updater',wx.YES_NO | wx.ICON_QUESTION)
            result = dlg.ShowModal()
            if result == wx.ID_YES:
                db_conn.execute("DELETE FROM SandboxTB")
                db_conn.execute("DELETE FROM SandboxOB")
                db_conn.commit() 
                # Here I tried to change background
                self.SetCellBackgroundColour(0, 16, "#ffffff")
                #and here the refresh
                self.ForceRefresh()

Thank you,

Answer 1

I used self.grid.SetCellBackgroundColour and it worked.