'''Created 29 Mar 2021 deeejas'''
import declarations as decl

d300 = decl.D300()

# d300_headers = ['cui', 'den', 'adresa', 'luna', 'an', 'd_rec', 'totalPlata_A', 'nrOPI',
                # 'bazaT', 'bazaL', 'bazaA', 'bazaP', 'bazaS', 'bazaR', 'total_baza']

d300.from_xml('sample_files/D300_22520381_2021_02.xml')
attrs = vars(d300)
d300_headers = []
excl_from_header = {'addr', 'decl_name', 'decl_func', 'root', 'rect', '_filename', 'def_root'}
for k in attrs.keys():
    if k not in excl_from_header:
        d300_headers.append(k)

print(d300_headers)

d300.to_xlsx('D300', 'data', decl.filter_files('D300', '.xml'), d300_headers, autofilter=[1, 0], freeze=[2, 1])
decl.file_open(d300.filename)
# print(d300)
#
#
# # print(attrs)
# print(d300.data)