Vehicle manufacturing stage data difference accuracy verification method and system

Through automated data difference detection methods, the data consistency and specific column information identification problems in the vehicle manufacturing stage are solved, the accuracy and efficiency of data comparison are improved, the dependence on professional skills is reduced, and product quality and consumer trust is improved. .

CN119089889APending Publication Date: 2024-12-06QIMING INFORMATION TECH
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411278562.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-09-12
Publication Date
2024-12-06

AI Technical Summary

Technical Problem

During the vehicle manufacturing stage, existing data differences verification methods have problems such as data consistency, identification of specific column information and inconsistent data formats, which makes it difficult to ensure accuracy and consistency, and manual inspection efficiency is inefficient, spreadsheet or database comparisons are corrected. Non-professional unfriendly, and limited support for dedicated software tools.

Method used

A method of data difference accuracy verification in vehicle manufacturing stage is adopted. By setting up a database, importing Excel table files, traversing the process, realizing data difference detection of vehicle model specifications, electronic control names, part numbers and configuration codes, and passing the background color and Font color displays comparison results, automated processing for improved accuracy and efficiency.

Benefits of technology

It significantly improves the accuracy and consistency of data comparison, reduces human errors, improves data processing efficiency, reduces dependence on professional skills, improves product quality and consumer trust, and reduces work pressure and error rate.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119089889A_ABST
    Figure CN119089889A_ABST
Patent Text Reader

Abstract

The invention discloses a vehicle manufacturing stage data difference accuracy verification method and system, and the method comprises the following steps: S1, setting a database which is used for storing information in an excel table; s2, a file needing to be verified is imported and verified; s3, traversing all the running processes, and adding the IDs (Identity) of the excel related processes to a protocol list; and S4, comparing the excel table to realize data difference detection of the vehicle type specification number, the electronic control name, the part number and the configuration code, and displaying a comparison result through different background colors and font colors. According to the invention, the speed and accuracy of data processing are improved, the dependence on professional skills is reduced, and the data processing is more efficient, reliable and economical.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of vehicle manufacturing, and in particular to a method and system for verifying the accuracy of data differences in a vehicle manufacturing stage. Background Art

[0002] At present, the methods for data difference verification in the vehicle manufacturing stage include manual inspection, spreadsheet or database comparison, and dedicated software tools. Among them, manual inspection: These tasks usually need to be completed manually, and the differences between data are identified and compared through visual or manual operations. Although this method is feasible in some small-scale projects, it has obvious limitations, such as inefficiency, error-prone and time-consuming. Due to human factors, data differences may be missed or misjudged, resulting in quality problems and seriously affecting production line shutdowns. Spreadsheet or database comparison: Data comparison is performed using spreadsheets (such as Excel) or database systems. Although this method is more efficient than pure manual operation, it still faces the problem of difficult to ensure accuracy and consistency, especially when dealing with large data sets. In addition, this method may not be intuitive or easy to operate for non-professionals. Dedicated software tools: There are some dedicated data comparison software on the market, which provide automated solutions to improve efficiency and accuracy. However, these tools usually require users to have a certain technical background, and support for specific formats or data structures may be limited, which limits their widespread application.

[0003] In general, there are at least the following technical problems in the prior art: 1. Data consistency issues: For example, inconsistent serial number ordering of vehicle models, inconsistent electronic control ordering, part numbers with suffixes (-A), and multiple data separated by spaces, semicolons, colons, and other punctuation marks.

[0004] 2. Specific column information identification problem: Since specific columns (such as vehicle model specification number, electronic control name, etc.) need to be identified and compared, the software must be able to understand and distinguish these key columns.

[0005] 3. Inconsistent data formats: When the formats of two sets of data are not uniform (for example, name, date format, numerical representation, etc.), direct comparison may produce false positives. Summary of the invention

[0006] In response to the above technical problems, the present invention provides a method and system for verifying the accuracy of data differences in the vehicle manufacturing stage.

[0007] The present invention is implemented by adopting the following technical solution: a method for verifying the accuracy of data differences in the vehicle manufacturing stage, comprising the following steps: S1: Set up a database to store information in the Excel table; S2: Import the file that needs to be verified and perform verification; S3: Traverse all running processes and add the IDs of the excel-related processes to the processid list; S4: Compare the Excel table to detect data differences in vehicle specification number, electronic control name, part number and configuration code, and display the comparison results through different background colors and font colors.

