def get_category_group_value(range): book = xwu.get_book_from_range(range) sheet = xwu.get_sheet_from_range(range) row_no = range.row category_group_col_no = xwu.find_col_by_multi_metakey(['CategoryGroup'], sheet) category_group_value = sheet.range(row_no, category_group_col_no).value return category_group_value
def get_sales_order_params_by_range_legacy_tool(self, range): sheet = xwu.get_sheet_from_range(range) row = range.row column = range.column sales_order_params = {} partner_name_row_num = xwu.find_row_by_metakey(sheet, "PartnerName") sales_order_params[ "OrderRowId"] = self.get_order_row_id_by_row_no_legacy(sheet, row) sales_order_params["Partner"] = sheet.range(partner_name_row_num, column).value return sales_order_params
def validate_size(size_dict, range): sheet = xwu.get_sheet_from_range(range) size_range = str( sheet.range(range.row, xwu.find_col_by_metakey("SizeRange", sheet)).value) size_metakey = xwu.find_size_metakey_by_col(range.column, sheet) range_length = 0 try: range_length = len(size_dict[size_range].split(';')) except KeyError: range_length = len(size_dict[float(size_range)].split(';')) if (size_metakey > range_length): return False else: return True
def get_hub_level_budget_value_gbp(range): budget_sheet = xwu.get_sheet_from_range(range) row = range.row budget_value_gbp_col_no = xwu.find_col_by_multi_metakey( [c.HUB_LEVEL_BUDGET_VALUE_GBP_METAKEY], budget_sheet, col_start=7) return budget_sheet.range(row, budget_value_gbp_col_no).value
def get_hub_level_ly_actual_gbp(range): budget_sheet = xwu.get_sheet_from_range(range) row = range.row ly_actual_gbp_col_no = xwu.find_col_by_multi_metakey( [c.HUB_LEVEL_LY_ACTUAL_GBP_METAKEY], budget_sheet, col_start=7) return budget_sheet.range(row, ly_actual_gbp_col_no).value
def get_hub_level_partner_business_unit(range): budget_sheet = xwu.get_sheet_from_range(range) row = range.row partner_business_unit_col_no = xwu.find_col_by_multi_metakey( [c.HUB_LEVEL_PARTNER_BUSINESS_UNIT_METAKEY], budget_sheet) return budget_sheet.range(row, partner_business_unit_col_no).value
def get_hub_level_sub_category(range): budget_sheet = xwu.get_sheet_from_range(range) row = range.row sub_category_col_no = xwu.find_col_by_multi_metakey( [c.HUB_LEVEL_SUB_CATEGORY_METAKEY], budget_sheet) return budget_sheet.range(row, sub_category_col_no).value
def get_hub_level_partner_season(range): budget_sheet = xwu.get_sheet_from_range(range) row = range.row partner_season_col_no = xwu.find_col_by_multi_metakey( [c.HUB_LEVEL_PARTNER_SEASON_METAKEY], budget_sheet) return budget_sheet.range(row, partner_season_col_no).value
def get_brand_level_arcadia_season(range): budget_sheet = xwu.get_sheet_from_range(range) row = range.row arcadia_season_col_no = xwu.find_col_by_multi_metakey( [c.BRAND_LEVEL_ARCADIA_SEASON_METAKEY], budget_sheet) return budget_sheet.range(row, arcadia_season_col_no).value
def get_brand_level_budget_value_gbp(range): budget_sheet = xwu.get_sheet_from_range(range) row = range.row budget_value_gbp_no = xwu.find_col_by_multi_metakey( [c.BRAND_LEVEL_BUDGET_VALUE_GBP_METAKEY], budget_sheet) return budget_sheet.range(row, budget_value_gbp_no).value
def get_brand_level_budget_month(range): budget_sheet = xwu.get_sheet_from_range(range) row = range.row budget_month_col_no = xwu.find_col_by_multi_metakey( [c.BRAND_LEVEL_BUDGET_MONTH_METAKEY], budget_sheet) return budget_sheet.range(row, budget_month_col_no).value
def get_brand_level_department(range): budget_sheet = xwu.get_sheet_from_range(range) row = range.row department_col_no = xwu.find_col_by_multi_metakey( [c.BRAND_LEVEL_DEPARTMENT_METAKEY], budget_sheet) return budget_sheet.range(row, department_col_no).value