Method and device for generating EXCEL-to-DBC file

Abstract

The invention discloses a method for generating an EXCEL-to-DBC file based on MATLAB and PCAN-EXPLORER. The method comprises the steps: S1, selecting a CAN matrix file needing to generate DBC; S2, judging message information; S3, reading the message information; S4, continuously reading the message information; S5, ending the reading; S6, generating an SYM file; S7, opening the SYM file by the PCAN-EXPLORER software; and S8, producing a DBC file. When the CAN matrix is converted into the SYM file, the SYM file is simpler and clearer than the DBC file, written codes are simpler than existing codes, errors are not likely to happen, and the code writing threshold can be lowered; the DBC file can be automatically generated so that the workload of engineers is reduced and the working efficiencyis improved; when the SYM file is checked through the PCAN, whether the generated file is different from the CAN matrix or not can be detected more conveniently, and the error rate is reduced.

Description

technical field [0001] The invention belongs to the technical field of product vehicle detection and control, and more specifically, relates to a method for generating an EXCEL-to-DBC file. Background technique [0002] We know that the transmission of control signals and communication signals on the car needs to rely on various signal lines. The more functions, the more complex the lines. The complex and lengthy lines may lead to unreliable system communication, affect the normal operation of electronic control sub-components, and cause control errors. There is a possibility of a car accident. In order to solve this problem, German BOSCH introduced serial data communication CAN in the 1980s, which made the data communication and resource sharing problems between the control system and detection system on the car very effectively solved. Since its development, CAN has also derived many communication protocols with more complete specifications and stronger interoperability, ...

AI Technical Summary

Problems solved by technology

[0003] In the development of modern pure electric vehicles, it is inseparable from CAN bus, which is a crucial means of communication control. However, with the rapid development of pure electric vehicles, the number of CAN bus nodes and messages is increasing. Manual editing through Database is very important for engineers. The workload is greatly increased, and time-consuming, while the editing process is error-prone and imperceptible

[0004] The existing CAN bus has the following defects, that is, the engineer manually writes the DBC file information according to the CAN matrix provided, which causes the engineer's workload to be too large, and is prone to errors; the CAN matrix table of EXCEL is arranged in a certain order by writing the code Directly generate DBC files, so that the CAN matrix table must be arranged in a strict order. At the same time, because the DBC files are more cumbersome, when writing code to generate DBC, the code is not easy to write, and it is too long and error-prone

Images