[0008] Furthermore, step S2 includes the following sub-steps: S21: add a click event processing method btnFile_Click to open a file selection dialog box and verify the conditions of the selected file, including whether the number of files is 2 and whether it is exported from the EOL system; S22: assign the selected file names to the text attributes of the labFile1 and labFile2 tags respectively; S23: Open the Excel application, and open the two files in sequence, and verify them with the expected values ​​respectively. If the verification passes, go to step S3.

[0009] Furthermore, the specific method of verifying with the expected value is: read the cell value from the worksheets of the two files respectively, convert it into uppercase strings and store it in the corresponding variables, compare the read value with the expected value for verification, and end the verification if it does not meet the expected value, wherein the expected value includes one or more of vehicle specifications, remarks and unit.

[0010] Further, step S3 includes the following steps: S31: Use the StoreProcess method: first clear the processid list, then get all currently running processes through Process.GetProcesses(), traverse all processes, and add the ID of the excel-related process to the processid list; S32: Use KillExcelProcess method: First, get all currently running processes through Process.GetProcesses(), then traverse all processes and terminate the processes related to Excel that are not in the processid list.

[0011] Further, step S4 includes the following steps: S41: Load and parse Excel file; S42: Set the progress bar and status text; S43: Parse the worksheet data and update the progress bar and status text; S44: Traverse the worksheet to detect data differences in vehicle model specification number, electronic control name, part number and configuration code, and insert the data difference detection result into the VSCS table.

[0012] Furthermore, the vehicle model specification number data difference detection includes forward processing and reverse processing, wherein: Forward processing: Select the vehicle models and part numbers that exist in the EOL system export table but do not exist in the VSCS table from the database, and mark the corresponding cells with a red background and white font; Reverse processing: Select the vehicle models and part numbers that exist in the VSCS table but do not exist in the EOL system export table from the database, and mark the corresponding cells with a red background and white font.

[0013] Furthermore, the electric control name data difference detection includes forward processing and reverse processing, wherein: Forward processing: Select the electric control names that exist in the EOL system export table but do not exist in the VSCS table from the database, and mark the corresponding cells with a red background and white font; Reverse processing: Select the electric control names that exist in the VSCS table but do not exist in the EOL system export table from the database, and mark the corresponding cells with a red background and white font.

[0014] Furthermore, part number data difference detection includes forward processing and reverse processing, wherein: Forward processing: Select the part numbers from the database that exist in the EOL system export table but do not exist in the VSCS table, and mark the corresponding cells with a dark orange background and blue font; Reverse process: Select the part numbers from the database that exist in the VSCS table but do not exist in the EOL system export table, and mark the corresponding cells with a dark orange background and blue font.

[0015] Furthermore, the configuration code data difference detection includes forward processing and reverse processing, wherein: Forward processing: Select the configuration codes from the database that exist in the EOL system export table but do not exist in the VSCS table, and mark the corresponding cells with a dark orange background and blue font; Reverse processing: Select the configuration codes that exist in the VSCS table but do not exist in the EOL system export table from the database, and mark the corresponding cells with a dark orange background and blue font.

[0016] A vehicle manufacturing stage data difference accuracy verification system is used to implement the above-mentioned vehicle manufacturing stage data difference accuracy verification method, including a database, an import module, a traversal module and a comparison module, wherein: Database, used to store information in excel sheets; Import module, used to import files that need to be verified and perform verification; The traversal module is used to traverse all running processes and add the IDs of the excel-related processes to the processid list; The comparison module is used to compare the Excel table to detect the data differences of vehicle specification number, electronic control name, part number and configuration code, and display the comparison results through different background colors and font colors.

[0017] The beneficial effects of the present invention are: Technical effect: By adopting advanced algorithms and automation technology, the accuracy and consistency of data comparison are significantly improved. This method can automatically identify and correct data differences and reduce the possibility of human error.

[0018] Economic effect: Improved efficiency of data processing, thus saving time and labor costs; automated processes reduce reliance on specialized skills, reducing training costs and the need for highly skilled labor.

[0019] Social impact: By improving the accuracy of data processing, it helps to improve the quality of the final product and enhance consumer trust. In addition, reducing human intervention can also help reduce stress and error rates in the workplace and improve employee job satisfaction.

