123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081 |
- '''Created Dec 7, 2021 Levi'''
- # import time
- import xlsxwriter as xlsw
- class Writer(object):
- '''classdocs
- '''
- my_row, my_col = 0, 0
- range_row = 0
- book = xlsw.Workbook()
- w_sheet = book.add_worksheet()
- num_format = book.add_format()
- num_format.set_num_format('#,##0.00')
- def __init__(self, name):
- '''Constructor
- '''
- self.book.filename = name
- # self.w_sheet = self.book.add_worksheet(sh_name)
- # self.my_row, self.my_col = 0, 0
- @staticmethod
- def to_vat(cui, func, year=None, range_=None):
- for code in cui:
- vat_dict = func(code)
- for i in vat_dict[0]:
- Writer.my_row += 1
- print(i)
- Writer.w_sheet.write(Writer.my_row, 0, code)
- Writer.w_sheet.write(Writer.my_row, 1, i)
- Writer.w_sheet.write_row(Writer.my_row, 2, vat_dict[0][i])
- Writer.w_sheet.write(0, Writer.my_col, 'code mentor')
- for keys in vat_dict[1].keys():
- Writer.w_sheet.write(0, Writer.my_col + 1, keys)
- Writer.my_col += 1
- # Writer.w_sheet.set_column(3, 3, 50)
- Writer.w_sheet.autofilter(0, 0, len(cui), len(vat_dict[1].keys()) - 1)
- Writer.w_sheet.freeze_panes(1, 0)
- Writer.book.close()
- @staticmethod
- def to_cult(cui, func, year=None, range_=None):
- for code in cui:
- vat_dict = func(code)
- for i in vat_dict[0]:
- Writer.my_row += 1
- print(i)
- Writer.w_sheet.write(Writer.my_row, 0, code)
- Writer.w_sheet.write(Writer.my_row, 1, i)
- Writer.w_sheet.write_row(Writer.my_row, 2, vat_dict[0][i])
- Writer.w_sheet.write(0, Writer.my_col, 'code mentor')
- for keys in vat_dict[1].keys():
- Writer.w_sheet.write(0, Writer.my_col + 1, keys)
- Writer.my_col += 1
- # Writer.w_sheet.set_column(3, 3, 50)
- Writer.w_sheet.autofilter(0, 0, len(cui), len(vat_dict[1].keys()))
- Writer.w_sheet.freeze_panes(1, 0)
- Writer.book.close()
- @staticmethod
- def to_rep(cui, func, year=None, range_=None):
- if range_:
- for year_ in range(int(range_[:4]), int(range_[-4:]) + 1):
- Writer.range_row += 1
- for code in cui:
- vat_list = func(code, year_)
- Writer.my_row += 1
- Writer.w_sheet.write_row(Writer.my_row, 0, vat_list[1])
- else:
- for code in cui:
- vat_list = func(code, year)
- # for i in vat_list[1]:
- Writer.my_row += 1
- Writer.w_sheet.write_row(Writer.my_row, 0, vat_list[1])
- for keys in vat_list[0]:
- Writer.w_sheet.write(0, Writer.my_col, keys)
- Writer.my_col += 1
- Writer.w_sheet.set_column(5, 24, cell_format=Writer.num_format)
- Writer.w_sheet.autofilter(0, 0, len(cui), len(vat_list[1]))
- Writer.w_sheet.freeze_panes(1, 0)
- Writer.book.close()
|