Openpyxl module does that, check it out: https://code.sololearn.com/cGcw92Q6ZUjB/?ref=app
tkinter doesn't have that. You can use a few modules which can write to excel files but you have to view them through the excel program. Alternatively you could use tkinters grid layout which could display labels and other widgets in a grid layout similar to excel's.
I was researching two of the python wxcwl modules but they seemed inadequate. As i already have them automated so it would be a waste of time. As for the functionality i think python has some code to replace sumifs etc but if i made the spreadsheet using the tkinter grid manager entry and labels, how would i go about referencing the cells. my short term goal is to reproduce my timetable and its functionality in python but my long term goal is to make the graphics and interface 3d. at the moment i dont know enough code to dp either and the boks i m reading are technical and not easy for me to understand
is it possible to reference cells if i make the spreadsheet using tkinter?