Method, device and equipment for automatically analyzing routing table to generate programming firmware and medium
By automatically analyzing the routing table to generate a firmware, the problem of cumbersome routing table analysis and writing processes in the existing technology is solved, and a fast and simplified firmware upgrade process is realized. Users only need to operate the host computer to import the routing table file. Generate required files, saving time and increasing efficiency.
Patent Information
- Application Number
- CN202410959414.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-17
- Publication Date
- 2024-11-26
AI Technical Summary
The existing technology is cumbersome when dealing with the analysis of the routing table of the automobile gateway and firing firmware, which leads to a long development cycle and troublesome maintenance. Especially when the number of messages is large, it is necessary to manually draw a flow chart or gradually convert the routing table array, which is cumbersome.
Provides a method of automatically parsing the routing table to generate and write firmware. By importing the routing table to the superior computer, it determines whether it is a standard file based on the routing table name. If it is a standard file, it generates a c file and a hex file that can be directly burned. If it is a non-standard file, it will be converted to a standard file format for pre-processing, and generate c-files and hex files available for the project to realize the automated writing process.
It greatly reduces the difficulty of user operations. You only need to import the routing table file to automatically generate the required files, saving upgrade time, and you can directly write the hex file when the routing table changes, without the need to write the entire project.
Smart Images