[0020] The present invention solves several problems existing in the prior art, including the low efficiency and high error rate of manual inspection, the accuracy and consistency of electronic spreadsheet or database comparison, and the operational complexity and support limitations of dedicated software tools. By introducing a new automated data comparison method, it not only improves the speed and accuracy of data processing, but also reduces the dependence on professional skills, making data processing more efficient, reliable and economical. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the structures shown in these drawings without paying creative work.

[0022] Figure 1 It is a flow chart of the present invention. DETAILED DESCRIPTION

[0023] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Generally, the components of the embodiments of the present invention described and shown in the drawings here can be arranged and designed in various different configurations.

[0024] It should be noted that similar reference numerals and letters denote similar items in the following drawings, and therefore, once an item is defined in one drawing, further definition and explanation thereof is not required in subsequent drawings.

[0025] Some embodiments of the present invention are described in detail below in conjunction with the accompanying drawings. In the absence of conflict, the following embodiments and features in the embodiments can be combined with each other.

[0026] See also Figure 1 , a method for verifying the accuracy of data differences in a vehicle manufacturing stage, comprising the following steps: S1: Set up a database to store information in the Excel table; S2: Import the file that needs to be verified and perform verification; S3: Traverse all running processes and add the IDs of the excel-related processes to the processid list; S4: Compare the Excel table to detect data differences in vehicle specification number, electronic control name, part number and configuration code, and display the comparison results through different background colors and font colors.

[0027] In this embodiment, step S1 specifically includes: establishing a CompareDB.db database file for storing information in two Excel tables.

[0028] In the present embodiment, step S2 is specifically as follows: a button for selecting files is set, and a click event processing method btnFile_Click is added to it, which is used to open a file selection dialog box and verify the conditions of the selected files. Specifically, an OpenFileDialog object openFile is created in the code, and it is set to allow multiple selections, and the filter condition is specified as an Excel file. Then the file selection dialog box is displayed through the ShowDialog method. If the user selects a file and clicks the OK button, the verification and processing of the file begins. After the file is selected, the code first checks whether the number of selected files is 2. If not, a message box pops up to prompt the user that two files must be selected. Then, it is checked in turn whether the selected file name contains specific keywords "EOL system export" and "VSCS". If not, the user is prompted to include the corresponding keywords respectively. According to the verification result, the selected file name is assigned to the text attributes of the labFile1 and labFile2 tags respectively, which is used to display the selected file path on the interface.

[0029] Then, open the Excel application and open the first file (the path specified by labFile1.Text). Read the value of a specific cell from the first worksheet of the first file, convert it to an uppercase string and store it in the corresponding variable. Compare the read value with the expected value ("Model Specification Number", "Remarks", "Unit") for verification. If it does not meet the expectations, a message box pops up to prompt that the format is incorrect and end the verification process. If the first file passes the format verification, close the first file and open the second file (the path specified by labFile2.Text). Read the value of a specific cell from the first worksheet of the second file and compare it with the expected value. If the second file passes the format verification, close the second file, close the Excel application, clear the Excel process, and then reset the progress bar, status text, and enable the "Start" button.

[0030] In this embodiment, step S3 is specifically as follows: Use the StoreProcess method: first clear the processid list, then use Process.GetProcesses() to get all the running processes in the current system, traverse all processes, and if the process name is "EXCEL" or "EXCEL.EXE" (case-insensitive), add the process ID to the processid list.

[0031] Use the KillExcelProcess method: Also use Process.GetProcesses() to get all the running processes in the current system, then traverse all processes, and terminate the process named "EXCEL" or "EXCEL.EXE" that is not in the processid list (call the process.Kill() method) to ensure that during the execution of the program, other Excel processes opened by non-current programs will be closed to avoid possible conflicts or resource occupation problems.

[0032] In this embodiment, step S4 is specifically: adding a comparison button click event processing method btnStart_Click for comparing two Excel tables, specifically including: First disable the btnStart button to prevent users from clicking it repeatedly.

[0033] The Excel file is loaded and a new Excel application object excel is created. Two Excel files are opened respectively and their first worksheets are obtained.

[0034] Parsed the EOL export file and set the maximum value of the progress bar to the number of columns in the first worksheet. Made a series of formatting adjustments to the cells in the first and second worksheets, including changing the font, background color, etc. Looped through the first worksheet, parsed specific data, and concatenated the strings strEcu1 and strEcuCol1 based on the conditions. During the parsing process, the interface was updated in real time by updating the progress bar and calling the Application.DoEvents() method.

