def write_data(self, sheet: Worksheet, year_list): sheet.write_column(1, 0, asset_sheet_content_zh) col = 1 for year in year_list: sheet.write(0, col, str(year) + self.date) sheet.write_column(1, col, self.get_sheet(year).data_list) col += 1
def write_data(self, sheet: Worksheet, merge_format): """ write the indicator data to the indicator sheet :param sheet: indicator sheet which is a xlsxwriter.Worksheet instance """ col = 1 for year in self.year_list: year_data = self.year2data[year] sheet.write_column(6, col, year_data.data_list) col += 1 avg_col = 1 + len(self.year_list) # “行业平均”数据所在列 ratio_col = 1 + avg_col # “比率”数据所在列 sub_score_col = 1 + ratio_col # “分项能力”得分所在列 sheet.write_column(6, avg_col, self.avg_data) sheet.write_column(6, ratio_col, self.ratio) sheet.merge_range("%s:%s" % (xl_rowcol_to_cell(6, sub_score_col), xl_rowcol_to_cell(11, sub_score_col)), self.score, merge_format)