'''
Created on Apr 21, 2020 @author: vnc-console
'''
from winmentor import (WinMentor,
                       Mentorutils,
                       check_list,
                       file_open)

exclude = ['KRALFA', 'CRH']

head = ['Denumire', 'CF', 'J', 'Adresa', 'Oras', 'Judet', 'Prescurtat', 'Obs']

mentor = WinMentor()
utils = Mentorutils()

office = mentor.filtered_firmlist(headers=head, ban=exclude)

firm_list = utils.gen_txt(file_name=None)
# utils.gen_txt(file_name='lista_cf.txt')
# print(firm_list)
check_list('xlsx/anaf_data', list_=firm_list)
# check_list(file_name='lista_cf.txt')
file_open('xlsx/anaf_data.xlsm')