We need the “View” portion of an MVC model, written with wxPython, for editing an Excel (xlsx) document, stored in a dictionary of pandas.dataframe objects, as from the Pandas routine “pandas.read_excel(“path_to_file.xlsx”, sheetname = None). See documentation here:
The view should display the Excel grid with values in proper cells. Several menu items or buttons are required:
1) buttons that choose a color for highlighting (or boxing) cells in a given color
2) buttons that “Confirm” or “Cancel” once the user is happy that the correct cells are highlighted.
The contents of the cells should not be editable. When they don't have focus, individual cells with a formula will display the value calculated for the cell (provided from the Model). When clicked and have focus, the formula for a cell will display in a text box at the top of the window (similar to Excel).
Further details and clarification are available.