def __init__(self, sheet_index, base_name, xl_out_path, app_echo=True, save_per_worker=False): super(LaborHourDataXLWriter, self).__init__(xl_out_path, app_echo, save_per_worker) self.base_name = base_name self.lh_sheet = self.xl_app.Sheets((base_name + config.lh_suffix).decode('utf-8').encode('gbk')) self.w_sheet = self.xl_app.Sheets((base_name + config.w_suffix).decode('utf-8').encode('gbk')) self.m_sheet = self.xl_app.Sheets(u'首页'.encode('gbk')) xl_operator = ExcelOperator(config.XLS_PATH) self.worker_dict_x = dict(xl_operator.get_id_name_pairs_with_row_number(sheet_index)) self.main_worker_dict_x = dict(xl_operator.get_id_name_pairs_with_row_number(0)) self.write_dates()
def __init__(self, sheet_index, base_name, xl_out_path, app_echo=True, save_per_worker=False): super(PerformanceXLWriter, self).__init__(xl_out_path, app_echo, save_per_worker) self.perf_sheet = self.xl_app.Sheets((base_name + config.p_suffix).decode('utf-8').encode('gbk')) xl_operator = ExcelOperator(config.XLS_PATH) self.worker_dict_x = dict(xl_operator.get_id_name_pairs_with_row_number(sheet_index)) self.main_worker_dict_x = dict(xl_operator.get_id_name_pairs_with_row_number(0)) worker_dict = xl_operator.get_id_name_pairs(sheet_index) self.perf_data_provider = PerformanceDataProvider('', dict(worker_dict),dict(worker_dict), dict(xl_operator.get_attended_days_count_pairs()), dict(xl_operator.get_work_performance( config.p_index_offset + sheet_index )))