Python自动生成DBC文件程序

# encoding='utf-8' import xlrd from decimal import Decimal def remove_exponent(num): # 去掉读取到的数值的小数点后边的0 return num.to_integral() if num == num.to_integral() else num.normalize() # 打开CAN矩阵EXCL表格并读取 xlsx = xlrd.open_workbook("AC_Matrix_CAN_V1.2_20210918.xls") table = xlsx.sheet_by_name("AC") # 定位sheet表 nrows = table.nrows # 拾取所有行数 colors = table.ncols # 拾取所有列数 with open("AC_Matrix_CAN_DBC.dbc", "a+",encoding="utf-8") as f: f.write("VERSION \"\"") f.write("\n") f.write("\n") f.write(''' NS_ : NS_DESC_ CM_ BA_DEF_ BA_ VAL_ CAT_DEF_ CAT_ FILTER BA_DEF_DEF_ EV_DATA_ ENVVAR_DATA_ SGTYPE_ SGTYPE_VAL_ BA_DEF_SGTYPE_ BA_SGTYPE_ SIG_TYPE_REF_ VAL_TABLE_ SIG_GROUP_ SIG_VALTYPE_ SIGTYPE_VALTYPE_ BO_TX_BU_ BA_DEF_REL_ BA_REL_ BA_DEF_DEF_REL_ BU_SG_REL_ BU_EV_REL_ BU_BO_REL_ SG_MUL_VAL_ BS_:\n''') f.write("\n") # 写入网络节点 f.write("BU_:") f.write("\n") # for VAL in range(1, nrows): # if table.cell_value(VAL, 0) == "": # continue # else: # Id_Name = table.cell_value(VAL, 0) # for val in range(VAL + 1, nrows): # if table.cell_value(val, 7) == "": # break # else: # Id_SignalValueDescriptionTemp = table.cell_value(val, 25).strip().replace("\r", "").split("\n") # Id_SignalValueDescription = list(reversed(Id_SignalValueDescriptionTemp)) # if Id_SignalValueDescription != [""]: # #处理列表元素使其生成DBC文件格式中一样的格式 # #print(Id_SignalValueDescription) # ELE = "\" ".join(Id_SignalValueDescription).replace("0x","").replace(":"," \"")+"\"" # f.write(f"VAL_TABLE_ Vt_{Id_Name}_{val} {ELE} ;\n") f.write("\n\n") # 写入报文消息数据格式 for i in range(1, nrows): if table.cell_value(i, 0) == "": continue else: Id_Name = table.cell_value(i, 0) Id_ID = int((table.cell_value(i, 2)), 16) f.write(f"BO_ {Id_ID} {Id_Name}: 8 Vector__XXX\n") # 写ID信息 for j in range(i + 1, nrows): if table.cell_value(j, 7) == "": break else: Id_SingleName = table.cell_value(j, 7) Id_SignalStartBit = remove_exponent( Decimal(table.cell_value(j, 11)).quantize(Decimal("0"))) # 去除小数点后边的0以及保留小数点后O位 Id_SignalLength = remove_exponent(Decimal(table.cell_value(j, 13)).quantize(Decimal("0"))) if table.cell_value(j, 9) == "Motorola MSB": Id_SignalByteOrder = "@0" else: Id_SignalByteOrder = "@1" if table.cell_value(j, 14) == "Unsigned": Id_SignalDateType = "+" else: Id_SignalDateType = "-" Id_SignalMinValue = remove_exponent(Decimal(table.cell_value(j, 17)).quantize(Decimal("0"))) Id_SignalMaxValue = remove_exponent(Decimal(table.cell_value(j, 18)).quantize(Decimal("0"))) Id_SignalResolution = remove_exponent( Decimal(table.cell_value(j, 15)).quantize(Decimal("0.00000"))) # 去除小数点后边的0以及保留小数点后5位 Id_SignalOffset = remove_exponent(Decimal(table.cell_value(j, 16)).quantize(Decimal("0.00000"))) if table.cell_value(j, 24) == "": Id_SignalUnit = "" else: Id_SignalUnit = table.cell_value(j, 24) print(f"Id_SignalStartBit={Id_SignalStartBit}") print(f"Id_SignalLength={Id_SignalLength}") f.write( f" SG_ {Id_SingleName} : {Id_SignalStartBit}|{Id_SignalLength}{Id_SignalByteOrder}{Id_SignalDateType} ({Id_SignalResolution},{Id_SignalOffset}) [{Id_SignalMinValue}|{Id_SignalMaxValue}] \"{Id_SignalUnit}\" Vector__XXX\n") f.write("\n\n\n") f.close() with open("BAIC_B60V_AC_Matrix_CAN_DBC.dbc", "a+", encoding="GB2312") as f: #添加DBC文件注释 for z in range(1, nrows): if table.cell_value(z, 0) == "": continue else: Id_ID = int((table.cell_value(z, 2)), 16) for x in range(z + 1, nrows): if table.cell_value(x, 7) == "": break else: Id_SingleName = table.cell_value(x, 7) Id_SignalDescription = table.cell_value(x, 8).strip().replace("\n", "").replace("\r", "") f.write(f"CM_ SG_ {Id_ID} {Id_SingleName} \"{Id_SignalDescription}\";\n") f.write("""BA_DEF_ BU_ "NodeLayerModules" STRING ; BA_DEF_ BO_ "GenMsgStartDelayTime" INT 0 65535; BA_DEF_ SG_ "NWM-WakeupAllowed" ENUM "No","Yes"; BA_DEF_ BO_ "NmMessage" ENUM "no","yes"; BA_DEF_ BO_ "GenMsgILSupport" ENUM "No","Yes"; BA_DEF_ BU_ "NmNode" ENUM "no","yes"; BA_DEF_ BU_ "NmStationAddress" INT 0 63; BA_DEF_ "NmBaseAddress" HEX 1024 1087; BA_DEF_ BO_ "GenMsgCycleTimeFast" INT 0 50000; BA_DEF_ "BusType" STRING ; BA_DEF_ BO_ "GenMsgCycleTime" INT 0 50000; BA_DEF_ BO_ "GenMsgDelayTime" INT 0 1000; BA_DEF_ BO_ "GenMsgNrOfRepetition" INT 0 999999; BA_DEF_ BO_ "GenMsgSendType" ENUM "Cyclic","NotUsed","NotUsed","NotUsed","NotUsed","NotUsed","NotUsed","IfActive","NoMsgSendType","NotUsed","vector_leerstring"; BA_DEF_ SG_ "GenSigInactiveValue" INT 0 100000; BA_DEF_ SG_ "GenSigSendType" ENUM "Cyclic","OnWrite","OnWriteWithRepetition","OnChange","OnChangeWithRepetition","IfActive","IfActiveWithRepetition","NoSigSendType","NotUsed","NotUsed","NotUsed","NotUsed","NotUsed"; BA_DEF_ SG_ "GenSigStartValue" FLOAT 0 100000000000; BA_DEF_DEF_ "NodeLayerModules" "CANoeILNLVector.dll"; BA_DEF_DEF_ "GenMsgStartDelayTime" 0; BA_DEF_DEF_ "NWM-WakeupAllowed" ""; BA_DEF_DEF_ "NmMessage" "no"; BA_DEF_DEF_ "GenMsgILSupport" "Yes"; BA_DEF_DEF_ "NmNode" "no"; BA_DEF_DEF_ "NmStationAddress" 0; BA_DEF_DEF_ "NmBaseAddress" 1024; BA_DEF_DEF_ "GenMsgCycleTimeFast" 0; BA_DEF_DEF_ "BusType" ""; BA_DEF_DEF_ "GenMsgCycleTime" 0; BA_DEF_DEF_ "GenMsgDelayTime" 0; BA_DEF_DEF_ "GenMsgNrOfRepetition" 0; BA_DEF_DEF_ "GenMsgSendType" "NoMsgSendType"; BA_DEF_DEF_ "GenSigInactiveValue" 0; BA_DEF_DEF_ "GenSigSendType" "Cyclic"; BA_DEF_DEF_ "GenSigStartValue" 0;\n""") f.close() with open("BAIC_B60V_AC_Matrix_CAN_DBC.dbc", "a+", encoding="utf-8") as f: for VAL in range(1, nrows): if table.cell_value(VAL, 0) == "": continue else: Id_ID = int((table.cell_value(VAL, 2)), 16) for val in range(VAL + 1, nrows): if table.cell_value(val, 7) == "": break else: Id_SingleName = table.cell_value(val, 7) Id_SignalValueDescriptionTemp = table.cell_value(val, 25).strip().replace("\r", "").split("\n") Id_SignalValueDescription = list(reversed(Id_SignalValueDescriptionTemp)) if Id_SignalValueDescription != [""]: #处理列表元素使其生成DBC文件格式中一样的格式 #print(Id_SignalValueDescription) ELE = "\" ".join(Id_SignalVa