当前位置: 首页 > article >正文

Excel生成DBC脚本源文件

Excel制作

新建一个Excel,后缀为“.xls”

工作本名称改为“CAN_Matrix”

在首行按照列来起名字,在里面只需要填写必须的内容即可。

列数名称
第0列Message Name
第1列Message Format
第2列Message
ID
第3列Message
Length
(byte)
第4列Message Transmitter
ECU
第5列Message Receiver
ECU
第6列Message Send Method
第7列Message Cycle Period(ms)
第8列Message Cycle Period Fast(ms)
第9列Message Delay Time(ms)
第10列Message IL Support 
第11列Message Num Of Repetition
第12列Message Start Delay Time(ms)
第13列NM Message
第14列CANFD BRS
第15列Message Comment
第16列Signal Name
第17列Signal
Length
(Bit)
第18列Signal Start Bit
第19列Singal Byte
Order
第20列Signal Unit
第21列Signal Data Type
第22列Signal Resolution
第23列Signal OffSet
第24列Signal Min
Value
第25列Signal Max Value
第26列Singal Inactive Value
第27列Singal Send Method
第28列Singal Start Value
第29列NWM- Wakeup Allowed
第30列Signal Value Descriptions
第31列Signal Comment

代码源码

# encoding='utf-8'
import xlrd
from decimal import Decimal

import sys
global Table        #表格
global RowCount     #行数
global ColumnCount  #列数
global OutputFile   #输出文件

ExcelTable = "CAN_Matrix"   #表格
Note = "xin1"               #节点名称

MessageName_Position = 0 #报文名称序号
MessageFormat_Position = 1 #报文格式序号
MessageID_Position = 2 #报文ID序号
MessageLength_Position = 3 #报文长度序号
MessageTransmitterNote_Position = 4 #报文发送节点序号
MessageReceiverNote_Position = 5 #报文接收节点序号
MessageSendMethod_Position  = 6 #报文发送方式序号
MessagePeriod_Position = 7 #报文周期序号
MessagePeriodFast_Position = 8 #报文快速周期序号
MessageDelayTime_Position = 9 #报文延迟时间序号
MessageILSupport_Position = 10 #报文支持IL序号
MessageNumOfRepetition_Position = 11 #报文重发次数序号
MessageStartDelayTime_Position = 12 #报文开始延迟时间序号
MessageNM_Position = 13 #报文网络管理序号
MessageCANFDBRS_Position = 14 #报文CANFDBRS序号
MessageComment_Position = 15 #报文注释序号

SignalName_Position = 16 #信号名称序号
SignalStartLength_Position = 17 #信号长度序号
SignalStartBit_Position = 18 #信号起始位序号
SignalByteOrder_Position = 19 #信号字节序序号
SignalUnit_Position = 20 #信号单位序号
SignalDataType_Position = 21 #信号数据类型序号
SignalResolution_Position = 22 #信号比率序号
SignalOffset_Position = 23 #信号偏移序号
SignalMinValue_Position = 24 #信号最小值序号
SignalMaxValue_Position = 25 #信号最大值序号
SingalInactiveValue_Position = 26 #信号未激活值序号
SingalSendMethod_Position = 27 #信号发送方式序号
SingalStartValue_Position = 28 #信号开始值序号
SingalNWMWakeupAllowed_Position = 29 #信号网管唤醒序号
SignalValueDescriptions_Position = 30 #信号数值描述序号
SignalComment_Position = 31 #信号标注序号


def remove_exponent(num):  # 去掉读取到的数值的小数点后边的0
    return num.to_integral() if num == num.to_integral() else num.normalize()
  
def Read_Base_Infomation(): # 获取基本信息
    global Table        #表格
    global RowCount     #行数
    global ColumnCount  #列数
    global OutputFile   #输出文件
    
    if len(sys.argv) > 1:
        InputFilePath = sys.argv[1]
    else:
        InputFilePath = "DBCDemo.xls"
    #print(f"InputFilePath:{InputFilePath}\n")
    
    LastIndex = InputFilePath.rfind('\\')
    StartIndex = InputFilePath.find('.xls', LastIndex)

    InputFileSuffix = InputFilePath[LastIndex + 1:]
    #print(f"InputFileSuffix:{InputFileSuffix}\n")
    
    Xlsx = xlrd.open_workbook(InputFileSuffix)    # 找到输入文件
    Table = Xlsx.sheet_by_name(ExcelTable)  # 找到sheet
    RowCount = Table.nrows                  # 提取行数
    ColumnCount = Table.ncols               # 提取列数
    
    InputFileNoSuffix = InputFilePath[LastIndex + 1:StartIndex - 3]#输出文件
    #print(f"InputFileNoSuffix:{InputFileNoSuffix}\n")
    OutputFile = InputFileNoSuffix + ".dbc"
    #print(f"OutputFile:{OutputFile}\n")
    
    
    
