CN103823804B - CAN network file is converted to the method and device of Excel file - Google Patents
CAN network file is converted to the method and device of Excel file Download PDFInfo
- Publication number
- CN103823804B CN103823804B CN201210464311.4A CN201210464311A CN103823804B CN 103823804 B CN103823804 B CN 103823804B CN 201210464311 A CN201210464311 A CN 201210464311A CN 103823804 B CN103823804 B CN 103823804B
- Authority
- CN
- China
- Prior art keywords
- file
- message
- excel
- critical data
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Storage Device Security (AREA)
Abstract
The embodiment of the invention discloses a kind of method that CAN network file is converted to Excel file, comprise the following steps：Critical data is extracted from CAN network file, wherein, critical data includes：The definition of all CAN signals in all CAN message parameters and each CAN message and property parameters；Obtain predefined profiles；According to critical data and configuration file, the Excel file of CAN network data is generated.The embodiment of the invention also discloses a kind of device that CAN network file is converted to Excel file.CAN network file can be converted into automatically by Excel file using the present invention, cost of labor is saved, improve work efficiency.
Description
Technical field
The present invention relates to the communications field, more particularly to a kind of method and dress that CAN network file is converted to Excel file
Put.
Background technology
In automobile controller local area network communication field, CAN（Controller Area Network, controller LAN
Network）Communication protocol has become a kind of the most commonly used communication protocol, this communication protocol define all CAN messages and each
The definition of all CAN signals and attribute in CAN message, it is necessary to according to defined in CAN network file in controller software application
CAN communication protocol contents, CAN message is parsed into the actual signal with physical significance.In view of data interchange format
Problem, vehicle factory needs finally to be issued the key message in CAN network file with Excel form.
In the prior art, all it is by the key message write-in Excel texts in CAN network file by the way of manual entry
In part, but be due to CAN network file data volume greatly, be likely to occur during artificial conversion because artificial carelessness is led
The corrupt data of cause, and can also expend substantial amounts of manpower proof time so that operating efficiency is low.
The content of the invention
Technical problem to be solved of the embodiment of the present invention is CAN network file is converted into Excel texts there is provided one kind
The method and device of part, can save labour turnover, and improve work efficiency.
In order to solve the above-mentioned technical problem, CAN network file is converted into Excel texts the embodiments of the invention provide one kind
The method of part, including：
Critical data is extracted from CAN network file, the critical data includes：All CAN message parameter and each
The definition of all CAN signals in CAN message and property parameters；
Obtain predefined profiles；
According to the critical data and the configuration file, the Excel file of CAN network data is generated.
Wherein, the step of critical data is extracted in the file from CAN network includes：
Progressively scan the data in CAN network file；
If inquiring critical data from current line, the critical data in current line is stored.
Wherein, the step of critical data in current line being stored, be specially：
The critical data is stored in the form of predefined CAN data structures.
Wherein, it is described according to the critical data and predefined profiles, generate the Excel texts of CAN network data
The step of part, includes：
The configuration specification to critical data is obtained from the configuration file；
The critical data is write in Excel file according to the configuration specification, so as to generate CAN network data
Excel file.
Wherein, the step that the critical data is write in Excel file according to the configuration specification, be specially：
Critical data in the CAN data structures is write in Excel file according to the configuration specification.
Wherein, the configuration specification is the order of keyword, and the keyword is CAN message parameter name and CAN message
In all CAN signals definition and the title of property parameters.
Wherein, it is described obtained from the configuration file to critical data configuration specification the step of after include：
Judge whether the be stored with prefabricated Excel sample files of user, the first row title bar of the Excel sample files
Content is the predefined keyword of user；
If the determination result is YES, then the critical data is write into the Excel sample files according to the configuration specification；
If judged result is no, the keyword in the critical data and the configuration file is advised according to the configuration
Model writes newly-built Excel file.
Wherein, the order and the sequence consensus of keyword in the configuration file of the predefined keyword of the user.
Wherein, the CAN network file is the CANdb network files of DBC forms.
Embodiments of the invention additionally provide a kind of device that CAN network file is converted to Excel file, including：
Critical data extraction module, for extracting critical data from CAN network file, the critical data includes：Institute
The definition of all CAN signals in some CAN message parameter and each CAN message and property parameters；
Configuration file acquisition module, for obtaining predefined profiles；
Excel file generation module, for according to the critical data and predefined profiles, generating CAN network
The Excel file of data.
Wherein, configuration specification acquiring unit, for obtaining the configuration specification to critical data from configuration file.
Writing unit, for the critical data to be write in Excel file according to configuration specification, so as to generate CAN nets
The Excel file of network data.
Wherein, described device also includes：
Judge module, for judging whether the be stored with prefabricated Excel sample files of user, the Excel sample files
The first row title bar content be the predefined keyword of user；
When judged result for when being, said write unit writes the critical data according to the configuration specification described
Excel sample files；
When judged result is no, said write unit presses the keyword in the critical data and the configuration file
Newly-built Excel file is write according to the configuration specification.
Implement the embodiment of the present invention, have the advantages that：
Embodiments of the invention are automatic raw by according to the critical data and configuration file extracted from CAN network file
Into the Excel file of CAN network data, thus save it is artificial CAN network file is converted into required for Excel file it is big
Typing and proof time are measured, work efficiency is improved, while it also avoid the corrupt data caused by human negligence.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the accompanying drawing used required in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can be with
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is the flow signal of the first embodiment of the method that CAN network file is converted to Excel file of the present invention
Figure.
Fig. 2 is the flow signal of the second embodiment of the method that CAN network file is converted to Excel file of the present invention
Figure.
Fig. 3 is the structural representation of the first embodiment of the device that CAN network file is converted to Excel file of the present invention
Figure.
Fig. 4 is the structural representation of the embodiment of the critical data extraction module of the present invention.
Fig. 5 is the structural representation of the embodiment of the Excel file generation module of the present invention.
Fig. 6 is the structural representation of the second embodiment of the device that CAN network file is converted to Excel file of the present invention
Figure.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation is described, it is clear that described embodiment is only a part of embodiment of the invention, rather than whole embodiments.It is based on
Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under the premise of creative work is not made
Embodiment, belongs to the scope of protection of the invention.
Fig. 1 is refer to, is the first embodiment of the method that CAN network file is converted to Excel file of the present invention
Schematic flow sheet.This method includes：
Step S101, critical data is extracted from CAN network file.Wherein, critical data includes：All CAN messages
The definition of all CAN signals in parameter and each CAN message and property parameters.CAN message parameter includes：Message indications,
Message name, message data length, message loop cycle, message mode, message sender, message receiver.CAN message
In all CAN signals definition and property parameters include：Signal name, signal bit length, signal byte order, signal physics list
Position, the type of signal value, signal proportion, signal offset, signal minimum, signal maximum, signal initial value, signal are illegal
Value, signal value annotation, defined signal value, signalling, receiving side signal.
Step S102, obtains predefined profiles.The acquisition of configuration file can be by inquiring about under local directory
Conf.ini files are realized.
Step S103, according to critical data and configuration file, generates the Excel file of CAN network data.
Embodiments of the invention are automatic raw by according to the critical data and configuration file extracted from CAN network file
Into the Excel file of CAN network data, thus save it is artificial CAN network file is converted into required for Excel file it is big
Typing and proof time are measured, work efficiency is improved, while it also avoid the corrupt data caused by human negligence.
Fig. 2 is refer to, is the second embodiment of the method that CAN network file is converted to Excel file of the present invention
Schematic flow sheet.This method includes：
Data in step S201, progressive scan CAN network file, will if inquiring critical data from current line
Critical data in current line is stored；If critical data is not inquired from current line, continue to scan on next line until
Last column end of scan.
Wherein, critical data includes：The definition of all CAN signals in all CAN message parameters and each CAN message
And property parameters.CAN message parameter includes：Message indications, message name, message data length, message loop cycle, message
Sending method, message sender, message receiver.The definition of all CAN signals and property parameters include in CAN message：Signal
Title, signal bit length, signal byte order, signal physical unit, the type of signal value, signal proportion, signal offset, letter
Number minimum value, signal maximum, signal initial value, signal illegal value, signal value annotation, defined signal value, signal are sent
Side, receiving side signal.CAN network file is usually the CANdb network files of DBC forms, and it can be opened in the way of text,
The content of the inside is readable.
Preferably, the critical data in step S201 can be stored in the form of predefined CAN data structures,
Specifically, can be by all parameters in a CAN message（Including：All CAN in the CAN message parameter and the CAN message
The definition of signal and property parameters）It is defined into a CAN data structure so that one CAN data knots of each CAN message correspondence
Structure body, is packaged thus by CAN data structures to each CAN message, can be conveniently follow-up to these critical datas
Write-in.
CAN data structures predefine the title and data type of all parameters of CAN message, by critical data with pre-
, it is necessary to by parameters and its title and its data type during the form of the CAN data structures of definition is stored
Correspond storage.
Step S202, obtains predefined profiles.The acquisition of configuration file can be by inquiring about under local directory
Conf.ini files are realized.
Step S203, obtains the configuration specification to critical data from configuration file.Configuration specification defines keyword
Sequentially, wherein, keyword is definition and the property parameters of CAN message parameter name and all CAN signals in CAN message
Title, keyword should be consistent with the title defined in CAN data structures.
The keyword that the code language of current operation can be recognized defined in configuration file, such as when the generation currently run
When code language is MATLAB M language, the recognizable keyword defined in configuration file includes： Message Name、
Message ID、Message DLC、Message Transmitters、 Message Receiver、Message Cycle
Time、Message Send Type、Signal Name、Signal Byte Order、Signal Start Bit、Signal
Length、Signal Value Type、Signal Factor、Signal offset、Signal Minimum Value、
Signal Maximum Value、Signal Unit、Signal Receiver、Signal Initial Value、Signal
Invalid Value、Signal Value Table、Signal Comment.The selection and sequence of these keywords can be by
User presets according to the demand of vehicle factory in configuration file.
Step S204, judges whether the prefabricated Excel sample files of user that are stored with, if the determination result is YES, then enters
Step S205, if judged result is no, into step S206.
Wherein, the first row title bar content of Excel sample files is the predefined keyword of user.Due to different whole
Depot requires different to the pattern of Excel file, and the predefined keyword of user can not be complete with the keyword of configuration file
It is consistent, but both corresponding key word arrangements orders must be consistent, it is such as inconsistent, critical data and pass can be caused
The dislocation of key word corresponding relation.For example, the more complete Excel sample files of a ratio, the content of its first row title bar is from
A line first case is followed successively by from left to right：Message Name、Message ID（hex）、DLC（bytes）、Message
Cycle Time（ms）、Signal Name、Signal Comment、Start Bit Position、 Signal Length、
Signal Minimum Value、Signal Maximum Value、Init Value、Invalid Value、Signal
Unit.So correspondingly, the keyword rank in configuration file should be：Message Name、Message ID、
Message DLC、Message Cycle Time、Signal Name、Signal Comment、Signal Start Bit、
Signal Length、Signal Minimum Value、Signal Maximum Value、Signal Initial Value、
Signal Invalid Value、Signal Unit。
Step S205, Excel sample files are write by critical data according to configuration specification.
Step S206, the keyword in critical data and configuration file is write according to configuration specification newly-built Excel texts
Part.Specifically, step S206 first can write the keyword in configuration file successively according to configuration specification regulation order newly-built
The first row title bar of Excel file, then by corresponding to the critical data of keyword according to sequential write as defined in configuration specification
To under the first row title bar.
Step S205 and step S206, can be from current CAN data during critical data is write into Excel file
Structure extracts all parameters of CAN message, and by all parameters in the CAN message according to the pass corresponding to these parameters
The order of key word writes in a line of certain in Excel file successively, after the completion of the CAN message is write, then from next CAN data
Extract all parameters of another CAN message in structure, and by next line, Zhi Daosuo in these parameter read-in Excel files
Some CAN message write-ins are completed, so as to ultimately generate the Excel file of CAN network data.
Embodiments of the invention are automatic raw by according to the critical data and configuration file extracted from CAN network file
Into the Excel file of CAN network data, thus save it is artificial CAN network file is converted into required for Excel file it is big
Typing and proof time are measured, work efficiency is improved, while it also avoid the corrupt data caused by human negligence.
It is worth noting that, the method that CAN network file is converted to Excel file that the present invention is introduced in Fig. 1 to 2
Two embodiments can based on MATLAB M language realize.
Fig. 1 to Fig. 2 has been carried out in detail to the method that CAN network file is converted to Excel file of the embodiment of the present invention
Elaboration, continue with reference to accompanying drawing, the device corresponding to above method flow illustrated.
Fig. 3 is refer to, is the first embodiment of the device that CAN network file is converted to Excel file of the present invention
Schematic flow sheet.The device 100 includes：
Critical data extraction module 110, for extracting critical data from CAN network file.Wherein, critical packet
Include：The definition of all CAN signals in all CAN message parameters and each CAN message and property parameters.CAN message parameter
Including：Message indications, message name, message data length, the message loop cycle, message mode, message sender, disappear
Cease recipient.The definition of all CAN signals and property parameters include in CAN message：Signal name, signal bit length, signal letters
Section order, signal physical unit, the type of signal value, signal proportion, signal offset, signal minimum, signal maximum, letter
Number initial value, signal illegal value, signal value annotation, defined signal value, signalling, receiving side signal.
Configuration file acquisition module 120, for obtaining predefined profiles.The acquisition of configuration file can by
Conf.ini files are inquired about under local directory to realize.
Excel file generation module 130, for according to critical data and configuration file, generating CAN network data
Excel file.
Embodiments of the invention are automatic raw by according to the critical data and configuration file extracted from CAN network file
Into the Excel file of CAN network data, thus save it is artificial CAN network file is converted into required for Excel file it is big
Typing and proof time are measured, work efficiency is improved, while it also avoid the corrupt data caused by human negligence.
Fig. 4 is refer to, is the structural representation of the embodiment of the critical data extraction module of the present invention.Critical data is extracted
Module 110 includes：
Scanning element 111, for progressively scanning the data in CAN network file.Mistake of the scanning element 111 in scan data
Cheng Zhong, if inquiring critical data from current line, notifies that memory cell 112 is deposited the critical data in current line
Storage；If not inquiring critical data from current line, next line to the last a line end of scan is continued to scan on.
Memory cell 112, for when inquiring critical data from current line, the critical data in current line to be carried out
Storage.Preferably, critical data can be stored in the form of predefined CAN data structures.Specifically, can be with
By all parameters in a CAN message（Including：In the CAN message parameter and the CAN message definition of all CAN signals and
Property parameters）It is defined into a CAN data structure so that one CAN data structures of each CAN message correspondence, it is so logical
CAN data structures are crossed to be packaged each CAN message, can the conveniently follow-up write-in to these critical datas.
CAN data structures predefine the title and data type of all parameters of CAN message, by critical data with pre-
, it is necessary to by parameters and its title and its data type during the form of the CAN data structures of definition is stored
Correspond storage.
Fig. 5 is refer to, is the structural representation of the embodiment of the Excel file generation module of the present invention.Excel file is given birth to
Include into module 130：
Configuration specification acquiring unit 131, for obtaining the configuration specification to critical data from configuration file.
Writing unit 132, for the critical data to be write in Excel file according to configuration specification, so as to generate CAN
The Excel file of network data.Configuration specification defines the order of keyword, wherein, keyword is CAN message parameter name
And definition and the title of property parameters of all CAN signals in CAN message, defined in keyword and CAN data structures
Title is consistent.The keyword that the code language of current operation can be recognized defined in configuration file, such as when current fortune
When capable code language is MATLAB M language, the recognizable keyword defined in configuration file includes： Message
Name、Message ID、Message DLC、Message Transmitters、 Message Receiver、Message
Cycle Time、Message Send Type、Signal Name、Signal Byte Order、Signal Start Bit、
Signal Length、Signal Value Type、Signal Factor、Signal offset、Signal Minimum
Value、Signal Maximum Value、Signal Unit、Signal Receiver、Signal Initial Value、
Signal Invalid Value、Signal Value Table、Signal Comment.The selection and sequence of these keywords
It can be preset by user according to the demand of vehicle factory in configuration file.
Fig. 6 is refer to, is the second embodiment of the device that CAN network file is converted to Excel file of the present invention
Schematic flow sheet.The device 100 includes：
Critical data extraction module 110, for extracting critical data from CAN network file.Specifically, critical data
Extraction module 110 can progressively scan the data in CAN network file, if inquiring critical data from current line, will be current
Critical data in row is stored；If not inquiring critical data from current line, next line is continued to scan on to the last
A line end of scan.Critical data includes：The definition of all CAN signals in all CAN message parameters and each CAN message
And property parameters.CAN message parameter includes：Message indications, message name, message data length, message loop cycle, message
Sending method, message sender, message receiver.The definition of all CAN signals and property parameters include in CAN message：Signal
Title, signal bit length, signal byte order, signal physical unit, the type of signal value, signal proportion, signal offset, letter
Number minimum value, signal maximum, signal initial value, signal illegal value, signal value annotation, defined signal value, signal are sent
Side, receiving side signal.Preferably, critical data extraction module 110 can be by critical data with predefined CAN data structures
Form stored, specifically, can be by all parameters in a CAN message（Including：The CAN message parameter and should
The definition of all CAN signals and property parameters in CAN message）It is defined into a CAN data structure so that every CAN disappears
Breath one CAN data structures of correspondence, are packaged thus by each CAN message, can be conveniently follow-up to these crucial numbers
According to write-in.
Configuration file acquisition module 120, for obtaining predefined profiles.The acquisition of configuration file can by
Conf.ini files are inquired about under local directory to realize.The code language of current operation can be recognized defined in configuration file
Keyword, keyword is definition and the name of property parameters of CAN message parameter name and all CAN signals in CAN message
Claim.For example when the code language currently run is MATLAB M language, the recognizable keyword bag defined in configuration file
Include： Message Name、Message ID、Message DLC、Message Transmitters、 Message
Receiver、Message Cycle Time、Message Send Type、Signal Name、Signal Byte Order、
Signal Start Bit、Signal Length、Signal Value Type、Signal Factor、Signal offset、
Signal Minimum Value、Signal Maximum Value、Signal Unit、Signal Receiver、Signal
Initial Value、Signal Invalid Value、Signal Value Table、Signal Comment.These are crucial
The selection and sequence of word can be by demand of the user according to vehicle factory, by being preset in configuration file.Configuration file is also
The configuration specification on these keywords is defined, configuration specification is the order of keyword.
Judge module 140, for judging whether the prefabricated Excel sample files of user that are stored with.
Excel file generation module 130, for according to critical data and configuration file, generating CAN network data
Excel file.Specifically, Excel file generation module 130 can obtain the configuration specification to critical data from configuration file,
And when the judged result of judge module 140 is is, critical data is write into Excel sample files according to configuration specification；When
When the judged result of judge module 140 is no, the keyword in critical data and configuration file is write according to configuration specification new
The Excel file built.
The first row title bar content of Excel sample files is the predefined keyword of user.Due to different vehicle factories
Different is required to the pattern of Excel file, the predefined keyword of user can not completely be kept with the keyword of configuration file
Unanimously, but both corresponding key word arrangements orders must be consistent.For example, the more complete Excel samples text of a ratio
Part, the content of its first row title bar is followed successively by from left to right from the first row first case：Message Name、Message ID
（hex）、DLC（bytes）、Message Cycle Time（ms）、Signal Name、Signal Comment、Start Bit
Position、 Signal Length、Signal Minimum Value、Signal Maximum Value、Init Value、
Invalid Value、Signal Unit.So correspondingly, the keyword rank in configuration file should be：Message
Name、Message ID、Message DLC、Message Cycle Time、Signal Name、Signal Comment、
Signal Start Bit、Signal Length、Signal Minimum Value、Signal Maximum Value、
Signal Initial Value、Signal Invalid Value、Signal Unit。
When the judged result of judge module 140 is no, Excel file generation module 130 can be first by the pass in configuration file
Key word writes the first row title bar of newly-built Excel file according to order as defined in configuration specification successively, then will correspond to
The critical data of keyword is write under the first row title bar successively according to order as defined in configuration specification.Excel file is generated
Module 130 can extract a certain CAN message during critical data is write into Excel file from current CAN data structures
All parameters, and all parameters in the CAN message are write successively according to the order of the keyword corresponding to these parameters
In a line of certain in Excel file, after the completion of the CAN message is write, then extract from next CAN data structures another
All parameters of CAN message, and by next line in these parameter read-in Excel files, until all CAN messages have write
Into so as to ultimately generate the Excel file of CAN network data.
Embodiments of the invention are automatic raw by according to the critical data and configuration file extracted from CAN network file
Into the Excel file of CAN network data, thus save it is artificial CAN network file is converted into required for Excel file it is big
Typing and proof time are measured, work efficiency is improved, while it also avoid the corrupt data caused by human negligence.
One of ordinary skill in the art will appreciate that realize all or part of flow in above-described embodiment method, being can be with
The hardware of correlation is instructed to complete by computer program, described program can be stored in a computer read/write memory medium
In, the program is upon execution, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, described storage medium can be magnetic
Dish, CD, read-only memory（Read-Only Memory, ROM）Or random access memory（Random Access
Memory, RAM）Deng.
Above disclosed is only a kind of preferred embodiment of the invention, can not limit the power of the present invention with this certainly
Sharp scope, one of ordinary skill in the art will appreciate that all or part of flow of above-described embodiment is realized, and according to present invention power
Profit requires made equivalent variations, still falls within and invents covered scope.
Claims (5)
1. a kind of method that CAN network file is converted to Excel file, it is characterised in that including：
Critical data is extracted from CAN network file, the critical data is entered in the form of predefined CAN data structures
Row storage, the CAN data structures predefine the title and data type of all parameters of CAN message, by critical data
During being stored in the form of predefined CAN data structures, by parameters and its title and its data type
Storage is corresponded, the critical data includes：All CAN signals in all CAN message parameters and each CAN message
Definition and property parameters；
Obtain predefined profiles；
The configuration specification to critical data is obtained from the configuration file, the configuration specification defines the order of keyword,
The keyword is definition and the title of property parameters of all CAN signals in CAN message parameter name and CAN message, described
Keyword is consistent with the title defined in CAN data structures；
Judge whether the prefabricated Excel sample files of user that are stored with, the first row title bar content of the Excel sample files
For the predefined keyword of user, the order and the order of keyword in the configuration file of the predefined keyword of user
Unanimously；
If the determination result is YES, then the critical data is write into the Excel sample files according to the configuration specification；
If judged result is no, the keyword in the critical data and the configuration file is write according to the configuration specification
Enter newly-built Excel file.
2. the method as described in claim 1, it is characterised in that the step of extracting critical data in the file from CAN network
Including：
Progressively scan the data in CAN network file；
If inquiring critical data from current line, the critical data in current line is stored.
3. the method as described in claim 1, it is characterised in that described to write the critical data according to the configuration specification
Step in Excel file, be specially：
Critical data in the CAN data structures is write in Excel file according to the configuration specification.
4. the method as described in claim 1, it is characterised in that the CAN network file is literary for the CANdb networks of DBC forms
Part.
5. a kind of device that CAN network file is converted to Excel file, it is characterised in that including：
Critical data extraction module, for extracting critical data from CAN network file, by the critical data with predefined
The form of CAN data structures is stored, the CAN data structures predefine all parameters of CAN message title and
Data type, by critical data during being stored in the form of predefined CAN data structures, by parameters
Correspond and store with its title and its data type, the critical data includes：All CAN message parameters and every CAN
The definition of all CAN signals in message and property parameters；
Configuration file acquisition module, for obtaining predefined profiles；
Excel file generation module, for according to the critical data and predefined profiles, generating CAN network data
Excel file；
The Excel file generation module includes：
Configuration specification acquiring unit, for obtaining the configuration specification to critical data from configuration file, the configuration specification is determined
The justice order of keyword, the keyword is definition and the category of all CAN signals in CAN message parameter name and CAN message
The title of property parameter, the keyword is consistent with the title defined in CAN data structures；
Writing unit, for the critical data to be write in Excel file according to configuration specification, so as to generate CAN network number
According to Excel file；
Described device also includes：
Judge module, for judging whether the prefabricated Excel sample files of user that are stored with, the of the Excel sample files
A line title bar content is the predefined keyword of user, the order and the configuration file of the predefined keyword of user
The sequence consensus of middle keyword；
When judged result for when being, the critical data is write the Excel by said write unit according to the configuration specification
Sample file；
When judged result is no, said write unit is by the keyword in the critical data and the configuration file according to institute
State configuration specification and write newly-built Excel file；
Wherein, configuration specification defines the order of keyword, and the keyword is institute in CAN message parameter name and CAN message
There are the definition of CAN signal and the title of property parameters, the keyword keeps one with the title defined in CAN data structures
Cause；The pass defined with the configuration specification that puts in order of keyword in the Excel sample files the first row title bar content
The sequence consensus of key word.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210464311.4A CN103823804B (en) | 2012-11-19 | 2012-11-19 | CAN network file is converted to the method and device of Excel file |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210464311.4A CN103823804B (en) | 2012-11-19 | 2012-11-19 | CAN network file is converted to the method and device of Excel file |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103823804A CN103823804A (en) | 2014-05-28 |
| CN103823804B true CN103823804B (en) | 2017-10-17 |
Family
ID=50758876
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210464311.4A Active CN103823804B (en) | 2012-11-19 | 2012-11-19 | CAN network file is converted to the method and device of Excel file |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103823804B (en) |
Families Citing this family (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105260422B (en) * | 2015-09-28 | 2018-10-26 | 西北核技术研究所 | A kind of multi-format Wave data file batch processing method |
| CN108345288B (en) * | 2017-01-23 | 2020-01-31 | 长城汽车股份有限公司 | Automatic generation method and system of CAN signal interface software and vehicle |
| CN107247697A (en) * | 2017-07-05 | 2017-10-13 | 上海蔚赫信息科技有限公司 | A kind of method that Excel file is converted to automotive networking DBC files |
| CN107566344B (en) * | 2017-08-03 | 2020-08-21 | 智车优行科技（北京）有限公司 | CAN signal analysis method and system |
| CN109582639A (en) * | 2018-11-01 | 2019-04-05 | 广东国鸿氢能科技有限公司 | A kind of automobile protocol database document generating method and device |
| CN112347047A (en) * | 2019-08-09 | 2021-02-09 | 广州汽车集团股份有限公司 | Vehicle data file generation method and device |
| CN112751810B (en) * | 2019-10-31 | 2023-03-24 | 杭州海康汽车技术有限公司 | CAN message analysis method, device and terminal |
| CN111309684A (en) * | 2020-03-13 | 2020-06-19 | 佛山市飞驰汽车制造有限公司 | Method for analyzing automobile network DBC file based on script tool |
| CN112799321B (en) * | 2020-12-14 | 2022-02-01 | 东风汽车集团有限公司 | DBC file rapid creating method following CAN bus communication protocol |
| CN113568875A (en) * | 2021-07-26 | 2021-10-29 | 广州小鹏自动驾驶科技有限公司 | Database DBC file generation method and device |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100388676C (en) * | 2004-12-06 | 2008-05-14 | 中兴通讯股份有限公司 | Method for auto-forming reporting forms of telecommunication equipment performance |
| US9128727B2 (en) * | 2006-08-09 | 2015-09-08 | Microsoft Technology Licensing, Llc | Generation of managed assemblies for networks |
| CN101751461A (en) * | 2009-12-30 | 2010-06-23 | 中兴通讯股份有限公司 | Document conversion method and device |
| CN102156741A (en) * | 2011-04-16 | 2011-08-17 | 武钢集团昆明钢铁股份有限公司 | Custom dynamic report system and implementation method thereof |
-
2012
- 2012-11-19 CN CN201210464311.4A patent/CN103823804B/en active Active
Non-Patent Citations (3)
| Title |
|---|
| CAN总线分析仪检测装置的研制;林丹红;《计量与测试技术》;20111231;全文 * |
| CAN总线技术在汽车网络中的研究与实现;王磊 等;《长春工业大学学报(自然科学版)》;20080317;全文 * |
| 基于汽车电子控制网络的CAN总线网络环境的研究;范宇;《中国优秀硕士学位论文全文数据库 工程科技II辑》;20071115;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103823804A (en) | 2014-05-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103823804B (en) | CAN network file is converted to the method and device of Excel file | |
| CN101694952B (en) | Method for generating embedded telecontrol system definitions by IEC61850 SCD files | |
| CN103838683B (en) | The method and apparatus of data transfer | |
| CN109901888B (en) | Design method of automatic configuration file generation tool | |
| CN102289407A (en) | Method for automatically testing document format conversion and device thereof | |
| CN111585344B (en) | Substation intelligent checking method and device based on total station IED simulation | |
| CN109033338B (en) | Method and system for generating database file of automobile communication protocol | |
| CN101600178A (en) | Junk information confirmation method and device, terminal | |
| CN103777934B (en) | A kind of method and system generating controller CAN alternation of bed based on MATLAB | |
| CN103577548B (en) | Method and device for matching characters with close pronunciation | |
| CN105045391A (en) | Smart watch gesture input method and smart watch | |
| CN103324401A (en) | Chart display method and device of report | |
| CN103377123B (en) | A kind of web page code automated testing method and device | |
| WO2014040488A1 (en) | Method and device for guaranteeing consistency of planning data | |
| CN110390082A (en) | A kind of communication matrix control methods and system | |
| CN102801548A (en) | Intelligent early warning method, device and information system | |
| Dybkjær et al. | The MATE markup framework | |
| CN103929499A (en) | Internet of things heterogeneous identification recognition method and system | |
| CN103970776B (en) | A kind of method and system of establishment CAN hierarchical trees | |
| KR100850021B1 (en) | System and Method for Changing Web Document Style | |
| CN107645564A (en) | A kind of CAN message analytic method and its system based on data buffer storage | |
| CN107644059A (en) | Method and apparatus, storage medium and terminal device derived from database file | |
| CN107643968A (en) | Crash log processing method and processing device | |
| CN106649852A (en) | Method and system for converting PCB file into Gerber file | |
| CN102609664B (en) | Based on the identification of process fingerprint intelligent and fuzzy acquisition system and method thereof that can carry out body |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Jiang Jianshan Inventor before: Jiang Jianshan |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20211229 Address after: 511400 No.36 Longying Road, Shilou Town, Panyu District, Guangzhou City, Guangdong Province Patentee after: GAC AIAN New Energy Vehicle Co.,Ltd. Address before: 510030 23 building, Cheng Yue mansion 448-458, Dongfeng Middle Road, Yuexiu District, Guangzhou, Guangdong. Patentee before: GUANGZHOU AUTOMOBILE GROUP Co.,Ltd. |