[0035] Set the progress bar and status text. First, set the value of the progress bar to 0, then set the maximum value of the progress bar to the number of columns of workSheet2, and update the status text to "Parsing VSCS file".

[0036] Parse the second worksheet data, use a loop to iterate through the columns of workSheet2, starting from the 4th column (index 3), and perform a series of processing on each column: get the title, find the cell position of a specific condition, and concatenate the strings strEcu2 and strEcuCol2 according to the condition.

[0037] Update the progress bar and status text. In the loop, update the value of the progress bar and use the System.Windows.Forms.Application.DoEvents() method to update the interface in real time. Update the status text to "Collating EOL export file data".

[0038] Traverse the first worksheet and insert data into the database according to certain logic. Traverse each row of the first worksheet to obtain vehicle information. If the character length is greater than 5, continue to perform subsequent operations, process each element in the headers1 array, extract ECU related information and perform database insertion operations. Update the progress bar and interface, update the value of the progress bar in the loop, and use the System.Windows.Forms.Application.DoEvents() method to update the interface in real time. Submit the transaction. After the loop ends, submit the transaction through transaction.Commit().

[0039] The second worksheet is traversed and the qualified data is inserted into a table named VSCS to detect data differences in vehicle model specification number, electronic control name, part number and configuration code.

[0040] The part that handles the difference in vehicle model specification numbers includes both forward and reverse processing. The specific operations include: Forward processing: Select the vehicle model and part number that exists in the EOL table but does not exist in the VSCS table from the database, and mark the corresponding cells with a red background and white font for easy identification. Reverse processing: Select the vehicle model and part number that exists in the VSCS table but does not exist in the EOL table from the database, and also mark the corresponding cells with a red background and white font.

[0041] The part with different electronic control names includes processing in both forward and reverse directions. The specific operations include: Forward processing: Select ECUs of type 'ECU' from the EOL table that exist in the EOL table but are not in the VSCS table. For each ECU found, locate it to the corresponding area in the Excel worksheet according to its range, and mark the area with a red background and white font for easy identification. At the same time, update the progress bar of the interface and ensure timely response of the interface. Reverse processing: Select ECUs of type 'ECU' from the EOL table that exist in the VSCS table but are not in the EOL table. Similarly, for each ECU found, locate it to the corresponding area in another Excel worksheet according to its range, and perform similar marking processing. The progress bar of the interface will also be updated to ensure timely response of the interface.

[0042] The difference in part numbers includes: Get the data that meets the conditions in the EOL and VSCS tables from the database through SQL query statements: First, query the data in the EOL and VSCS tables that have the same vehicle and ECU but different part numbers. Sort the query results by PartId, PartId_Y, and PartId_X. Fill the query results into the DataSet: Use SQLiteDataAdapter to execute the query statement and fill the results into the "EOL" table in the DataSet. Process and mark the data in the DataSet: Loop through each row of data in the DataSet. For each row of data, get the values ​​of PartId_Y and PartId_X, and then mark the corresponding cells in the Excel table. In forward processing, mark the cells in workSheet1; in reverse processing, mark the cells in workSheet2. Special processing for Ecu: Get the values ​​of Ecu_X and Ecu_EX according to the query results, and specially mark the corresponding areas in the Excel table. Finally, update the progress bar and status information: Update the value of the progress bar to ensure that the user can see the progress of the processing. Update labStatus.Text to display the status information of the current processing.

[0043] The part about configuration code difference specifically includes: firstly, obtaining the data of different configuration codes in the EOL table and the VSCS table by querying the database; then marking different cells in the Excel worksheet according to the data and setting the color; then querying the configuration code difference data in the other direction, and marking different cells in the Excel worksheet as well; finally, updating the color of the cell area in Excel according to the query results.

[0044] Finally, the comparison results show that: Vehicle specification number comparison [two-way comparison], if the comparison fails, the background of the data line will be red and the font will be white; Electronic control name comparison [two-way comparison], if the comparison fails, the column background of the controller corresponding to it will be red and the font will be white; Part number comparison [two-way comparison], if the comparison fails, the cell background will be dark orange and the font will be blue; Configuration code comparison [two-way comparison], if the comparison fails, the background of the cell will be dark orange and the font will be blue.

