+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: GUI (https://python-forum.io/forum-10.html)
+--- Thread: VBA function convert to python by PysimpleGUI (/thread-39022.html)
VBA function convert to python by PysimpleGUI - SamLiu - Dec-21-2022
Hi All,
Tried to use PysimpleGUI instead of VBA could not do it, please help me check out it, thanks in advance!
Selected file pick up what I want column data and subtract with Target median value get delta then check delta whether in range or not,paint different background color to Text control.
If delta>=0.1 paint background color green.
If delta>=0.2 paint background color pink.
If delta>=0.3 paint background color red.
Last update delta value in each text control(1-35).
The VBA code and check file is attached for your reference.
import PySimpleGUI as sg
import pandas as pd
import os
working_directory=os.getcwd()
Standard_median=-38.1
sg.theme('Dark Brown 1')
headings = [['1]', '2]', '3]','4]','5]','6]','7]'],
['8]', '9]', '10]','11]','12]','13]','14]'],
['15]', '16]', '17]', '18]', '19]', '20]', '21]'],
['22]', '23]', '24]', '25]', '26]', '27]', '28]'],
['29]', '30]', '31]', '32]', '33]', '34]', '35]'],]
header = [[sg.Text(headings[row][col],size=(10,5),font=("Helvetica", 15),background_color='white',text_color='red')for col in range(7)] for row in range(5)]
BNT=[
[sg.Text('Selected File')],
[sg.InputText(key="-FILE_PATH-"),
sg.FilesBrowse(initial_folder=working_directory,file_types=[("CSV Files", "*.csv")])],
[sg.OK('Check Master',key='OK',size=(10,2)),sg.Exit(size=(10,2))]
]
input_rows = [[sg.Input(size=(15,1), pad=(0,0)) for col in range(4)] for row in range(10)]
layout=BNT+header
window = sg.Window('Master Check',layout,font='Courier 12')
def read_csv(csv_add):
df=pd.read_csv(csv_add,usecols=[597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,
626,627,628,629,630,631])
tt=df.values[-1].astype('float')-Standard_median
return tt
while True:
event,value = window.read()
if event in (sg.WIN_CLOSED,'Exit'):
break
elif event == "OK":
csv_add=value["-FILE_PATH-"]
print(read_csv(csv_add))
window.close()
RE: VBA function convert to python by PysimpleGUI - SamLiu - Dec-28-2022
Who can help me for the matter. My purpose is click button select *.csv pick up specific column data updated in Text control and compared value in which level then paint different background color with text control.
In other words, how to dynamic updated data in each text control(35 sites) and compared then paint color.