import tkinter as Tk
import xlsxwriter 
import  openpyxl, xlrd, xlwt
from tkinter import *
from tkinter import messagebox as mb
from tkinter import ttk
#Excel
root = Tk()
root.title("Добавление детали")
root.geometry("250x350")
#текстовые поля
label1 = Label(root, text = "тип тс", bg = "green", fg = "white")
label2 = Label(root, text = "гос.номер", bg = "green", fg = "white")
label3 = Label(root, text = "наименование детали", bg = "red", fg = "white")
label4 = Label(root, text = "цена", bg = "red", fg = "white")
label5 = Label(root, text = "количество", bg = "red", fg = "white")
label1.pack( anchor=NW)
combo1 = ttk.Combobox(
                            values=[
                                    ])
combo1.pack(anchor=NW)
label2.pack(  anchor=NW)
combo2 = ttk.Combobox(
                            values=[
                                    ])
combo2.pack(anchor=NW)
label3.pack(anchor=SW)
input3 = Entry(root, width = 20, bd = 3)
input3.pack( anchor=SW)
label4.pack( anchor=SW)
input4 = Entry(root, width = 20, bd = 3)
input4.pack( anchor=SW)
label5.pack( anchor=SW)
input5 = Entry(root, width = 20, bd = 3)
input5.pack( anchor=SW)
btn = Button(text="Внести")
btn.pack(anchor=SW)
root.mainloop()

 import win32com.client
import tkinter as Tk
from tkinter import *
from tkinter import messagebox as mb
from tkinter import ttk
#Excel
root = Tk()
root.title("Добавление детали")
root.geometry("250x350")
#текстовые поля
label1 = Label(root, text = "тип тс", bg = "green", fg = "white")
label2 = Label(root, text = "гос.номер", bg = "green", fg = "white")
label3 = Label(root, text = "наименование детали", bg = "red", fg = "white")
label4 = Label(root, text = "цена", bg = "red", fg = "white")
label5 = Label(root, text = "количество", bg = "red", fg = "white")
label1.pack( anchor=NW)
combo1 = ttk.Combobox(
                            values=[
                                    ])
combo1.pack(anchor=NW)
label2.pack(  anchor=NW)
combo2 = ttk.Combobox(
                            values=[
                                    ])
combo2.pack(anchor=NW)
label3.pack(anchor=SW)
input3 = Entry(root, width = 20, bd = 3)
input3.pack( anchor=SW)
label4.pack( anchor=SW)
input4 = Entry(root, width = 20, bd = 3)
input4.pack( anchor=SW)
label5.pack( anchor=SW)
input5 = Entry(root, width = 20, bd = 3)
input5.pack( anchor=SW)
Excel = win32com.client.Dispatch("Excel.Application")
wb = Excel.Workbooks.Open(u'C:\\Users\\Мих Мих\\Documents\\OpenOffice\\test.ods')
sheet = wb.ActiveSheet
val = sheet.Cells(1,1).value
def ins():
	sheet.Cells(1, 1).value = input5.get()
	wb.Save()
def click():
	ins()
btn = Button(text="Внести",command = click)
btn.pack(anchor=SW)
root.mainloop()