Data processing system and method for automobile wire harness Inline file based on Excel-VBA

Abstract

The invention discloses a data processing system and method for an automobile wire harness Inline file based on Excel-VBA. The method comprises the following steps: step 100, establishing a database for storing project parameters of an automobile electronic wire harness Inline connector based on a VBA window; 200, reading an externally input target file, and automatically obtaining source file information of connector data in the target file according to a VBA language; step 300, reading the source file information and the project parameters respectively, performing reasonable logical operation on the source file information according to a VBA language and the project parameters, and forming a logical operation result; and step 400, reading the logical operation result, and displaying the logical operation result on a window appointed interface which is set in a user-defined manner and aims at the automobile electronic wire harness. According to the method and the device, the file information can be quickly checked based on Excel, and the working efficiency and the working accuracy of checking the file data are improved.

Description

Technical Field

[0001] The invention relates to the technical field of data processing, and in particular to a data processing system for automotive electronic wiring harness Inline files based on Excel-VBA. Background Art

[0002] With the rapid development of the current intelligent automobile industry, the electrical circuits of automobile wiring harnesses are becoming more and more numerous and increasingly complex. At the same time, the R&D project cycle is constantly compressed. How to complete the delivery task with high quality within the specified time has become particularly important for the engineering and technical personnel in the automotive industry. Therefore, the requirements for the work efficiency of engineering and technical personnel in the automotive industry are increasing. The existing data processing of automotive electronic wiring harness Inline files completely relies on Excel tools to manually complete the inspection of file information. Due to the huge amount of data in the electrical circuit, it will consume a lot of energy and time of technicians. Therefore, how to develop a new data processing system for automotive electronic wiring harness Inline files to overcome the above-mentioned problems in the prior art is a direction that technicians in this field need to study. Summary of the invention

[0003] The first object of the present invention is to provide a data processing method for automotive electronic wiring harness Inline files based on Excel-VBA, which can realize rapid checking and display of file information based on Excel to improve the work efficiency and accuracy of checking file data.

[0004] The second object of the present invention is to provide an Excel-VBA-based automotive electronic wiring harness Inline file data processing system for executing the above data processing method.

[0005] The invention discloses a data processing method of an automobile wiring harness Inline file based on Excel-VBA, which comprises the following steps:

[0006] Step 100: Establish a database for storing project parameters of the automotive electronic wiring harness Inline connector based on a VBA form;

[0007] Step 200: reading an externally input target file, and automatically acquiring source file information of connector data in the target file according to the VBA language;

[0008] Step 300: respectively reading the source file information and the project parameters, performing rational logic operations on the source file information according to the VBA language and the project parameters, and forming a logic operation result;

[0009] Step 400: reading the logic operation result, and displaying the logic operation result on a custom window designation interface for an automotive electronic wiring harness.

[0010] Preferably, the project parameters of the automotive electronic wiring harness Inline connector include:

[0011] The material number of the automotive electronic wiring harness Inline connector; the image information of the automotive electronic wiring harness Inline connector; the hole layout of the automotive electronic wiring harness Inline connector; the wire diameter range adapted by the hole terminals of the automotive electronic wiring harness Inline connector.

[0012] Preferably, the step 200 includes:

[0013] Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file;

[0014] Step 220: Automatically obtain wire diameter information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the wire diameter information in the form of a character string;

[0015] The step 300 includes:

[0016] Step 310: Arranging the wire diameter information in sequence in an array manner and comparing it with the adaptation data in the database, automatically determining whether the wire diameter information corresponding to all loops of the target file is adapted to the terminals in the connector based on the comparison result, and if it is determined that there is wire diameter information that is not compatible with the terminals in the connector, assigning the incompatible wire diameter information to the specified text;

[0017] The step 400 includes:

[0018] Step 410: if it is determined in step 310 that the unmatched wire diameter information exists, the assigned designated text is displayed on the window designated interface;