def Output_DBC_Head():#打印文件头部
    global OutputFile   #输出文件
    with open(OutputFile, "w",encoding="utf-8") as f:
        f.write("VERSION \"\"")
        f.write("\n\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\n''')
        f.write(f"BU_: {Note}\n\n\n")
   
def Output_MessageMappingSignal():#报文和信号映射关系
    global Table        #表格
    global RowCount     #行数
    global OutputFile   #输出文件
    
    with open(OutputFile, "a+",encoding="utf-8") as f:
        i = 1 #跳过表头
        while i < RowCount:#逐行轮询
            MessageName = Table.cell_value(i, MessageName_Position)# 报文名称
            if MessageName == "":   # 本行为空
                print(f"Empty Message exists\n")
                return
            else:                   # 本行有内容
                #MessageID = Table.cell_value(i, MessageID_Position)
                MessageID = int((Table.cell_value(i, MessageID_Position)), 16)# 报文ID十六进制
                #print(f"MessageID:{MessageID}\n")
                MessageLength = remove_exponent(Decimal(Table.cell_value(i, MessageLength_Position)).quantize(Decimal("0")))# 报文长度
                MessageTransmitterNote = Table.cell_value(i, MessageTransmitterNote_Position)# 报文发送节点
                MessageReceiverNote = Table.cell_value(i, MessageReceiverNote_Position)# 报文接收节点
                
                if MessageTransmitterNote == Note :# 写入报文ID信息
                    f.write(f"BO_ {MessageID} {MessageName}: {MessageLength} {Note}\n")  
                else:
                    f.write(f"BO_ {MessageID} {MessageName}: {MessageLength} Vector__XXX\n")               
                
                while 1:#扫描这个报文里面的所有信号
                    if (i == RowCount) or (MessageID != int((Table.cell_value(i, MessageID_Position)), 16)):#后面没有该报文的信号或者已经到尽头
                        f.write("\n")
                        break
                    else:# 后面还有该报文的信号
                        SingleName = Table.cell_value(i, SignalName_Position)#信号名称
                        #print(f"SingleName:{SingleName}\n")
                        
                        SignalStartBit = remove_exponent(Decimal(Table.cell_value(i, SignalStartBit_Position)).quantize(Decimal("0")))#信号起始位,去除小数点后边的0以及保留小数点后O位
                        #print(f"SignalStartBit:{SignalStartBit}\n")
                                    
                        SignalLength = remove_exponent(Decimal(Table.cell_value(i, SignalStartLength_Position)).quantize(Decimal("0"))) #信号长度
                        #print(f"SignalLength:{SignalLength}\n")
                        
                        if Table.cell_value(i, SignalByteOrder_Position) == "Motorola MSB" or Table.cell_value(i, SignalByteOrder_Position) == "Motorola" or Table.cell_value(i, SignalByteOrder_Position) == "":#信号字节序
                            SignalByteOrder = "@0"
                        else:
                            SignalByteOrder = "@1"
                        #print(f"SignalByteOrder:{SignalByteOrder}\n")
                        
                        if Table.cell_value(i, SignalDataType_Position) == "Unsigned" or Table.cell_value(i, SignalDataType_Position) == "unsigned" or Table.cell_value(i, SignalDataType_Position) == "":#信号有无符号
                            SignalDateType = "+"
                        else:
                            SignalDateType = "-"
                        #print(f"SignalDateType:{SignalDateType}\n")
                        
                        if Table.cell_value(i, SignalUnit_Position) == "":#信号单位
                            SignalUnit = ""
                        else:
                            SignalUnit = Table.cell_value(i, SignalUnit_Position)
                        #print(f"SignalUnit:{SignalUnit}\n")
                        
                        if Table.cell_value(i, SignalResolution_Position) == "":#信号精度
                            SignalResolution = 1
                        else:
                            SignalResolution = remove_exponent(Decimal(Table.cell_value(i, SignalResolution_Position)).quantize(Decimal("0.00000")))

                        if Table.cell_value(i, SignalOffset_Position) == "":#信号偏移
                            SignalOffset = 0
                        else:
                            SignalOffset = remove_exponent(Decimal(Table.cell_value(i, SignalOffset_Position)).quantize(Decimal("0.00000")))
                        #print(f"SignalOffset:{SignalOffset}\n")                         

                        if Table.cell_value(i, SignalOffset_Position) == "":
                            SignalMinValue = 0;
                        else:
                            HexValue = str(Table.cell_value(i, SignalMinValue_Position))#信号最小值
                            if HexValue.startswith('0x') or HexValue.startswith('0X'):
                                SignalMinValue = int(HexValue, 16)  # 将字符串转换为10进制整数
                            else:
                                SignalMinValue = remove_exponent(Decimal(Table.cell_value(i, SignalMinValue_Position)).quantize(Decimal("0")))
                            #print(f"SignalMinValue:{SignalMinValue}\n") 

                        if Table.cell_value(i, SignalMaxValue_Position) == "":
                            SignalMaxValue = 0xFF;
                        else:           
                            HexValue = str(Table.cell_value(i, SignalMaxValue_Position))#信号最大值
                            if HexValue.startswith('0x') or HexValue.startswith('0X'):
                                SignalMaxValue = int(HexValue, 16)  # 将字符串转换为10进制整数
                            else:
                                SignalMaxValue = remove_exponent(Decimal(Table.cell_value(i, SignalMaxValue_Position)).quantize(Decimal("0")))        
                            #print(f"SignalMaxValue:{SignalMaxValue}\n") 
                        
                        if MessageTransmitterNote == Note :
                            f.write(f" SG_ {SingleName} : {SignalStartBit}|{SignalLength}{SignalByteOrder}{SignalDateType} ({SignalResolution},{SignalOffset}) [{SignalMinValue}|{SignalMaxValue}] \"{SignalUnit}\" Vector__XXX\n")
                        else :
                            f.write(f" SG_ {SingleName} : {SignalStartBit}|{SignalLength}{SignalByteOrder}{SignalDateType} ({SignalResolution},{SignalOffset}) [{SignalMinValue}|{SignalMaxValue}] \"{SignalUnit}\" {Note} \n")    
 
                        i = i + 1 #扫描下一行
                        #print(f"i:{i}\n")
        f.write("\n")

            
def Output_DBC_Comment(): 
    global Note
    global OutputFile   #输出文件
    
    with open(OutputFile, "a+", encoding="GB2312") as f:     
        f.write("""
BA_DEF_ SG_  "GenSigStartValue" FLOAT 0 100000000000;
BA_DEF_ SG_  "GenSigSendType" ENUM  "Cyclic","OnWrite","OnWriteWithRepetition","OnChange","OnChangeWithRepetition","IfActive","IfActiveWithRepetition","NoSigSendType","NotUsed","NotUsed","NotUsed","NotUsed","NotUsed";
BA_DEF_ SG_  "GenSigInactiveValue" INT 0 100000;
BA_DEF_ SG_  "NWM-WakeupAllowed" ENUM  "No","Yes";
BA_DEF_ BO_  "GenMsgSendType" ENUM  "Cyclic","NotUsed","NotUsed","NotUsed","NotUsed","Cyclic","NotUsed","IfActive","NoMsgSendType","NotUsed","vector_leerstring";
BA_DEF_ BO_  "GenMsgNrOfRepetition" INT 0 999999;
BA_DEF_ BO_  "GenMsgDelayTime" INT 0 1000;
BA_DEF_ BO_  "GenMsgCycleTime" INT 0 50000;
BA_DEF_ BO_  "GenMsgCycleTimeFast" INT 0 50000;
BA_DEF_ BO_  "GenMsgILSupport" ENUM  "No","Yes";
BA_DEF_ BO_  "NmMessage" ENUM  "no","yes";
BA_DEF_ BO_  "GenMsgStartDelayTime" INT 0 65535;
BA_DEF_ BU_  "NmStationAddress" INT 0 63;
BA_DEF_ BU_  "NmNode" ENUM  "no","yes";
BA_DEF_  "NmBaseAddress" HEX 1024 1087;
BA_DEF_ BO_  "CANFD_BRS" ENUM  "0","1";
BA_DEF_  "DBName" STRING ;
BA_DEF_  "BusType" STRING ;
BA_DEF_ BU_  "NodeLayerModules" STRING ;
BA_DEF_ BU_  "ECU" STRING ;
BA_DEF_ BU_  "CANoeJitterMax" INT 0 0;
BA_DEF_ BU_  "CANoeJitterMin" INT 0 0;
BA_DEF_ BU_  "CANoeDrift" INT 0 0;
BA_DEF_ BU_  "CANoeStartDelay" INT 0 0;
BA_DEF_ BO_  "VFrameFormat" ENUM  "StandardCAN","ExtendedCAN","reserved","reserved","reserved","reserved","reserved","reserved","reserved","reserved","reserved","reserved","reserved","reserved","StandardCAN_FD","ExtendedCAN_FD";
BA_DEF_DEF_  "GenSigStartValue" 0;
BA_DEF_DEF_  "GenSigSendType" "Cyclic";
BA_DEF_DEF_  "GenSigInactiveValue" 0;
BA_DEF_DEF_  "NWM-WakeupAllowed" "";
BA_DEF_DEF_  "GenMsgSendType" "NoMsgSendType";
BA_DEF_DEF_  "GenMsgNrOfRepetition" 0;
BA_DEF_DEF_  "GenMsgDelayTime" 0;
BA_DEF_DEF_  "GenMsgCycleTime" 0;
BA_DEF_DEF_  "GenMsgCycleTimeFast" 0;
BA_DEF_DEF_  "GenMsgILSupport" "Yes";
BA_DEF_DEF_  "NmMessage" "no";
BA_DEF_DEF_  "GenMsgStartDelayTime" 0;
BA_DEF_DEF_  "NmStationAddress" 0;
BA_DEF_DEF_  "NmNode" "no";
BA_DEF_DEF_  "NmBaseAddress" 1024;
BA_DEF_DEF_  "CANFD_BRS" "1";
BA_DEF_DEF_  "DBName" "";
BA_DEF_DEF_  "BusType" "";
BA_DEF_DEF_  "NodeLayerModules" "";
BA_DEF_DEF_  "ECU" "";
BA_DEF_DEF_  "CANoeJitterMax" 0;
BA_DEF_DEF_  "CANoeJitterMin" 0;
BA_DEF_DEF_  "CANoeDrift" 0;
BA_DEF_DEF_  "CANoeStartDelay" 0;
BA_DEF_DEF_  "VFrameFormat" "StandardCAN";
BA_ "BusType" "CAN FD";
""")
        f.write(f'BA_ "DBName" \"{Note}\";\n\n')

        
def Output_SignalAttributes():#添加信号属性
    global Table        #表格
    global RowCount     #行数
    global OutputFile   #输出文件
    
    with open(OutputFile, "a+", encoding="utf-8") as f:
    #with open(OutputFile, "a+", encoding="GB2312") as f:  
        i = 1 #跳过表头
        while i < RowCount:#逐行轮询
            SingleName = Table.cell_value(i, SignalName_Position)#信号名称
            #print(f"SingleName:{SingleName}\n")
            MessageID = int((Table.cell_value(i, MessageID_Position)), 16)# 报文ID十六进制

            if Table.cell_value(i, SingalInactiveValue_Position) != "":#信号未激活值
                SingalInactiveValue = remove_exponent(Decimal(Table.cell_value(i, SingalInactiveValue_Position)).quantize(Decimal("0")))
                #print(f"SingalInactiveValue:{SingalInactiveValue}\n")
                f.write(f"BA_ \"GenSigInactiveValue\" SG_ {MessageID} {SingleName} {SingalInactiveValue};\n")
            
            if Table.cell_value(i, SingalSendMethod_Position) != "":#信号发送方式
                SingalSendMethod = Table.cell_value(i, SingalSendMethod_Position)
                #print(f"SingalSendMethod:{SingalSendMethod}\n")
                if SingalSendMethod == "Cyclic":
                    f.write(f"BA_ \"GenSigSendType\" SG_ {MessageID} {SingleName} 0;\n")
                elif SingalSendMethod == "OnWrite":
                    f.write(f"BA_ \"GenSigSendType\" SG_ {MessageID} {SingleName} 1;\n")
                elif SingalSendMethod == "OnWriteWithRepetition":
                    f.write(f"BA_ \"GenSigSendType\" SG_ {MessageID} {SingleName} 2;\n")              
                elif SingalSendMethod == "OnChange":
                    f.write(f"BA_ \"GenSigSendType\" SG_ {MessageID} {SingleName} 3;\n")
                elif SingalSendMethod == "OnChangeWithRepetition":
                    f.write(f"BA_ \"GenSigSendType\" SG_ {MessageID} {SingleName} 4;\n")
                elif SingalSendMethod == "IfActive":
                    f.write(f"BA_ \"GenSigSendType\" SG_ {MessageID} {SingleName} 5;\n")
                elif SingalSendMethod == "IfActiveWithRepetition":
                    f.write(f"BA_ \"GenSigSendType\" SG_ {MessageID} {SingleName} 6;\n")
                else:
                    f.write(f"BA_ \"GenSigSendType\" SG_ {MessageID} {SingleName} 0;\n")
 
            if Table.cell_value(i, SingalStartValue_Position) != "":#信号开始值
                SingalStartValue = remove_exponent(Decimal(Table.cell_value(i, SingalStartValue_Position)).quantize(Decimal("0")))
                #print(f"SingalStartValue:{SingalStartValue}\n")
                f.write(f"BA_ \"GenSigStartValue\" SG_ {MessageID} {SingleName} {SingalStartValue};\n")
                
            if Table.cell_value(i, SingalNWMWakeupAllowed_Position) != "":#信号网管唤醒序号
                SingalNWMWakeupAllowed = Table.cell_value(i, SingalNWMWakeupAllowed_Position)
                #print(f"SingalNWMWakeupAllowed:{SingalNWMWakeupAllowed}\n")
                if SingalNWMWakeupAllowed == "Yes" or SingalNWMWakeupAllowed == "YES":
                    f.write(f"BA_ \"NWM-WakeupAllowed\" SG_ {MessageID} {SingleName} 1;\n")
                else:
                    f.write(f"BA_ \"NWM-WakeupAllowed\" SG_ {MessageID} {SingleName} 0;\n")              
            
            i = i + 1
            
def Output_SignalValue():#打印信号值定义
    global RowCount     #行数
    global Table 
    global OutputFile   #输出文件
    
    with open(OutputFile, "a+", encoding="utf-8") as f:
        i = 1 #跳过表头
        while i < RowCount:#逐行轮询
            if Table.cell_value(i, SignalName_Position) != "":
                MessageID = int((Table.cell_value(i, MessageID_Position)), 16)
                if Table.cell_value(i, SignalValueDescriptions_Position) != "":
                    SingleName = Table.cell_value(i, SignalName_Position)
                    SignalValueDescription = Table.cell_value(i, SignalValueDescriptions_Position).strip().replace("\r", "").split("\n")
                    SignalValueDescription = list(reversed(SignalValueDescription))
                    if SignalValueDescription != [""]:
                        #处理列表元素使其生成DBC文件格式中一样的格式
                        ELE = "\" ".join(SignalValueDescription).replace("0x","").replace(":"," \"")+"\""
                        f.write(f"VAL_ {MessageID} {SingleName} {ELE} ;\n") 
            i = i + 1      
            
def Output_SignalComment():#添加信号注释
    global Table        #表格
    global RowCount     #行数
    global OutputFile   #输出文件
    
    with open(OutputFile, "a+", encoding="utf-8") as f:#信号注释,不提倡添加中文注释
    #with open(OutputFile, "a+", encoding="GB2312") as f:  
        i = 1 #跳过表头
        while i < RowCount:#逐行轮询
            if Table.cell_value(i, SignalName_Position) != "":
                MessageID = int((Table.cell_value(i, MessageID_Position)), 16)
                if Table.cell_value(i, SignalValueDescriptions_Position) != "":
                    SingleName = Table.cell_value(i, SignalName_Position)
                    if Table.cell_value(i, SignalComment_Position) != "":#信号标注序号
                        SignalComment = Table.cell_value(i, SignalComment_Position).strip().replace("\n", "").replace("\r", "")
                        f.write(f"CM_ SG_ {MessageID} {SingleName} \"{SignalComment}\";\n")
            
            i = i + 1
          

def Output_MessageAttribute():#打印报文属性
    global RowCount     #行数
    global Table
    global OutputFile   #输出文件
    
    with open(OutputFile, "a+",encoding="utf-8") as f:
        i = 1 #跳过表头
        while i < RowCount:#逐行轮询
            MessageID = int((Table.cell_value(i, MessageID_Position)), 16)# 报文ID
            
            if Table.cell_value(i, MessageFormat_Position) != "":# 报文格式
                MessageFormat = Table.cell_value(i, MessageFormat_Position)
                #print(f"MessageFormat:{MessageFormat}\n")
                if MessageFormat == "CAN Standard":  
                    f.write(f"BA_ \"VFrameFormat\" BO_ {MessageID} 0;\n")
                elif MessageFormat == "CAN Extended":               
                    f.write(f"BA_ \"VFrameFormat\" BO_ {MessageID} 1;\n") 
                elif MessageFormat == "CAN FD Standard":              
                    f.write(f"BA_ \"VFrameFormat\" BO_ {MessageID} 14;\n")                      
                elif MessageFormat == "CAN FD Extended":              
                    f.write(f"BA_ \"VFrameFormat\" BO_ {MessageID} 15;\n")           
                else:              
                    f.write(f"BA_ \"VFrameFormat\" BO_ {MessageID} 0;\n")  

            if Table.cell_value(i, MessageSendMethod_Position) != "":# 报文发送方式
                MessageSendMethod = Table.cell_value(i, MessageSendMethod_Position)
                #print(f"MessageSendMethod:{MessageSendMethod}\n")
                if MessageSendMethod == "Cyclic":
                    f.write(f"BA_ \"GenMsgSendType\" BO_ {MessageID} 0;\n")   
                elif MessageSendMethod == "IfActive":           
                    f.write(f"BA_ \"GenMsgSendType\" BO_ {MessageID} 7;\n")     
                else:
                    f.write(f"BA_ \"GenMsgSendType\" BO_ {MessageID} 0;\n")     
            
            if Table.cell_value(i, MessagePeriod_Position) != "":            
                MessagePeriod = Table.cell_value(i, MessagePeriod_Position)
                if MessagePeriod != "Event":# 报文周期      
                    MessagePeriod = remove_exponent(Decimal(Table.cell_value(i, MessagePeriod_Position)).quantize(Decimal("0")))                
                    #print(f"MessagePeriod:{MessagePeriod}\n")
                    f.write(f"BA_ \"GenMsgCycleTime\" BO_ {MessageID} {MessagePeriod};\n") 

            if Table.cell_value(i, MessagePeriodFast_Position) != "":#报文快速周期 
                MessagePeriodFast = remove_exponent(Decimal(Table.cell_value(i, MessagePeriodFast_Position)).quantize(Decimal("0")))         
                f.write(f"BA_ \"GenMsgCycleTimeFast\" BO_ {MessageID} {MessagePeriodFast};\n") 

            if Table.cell_value(i, MessageDelayTime_Position) != "":#报文延迟时间
                MessageDelayTime = remove_exponent(Decimal(Table.cell_value(i, MessageDelayTime_Position)).quantize(Decimal("0")))            
                f.write(f"BA_ \"GenMsgDelayTime\" BO_ {MessageID} {MessageDelayTime};\n")  
                
            if Table.cell_value(i, MessageILSupport_Position) != "":#报文支持IL序号
                MessageILSupport = Table.cell_value(i, MessageILSupport_Position)
                if MessageILSupport == "Yes" or MessageILSupport == "YES":
                    f.write(f"BA_ \"GenMsgILSupport\" BO_ {MessageID} 1;\n") 
                else:
                    f.write(f"BA_ \"GenMsgILSupport\" BO_ {MessageID} 0;\n")    

            if Table.cell_value(i, MessageNumOfRepetition_Position) != "":#报文重发次数
                MessageNumOfRepetition = remove_exponent(Decimal(Table.cell_value(i, MessageNumOfRepetition_Position)).quantize(Decimal("0")))              
                f.write(f"BA_ \"GenMsgNrOfRepetition\" BO_ {MessageID} {MessageNumOfRepetition};\n") 
                
            if Table.cell_value(i, MessageStartDelayTime_Position) != "":#报文开始延迟时间
                MessageStartDelayTime = remove_exponent(Decimal(Table.cell_value(i, MessageStartDelayTime_Position)).quantize(Decimal("0")))            
                f.write(f"BA_ \"GenMsgStartDelayTime\" BO_ {MessageID} {MessageStartDelayTime};\n") 
                
            if Table.cell_value(i, MessageNM_Position) != "":#报文网络管理
                MessageNM = Table.cell_value(i, MessageNM_Position)        
                if MessageNM == "Yes" or MessageNM == "YES":
                    f.write(f"BA_ \"NmMessage\" BO_ {MessageID} 1;\n") 
                else:
                    f.write(f"BA_ \"NmMessage\" BO_ {MessageID} 0;\n")
                
            if Table.cell_value(i, MessageCANFDBRS_Position) != "":#报文CANFDBRS
                MessageCANFDBRS = Table.cell_value(i, MessageCANFDBRS_Position)                                          
                if MessageCANFDBRS == "Yes" or MessageCANFDBRS == "YES":
                    f.write(f"BA_ \"CANFD_BRS\" BO_ {MessageID} 1;\n") 
                else:
                    f.write(f"BA_ \"CANFD_BRS\" BO_ {MessageID} 0;\n")

            i = i + 1

def Output_MessageComment():#打印报文注释
    global Table        #表格
    global RowCount     #行数
    global OutputFile   #输出文件
    
    with open(OutputFile, "a+", encoding="GB2312") as f:#打印报文注释  
        i = 1 #跳过表头
        while i < RowCount:#逐行轮询
            MessageID = int((Table.cell_value(i, MessageID_Position)), 16)# 报文ID
            MessageComment = Table.cell_value(i, MessageComment_Position)# 报文注释
            if MessageComment != "":
                f.write(f"CM_ BO_ {MessageID} \"{MessageComment}\";\n") 
            i = i + 1
       
if __name__ == "__main__" :

    print(f"Start")#打印的顺序不要乱,不然会打不开文件
    
    Read_Base_Infomation()
    
    Output_DBC_Head()
    
    Output_MessageMappingSignal()
    
    Output_SignalComment()
    
    Output_MessageComment() 
    
    Output_DBC_Comment()  
    
    Output_SignalAttributes()
    
    Output_MessageAttribute()
    
    Output_SignalValue()

    print(f"Success!!")
    


http://www.kler.cn/a/450740.html

相关文章:

  • SQL Server数据库多主模式解决方案
  • 【Unity3D】Particle粒子特效或3D物体显示在UGUI上的方案
  • 《智启新材:人工智能重塑分子结构设计蓝图》
  • 智能座舱进阶-应用框架层-Jetpack主要组件
  • 重温设计模式--命令模式
  • VSCode搭建Java开发环境 2024保姆级安装教程(Java环境搭建+VSCode安装+运行测试+背景图设置)
  • 分布式 IO 模块:赋能造纸业,革新高速纸机主传动
  • 【MFC】如何修改多文档视图的标签
  • 深入解析Android Recovery系统
  • 代写软件标书哪里找:如何让标书撰写变得高效轻松
  • 自动驾驶---Parking端到端架构
  • 在 .NET Core 中使用 ActionBlock 实现高效率的多步骤数据处理
  • 阿里云ESC服务器一次性全部迁移到另一个ESC
  • 以“技”出圈,珈和科技农业典型案例 “盛放”2024湖北农博会
  • 问题小记-达梦数据库报错“字符串转换出错”处理
  • 深入理解C++23的Deducing this特性(上):基础概念与语法详解
  • curl 放弃对 Hyper Rust HTTP 后端的支持
  • 《Opencv》基础操作详解(3)
  • 全国硕士研究生入学考试(考研)考研时间线之大四
  • 24.12.25 AOP
  • CASA模型相关遥感数据及MODIS NDVI、FPAR遥感产品数据时序重建
  • SpringBoot3——Web开发
  • 软件测试之压力测试【详解】
  • 安卓修改进程数 termux报错signal 9 vmos
  • webpack3 webpack4 webpack5 有什么区别
  • Java重要面试名词整理(四):并发编程(下)