xlwings issue using Python 3 -
i'm making database-ish python 3 program saves tkinter
entries excel file. using xlwings
, please find solution xlwings
. anyways, here issue:
from tkinter import * import xlwings xw def save() : entrylist = [entry1.get(), entry2.get(), entry3.get(), entry4.get(), entry5.get(), entry6.get(), entry7.get(), entry8.get(), entry9.get()] if len(entrylist[i]) != 0 , entry2.get() == entry3.get(): teller = int(xw.range('m1').value) + 1 in range(0,3): rowlist = ["a"+ str(teller), "b"+ str(teller), "c"+str(teller), "d"+str(teller)] rowcode = "\'"+ rowlist[i] + "\'" xw.range(rowcode).value = entrylist[i] xw.range('m1').value = teller wb.save('klantendatabase.xlsx')
now problem following piece of code not allowed:
xw.range(rowcode).value = entrylist[i]
this allowed (a1 example cellnumber excel file)::
xw.range('a1').value = entrylist[i]
is there way make xw.range().value
take variable?
make sure set service run on https set rather http. port 8080 reliable security. after run code in debug mode , run database diff source code. should take care of log messages.
Comments
Post a Comment