[0019] Step 420: modify the incompatible information, and repeat the steps 210, 220, and 310 until the wire diameter information is completely matched with the inner end of the connector;

[0020] Step 430: If it is determined in step 310 that there is no unmatched wire diameter information, all matching wire diameters are displayed in the window designation interface.

[0021] Preferably, the step 200 includes:

[0022] Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file;

[0023] Step 230: Automatically obtain the circuit configuration information corresponding to all circuits of the connector of the target file according to the VBA language, and temporarily store the circuit configuration information in the form of a character string;

[0024] The step 300 comprises:

[0025] Step 320: Filter out holes with different configurations on the connector of the target file by traversing and looping, and temporarily store the filter results;

[0026] The step 400 includes:

[0027] Step 440: Fill the holes with different configurations temporarily stored in step 320 with colors, set different variables for each hole with different configurations, assign them to different groups, assign different colors to different groups, and display them on the specified interface of the window.

[0028] Preferably, the step 200 includes:

[0029] Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file;

[0030] Step 230: Automatically obtain the circuit configuration information corresponding to all circuits of the connector of the target file according to the VBA language, and temporarily store the circuit configuration information in the form of a character string;

[0031] The step 300 comprises:

[0032] Step 330: Automatically filter out the cases in which the plug-in corresponds to the same hole position and is a single configuration in the target file, and determine whether the configuration information of the male and female plug-in pair is consistent. If it is determined that there is inconsistent configuration information of the male and female plug-in pair, temporarily store the inconsistent configuration information of the male and female plug-in pair;

[0033] The step 400 includes:

[0034] Step 450: if it is determined in step 330 that there is no inconsistent male-female pair plug-in configuration information, displaying that there is no inconsistency between the male-female pair plug-ins at a designated position of the designated interface of the window;

[0035] Step 460: If it is determined in step 330 that there is inconsistent male-female pair plug-in configuration information, the inconsistent male-female pair plug-in configuration information is displayed in a list at a specified position of the specified window interface, and the font color configured for the corresponding circuit is changed.

[0036] Preferably, the step 200 includes:

[0037] Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file;

[0038] Step 240: Automatically obtain the twisting mode information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the twisting mode information in the form of a character string;

[0039] The step 300 includes:

[0040] Step 340: all strings with the prefix TW are traversed according to the algorithm and temporarily stored, and the same strings are grouped into the same group in an array, and are grouped in order and temporarily stored;

[0041] The step 400 includes:

[0042] Step 470: Bold the fonts of the same hole position numbers corresponding to the different groups stored in step 340 in the form designation interface, and assign different colors to the fonts of the same hole position numbers corresponding to the different groups in the form designation interface according to the rules pre-stored in the background.

[0043] Preferably, the step 200 includes:

[0044] Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file;

[0045] Step 240: Automatically obtain the twisting mode information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the twisting mode information in the form of a character string;

[0046] The step 300 includes:

[0047] Step 350: all character strings with the prefix SH are traversed according to the algorithm and temporarily stored, and the same character strings are grouped into the same group in an array, and are grouped in order and temporarily stored;

[0048] The step 400 includes:

[0049] Step 480: Bold the fonts of the same hole position numbers corresponding to the different groups stored in step 350 in the form designation interface and fill the fonts of the same hole position numbers corresponding to the different groups in the form designation interface with different colors according to specific rules set by the background algorithm.

[0050] Preferably, the step 200 includes:

[0051] Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file;

[0052] Step 250: Automatically obtain wire color abbreviation information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the wire color abbreviation information in the form of a character string;

[0053] The step 300 includes:

[0054] Step 360: sorting the obtained wire color abbreviation information, separating the abbreviations of the primary color line and the secondary color line by using a string processing algorithm, assigning the wire color abbreviations of all the hole positions in the target file with codes that are recognizable in the specified interface of the form and corresponding to the hole position number, and temporarily storing the codes;

[0055] The step 400 includes:

