creating excel look a like tables in python? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

creating excel look a like tables in python?

How do i create excel look a like tables in python? Do I need to use tkinter?

2nd Aug 2016, 8:50 AM
Michael Bosher
Michael Bosher - avatar
4 Answers
+ 4
Openpyxl module does that, check it out: https://code.sololearn.com/cGcw92Q6ZUjB/?ref=app
29th Mar 2017, 4:48 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 2
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.
2nd Aug 2016, 7:28 PM
Bailey
+ 1
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
3rd Aug 2016, 12:15 AM
Michael Bosher
Michael Bosher - avatar
+ 1
is it possible to reference cells if i make the spreadsheet using tkinter?
3rd Aug 2016, 2:03 AM
Michael Bosher
Michael Bosher - avatar