[0045] It should be noted that multiple static methods are applied in the present invention: The Ecu_compare_find() method is used to read data from an Excel file and concatenate each row of data into a string array and return it. First, open the specified Excel file, traverse each row and column, concatenate the values ​​of each cell together, and use "|" as a separator. Store the concatenated data in the string array rows and return the array. Finally, close the Excel application and workbook.

[0046] The Ecu_compare_change(string[] rows, string Ecu) method is used to compare data in a string array and return the matching result. The method receives the previously obtained data array rows and a string Ecu to be compared. It traverses each row of data and compares each row's substring separated by "|" with the Ecu to be compared one by one. If a match is found, the value of Ecu is updated to the value of the first cell in the row, and Break is set to 1 to terminate the loop. The comparison result is returned.

[0047] The A_A_delete(string str) method is used to delete the non-letter and non-digit part of a string and return the processed string. First, convert the input string into a character array. Then find the position of the first letter or number as the starting point, and find the position of the last letter or number as the ending point. Use the Substring method to intercept the part between the starting point and the ending point as a new string and return it.

[0048] The A_A_same(string str) method is used to determine whether a string is symmetrical (i.e., the left half is equal to the right half) and return the processed string. If the string length is an odd number, the original string is returned directly. If the string length is an even number, the string is divided into left and right halves, and then the left and right halves are compared to see if they are equal. If they are equal, the left half of the string is returned; otherwise, the original string is returned. If the string is equal to "TBD", an empty string is returned.

[0049] The worksheetcompare_ecu(string[]worksheetstr_ecu1, string[]worksheetstr_ecu2) method is used to compare the number of controllers in two Excel tables. The method accepts two string arrays as parameters, which represent the controller data in the two Excel tables. The main functions of this method include: 1) Create two dictionaries<string, int> Object, used to store controller names and their occurrence counts. 2) Traverse the first string array worksheetstr_ecu1, store the controller name as a key in dict1, and if it already exists, add one to the corresponding value, otherwise add the new key-value pair to the dictionary. 3) Traverse dict1, and for controllers with a number of occurrences greater than 1, pop up a message box to prompt that the comparison failed and display the controller name and number of occurrences. 4) Similarly, traverse the second string array worksheetstr_ecu2, store the controller name and its occurrence count in dict2, and then search for controllers with a number of occurrences greater than 1 and pop up a corresponding message box prompt.

[0050] Based on the above embodiments, the present invention has at least the following technical effects: Technical effect: By adopting advanced algorithms and automation technology, the accuracy and consistency of data comparison are significantly improved. The method can automatically identify and correct data differences and reduce the possibility of human error. Economic effect: The efficiency of data processing is improved, thereby saving time and labor costs. The automated process reduces the reliance on professional skills, reduces training costs and the demand for highly skilled labor. Social effect: By improving the accuracy of data processing, it helps to improve the quality of the final product and enhance consumer trust. In addition, reducing human intervention also helps to reduce stress and error rates in the workplace and improve employee job satisfaction.

[0051] The present invention solves several problems existing in the prior art, including the low efficiency and high error rate of manual inspection, the accuracy and consistency of electronic spreadsheet or database comparison, and the operational complexity and support limitations of dedicated software tools. By introducing a new automated data comparison method, it not only improves the speed and accuracy of data processing, but also reduces the dependence on professional skills, making data processing more efficient, reliable and economical.

[0052] For the aforementioned embodiments, for the sake of simplicity, they are all described as a series of action combinations, but those skilled in the art should be aware that the present application is not limited by the order of the actions described, because according to the present application, some steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are preferred embodiments, and the actions involved are not necessarily required by the present application.

[0053] The above embodiments describe the basic principles and main features of the present invention and the advantages of the present invention. Those skilled in the art should understand that the present invention is not limited by the above embodiments, and the above embodiments and descriptions are only for explaining the principles of the present invention. Without departing from the spirit and scope of the present invention, the changes and modifications made by those skilled in the art shall be within the scope of protection of the appended claims of the present invention without departing from the spirit and scope of the present invention.

Claims

1. A method for verifying the accuracy of data differences in vehicle manufacturing, characterized in that: The steps include: S1: Set up a database to store information in the Excel table; S2: Import the file that needs to be verified and perform verification; S3: Traverse all running processes and add the IDs of the excel-related processes to the processid list; S4: Compare the Excel table to detect data differences in vehicle specification number, electronic control name, part number and configuration code, and display the comparison results through different background colors and font colors.

