python生成多种json报文（排列组合，自动读取excel文件信息）

# -*- coding:utf-8 -*-
import json
import sys
# from  xlrd import open_workbook
import xlrd
import xlwt

# reload(sys)
# sys.setdefaultencoding("utf-8")
readbook = xlrd.open_workbook("C:\\Users\")#文件所在路径

total = {"GR_A1": "","GR_A2": "", "GR_B1": "", "GR_B2": "", "GR_B3": "", "GR_B41": "", "GR_C1": "","GR_C11": "","GR_C21": "",
         "GR_C22": "", "GR_C23": "", "GR_C24": "","GR_C31": "", "GR_C32": "", "GR_C33": "", "GR_C34": "",
         "GR_D1": "", "GR_D2": "","GR_D31": "", "GR_D32": "", "GR_D33": "", "GR_D34": "","GR_D41": "", "GR_D42": "", "GR_D43": "", "GR_D44": "","GR_D51": "",
         "GR_D52": "", "GR_D53": "", "GR_D54": "","GR_D6": "", "GR_E1": "","GR_E21": "", "GR_E22": "",
         "GR_E3": "", "GR_E4": "","GR_E51": "", "GR_E52": "","GR_E6": "","GR_E7": "", "GR_E8": "", "GR_E9": "",
         "GR_E10": "", "GR_F1": "", "GR_F2": "", "GR_G1": "", "GR_G2": ""}
total1={}#total1暂时保存所有的必填项
# total["A"] = {"GR_A1": "", "GR_A2": ""}
# total["B"] = {"GR_B1": "", "GR_B2": "", "GR_B3": "", "GR_B41": ""}
# total["C"] = {"GR_C1": "", "C2": {"GR_C21": "", "GR_C22": "", "GR_C23": "", "GR_C24": ""},
#               "C3": {"GR_C31": "", "GR_C32": "", "GR_C33": "", "GR_C34": ""}}
# total["D"] = {"GR_D1": "", "GR_D2": "", "D3": {"GR_D31": "", "D32": "", "GR_D33": "", "GR_D34": ""},
#               "D4": {"GR_D41": "", "GR_D42": "", "GR_D43": "", "GR_D44": ""}, "D5": {"GR_D51": "", "GR_D52": "", "GR_D53": "", "GR_D54": ""},
#               "GR_D6": ""}
# total["E"] = {"GR_E1": "", "E2": {"GR_E21": "", "GR_E22": ""}, "GR_E3": "", "GR_E4": "", "E5": {"GR_E51": "", "GR_E52": ""}, "GR_E6": "",
#               "GR_E7": "", "GR_E8": "", "GR_E9": "", "GR_E10": "", }
# total["F"] = {"GR_F1": "", "GR_F2": ""}
# total["G"] = {"GR_G1": "", "GR_G2": ""}

sheet_name = readbook.sheet_names()  # 打印所有sheet名称，是个列表
sheet1 = readbook.sheet_by_index(1)  # 根据sheet索引读取sheet中的所有内容
sheet2 = readbook.sheet_by_index(2)
sheet3 = readbook.sheet_by_index(3)
sheet4 = readbook.sheet_by_index(4)
sheet5 = readbook.sheet_by_index(5)
sheet6 = readbook.sheet_by_index(6)
sheet7 = readbook.sheet_by_index(7)

# print(sheet.name, sheet.nrows, sheet.ncols)
# print(sheet_name)
# print(total)

# sheet1=readbook.sheet_by_name("A报告头")
# content1=sheet1.col_values(1)
temp={}

"""=======================A报告头==================="""

GR_A1 = {}
for i in range(3):
    GR_A1[sheet1.cell(i + 3, 1).value] = sheet1.cell(i + 3, 6).value
for i in GR_A1:
    if("ReportNo" in GR_A1):
        total['GR_A1']={'ReportNo':GR_A1['ReportNo']}
    # if("Id"in GR_A1):
    #     total['GR_A1'].update({'Id':GR_A1['Id']})
GR_A2 = {}
for i in range(7):
    GR_A2[sheet1.cell(i + 9, 1).value] = sheet1.cell(i + 9, 6).value
for i in GR_A2:
    if("ReportNo" in GR_A2):
        total['GR_A2']={'ReportNo':GR_A2['ReportNo']}
    if("Id"in GR_A2):
        total['GR_A2'].update({'Id':GR_A2['Id']})
print('tot================================================================================================al')
print(total)
"""====================B个人基本信息================="""
GR_B1 = {}
for i in range(12):
    GR_B1[sheet2.cell(i + 3, 1).value] = sheet2.cell(i + 3, 6).value
for i in GR_B1:
    if("ReportNo" in GR_B1):
        total['GR_B1']={'ReportNo':GR_B1['ReportNo']}
    if("Id"in GR_B1):
        total['GR_B1'].update({'Id':GR_B1['Id']})

GR_B2 = {}
for i in range(7):
    GR_B2[sheet2.cell(i + 18, 1).value] = sheet2.cell(i + 18, 6).value
for i in GR_B2:
    if("ReportNo" in GR_B2):
        total['GR_B2']={'ReportNo':GR_B2['ReportNo']}
    if("Id"in GR_B2):
        pass
    total['GR_B2'].update({'Id':GR_B2['Id']})
# print(total)

GR_B3 = {}
for i in range(5):
    GR_B3[sheet2.cell(i + 29, 1).value] = sheet2.cell(i + 29, 6).value
for i in GR_B3:
    if("ReportNo" in GR_B3):
        total['GR_B3']={'ReportNo':GR_B3['ReportNo']}
    if("Id"in GR_B3):
        total['GR_B3'].update({'Id':GR_B3['Id']})
GR_B41 = {}
for i in range(10):
    GR_B41[sheet2.cell(i + 38, 1).value] = sheet2.cell(i + 38, 6).value
for i in GR_B41:
    if("ReportNo" in GR_B41):
        total['GR_B41']={'ReportNo':GR_B41['ReportNo']}
    if("Id"in GR_B41):
        total['GR_B41'].update({'Id':GR_B41['Id']})
# print(GR_B41)
"""====================C信息概要================="""

GR_C1 = {}
for i in range(14):
    GR_C1[sheet3.cell(i + 3, 1).value] = sheet3.cell(i + 3, 6).value
for i in GR_C1:
    if("ReportNo" in GR_C1):
        total['GR_C1']={'ReportNo':GR_C1['ReportNo']}
    if("Id"in GR_C1):
        total['GR_C1'].update({'Id':GR_C1['Id']})
GR_C11 = {}
for i in range(4):
    GR_C11[sheet3.cell(i + 21, 1).value] = sheet3.cell(i + 21, 6).value
for i in GR_C11:
    if("ReportNo" in GR_C11):
        total['GR_C11']={'ReportNo':GR_C11['ReportNo']}
    if("Id"in GR_C11):
        total['GR_C1'].update({'Id':GR_C11['Id']})
# C2 = {}
GR_C21 = {}
for i in range(4):
    GR_C21[sheet3.cell(i + 29, 1).value] = sheet3.cell(i + 29, 6).value
for i in GR_C21:
    if("ReportNo" in GR_C21):
        total['GR_C21']={'ReportNo':GR_C21['ReportNo']}
    if("Id"in GR_C21):
        total['GR_C21'].update({'Id':GR_C21['Id']})
GR_C22 = {}
for i in range(4):
    GR_C22[sheet3.cell(i + 37, 1).value] = sheet3.cell(i + 37, 6).value
for i in GR_C22:
    if("ReportNo" in GR_C22):
        total['GR_C22']={'ReportNo':GR_C22['ReportNo']}
    if("Id"in GR_C22):
        total['GR_C22'].update({'Id':GR_C22['Id']})
GR_C23 = {}
for i in range(4):
    GR_C23[sheet3.cell(i + 45, 1).value] = sheet3.cell(i + 45, 6).value
for i in GR_C23:
    if("ReportNo" in GR_C23):
        total['GR_C23']={'ReportNo':GR_C23['ReportNo']}
    if("Id"in GR_C23):
        total['GR_C23'].update({'Id':GR_C23['Id']})
GR_C24 = {}
for i in range(14):
    GR_C24[sheet3.cell(i + 53, 1).value] = sheet3.cell(i + 53, 6).value
for i in GR_C24:
    if("ReportNo" in GR_C24):
        total['GR_C24']={'ReportNo':GR_C24['ReportNo']}
    if("Id"in GR_C24):
        total['GR_C24'].update({'Id':GR_C24['Id']})
GR_C31 = {}
for i in range(8):
    GR_C31[sheet3.cell(i + 71, 1).value] = sheet3.cell(i + 71, 6).value
for i in GR_C31:
    if("ReportNo" in GR_C31):
        total['GR_C31']={'ReportNo':GR_C31['ReportNo']}
    if("Id"in GR_C31):
        total['GR_C31'].update({'Id':GR_C31['Id']})
GR_C32 = {}
for i in range(10):
    GR_C32[sheet3.cell(i + 83, 1).value] = sheet3.cell(i + 83, 6).value
for i in GR_C32:
    if("ReportNo" in GR_C32):
        total['GR_C32']={'ReportNo':GR_C32['ReportNo']}
    if("Id"in GR_C32):
        total['GR_C32'].update({'Id':GR_C32['Id']})
GR_C33 = {}
for i in range(10):
    GR_C33[sheet3.cell(i + 97, 1).value] = sheet3.cell(i + 97, 6).value
for i in GR_C33:
    if("ReportNo" in GR_C33):
        total['GR_C33']={'ReportNo':GR_C33['ReportNo']}
    if("Id"in GR_C33):
        total['GR_C33'].update({'Id':GR_C33['Id']})
GR_C34 = {}
for i in range(5):
    GR_C34[sheet3.cell(i + 111, 1).value] = sheet3.cell(i + 111, 6).value
for i in GR_C34:
    if("ReportNo" in GR_C34):
        total['GR_C34']={'ReportNo':GR_C34['ReportNo']}
    if("Id"in GR_C34):
        total['GR_C34'].update({'Id':GR_C34['Id']})

"""====================D信贷交易信息明细================="""

"""
for i in range():
    [sheet4.cell(i+,1).value]=sheet4.cell(i+,6).value

"""
GR_D1 = {}
for i in range(7):
    GR_D1[sheet4.cell(i + 3, 1).value] = sheet4.cell(i + 3, 6).value
for i in GR_D1:
    if("ReportNo" in GR_D1):
        total['GR_D1']={'ReportNo':GR_D1['ReportNo']}
    if("Id"in GR_D1):
        total['GR_D1'].update({'Id':GR_D1['Id']})
    if("LoanNo" in GR_D1):
        total['GR_D1'].update({'LoanNo':GR_D1['LoanNo']})
GR_D2 = {}
for i in range(7):
    GR_D2[sheet4.cell(i + 14, 1).value] = sheet4.cell(i + 14, 6).value
for i in GR_D2:
    if("ReportNo" in GR_D2):
        total['GR_D2']={'ReportNo':GR_D2['ReportNo']}
    if("Id"in GR_D2):
        total['GR_D2'].update({'Id':GR_D2['Id']})
    if("LoanNo" in GR_D2):
        total['GR_D2'].update({'LoanNo':GR_D2['LoanNo']})
GR_D31 = {}
for i in range(16):
    GR_D31[sheet4.cell(i + 25, 1).value] = sheet4.cell(i + 25, 6).value
for i in GR_D31:
    if("ReportNo" in GR_D31):
        total['GR_D31']={'ReportNo':GR_D31['ReportNo']}
    if ("Id" in GR_D31):
        total['GR_D31'].update({'Id': GR_D31['Id']})
    if ("LoanNo" in GR_D31):
        total['GR_D31'].update({'LoanNo': GR_D31['LoanNo']})
GR_D32 = {}
for i in range(47):
    GR_D32[sheet4.cell(i + 45, 1).value] = sheet4.cell(i + 45, 6).value
for i in GR_D32:
    if("ReportNo" in GR_D32):
        total['GR_D32']={'ReportNo':GR_D32['ReportNo']}
    if ("Id" in GR_D32):
        total['GR_D32'].update({'Id': GR_D32['Id']})
    if ("LoanNo" in GR_D32):
        total['GR_D32'].update({'LoanNo': GR_D32['LoanNo']})
GR_D33 = {}
for i in range(31):
    GR_D33[sheet4.cell(i + 96, 1).value] = sheet4.cell(i + 96, 6).value
for i in GR_D33:
    if("ReportNo" in GR_D33):
        total['GR_D33']={'ReportNo':GR_D33['ReportNo']}
    if ("Id" in GR_D33):
        total['GR_D33'].update({'Id': GR_D33['Id']})
    if ("LoanNo" in GR_D33):
        total['GR_D33'].update({'LoanNo': GR_D33['LoanNo']})
GR_D34 = {}
for i in range(31):
    GR_D34[sheet4.cell(i + 131, 1).value] = sheet4.cell(i + 131, 6).value
for i in GR_D34:
    if("ReportNo" in GR_D34):
        total['GR_D34']={'ReportNo':GR_D34['ReportNo']}
    if ("Id" in GR_D34):
        total['GR_D34'].update({'Id': GR_D34['Id']})
    if ("LoanNo" in GR_D34):
        total['GR_D34'].update({'LoanNo': GR_D34['LoanNo']})
GR_D41 = {}
for i in range(13):
    GR_D41[sheet4.cell(i + 166, 1).value] = sheet4.cell(i + 166, 6).value
for i in GR_D41:
    if("ReportNo" in GR_D34):
        total['GR_D41']={'ReportNo':GR_D41['ReportNo']}
    if ("Id" in GR_D34):
        total['GR_D41'].update({'Id': GR_D41['Id']})
    if ("LoanNo" in GR_D34):
        total['GR_D41'].update({'LoanNo': GR_D41['LoanNo']})
GR_D42 = {}
for i in range(40):
    GR_D42[sheet4.cell(i + 182, 1).value] = sheet4.cell(i + 182, 6).value
for i in GR_D42:
    if("ReportNo" in GR_D34):
        total['GR_D42']={'ReportNo':GR_D42['ReportNo']}
    if ("Id" in GR_D34):
        total['GR_D42'].update({'Id': GR_D42['Id']})
    if ("LoanNo" in GR_D34):
        total['GR_D42'].update({'LoanNo': GR_D42['LoanNo']})
GR_D43 = {}
for i in range(28):
    GR_D43[sheet4.cell(i + 226, 1).value] = sheet4.cell(i + 226, 6).value
for i in GR_D43:
    if("ReportNo" in GR_D34):
        total['GR_D43']={'ReportNo':GR_D43['ReportNo']}
    if ("Id" in GR_D34):
        total['GR_D43'].update({'Id': GR_D43['Id']})
    if ("LoanNo" in GR_D34):
        total['GR_D43'].update({'LoanNo': GR_D43['LoanNo']})
GR_D44 = {}
for i in range(18):
    GR_D44[sheet4.cell(i + 258, 1).value] = sheet4.cell(i + 258, 6).value
for i in GR_D44:
    if("ReportNo" in GR_D34):
        total['GR_D44']={'ReportNo':GR_D44['ReportNo']}
    if ("Id" in GR_D34):
        total['GR_D44'].update({'Id': GR_D44['Id']})
    if ("LoanNo" in GR_D34):
        total['GR_D44'].update({'LoanNo': GR_D44['LoanNo']})
GR_D51 = {}
for i in range(13):
    GR_D51[sheet4.cell(i + 280, 1).value] = sheet4.cell(i + 280, 6).value
for i in GR_D51:
    if("ReportNo" in GR_D34):
        total['GR_D51']={'ReportNo':GR_D51['ReportNo']}
    if ("Id" in GR_D34):
        total['GR_D51'].update({'Id': GR_D51['Id']})
    if ("LoanNo" in GR_D34):
        total['GR_D51'].update({'LoanNo': GR_D51['LoanNo']})
GR_D52 = {}
for i in range(38):
    GR_D52[sheet4.cell(i + 297, 1).value] = sheet4.cell(i + 297, 6).value
for i in GR_D52:
    if("ReportNo" in GR_D34):
        total['GR_D52']={'ReportNo':GR_D52['ReportNo']}
    if ("Id" in GR_D34):
        total['GR_D52'].update({'Id': GR_D52['Id']})
    if ("LoanNo" in GR_D34):
        total['GR_D52'].update({'LoanNo': GR_D52['LoanNo']})
GR_D53 = {}
for i in range(28):
    GR_D53[sheet4.cell(i + 339, 1).value] = sheet4.cell(i + 339, 6).value
for i in GR_D53:
    if("ReportNo" in GR_D53):
        total['GR_D53']={'ReportNo':GR_D53['ReportNo']}
    if ("Id" in GR_D53):
        total['GR_D53'].update({'Id': GR_D53['Id']})
    if ("LoanNo" in GR_D53):
        total['GR_D53'].update({'LoanNo': GR_D53['LoanNo']})
GR_D54 = {}
for i in range(18):
    GR_D54[sheet4.cell(i + 371, 1).value] = sheet4.cell(i + 371, 6).value
for i in GR_D54:
    if("ReportNo" in GR_D54):
        total['GR_D54']={'ReportNo':GR_D54['ReportNo']}
    if ("Id" in GR_D54):
        total['GR_D54'].update({'Id': GR_D54['Id']})
    if ("LoanNo" in GR_D54):
        total['GR_D54'].update({'LoanNo': GR_D54['LoanNo']})
GR_D6 = {}
for i in range(10):
    GR_D6[sheet4.cell(i + 394, 1).value] = sheet4.cell(i + 394, 6).value
for i in GR_D6:
    if("ReportNo" in GR_D6):
        total['GR_D6']={'ReportNo':GR_D6['ReportNo']}
    if("Id"in GR_D6):
        total['GR_D6'].update({'Id':GR_D6['Id']})
GR_E1 = {}
for i in range(5):
    GR_E1[sheet5.cell(i + 3, 1).value] = sheet5.cell(i + 3, 6).value
for i in GR_E1:
    if("ReportNo" in GR_E1):
        total['GR_E1']={'ReportNo':GR_E1['ReportNo']}
    if("Id"in GR_E1):
        total['GR_E1'].update({'Id':GR_E1['Id']})
GR_E21 = {}
for i in range(10):
    GR_E21[sheet5.cell(i + 12, 1).value] = sheet5.cell(i + 12, 6).value
for i in GR_E21:
    if("ReportNo" in GR_E21):
        total['GR_E21']={'ReportNo':GR_E21['ReportNo']}
    if ("Id" in GR_E21):
        total['GR_E21'].update({'Id': GR_E21['Id']})
GR_E22 = {}
for i in range(12):
    GR_E22[sheet5.cell(i + 26, 1).value] = sheet5.cell(i + 26, 6).value
for i in GR_E22:
    if("ReportNo" in GR_E22):
        total['GR_E22']={'ReportNo':GR_E22['ReportNo']}
    if ("Id" in GR_E22):
        total['GR_E22'].update({'Id': GR_E22['Id']})
GR_E3 = {}
for i in range(8):
    GR_E3[sheet5.cell(i + 42, 1).value] = sheet5.cell(i + 42, 6).value
for i in GR_E3:
    if("ReportNo" in GR_E3):
        total['GR_E3']={'ReportNo':GR_E3['ReportNo']}
    if ("Id" in GR_E3):
        total['GR_E3'].update({'Id': GR_E3['Id']})
GR_E4 = {}
for i in range(12):
    GR_E4[sheet5.cell(i + 54, 1).value] = sheet5.cell(i + 54, 6).value
for i in GR_E4:
    if("ReportNo" in GR_E4):
        total['GR_E4']={'ReportNo':GR_E4['ReportNo']}
    if ("Id" in GR_E4):
        total['GR_E4'].update({'Id': GR_E4['Id']})
GR_E51 = {}
for i in range(12):
    GR_E51[sheet5.cell(i + 70, 1).value] = sheet5.cell(i + 70, 6).value
for i in GR_E51:
    if("ReportNo" in GR_E51):
        total['GR_E51']={'ReportNo':GR_E51['ReportNo']}
    if ("Id" in GR_E51):
        total['GR_E51'].update({'Id': GR_E51['Id']})
GR_E52 = {}
for i in range(10):
    GR_E52[sheet5.cell(i + 87, 1).value] = sheet5.cell(i + 87, 6).value
for i in GR_E52:
    if("ReportNo" in GR_E52):
        total['GR_E52']={'ReportNo':GR_E52['ReportNo']}
    if ("Id" in GR_E52):
        total['GR_E52'].update({'Id': GR_E52['Id']})
GR_E6 = {}
for i in range(9):
    GR_E6[sheet5.cell(i + 101, 1).value] = sheet5.cell(i + 101, 6).value
for i in GR_E6:
    if("ReportNo" in GR_E6):
        total['GR_E6']={'ReportNo':GR_E6['ReportNo']}
    if ("Id" in GR_E6):
        total['GR_E6'].update({'Id': GR_E6['Id']})
GR_E7 = {}
for i in range(9):
    GR_E7[sheet5.cell(i + 114, 1).value] = sheet5.cell(i + 114, 6).value
for i in GR_E7:
    if("ReportNo" in GR_E7):
        total['GR_E7']={'ReportNo':GR_E7['ReportNo']}
    if ("Id" in GR_E7):
        total['GR_E7'].update({'Id': GR_E7['Id']})
GR_E8 = {}
for i in range(6):
    GR_E8[sheet5.cell(i + 128, 1).value] = sheet5.cell(i + 128, 6).value
for i in GR_E8:
    if("ReportNo" in GR_E8):
        total['GR_E8']={'ReportNo':GR_E8['ReportNo']}
    if ("Id" in GR_E8):
        total['GR_E8'].update({'Id': GR_E8['Id']})
GR_E9 = {}
for i in range(10):
    GR_E9[sheet5.cell(i + 138, 1).value] = sheet5.cell(i + 138, 6).value
for i in GR_E9:
    if("ReportNo" in GR_E9):
        total['GR_E9']={'ReportNo':GR_E9['ReportNo']}
    if ("Id" in GR_E9):
        total['GR_E9'].update({'Id': GR_E9['Id']})
# print(GR_E9)
GR_E10 = {}
for i in range(10):
    GR_E10[sheet5.cell(i + 152, 1).value] = sheet5.cell(i + 152, 6).value
for i in GR_E10:
    if("ReportNo" in GR_E10):
        total['GR_E10']={'ReportNo':GR_E10['ReportNo']}
    if ("Id" in GR_E10):
        total['GR_E10'].update({'Id': GR_E10['Id']})
# print(GR_E10)
"""====================F声明信息================="""
GR_F1 = {}
for i in range(4):
    GR_F1[sheet6.cell(i + 3, 1).value] = sheet6.cell(i + 3, 6).value
for i in GR_F1:
    if("ReportNo" in GR_F1):
        total['GR_F1']={'ReportNo':GR_F1['ReportNo']}
    if ("Id" in GR_F1):
        total['GR_F1'].update({'Id': GR_F1['Id']})
GR_F2 = {}
for i in range(4):
    GR_F2[sheet6.cell(i + 11, 1).value] = sheet6.cell(i + 11, 6).value
for i in GR_F2:
    if("ReportNo" in GR_F2):
        total['GR_F2']={'ReportNo':GR_F2['ReportNo']}
    if ("Id" in GR_F2):
        total['GR_F2'].update({'Id': GR_F2['Id']})
"""====================G查询记录================="""
GR_G1 = {}
for i in range(10):
    GR_G1[sheet7.cell(i + 3, 1).value] = sheet7.cell(i + 3, 6).value
for i in GR_G1:
    if("ReportNo" in GR_G1):
        total['GR_G1']={'ReportNo':GR_G1['ReportNo']}
    if ("Id" in GR_G1):
        total['GR_G1'].update({'Id': GR_G1['Id']})
GR_G2 = {}
for i in range(5):
    GR_G2[sheet7.cell(i + 17, 1).value] = sheet7.cell(i + 17, 6).value
for i in GR_G2:
    if("ReportNo" in GR_G2):
        total['GR_G2']={'ReportNo':GR_G2['ReportNo']}
    if ("Id" in GR_G2):
        total['GR_G2'].update({'Id': GR_G2['Id']})
# recode = open('C:\\Users\\sunyuhong6\\Desktop\\recode.txt', 'a')

# print(total)
print('A==========================================================')
print('A1==========================')
total1=total
for i in GR_A1:
    if(i in total['GR_A1']):
        pass;
    else:
        total['GR_A1'][i]=GR_A1[i]
        print(total)
# recode.write(total)
print('A2==========================')
total=total1
for i in GR_A2:
    if (i in total['GR_A2']):
        pass;
    else:
        total['GR_A2'][i]=GR_A2[i]
        print(total)
total=total1
print('B=============================================')
print('B1==========================')
for i in GR_B1:
    if (i in total['GR_B1']):
        pass;
    else:
        total['GR_B1'][i]=GR_B1[i]
        print(total)
total=total1
print('B2==========================')
for i in GR_B2:
    if (i in total['GR_B2']):
        pass;
    else:
        total['GR_B2'][i]=GR_B2[i]
        print(total)
total=total1
print('B3==========================')
for i in GR_B3:
    if (i in total['GR_B3']):
        pass;
    else:
        total['GR_B3'][i]=GR_B3[i]
        print(total)
total=total1
print('B41==========================')
for i in GR_B41:
    if (i in total['GR_B41']):
        pass;
    else:
        total['GR_B41'][i]=GR_B41[i]
        print(total)
total=total1
print('C==========================================================')
print('C1==========================')
for i in GR_C1:
    if (i in total['GR_C1']):
        pass;
    else:
        total['GR_C1'][i]=GR_C1[i]
        print(total)
total=total1
print('C11==========================')
for i in GR_C11:
    if (i in total['GR_C11']):
        pass;
    else:
        total['GR_C11'][i]=GR_C11[i]
        print(total)
total=total1
print('C21==========================')
for i in GR_C21:
    if (i in total['GR_C21']):
        pass;
    else:
        total['GR_C21'][i]=GR_C21[i]
        print(total)
total=total1
print('C22==========================')
for i in GR_C22:
    if (i in total['GR_C22']):
        pass;
    else:
        total['GR_C22'][i]=GR_C22[i]
        print(total)
total=total1
print('C23==========================')
for i in GR_C23:
    if (i in total['GR_C23']):
        pass;
    else:
        total['GR_C23'][i]=GR_C23[i]
        print(total)
total=total1
print('C24==========================')
for i in GR_C24:
    if (i in total['GR_C24']):
        pass;
    else:
        total['GR_C24'][i]=GR_C24[i]
        print(total)
total=total1
print('C31==========================')
for i in GR_C31:
    if (i in total['GR_C31']):
        pass;
    else:
        total['GR_C31'][i]=GR_C31[i]
        print(total)
total=total1
print('C32==========================')
for i in GR_C32:
    if (i in total['GR_C32']):
        pass;
    else:
        total['GR_C32'][i]=GR_C32[i]
        print(total)
total=total1
print('C33==========================')
for i in GR_C33:
    if (i in total['GR_C33']):
        pass;
    else:
        total['GR_C33'][i]=GR_C33[i]
        print(total)
total=total1
print('C34==========================')
for i in GR_C34:
    if (i in total['GR_C34']):
        pass;
    else:
        total['GR_C34'][i]=GR_C34[i]
        print(total)
total=total1
# print('D===================================================================')
# print('D1==========================')
# for i in GR_D1:
#     if (i in total['GR_D1']):
#         pass;
#     else:
#         total['GR_D1'][i]=GR_D1[i]
#         print(total)
# total=total1
# print('D2==========================')
# for i in GR_D2:
#     if (i in total['GR_D2']):
#         pass;
#     else:
#         total['GR_D2'][i]=GR_D2[i]
#         print(total)
# total=total1
# print('D31==========================')
# for i in GR_D31:
#     if (i in total['GR_D31']):
#         pass;
#     else:
#         total['GR_D31'][i]=GR_D31[i]
#         print(total)
# total=total1
# print('D32==========================')
# for i in GR_D32:
#     if (i in total['GR_D32']):
#         pass;
#     else:
#         total['GR_D32'][i]=GR_D32[i]
#         print(total)
# total=total1
# print('D33==========================')
# for i in GR_D33:
#     if (i in total['GR_D33']):
#         pass;
#     else:
#         total['GR_D33'][i]=GR_D33[i]
#         print(total)
# total=total1
# print('D34==========================')
# for i in GR_D34:
#     if (i in total['GR_D34']):
#         pass;
#     else:
#         total['GR_D34'][i]=GR_D34[i]
#         print(total)
# total=total1
# print('D41==========================')
# for i in GR_D41:
#     if (i in total['GR_D41']):
#         pass;
#     else:
#         total['GR_D41'][i]=GR_D41[i]
#         print(total)
# total=total1
# print('D42==========================')
# for i in GR_D42:
#     if (i in total['GR_D42']):
#         pass;
#     else:
#         total['GR_D42'][i]=GR_D42[i]
#         print(total)
# total=total1
# print('D43==========================')
# for i in GR_D43:
#     if (i in total['GR_D43']):
#         pass;
#     else:
#         total['GR_D43'][i]=GR_D43[i]
#         print(total)
# total=total1
# print('D44==========================')
# for i in GR_D44:
#     if (i in total['GR_D44']):
#         pass;
#     else:
#         total['GR_D44'][i]=GR_D44[i]
#         print(total)
# total=total1
# print('D51==========================')
# for i in GR_D51:
#     if (i in total['GR_D51']):
#         pass;
#     else:
#         total['GR_D51'][i]=GR_D51[i]
#         print(total)
# total=total1
# print('D52==========================')
# for i in GR_D52:
#     if (i in total['GR_D52']):
#         pass;
#     else:
#         total['GR_D52'][i]=GR_D52[i]
#         print(total)
# total=total1
# print('D53==========================')
# for i in GR_D53:
#     if (i in total['GR_D53']):
#         pass;
#     else:
#         total['GR_D53'][i]=GR_D53[i]
#         print(total)
# total=total1
# print('D54==========================')
# for i in GR_D54:
#     if (i in total['GR_D54']):
#         pass;
#     else:
#         total['GR_D54'][i]=GR_D54[i]
#         print(total)
# total=total1
# print('D6==========================')
# for i in GR_D6:
#     if (i in total['GR_D6']):
#         pass;
#     else:
#         total['GR_D6'][i]=GR_D6[i]
#         print(total)
# total=total1
# print('E===================================================')
# print('E1==========================')
# for i in GR_E1:
#     if (i in total['GR_E1']):
#         pass;
#     else:
#         total['GR_E1'][i]=GR_E1[i]
#         print(total)
# total=total1
# print('E21==========================')
# for i in GR_E21:
#     if (i in total['GR_E21']):
#         pass;
#     else:
#         total['GR_E21'][i]=GR_E21[i]
#         print(total)
# total=total1
# print('E22==========================')
# for i in GR_E22:
#     if (i in total['GR_E22']):
#         pass;
#     else:
#         total['GR_E22'][i]=GR_E22[i]
#         print(total)
# total=total1
# print('E3==========================')
# for i in GR_E3:
#     if (i in total['GR_E3']):
#         pass;
#     else:
#         total['GR_E3'][i]=GR_E3[i]
#         print(total)
# total=total1
# print('E4==========================')
# for i in GR_E4:
#     if (i in total['GR_E4']):
#         pass;
#     else:
#         total['GR_E4'][i]=GR_E4[i]
#         print(total)
# total=total1
# print('E51==========================')
# for i in GR_E51:
#     if (i in total['GR_E51']):
#         pass;
#     else:
#         total['GR_E51'][i]=GR_E51[i]
#         print(total)
# total=total1
# print('E52==========================')
# for i in GR_E52:
#     if (i in total['GR_E52']):
#         pass;
#     else:
#         total['GR_E52'][i]=GR_E52[i]
#         print(total)
# total=total1
# print('E6==========================')
# for i in GR_E6:
#     if (i in total['GR_E6']):
#         pass;
#     else:
#         total['GR_E6'][i]=GR_E6[i]
#         print(total)
# total=total1
# print('E7==========================')
# for i in GR_E7:
#     if (i in total['GR_E7']):
#         pass;
#     else:
#         total['GR_E7'][i]=GR_E7[i]
#         print(total)
# total=total1
# print('E8==========================')
# for i in GR_E8:
#     if (i in total['GR_E8']):
#         pass;
#     else:
#         total['GR_E8'][i]=GR_E8[i]
#         print(total)
# total=total1
# print('E9==========================')
# for i in GR_E9:
#     if (i in total['GR_E9']):
#         pass;
#     else:
#         total['GR_E9'][i]=GR_E9[i]
#         print(total)
# total=total1
# print('E10==========================')
# for i in GR_E10:
#     if (i in total['GR_E10']):
#         pass;
#     else:
#         total['GR_E10'][i]=GR_E10[i]
#         print(total)
# total=total1
# print('F==========================================================')
# print('F1==========================')
# for i in GR_F1:
#     if (i in total['GR_F1']):
#         pass;
#     else:
#         total['GR_F1'][i]=GR_F1[i]
#         print(total)
# total=total1
# print('F2==========================')
# for i in GR_F2:
#     if (i in total['GR_F2']):
#         pass;
#     else:
#         total['GR_F2'][i]=GR_F2[i]
#         print(total)
# total=total1
# print('G==========================================================')
# print('G1==========================')
# for i in GR_G1:
#     if (i in total['GR_G1']):
#         pass;
#     else:
#         total['GR_G1'][i]=GR_G1[i]
#         print(total)
# total=total1
# print('G2==========================')
# for i in GR_G2:
#     if (i in total['GR_G2']):
#         pass;
#     else:
#         total['GR_G2'][i]=GR_G2[i]
#         print(total)
# total=total1