[0056] Step 490: Automatically convert the wire color codes corresponding to different hole position numbers in the target file stored in step 360 into color images and fill them into the text labels of the form designation interface, and lay them out on the form designation interface according to the hole position distribution on the connector of the target file.

[0057] Preferably, the step 200 includes:

[0058] Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file;

[0059] Step 250: Automatically obtain wire color abbreviation information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the wire color abbreviation information in the form of a character string;

[0060] The step 300 includes:

[0061] Step 370: Filter out all the holes with different wire colors on the connector of the target file by loop traversal, and temporarily store them in the form of code;

[0062] The step 400 includes:

[0063] Step 4100: automatically display the codes temporarily stored in step 370 in a list at a designated position of the form designation interface, so that the hole positions corresponding to the text boxes of the form designation interface are updated with different colors in real time.

[0064] The present invention also discloses a data processing system for automobile wiring harness Inline files based on Excel-VBA.

[0065] It includes:

[0066] A database module, wherein the database module is used to store project parameters of an automotive electronic wiring harness Inline connector based on a VBA form;

[0067] A data acquisition module, the data acquisition module is used to read an external input target file and automatically acquire source file information of connector data in the target file according to the VBA language;

[0068] A data processing module, the data processing module is respectively connected to the data acquisition module and the database module by signal, the data processing module is used to read the source file information and the project parameters respectively, perform rational logic operation on the source file information according to the VBA language and the project parameters, and form a logic operation result;

[0069] A display module is signal-connected to the data processing module and is used to display the logic operation result.

[0070] Compared with the prior art, the present invention can greatly improve the efficiency and accuracy of engineering personnel in checking document data, and greatly improve the problem of material waste caused by human errors and the reduction of the number of product changes. BRIEF DESCRIPTION OF THE DRAWINGS

[0071] Figure 1 This is a module schematic diagram of Example 1.

[0072] Figure 2 This is a schematic diagram of the workflow of Example 1.

[0073] In the figure, the component names corresponding to the reference numerals are as follows:

[0074] 100, database module; 200, data acquisition module; 300, data processing module; 400, display module. DETAILED DESCRIPTION

[0075] The following describes the embodiments of the present invention through specific examples, and those skilled in the art can easily understand other advantages and effects of the present invention from the contents disclosed in this specification. The present invention can also be implemented or applied through other different specific embodiments, and the details in this specification can also be modified or changed in various ways based on different viewpoints and applications without departing from the spirit of the present invention.

[0076] Example 1, please refer to Figure 1-2 :

[0077] A data processing system for automobile wiring harness Inline files based on Excel-VBA comprises: a database module 100, a data acquisition module 200, a data processing module 300 and a display module 400.

[0078] The database module 100 is used to store the project parameters of the automotive electronic wiring harness Inline connector based on the VBA form; the data acquisition module 200 is used to read the external input target file and automatically obtain the source file information of the connector data in the target file according to the VBA language; the data processing module 300 is respectively connected to the data acquisition module 200 and the database module 100 by signal, the data processing module 300 is used to read the source file information and the project parameters respectively, perform rational logic operations on the source file information according to the VBA language and the project parameters, and form logic operation results; the display module 400 is connected to the data processing module 300 by signal, and the display module 400 is used to display the logic operation results.

[0079] The working process is as follows:

[0080] A data processing method of an automobile wiring harness Inline file based on Excel-VBA includes the following steps:

[0081] Step 100: Establish a database for storing project parameters of the automotive electronic wiring harness Inline connector based on a VBA form;

[0082] Step 200: reading an externally input target file, and automatically acquiring source file information of connector data in the target file according to the VBA language;

[0083] Step 300: respectively reading the source file information and the project parameters, performing rational logic operations on the source file information according to the VBA language and the project parameters, and forming a logic operation result;

[0084] Step 400: reading the logic operation result, and displaying the logic operation result on a custom window designation interface for an automotive electronic wiring harness.

[0085] in,

