'''Created Jan 25, 2022 Levi'''

import declarations as decl

d100 = decl.D710()

headers = ['cod fiscal', 'den', 'luna', 'an', 'oblig', 'dat', 'dat_C', 'ded', 'ded_C', 'plata', 'plata_C', 'rest', 'rest_C', 'bonif', 'spons', 'spons_C', 'AMEF',
               'oblig', 'dat', 'dat_C', 'ded', 'ded_C', 'plata', 'plata_C', 'rest', 'rest_C', 'bonif', 'spons', 'spons_C', 'AMEF']

# d.from_xml('../D100_2021_6_17259191_generat.xml')
d100.to_xlsx('D710', 'data', decl.filter_files('D710'), headers, autofilter=[1, 0], freeze=[2, 1])
decl.file_open(d100.filename)