Figure CN119025128A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of automotive electronic gateways, and in particular to a method, device, equipment and medium for automatically parsing a routing table to generate and burn firmware. Background Art
[0002] The gateway is the core of the internal communication LAN of the car. It can realize the sharing of information on each bus, as well as the network management and fault diagnosis functions inside the car. The gateway needs to receive and forward many messages on the bus, but not every message needs to be forwarded by the gateway. Therefore, when performing message forwarding operations, a routing table is required as a benchmark to determine which messages need to be forwarded and to which channel. This requires software engineers to handle when building gateway software. The routing table is generally an EXCEL file (spreadsheet file) defined by the OEM, and only some of the content is what the software needs to care about (such as: message ID, source address (Src), destination address (Dst), etc.), so the routing table needs to be parsed and written into the software.
[0003] In previous projects, there were two parsing methods. The first was to use Matlab (a commercial mathematical software) to draw a flow chart for the forwarding of each message, manually specify the source address and destination address of each message, and then generate the drawn flow chart as a c file, which was then imported into the compiler for compilation to generate a hex file (hex file is a file format that can be burned into a microcontroller and executed by the microcontroller, and c file can be compiled by the compiler to generate a hex file). However, the processing flow of this method is more cumbersome. When the number of messages is large, more diagrams need to be drawn, resulting in a long development cycle and subsequent maintenance troubles. The second method is to directly convert the routing table into an array containing only message ID, Src, and Dst in EXCEL and copy it to the code, process it in the program to identify this array, and only replace this array in the code each time it is changed. Although it reduces the workload compared to the first method, the process of converting the routing table to an array is still cumbersome. Summary of the invention
[0004] The present application provides a method, device, equipment and medium for automatically parsing a routing table to generate and burn firmware, so that when a customer only proposes a routing table change, the hex file generated by the host computer can be directly burned without burning the entire project, thus saving upgrade time.
[0005] In a first aspect, an embodiment of the present application provides a method for automatically parsing a routing table to generate a burning firmware, the method for automatically parsing a routing table to generate a burning firmware comprising:
[0006] Import the routing table to the host computer, parse the routing table based on the host computer, and determine whether the routing table is a standard file based on the routing table name:
[0007] If it is a standard file, the current routing table is preprocessed to generate a C file that can be used in the project and a hex file that can be directly burned;
[0008] If it is a non-standard file, convert the current routing table into a standard file format and pre-process it to generate a C file that can be used in the project and a hex file that can be directly burned;
[0009] The routing table is an Excel file, and the routing table includes multiple worksheets.
[0010] In combination with the first aspect, in one implementation, before importing the routing table into the host computer, it also includes: when allocating flash to the device to be burned, specifying a dedicated memory space for the routing table.
[0011] In combination with the first aspect, in one implementation, the importing of the routing table into the host computer, parsing the routing table based on the host computer and determining whether the routing table is a standard file based on the routing table name, specifically includes:
[0012] Select the routing table based on the file selection window of the host computer to import the routing table into the host computer, and the host computer records the storage path of the routing table;
[0013] The imported routing table is copied to the memory, the routing table is parsed to obtain the name of the worksheet in the routing table, and the worksheet name is identified to determine whether it is the specified worksheet name of the standard file. If so, the current routing table is a standard file, if not, the current routing table is a non-standard file.
[0014] In combination with the first aspect, in one implementation,
[0015] The content of the standard file is the specified content, and the file name and format are fixed and cannot be modified;
[0016] The non-standard file is an unprocessed source file, which contains required content, but has a non-fixed file name and format.
[0017] In combination with the first aspect, in one implementation, the preprocessing of the current routing table to generate a C file that can be used in the project or a hex file that can be directly burned specifically includes:
[0018] Convert the worksheet of the current routing table into a specified format, sort, remove duplicates, and merge similar contents of the worksheets in the current routing table to obtain a sorted table;
[0019] The host computer recognizes the contents of the sorting table and generates a C file that can be used in the project and a hex file that can be directly burned;
[0020] The host computer identifies the version number information in the current routing table name, and fills the identified version number into the c file and the hex file.
[0021] In combination with the first aspect, in one implementation, the converting the current routing table into a standard file format and performing preprocessing, wherein the converting the current routing table into a standard file format specifically includes:
[0022] Create a new worksheet in the current routing table and name the new worksheet as the specified worksheet name of the standard file;
[0023] Remove special characters from the names of the original worksheets and all column names in the current routing table, merge the worksheets, delete blank rows, and convert the worksheets to the specified format.
[0024] In combination with the first aspect, in one implementation, after generating a C file that can be used in the project and a hex file that can be directly burned, the method includes:
[0025] To burn data:
[0026] When only the routing table has been changed, burn the generated hex file to the device to be burned;
[0027] When there are changes in the routing table and the software content other than the routing table, the generated c file is used to replace the c file with the same name in the project, and the changes in the software content other than the routing table are modified at the same time;
[0028] Compile the entire project through the compiler to obtain the hex file of the entire project;
[0029] Burn the obtained hex file to the device to be burned.
[0030] In a second aspect, the present application provides a device for automatically parsing a routing table to generate a firmware for burning, the device for automatically parsing a routing table to generate a firmware for burning includes:
[0031] An import module, which is used to import a routing table into a host computer, parse the routing table based on the host computer and determine whether the routing table is a standard file based on the name of the routing table. If it is a standard file, the first execution module is driven to work; if it is a non-standard file, the second execution module is driven to work;
[0032] The first execution module is used to pre-process the current routing table and generate a C file that can be used in the project and a hex file that can be directly burned;
[0033] The second execution module is used to convert the current routing table into a standard file format and perform preprocessing to generate a C file that can be used in the project and a hex file that can be directly burned;
[0034] The routing table is an Excel file, and the routing table includes multiple worksheets.
[0035] In a third aspect, the present application provides a device for automatically parsing a routing table to generate firmware for burning, the device for automatically parsing a routing table to generate firmware for burning comprises a processor, a memory, and a program for automatically parsing a routing table to generate firmware for burning stored in the memory and executable by the processor, wherein when the program for automatically parsing a routing table to generate firmware for burning is executed by the processor, the steps of the method for automatically parsing a routing table to generate firmware for burning described above are implemented.
[0036] In a fourth aspect, the present application provides a computer-readable storage medium, on which is stored a program for automatically parsing a routing table to generate a burned firmware. When the program for automatically parsing a routing table to generate a burned firmware is executed by a processor, the steps of the method for automatically parsing a routing table to generate a burned firmware described above are implemented.
[0037] The beneficial effects brought by the technical solution provided in the embodiments of the present application include:
[0038] (1) The generation of firmware burning is realized through the host computer. Only the routing table file needs to be imported to automatically generate the C file and hex file required by the user. The user only needs to operate the host computer and does not need to care about the code, which greatly reduces the user's operation difficulty;
[0039] (2) When defining the flash space of the device, the routing table project is separated from the rest of the project content. This allows the customer to directly burn the hex file generated by the host computer when only proposing a routing table change, without having to burn the entire project, saving upgrade time. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1 A flowchart of a method for automatically parsing a routing table to generate firmware for burning is provided for this application;
[0041] Figure 2 A schematic diagram of the functional modules of the device for automatically parsing the routing table to generate the firmware for burning in this application;
[0042] Figure 3 Schematic diagram of the hardware structure of the device that automatically parses the routing table to generate the firmware for burning for this application. DETAILED DESCRIPTION
[0043] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.
[0044] In order to make the objectives, technical solutions and advantages of the present application clearer, the implementation methods of the present application will be further described in detail below with reference to the accompanying drawings.
[0045] In a first aspect, an embodiment of the present application provides a method for automatically parsing a routing table to generate a firmware for burning.
[0046] In one embodiment, referring to Figure 1 , Figure 1 This is a flow chart of the method for automatically parsing the routing table to generate firmware for burning in this application. Figure 1 As shown, the method for automatically parsing the routing table to generate the firmware for burning includes:
[0047] S1: Import the routing table to the host computer, parse the routing table based on the host computer and determine whether the routing table is a standard file based on the routing table name. If it is a standard file, go to S2; if it is a non-standard file, go to S3;
[0048] S2: Preprocess the current routing table to generate a C file that can be used in the project and a hex file that can be directly burned;
[0049] S3: Convert the current routing table into a standard file format and perform preprocessing to generate a C file that can be used in the project and a hex file that can be directly burned; the routing table is an Excel file, and the routing table includes multiple worksheets.
[0050] Further, in one embodiment, before importing the routing table to the host computer, it also includes: when the flash (a non-volatile memory) is distributed to the burning device, a dedicated memory space is specified for the routing table. That is, the use premise for the host computer is to specify a dedicated memory space for the routing table when the flash is distributed to the burning device. In the partition of the flash, the routing table engineering file area and other engineering file areas are included.
[0051] Further, in one embodiment, the routing table is imported into the host computer, and the host computer parses the routing table and determines whether the routing table is a standard file based on the name of the routing table, specifically including:
[0052] S101: Selecting a routing table based on a file selection window of the host computer to import the routing table into the host computer, and the host computer records a storage path of the routing table;
[0053] Specifically, click the import button in the host computer, a file selection window pops up, and after the routing table file is selected, the host computer will remember the storage path of the routing table file in the computer. If the imported routing table file is in an open or damaged state, the host computer will give an abnormal prompt.
[0054] S102: copy the imported routing table to the memory, parse the routing table to obtain the name of the worksheet in the routing table, identify the worksheet name to determine whether it is the specified worksheet name of the standard file, if so, the current routing table is a standard file, if not, the current routing table is a non-standard file.
[0055] Specifically, after the routing table is imported into the host computer, the host computer immediately starts to perform the parsing operation. The host computer is compatible with standard files and non-standard files. The content of the standard file is the specified content (that is, the content specified by the customer), and the file name and format are fixed and unmodified files; non-standard files are unprocessed source files (that is, unprocessed source files provided by the customer). Non-standard files contain the required content, but the file name and format are not fixed.
[0056] It should be noted that after the routing table is imported into the host computer, the routing table is copied to the memory, and subsequent operations are all backup files, that is, the routing table copied to the memory.
[0057] The host computer parses the routing table, obtains the name of the worksheet in the routing table, identifies the worksheet name to determine whether it is the specified worksheet name of the standard file, and thus determines whether the current routing table is a standard file. If it is a standard file, the processing process of the standard file is executed; if it is a non-standard file, it is converted into a standard file. After the conversion is completed, an Excel table in a standard format will be generated under the import path of the routing table file for the customer's subsequent reference, and then the processing process of the standard file is executed.
[0058] Further, in one embodiment, the current routing table is preprocessed to generate a C file that can be used in the project or a hex file that can be directly burned, specifically including:
[0059] S201: converting the worksheet of the current routing table into a specified format (the specified format is a file format specified by the user according to actual work needs), sorting, de-duplicating, and merging the same type of worksheets in the current routing table to obtain a sorted table;
[0060] After receiving the message, the gateway needs to find out whether there is a matching message in the routing table. Sorting and deduplication can help improve the search efficiency and improve the software work efficiency. The sorting table is automatically exported for customers to view. After that, the host will give a prompt "Import completed, please export", and display the processed Excel table preview in the interface, so that users can check whether the modification is correct.
[0061] S202: The host computer identifies the contents of the sorting table and generates a C file that can be used in the project and a hex file that can be directly burned; click the export button, the host computer will identify the contents of the sorting table, and generate a C file and a hex file.
[0062] S203: The host computer identifies the version number information in the name of the current routing table, and fills the identified version number into the c file and the hex file. For example, the host computer identifies the version number in the name of "routing table V1.0.0" and fills it into the c file and the hex file. In actual work, if the routing table name does not contain a version number, the user can select the version number by himself.
[0063] Further, in one embodiment, the current routing table is converted into a standard file format and preprocessed, wherein the current routing table is converted into a standard file format, specifically including:
[0064] S301: Create a new worksheet in the current routing table and name the new worksheet as the designated worksheet name of the standard file;
[0065] S302: Remove the names of the original worksheets in the current routing table and special characters in all column names (special characters include spaces, line breaks, etc.), merge the worksheets, delete blank lines, and convert the worksheets to a specified format, thereby converting non-standard files into standard files.
[0066] Similarly, after converting the current routing table into a standard file, convert the worksheet of the current routing table into a specified format, sort, deduplicate, and merge the contents of the worksheet in the current routing table to obtain a sorted table; the host computer recognizes the contents of the sorted table, generates a C file that can be used in the project and a hex file that can be directly burned; the host computer recognizes the version number information in the name of the current routing table, and fills the recognized version number into the C file and the hex file.
[0067] Further, in one embodiment, after generating a C file that can be used in the project and a hex file that can be directly burned, the following steps are included:
[0068] S311: Perform data burning operation:
[0069] S312: When only the routing table is changed, the generated hex file is burned into the device to be burned;
[0070] S313: When there are changes in both the routing table and the software content other than the routing table, the generated c file is used to replace the c file with the same name in the project, and the changes in the software content other than the routing table are modified at the same time;
[0071] S314: Compile the entire project through a compiler to obtain a hex file of the entire project;
[0072] S315: Burn the obtained hex file into the device to be burned.
[0073] There are two ways to burn, which are suitable for two situations. One is that only the routing table file has changed. At this time, you can directly use the hex file generated by the host computer to burn it into the device; the other is that the routing table and the software content outside the routing table have changed. At this time, you can replace the c file with the same name in the project with the generated c file, and modify the rest of the changed content synchronously. Use the compiler to compile the entire project to get the hex file of the entire project file. After burning, the overall program of the device is updated.
[0074] The method of automatically parsing the routing table to generate burning firmware in the embodiment of the present application realizes the generation of burning firmware through the host computer. It only needs to import the routing table file to automatically generate the C file and hex file required by the user. The user only needs to operate the host computer and does not need to care about the code, which greatly reduces the user's operation difficulty. At the same time, this solution applies to separate the routing table project from the rest of the project content when defining the flash space of the device. This allows the customer to directly burn the hex file generated by the host computer when only proposing a change to the routing table, without burning the entire project, saving upgrade time.
[0075] In a second aspect, an embodiment of the present application also provides a device for automatically parsing a routing table to generate a firmware for burning.
[0076] In one embodiment, referring to Figure 2 , Figure 2 This is a functional module diagram of a device for automatically parsing a routing table to generate a firmware for burning in this application. Figure 2 As shown, the device for automatically parsing the routing table to generate the burning firmware includes: an import module, a first execution module, and a second execution module.
[0077] The import module is used to import the routing table to the host computer, parse the routing table based on the host computer and determine whether the routing table is a standard file based on the name of the routing table. If it is a standard file, the first execution module is driven to work, and if it is a non-standard file, the second execution module is driven to work; the first execution module is used to preprocess the current routing table to generate a C file that can be used in the project and a hex file that can be directly burned; the second execution module is used to convert the current routing table into a standard file format and preprocess it to generate a C file that can be used in the project and a hex file that can be directly burned; wherein the routing table is an Excel file, and the routing table includes multiple worksheets.
[0078] In the present application, before importing the routing table into the host computer, it also includes: when allocating flash to the device to be burned, specifying a dedicated memory space for the routing table.
[0079] In this application, the routing table is imported into the host computer, and the host computer parses the routing table and determines whether the routing table is a standard file based on the routing table name, specifically including:
[0080] Select the routing table based on the file selection window of the host computer to import the routing table into the host computer, and the host computer records the storage path of the routing table;
[0081] The imported routing table is copied to the memory, the routing table is parsed to obtain the name of the worksheet in the routing table, and the worksheet name is identified to determine whether it is the specified worksheet name of the standard file. If so, the current routing table is a standard file, if not, the current routing table is a non-standard file.
[0082] In this application, the content of the standard file is the specified content, and the file name and format are fixed and cannot be modified;
[0083] The non-standard file is an unprocessed source file, which contains required content, but has a non-fixed file name and format.
[0084] In this application, the current routing table is preprocessed to generate a C file that can be used in the project or a hex file that can be directly burned, including:
[0085] Convert the worksheet of the current routing table into a specified format, sort, remove duplicates, and merge similar contents of the worksheets in the current routing table to obtain a sorted table;
[0086] The host computer recognizes the contents of the sorting table and generates a C file that can be used in the project and a hex file that can be directly burned;
[0087] The host computer identifies the version number information in the current routing table name, and fills the identified version number into the c file and the hex file.
[0088] In this application, the current routing table is converted into a standard file format and preprocessed, wherein the current routing table is converted into a standard file format, specifically including:
[0089] Create a new worksheet in the current routing table and name the new worksheet as the specified worksheet name of the standard file;
[0090] Remove special characters from the names of the original worksheets and all column names in the current routing table, merge the worksheets, delete blank rows, and convert the worksheets to the specified format.
[0091] In this application, after generating the c file that can be used in the project and the hex file that can be directly burned, it includes:
[0092] To burn data:
[0093] When only the routing table has been changed, burn the generated hex file to the device to be burned;
[0094] When there are changes in the routing table and the software content other than the routing table, the generated c file is used to replace the c file with the same name in the project, and the changes in the software content other than the routing table are modified at the same time;
[0095] Compile the entire project through the compiler to obtain the hex file of the entire project;
[0096] Burn the obtained hex file to the device to be burned.
[0097] In a third aspect, an embodiment of the present application provides a device for automatically parsing a routing table to generate a firmware for burning. The device for automatically parsing a routing table to generate a firmware for burning may be a personal computer (PC), a laptop computer, a server, or other device with data processing capabilities.
[0098] Reference Figure 3 , Figure 3 The hardware structure diagram of the device for automatically parsing the routing table to generate the firmware for burning involved in the embodiment of the present application is shown in FIG. In the embodiment of the present application, the device for automatically parsing the routing table to generate the firmware for burning may include a processor, a memory, a communication interface, and a communication bus.
[0099] The communication bus may be of any type and is used to interconnect the processor, the memory, and the communication interface.
[0100] The communication interface includes input / output (I / O) interfaces, physical interfaces, and logical interfaces, which are used to interconnect devices within the device that automatically parses the routing table to generate the firmware, and interfaces that interconnect the device that automatically parses the routing table to generate the firmware and other devices (such as other computing devices or user devices). The physical interface can be an Ethernet interface, a fiber optic interface, an ATM interface, etc.; the user device can be a display, a keyboard, etc.
[0101] The memory can be various types of storage media, such as random access memory (RAM), read-only memory (ROM), non-volatile RAM (NVRAM), flash memory, optical storage, hard disk, programmable ROM (PROM), erasable PROM (EPROM), electrically erasable PROM (EEPROM), etc.
[0102] The processor may be a general-purpose processor, and the general-purpose processor may call the program for automatically parsing the routing table to generate the firmware for burning stored in the memory, and execute the method for automatically parsing the routing table to generate the firmware for burning provided by the embodiment of the present application. For example, the general-purpose processor may be a central processing unit (CPU). Among them, the method executed when the program for automatically parsing the routing table to generate the firmware for burning is called may refer to the various embodiments of the method for automatically parsing the routing table to generate the firmware for burning of the present application, which will not be repeated here.
[0103] Those skilled in the art will understand that Figure 3 The hardware structure shown in the figure does not constitute a limitation on the present application, and may include more or less components than shown in the figure, or combine certain components, or arrange the components differently.
[0104] In a fourth aspect, an embodiment of the present application also provides a computer-readable storage medium.
[0105] The computer-readable storage medium of the present application stores a program for automatically parsing a routing table to generate a burning firmware, wherein when the program for automatically parsing a routing table to generate a burning firmware is executed by a processor, the steps of the method for automatically parsing a routing table to generate a burning firmware as described above are implemented.
[0106] Among them, the method implemented when the program for automatically parsing the routing table to generate the burning firmware is executed can refer to the various embodiments of the method for automatically parsing the routing table to generate the burning firmware of the present application, and will not be repeated here.
[0107] It should be noted that the serial numbers of the above-mentioned embodiments of the present application are only for description and do not represent the advantages or disadvantages of the embodiments.
[0108] The terms "including" and "having" and any variations thereof in the specification and claims of this application and the above-mentioned drawings are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device that includes a series of steps or units is not limited to the listed steps or units, but optionally includes steps or units that are not listed, or optionally includes other steps or units inherent to these processes, methods, products or devices. The terms "first", "second" and "third" are used to distinguish different objects, etc., and do not represent a sequence, nor do they limit "first", "second" and "third" to different types.
[0109] In the description of the embodiments of the present application, "exemplary", "for example" or "for example" are used to indicate examples, illustrations or descriptions. Any embodiment or design described as "exemplary", "for example" or "for example" in the embodiments of the present application should not be interpreted as being more preferred or more advantageous than other embodiments or designs. Specifically, the use of words such as "exemplary", "for example" or "for example" is intended to present related concepts in a specific way.
[0110] In the description of the embodiments of the present application, unless otherwise specified, “ / ” means or, for example, A / B can mean A or B; the “and / or” in the text is merely a description of the association relationship of associated objects, indicating that three relationships may exist, for example, A and / or B can mean: A exists alone, A and B exist at the same time, and B exists alone. In addition, in the description of the embodiments of the present application, “multiple” refers to two or more than two.
[0111] In some processes described in the embodiments of the present application, multiple operations or steps that appear in a specific order are included, but it should be understood that these operations or steps may not be executed in the order in which they appear in the embodiments of the present application or in parallel, and the sequence number of the operation is only used to distinguish the different operations, and the sequence number itself does not represent any execution order. In addition, these processes may include more or fewer operations, and these operations or steps may be executed in sequence or in parallel, and these operations or steps may be combined.
[0112] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present application is essentially or the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, disk, CD) as described above, and includes a number of instructions for a terminal device to execute the methods described in each embodiment of the present application.
[0113] The above are only preferred embodiments of the present application, and are not intended to limit the patent scope of the present application. Any equivalent structure or equivalent process transformation made using the contents of the present application specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present application.
Claims
1. A method for automatically parsing a routing table to generate a firmware for burning, characterized in that: The method for automatically parsing the routing table to generate the firmware for burning includes: Import the routing table to the host computer, parse the routing table based on the host computer, and determine whether the routing table is a standard file based on the routing table name: If it is a standard file, the current routing table is preprocessed to generate a C file that can be used in the project and a hex file that can be directly burned; If it is a non-standard file, convert the current routing table into a standard file format and pre-process it to generate a C file that can be used in the project and a hex file that can be directly burned; The routing table is an Excel file, and the routing table includes multiple worksheets.
2. A method for automatically parsing a routing table to generate a firmware for burning as claimed in claim 1, characterized in that: Before importing the routing table into the host computer, the method further includes: when allocating flash memory to the device to be burned, specifying a dedicated memory space for the routing table.
3. A method for automatically parsing a routing table to generate a firmware for burning as claimed in claim 1, characterized in that: The importing of the routing table into the host computer, parsing the routing table based on the host computer and judging whether the routing table is a standard file based on the routing table name, specifically includes: Select the routing table based on the file selection window of the host computer to import the routing table into the host computer, and the host computer records the storage path of the routing table; The imported routing table is copied to the memory, the routing table is parsed to obtain the name of the worksheet in the routing table, and the worksheet name is identified to determine whether it is the specified worksheet name of the standard file. If so, the current routing table is a standard file, if not, the current routing table is a non-standard file.
4. A method for automatically parsing a routing table to generate a firmware for burning as claimed in claim 1, characterized in that: The content of the standard file is the specified content, and the file name and format are fixed and cannot be modified; The non-standard file is an unprocessed source file, which contains required content, but has a non-fixed file name and format.
5. A method for automatically parsing a routing table to generate a firmware for burning as claimed in claim 1, characterized in that: The preprocessing of the current routing table to generate a C file that can be used in the project or a hex file that can be directly burned specifically includes: Convert the worksheet of the current routing table into a specified format, sort, remove duplicates, and merge similar contents of the worksheets in the current routing table to obtain a sorted table; The host computer recognizes the contents of the sorting table and generates a C file that can be used in the project and a hex file that can be directly burned; The host computer identifies the version number information in the current routing table name, and fills the identified version number into the c file and the hex file.
6. A method for automatically parsing a routing table to generate a firmware for burning as claimed in claim 1, characterized in that: The converting the current routing table into a standard file format and performing preprocessing, wherein the converting the current routing table into a standard file format specifically includes: Create a new worksheet in the current routing table and name the new worksheet as the specified worksheet name of the standard file; Remove special characters from the names of the original worksheets and all column names in the current routing table, merge the worksheets, delete blank rows, and convert the worksheets to the specified format.
7. A method for automatically parsing a routing table to generate a firmware for burning as claimed in claim 1, characterized in that: After generating the c file that can be used in the project and the hex file that can be burned directly, including: To burn data: When only the routing table has been changed, burn the generated hex file to the device to be burned; When there are changes in the routing table and the software content other than the routing table, the generated c file is used to replace the c file with the same name in the project, and the changes in the software content other than the routing table are modified at the same time; Compile the entire project through the compiler to obtain the hex file of the entire project; Burn the obtained hex file to the device to be burned.
8. A device for automatically parsing a routing table to generate a firmware for burning, characterized in that: The device for automatically parsing the routing table to generate the burning firmware includes: An import module, which is used to import a routing table into a host computer, parse the routing table based on the host computer and determine whether the routing table is a standard file based on the name of the routing table. If it is a standard file, the first execution module is driven to work; if it is a non-standard file, the second execution module is driven to work; The first execution module is used to pre-process the current routing table and generate a C file that can be used in the project and a hex file that can be directly burned; The second execution module is used to convert the current routing table into a standard file format and perform preprocessing to generate a C file that can be used in the project and a hex file that can be directly burned; The routing table is an Excel file, and the routing table includes multiple worksheets.
9. A device for automatically parsing a routing table to generate a firmware for burning, characterized in that: The device for automatically parsing a routing table to generate a firmware for burning comprises a processor, a memory, and a program for automatically parsing a routing table to generate a firmware for burning stored in the memory and executable by the processor, wherein when the program for automatically parsing a routing table to generate a firmware for burning is executed by the processor, the steps of the method for automatically parsing a routing table to generate a firmware for burning as described in any one of claims 1 to 7 are implemented.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a program for automatically parsing a routing table to generate a firmware for burning. When the program for automatically parsing a routing table to generate a firmware for burning is executed by a processor, the steps of the method for automatically parsing a routing table to generate a firmware for burning as described in any one of claims 1 to 7 are implemented.