[0086] In step 100, the project parameters of the automotive electronic wiring harness Inline connector include: the material number of the automotive electronic wiring harness Inline connector; the image information of the automotive electronic wiring harness Inline connector; the hole layout of the automotive electronic wiring harness Inline connector; and the wire diameter range adapted by the hole terminals of the automotive electronic wiring harness Inline connector.

[0087] The step 200 comprises:

[0088] Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file;

[0089] Step 220: Automatically obtain wire diameter information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the wire diameter information in the form of a character string;

[0090] Step 230: Automatically obtain the circuit configuration information corresponding to all circuits of the connector of the target file according to the VBA language, and temporarily store the circuit configuration information in the form of a character string;

[0091] Step 240: Automatically obtain the twisting mode information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the twisting mode information in the form of a character string;

[0092] Step 250: Automatically obtain wire color abbreviation information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the wire color abbreviation information in the form of a character string;

[0093] The step 300 includes:

[0094] Step 310: Arranging the wire diameter information in sequence in an array manner and comparing it with the adaptation data in the database, automatically determining whether the wire diameter information corresponding to all loops of the target file is adapted to the terminals in the connector based on the comparison result, and if it is determined that there is wire diameter information that is not compatible with the terminals in the connector, assigning the incompatible wire diameter information to the specified text;

[0095] Step 320: Filter out holes with different configurations on the connector of the target file by traversing and looping, and temporarily store the filter results;

[0096] Step 330: Automatically filter out the cases in which the plug-in corresponds to the same hole position and is a single configuration in the target file, and determine whether the configuration information of the male and female plug-in pair is consistent. If it is determined that there is inconsistent configuration information of the male and female plug-in pair, temporarily store the inconsistent configuration information of the male and female plug-in pair;

[0097] Step 340: all strings with the prefix TW are traversed according to the algorithm and temporarily stored, and the same strings are grouped into the same group in an array, and are grouped in order and temporarily stored;

[0098] Step 350: all character strings with the prefix SH are traversed according to the algorithm and temporarily stored, and the same character strings are grouped into the same group in an array, and are grouped in order and temporarily stored;

[0099] Step 360: sorting the obtained wire color abbreviation information, separating the abbreviations of the primary color line and the secondary color line by using a string processing algorithm, assigning the wire color abbreviations of all the hole positions in the target file with codes that are recognizable in the specified interface of the form and corresponding to the hole position number, and temporarily storing the codes;

[0100] Step 370: Filter out all the holes with different wire colors on the connector of the target file by loop traversal, and temporarily store them in the form of code;

[0101] The step 400 includes:

[0102] Step 410: if it is determined in step 310 that the unmatched wire diameter information exists, the assigned designated text is displayed on the window designated interface;

[0103] Step 420: modify the incompatible information, and repeat the steps 210, 220, and 310 until the wire diameter information is completely matched with the inner end of the connector;

[0104] Step 430: if it is determined in step 310 that there is no unmatched wire diameter information, displaying that all wire diameters are matched on the window designation interface;

[0105] Step 440: Fill the holes with different configurations temporarily stored in step 320 with colors, set different variables for each hole with different configurations, assign them to different groups, assign different colors to different groups, and display them on the specified interface of the window.

[0106] Step 450: if it is determined in step 330 that there is no inconsistent male-female pair plug-in configuration information, displaying that there is no inconsistency between the male-female pair plug-ins at a designated position of the designated interface of the window;

[0107] Step 460: If it is determined in step 330 that there is inconsistent male-female pair plug-in configuration information, the inconsistent male-female pair plug-in configuration information is displayed in a list at a specified position of the specified window interface, and the font color configured for the corresponding circuit is changed.

[0108] Step 470: Bold the fonts of the same hole position numbers corresponding to the different groups stored in step 340 in the form designation interface, and assign different colors to the fonts of the same hole position numbers corresponding to the different groups in the form designation interface according to the rules pre-stored in the background.