2. A method for verifying the accuracy of data differences in vehicle manufacturing as claimed in claim 1, characterized in that: Step S2 includes the following sub-steps: S21: add a click event processing method btnFile_Click to open a file selection dialog box and verify the conditions of the selected file, including whether the number of files is 2 and whether it is exported from the EOL system; S22: assign the selected file names to the text attributes of the labFile1 and labFile2 labels respectively; S23: Open the Excel application, and open the two files in sequence, and verify them with the expected values ​​respectively. If the verification passes, go to step S3.

3. A method for verifying the accuracy of data differences in vehicle manufacturing as claimed in claim 2, characterized in that: The specific method of verifying with the expected value is: read the cell value from the worksheets of the two files respectively, convert it into uppercase strings and store it in the corresponding variables, compare the read value with the expected value for verification, and end the verification if it does not meet the expected value. The expected value includes one or more of vehicle specifications, remarks and unit.

4. A method for verifying the accuracy of data differences in vehicle manufacturing stages as claimed in claim 3, characterized in that: Step S3 includes the following steps: S31: Use the StoreProcess method: first clear the processid list, then get all currently running processes through Process.GetProcesses(), traverse all processes, and add the ID of the excel-related process to the processid list; S32: Use KillExcelProcess method: First, get all currently running processes through Process.GetProcesses(), then traverse all processes and terminate the processes related to Excel that are not in the processid list.

5. A method for verifying the accuracy of data differences in vehicle manufacturing as claimed in claim 4, characterized in that: Step S4 includes the following steps: S41: Load and parse Excel file; S42: Set the progress bar and status text; S43: Parse the worksheet data and update the progress bar and status text; S44: Traverse the worksheet to detect data differences in vehicle model specification number, electronic control name, part number and configuration code, and insert the data difference detection result into the VSCS table.

6. A method for verifying the accuracy of data differences in vehicle manufacturing stages as claimed in claim 5, characterized in that: Model specification number data difference detection includes forward processing and reverse processing, among which, Forward processing: Select the vehicle models and part numbers from the database that exist in the EOL system export table but do not exist in the VSCS table, and mark the corresponding cells with a red background and white font; Reverse processing: Select the model and part number from the database that exists in the VSCS table but does not exist in the EOL system export table, and mark the corresponding cells with a red background and white font.

7. A method for verifying the accuracy of data differences in vehicle manufacturing stages as claimed in claim 5, characterized in that: The electronic control name data difference detection includes forward processing and reverse processing, among which, Forward processing: Select the electric control names that exist in the EOL system export table but do not exist in the VSCS table from the database, and mark the corresponding cells with a red background and white font; Reverse processing: Select the electric control names that exist in the VSCS table but do not exist in the EOL system export table from the database, and mark the corresponding cells with a red background and white font.

8. A method for verifying the accuracy of data differences in vehicle manufacturing as claimed in claim 5, characterized in that: Part number data difference detection includes forward processing and reverse processing, where: Forward processing: Select the part numbers from the database that exist in the EOL system export table but do not exist in the VSCS table, and mark the corresponding cells with a dark orange background and blue font; Reverse process: Select the part numbers from the database that exist in the VSCS table but do not exist in the EOL system export table, and mark the corresponding cells with a dark orange background and blue font.

9. A method for verifying the accuracy of data differences in vehicle manufacturing stages as claimed in claim 5, characterized in that: Configuration code data difference detection includes forward processing and reverse processing, where: Forward processing: Select the configuration codes from the database that exist in the EOL system export table but do not exist in the VSCS table, and mark the corresponding cells with a dark orange background and blue font; Reverse processing: Select the configuration codes that exist in the VSCS table but do not exist in the EOL system export table from the database, and mark the corresponding cells with a dark orange background and blue font.

10. A vehicle manufacturing stage data difference accuracy verification system, used to implement a vehicle manufacturing stage data difference accuracy verification method as claimed in any one of claims 1 to 9, characterized in that: Including database, import module, traversal module and comparison module, among which, Database, used to store information in excel sheets; Import module, used to import files that need to be verified and perform verification; The traversal module is used to traverse all running processes and add the IDs of the excel-related processes to the processid list; The comparison module is used to compare the Excel table to detect the data differences of vehicle specification number, electronic control name, part number and configuration code, and display the comparison results through different background colors and font colors.