def filling_list_of_data(table, column, rastr_win):
list_ = []
getting_parameter_obj = GettingParameter(rastr_win=rastr_win)
count = getting_parameter_obj.get_count_table(table)
print(f'count={count}')
print(f"Количество строк в таблице {table}: {count}")
for i in range(count):
char = getting_parameter_obj.get_cell_row(table=table,
column=column,
row_id=i)
list_.append(char)
return list_
wb_skuns = load_workbook(
filename=r'C:\Users\Ohrimenko_AG\Desktop\BARS\ВетвиСкунс.xlsx')
ws_skuns = wb_skuns["Ветви"]
vetv_list_bars = []
for i in range(3, 1430):
create_data_list(list_vetv=vetv_list_bars, work_sheet=ws_skuns, index=i)
# load - SMZU
load_file(rastr_win=RASTR,
file_path=r'C:\Users\Ohrimenko_AG\Desktop\BARS\smzu_mega.mptsmz',
shabl=Shabl.without_shabl,
switch_command_line=True)
vetv_list_smzu = []
getting_parameter_obj = GettingParameter(rastr_win=RASTR)
count_smzu_vetv = getting_parameter_obj.get_count_table(Vetv.table)
for i in range(count_smzu_vetv):
create_data_smzu(list_vetv=vetv_list_smzu, i=i)
count_bars_vetv = len(vetv_list_bars)
for i in range(count_bars_vetv - 3):
name_bars = vetv_list_bars[i]['name']
tip_bars = vetv_list_bars[i]['tip']
ip_bars = vetv_list_bars[i]['ip']
iq_bars = vetv_list_bars[i]['iq']
np_bars = vetv_list_bars[i]['np']
r_bars = vetv_list_bars[i]['r']
x_bars = vetv_list_bars[i]['x']
b_bars = vetv_list_bars[i]['b']
ktr_bars = vetv_list_bars[i]['ktr']
g = 3