[0109] Step 480: Bold the fonts of the same hole position numbers corresponding to the different groups stored in step 350 in the form designation interface and fill the fonts of the same hole position numbers corresponding to the different groups in the form designation interface with different colors according to specific rules set by the background algorithm.

[0110] Step 490: Automatically convert the wire color codes corresponding to different hole position numbers in the target file stored in step 360 into color images and fill them into the text labels of the form designation interface, and lay them out on the form designation interface according to the hole position distribution on the connector of the target file.

[0111] Step 4100: automatically display the codes temporarily stored in step 370 in a list at a designated position of the form designation interface, so that the hole positions corresponding to the text boxes of the form designation interface are updated with different colors in real time.

[0112] The embodiments of the present invention are described in detail above in conjunction with the accompanying drawings, but the present invention is not limited to the above embodiments. Even if various changes are made to the present invention, if these changes fall within the scope of the claims of the present invention and their equivalents, they still fall within the protection scope of the present invention.

Claims

1. A data processing method for automotive wiring harness Inline files based on Excel-VBA, It is characterized in that The steps include: Step 100: Establish a database for storing project parameters of the automotive electronic wiring harness Inline connector based on a VBA form; Step 200: reading an externally input target file, and automatically acquiring source file information of connector data in the target file according to the VBA language; Step 300: respectively reading the source file information and the project parameters, performing rational logic operations on the source file information according to the VBA language and the project parameters, and forming a logic operation result; Step 400: reading the logic operation result, and displaying the logic operation result on a custom window designation interface for an automotive electronic wiring harness.

2. The data processing method according to claim 1, characterized in that: The project parameters of the automotive electronic wiring harness Inline connector include: The material number of the automotive electronic wiring harness Inline connector; the image information of the automotive electronic wiring harness Inline connector; the hole layout of the automotive electronic wiring harness Inline connector; the wire diameter range adapted by the hole terminals of the automotive electronic wiring harness Inline connector.

3. The data processing method according to claim 2, characterized in that: The step 200 comprises: Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file; Step 220: Automatically obtain wire diameter information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the wire diameter information in the form of a character string; The step 300 includes: Step 310: Arranging the wire diameter information in sequence in an array manner and comparing it with the adaptation data in the database, automatically determining whether the wire diameter information corresponding to all loops of the target file is adapted to the terminals in the connector based on the comparison result, and if it is determined that there is wire diameter information that is not compatible with the terminals in the connector, assigning the incompatible wire diameter information to the specified text; The step 400 includes: Step 410: if it is determined in step 310 that the unmatched wire diameter information exists, the assigned designated text is displayed on the window designated interface; Step 420: modify the incompatible information, and repeat the steps 210, 220, and 310 until the wire diameter information is completely matched with the inner end of the connector; Step 430: If it is determined in step 310 that there is no unmatched wire diameter information, all matching wire diameters are displayed in the window designation interface.

4. The data processing method according to claim 2, characterized in that: The step 200 comprises: Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file; Step 230: Automatically obtain the circuit configuration information corresponding to all circuits of the connector of the target file according to the VBA language, and temporarily store the circuit configuration information in the form of a character string; The step 300 comprises: Step 320: Filter out holes with different configurations on the connector of the target file by traversing and looping, and temporarily store the filter results; The step 400 includes: Step 440: Fill the holes with different configurations temporarily stored in step 320 with colors, set different variables for each hole with different configurations, assign them to different groups, assign different colors to different groups, and display them on the specified interface of the window.

