Method and device for converting CAN (controller area network) files into Excel files

A network file and excel technology, applied in the field of communication, can solve problems such as low work efficiency, large data volume, and labor-intensive proofreading time, and achieve the effects of improving work efficiency, avoiding data errors, and saving input and proofreading time

Active Publication Date: 2014-05-28
GAC AION NEW ENERGY AUTOMOBILE CO LTD
View PDF4 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the prior art, the key information in the CAN network file is written into the Excel file by manual input, but due to the huge amount of data in the CAN network file, human negligence may occur in the process of manual conversion. The data is wrong, and it will consume a lot of manpower proofreading time, making the work efficiency low

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for converting CAN (controller area network) files into Excel files
  • Method and device for converting CAN (controller area network) files into Excel files
  • Method and device for converting CAN (controller area network) files into Excel files

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0046] Please refer to figure 1 , is a schematic flow chart of the first embodiment of the method for converting a CAN network file into an Excel file of the present invention. The method includes:

[0047] Step S101, extracting key data from CAN network files. Among them, the key data include: all CAN message parameters and the definition and attribute parameters of all CAN signals in each CAN message. CAN message parameters include: message identifier, message...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

An embodiment of the invention discloses a method for converting CAN (controller area network) files into Excel files. The method includes the following steps: extracting key data from the CAN files, wherein the key data include all CAN message parameters and definitions and attribute parameters of all CAN signals in each CAN message; acquiring predefined configuration files; generating the Excel files of the CAN data according to the key data and the configuration files. The embodiment of the invention further discloses a device for converting the CAN files into the Excel files. By the method and the device, the CAN files can be converted into the Excel files automatically, labor and cost are saved, and work efficiency is improved.

Description

technical field [0001] The invention relates to the communication field, in particular to a method and a device for converting a CAN network file into an Excel file. Background technique [0002] In the field of vehicle controller area network communication, the CAN (Controller Area Network, controller area network) communication protocol has become one of the most commonly used communication protocols. This communication protocol specifies all CAN messages and all CAN signals in each CAN message. Definition and attributes, in the controller software application, it is necessary to parse the CAN message into an actual signal with physical meaning according to the CAN communication protocol content defined in the CAN network file. Considering the data exchange format, the OEM needs to publish the key information in the CAN network file in the Excel format. [0003] In the prior art, the key information in the CAN network file is written into the Excel file by manual inpu...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06F17/22
CPCG06F16/116
Inventor 江健山
Owner GAC AION NEW ENERGY AUTOMOBILE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products