Esempio n. 1
0
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_
Esempio n. 2
0
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