5. The data processing method according to claim 2, characterized in that: The step 200 comprises: Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file; Step 230: Automatically obtain the circuit configuration information corresponding to all circuits of the connector of the target file according to the VBA language, and temporarily store the circuit configuration information in the form of a character string; The step 300 comprises: Step 330: Automatically filter out the cases in which the plug-in corresponds to the same hole position and is a single configuration in the target file, and determine whether the configuration information of the male and female plug-in pair is consistent. If it is determined that there is inconsistent configuration information of the male and female plug-in pair, temporarily store the inconsistent configuration information of the male and female plug-in pair; The step 400 includes: Step 450: if it is determined in step 330 that there is no inconsistent male-female pair plug-in configuration information, displaying that there is no inconsistency between the male-female pair plug-ins at a designated position of the designated interface of the window; Step 460: If it is determined in step 330 that there is inconsistent male-female pair plug-in configuration information, the inconsistent male-female pair plug-in configuration information is displayed in a list at a specified position of the specified window interface, and the font color configured for the corresponding circuit is changed.

6. The data processing method according to claim 2, characterized in that: The step 200 comprises: Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file; Step 240: Automatically obtain the twisting mode information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the twisting mode information in the form of a character string; The step 300 includes: Step 340: all strings with the prefix TW are traversed according to the algorithm and temporarily stored, and the same strings are grouped into the same group in an array, and are grouped in order and temporarily stored; The step 400 includes: Step 470: Bold the fonts of the same hole position numbers corresponding to the different groups stored in step 340 in the form designation interface, and assign different colors to the fonts of the same hole position numbers corresponding to the different groups in the form designation interface according to the rules pre-stored in the background.

7. The data processing method according to claim 2, characterized in that: The step 200 comprises: Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file; Step 240: Automatically obtain the twisting mode information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the twisting mode information in the form of a character string; The step 300 includes: Step 350: all character strings with the prefix SH are traversed according to the algorithm and temporarily stored, and the same character strings are grouped into the same group in an array, and are grouped in order and temporarily stored; The step 400 includes: Step 480: Bold the fonts of the same hole position numbers corresponding to the different groups stored in step 350 in the form designation interface and fill the fonts of the same hole position numbers corresponding to the different groups in the form designation interface with different colors according to specific rules set by the background algorithm.

8. The data processing method according to claim 2, characterized in that: The step 200 comprises: Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file; Step 250: Automatically obtain wire color abbreviation information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the wire color abbreviation information in the form of a character string; The step 300 includes: Step 360: sorting the obtained wire color abbreviation information, separating the abbreviations of the primary color line and the secondary color line by using a string processing algorithm, assigning the wire color abbreviations of all the hole positions in the target file with codes that are recognizable in the specified interface of the form and corresponding to the hole position number, and temporarily storing the codes; The step 400 includes: Step 490: Automatically convert the wire color codes corresponding to different hole position numbers in the target file stored in step 360 into color images and fill them into the text labels of the form designation interface, and lay them out on the form designation interface according to the hole position distribution on the connector of the target file.

9. The data processing method according to claim 2, characterized in that: The step 200 comprises: Step 210: automatically obtaining the connector material number in the target file according to the VBA language, and using the VBA form to call the data interface of the project parameters of the connector material number in the database that is adapted to the target file; Step 250: Automatically obtain wire color abbreviation information corresponding to all loops of the connector of the target file according to the VBA language, and temporarily store the wire color abbreviation information in the form of a character string; The step 300 includes: Step 370: Filter out all the holes with different wire colors on the connector of the target file by loop traversal, and temporarily store them in the form of code; The step 400 includes: Step 4100: automatically display the codes temporarily stored in step 370 in a list at a designated position of the form designation interface, so that the hole positions corresponding to the text boxes of the form designation interface are updated with different colors in real time.

10. A data processing system for automotive wiring harness Inline files based on Excel-VBA, It is characterized in that include: A database module, wherein the database module is used to store project parameters of an automotive electronic wiring harness Inline connector based on a VBA form; A data acquisition module, the data acquisition module is used to read an external input target file and automatically acquire source file information of connector data in the target file according to the VBA language; A data processing module, the data processing module is respectively connected to the data acquisition module and the database module by signal, the data processing module is used to read the source file information and the project parameters respectively, perform rational logic operation on the source file information according to the VBA language and the project parameters, and form a logic operation result; A display module is signal-connected to the data processing module and is used to display the logic operation result.

Images