Data processing method, device, system, computer equipment and storage medium

By embedding instruction sets and VBA codes in Excel tables, the acquisition and processing of signal integrity test data is solved, and the problems of low testing efficiency and low accuracy in the existing technology are achieved, and efficient and accurate test results are achieved.

CN113918741BActive Publication Date: 2024-12-03SUMA TECH CO LTD
View PDF 3 Cites 0 Cited by

Patent Information

Application Number
CN202111044095.3
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-09-07
Publication Date
2024-12-03
Estimated Expiration
2041-09-07

AI Technical Summary

Technical Problem

During signal integrity testing, the prior art requires a large number of repeated manual operations, resulting in inefficient testing and low accuracy. Especially when the test items increase, cumbersome operations increase the possibility of errors.

Method used

By embedding the instruction set for the device to be tested in Excel tables, the Visual Basic macro language VBA control measurement devices to collect test data, and processing data in Excel tables in real time, avoiding users manually writing data to improve efficiency and accuracy.

Benefits of technology

It realizes automated test data acquisition and processing, improves testing efficiency, reduces manual errors, and significantly improves the accuracy and efficiency of signal integrity testing.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113918741B_ABST
    Figure CN113918741B_ABST
Patent Text Reader

Abstract

The present application relates to a data processing method, device, system, computer equipment and storage medium. The method comprises: in response to a first control operation on an Excel table, determining a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table; sending the collection instruction to a vector measuring device so that the measuring device collects test data from a device to be tested in response to the collection instruction; receiving the test data sent by the measuring device; and processing the test data in the Excel table to obtain a data processing result. The use of this method can improve test efficiency.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a data processing method, apparatus, system, computer equipment and storage medium. Background Art

[0002] During the SI (Signal Integrity) test process, it is necessary to collect test data from the device under test through measuring equipment such as an oscilloscope (for example, capture the waveform image and waveform data of the signal of the device under test) and judge the signal quality of the device under test based on the test data.

[0003] In the related art, manual or third-party testing software is used to control the measuring equipment to collect the test data of the device to be tested, and the test data and / or the test results obtained by comparing the test data with the standard range are manually filled into an Excel spreadsheet to obtain a test report.

[0004] The above process requires repeated human operations during the SI test, and as the number of test items increases, a large number of tedious and repeated operations will result in low test efficiency. Summary of the invention

[0005] Based on this, it is necessary to provide a data processing method, device, system, computer equipment and storage medium that can improve test efficiency in response to the above technical problems.

[0006] A data processing method, the method comprising:

[0007] In response to a first control operation on an Excel table, determining a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table;

[0008] Sending the acquisition instruction to the measurement device, so that the measurement device collects test data from the device to be tested in response to the acquisition instruction;

[0009] Receiving test data sent by the measuring device;

[0010] The test data is processed in the Excel table to obtain a data processing result.

[0011] By adopting the data processing method provided by the embodiment of the present disclosure, an instruction set for the device to be tested can be embedded in an Excel table to control the measuring device to collect the test data of the device to be tested, and corresponding data processing of the test data can be implemented directly in the Excel table in real time. There is no need for the user to manually perform operations such as writing relevant test data into the Excel table, which can improve the test efficiency, avoid errors that may be caused by the user manually writing relevant test data into the Excel table, and improve the test accuracy.

[0012] In one embodiment, the method further comprises:

[0013] In response to the embedding operation for the instruction set, the instruction set for the device to be tested is embedded in the Excel table through Visual Basic macro language VBA.

[0014] By adopting the data processing method provided by the embodiment of the present disclosure, an instruction set for the device to be tested can be embedded in an Excel table through the Visual Basic macro language VBA, so as to control the measuring device to collect the test data of the device to be tested by embedding the instruction set for the device to be tested in the Excel table, and implement the corresponding data processing of the test data in the Excel table in real time according to the instructions in the instruction set. There is no need for the user to manually perform operations such as writing relevant test data into the Excel table, which can improve the test efficiency, avoid errors that may be caused by the user manually writing relevant test data, and improve the test accuracy.

[0015] In one embodiment, the step of processing the test data in the Excel table to obtain a data processing result includes:

[0016] Acquire a first designated position corresponding to the first control operation, where the first designated position is used to indicate a writing position of the test data in an Excel table;

[0017] The test data is written into the first designated location.

[0018] By adopting the data processing method provided in the embodiment of the present disclosure, after receiving the test data, the test data can be directly written into the corresponding first designated position in the Excel table, without the need for the user to manually write the test data into the Excel table. This can improve the test efficiency and avoid errors that may occur when the user manually writes, thereby improving the test accuracy.

[0019] In one embodiment, the step of processing the test data in the Excel table to obtain a data processing result includes:

[0020] In response to a second control operation on the Excel table, determining a processing instruction corresponding to the second control operation from the instruction set;

[0021] Performing data processing on the test data according to the processing instruction to obtain a test data processing result;

[0022] The test data processing result is written into a second designated location, wherein the processing instruction includes the second designated location, and the second designated location is used to indicate a writing location of the test data processing result in the Excel table.

[0023] By adopting the data processing method provided in the embodiment of the present disclosure, after receiving the test data, corresponding data processing can be performed directly on the test data in an Excel table in response to the processing instruction to obtain the test data result, and the test data processing result is written into the second designated location in the Excel table. There is no need for the user to manually perform data processing on the test data and write the processing result into the Excel table, which can improve the test efficiency and avoid the errors that may be generated when the user manually writes into the Excel table, thereby improving the test accuracy.

[0024] In one embodiment, the step of processing the test data in the Excel table to obtain a data processing result includes:

[0025] In response to a third control operation on the Excel table, determining a test instruction corresponding to the third control operation from the instruction set;

[0026] Performing test processing on the test data according to the test instruction to obtain a test result;

[0027] The test result is written into a third designated location to obtain a test report, wherein the test instruction includes the third designated location, and the third designated location is used to indicate the writing location of the test result in the Excel table.

[0028] By adopting the data processing method provided by the embodiment of the present disclosure, after receiving the test data, the corresponding test operation can be directly performed on the test data in the Excel table in response to the test instruction to obtain the test result, and the test result is written into the third designated position in the Excel table to obtain the test report. Based on the data processing method provided by the embodiment of the present disclosure, the test report can be obtained without the user manually performing the test comparison operation on the test data and the writing operation on the test result, which can improve the test efficiency and avoid the errors that may be generated when the user manually writes, thereby improving the test accuracy.

[0029] In one embodiment, the acquisition instruction includes a waveform acquisition instruction and / or a data acquisition instruction; wherein the waveform acquisition instruction is used to instruct the measuring device to acquire a waveform image of the device to be tested; and the data acquisition instruction is used to instruct the measuring device to acquire waveform data of the device to be tested.

[0030] By adopting the data processing method provided by the embodiment of the present disclosure, the waveform acquisition instruction and / or data acquisition instruction for the device to be tested can be embedded in the Excel table to control the measuring device to perform waveform image acquisition and / or waveform data acquisition on the device to be tested. There is no need for the user to manually control the measuring device to perform waveform image acquisition and / or waveform data acquisition, which can improve the test efficiency.

[0031] In one embodiment, the acquisition instruction includes control parameters, so that the measurement device acquires test data of the device to be tested according to the control parameters.

[0032] By adopting the data processing method provided by the embodiment of the present disclosure, it is possible to embed a collection instruction for the device to be tested in an Excel table, and specify control parameters in the collection instruction, so that the measuring device can collect corresponding test data from the device to be tested according to the control parameters. The test data can be collected without the user manually operating the measuring device, which can improve the test efficiency.

[0033] A data processing system includes a terminal, a measuring device and a device to be tested, wherein:

[0034] The terminal and the measuring device are connected based on the virtual instrument software architecture system VISA, the measuring device and the device to be tested are connected via a connecting line, and the terminal has an instruction set for the device to be tested embedded in an Excel table;

[0035] In response to the first control operation on the Excel table, the terminal determines a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table, and sends the collection instruction to the measurement device;

[0036] The measuring device collects test data from the device to be tested in response to the collection instruction, and sends the test data to the terminal;

[0037] The terminal receives the test data sent by the measuring device, and processes the test data in the Excel table to obtain a data processing result.

[0038] By adopting the data processing system provided by the embodiment of the present disclosure, the terminal can embed an instruction set for the device to be tested in an Excel table to control the measurement device to collect test data for the device to be tested, and can directly implement corresponding data processing of the test data in real time in the Excel table. There is no need for the user to manually write relevant test data into the Excel table, which can improve the test efficiency, avoid errors that may be caused by the user manually writing relevant test data, and improve the test accuracy.

[0039] A data processing device, comprising:

[0040] a determination module, configured to, in response to a first control operation on an Excel table, determine a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table;

[0041] A sending module, used for sending the acquisition instruction to the measurement device, so that the measurement device collects test data from the device to be tested in response to the acquisition instruction;

[0042] A receiving module, used for receiving the test data sent by the measuring device;

[0043] The processing module is used to process the test data in the Excel table to obtain data processing results.

[0044] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0045] In response to a first control operation on an Excel table, determining a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table;

[0046] Sending the acquisition instruction to the measurement device, so that the measurement device collects test data from the device to be tested in response to the acquisition instruction;

[0047] Receiving test data sent by the measuring device;

[0048] The test data is processed in the Excel table to obtain a data processing result.

[0049] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the following steps:

[0050] In response to a first control operation on an Excel table, determining a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table;

[0051] Sending the acquisition instruction to the measurement device, so that the measurement device collects test data from the device to be tested in response to the acquisition instruction;

[0052] Receiving test data sent by the measuring device;

[0053] The test data is processed in the Excel table to obtain a data processing result.

[0054] Based on the data processing method, apparatus, system, computer equipment and storage medium provided by the embodiments of the present disclosure, it is possible to embed an instruction set for the device to be tested in an Excel table to control the measuring equipment to collect test data of the device to be tested, and to implement corresponding data processing of the test data directly in the Excel table in real time, without the need for the user to manually perform operations such as writing relevant test data into the Excel table, thereby improving the test efficiency, avoiding errors that may be caused by the user manually writing relevant test data into the Excel table, and improving the test accuracy. BRIEF DESCRIPTION OF THE DRAWINGS

[0055] Figure 1 is a flow chart of a data processing method in one embodiment;

[0056] Figure 2 is a flow chart of a data processing method in one embodiment;

[0057] Figure 3 is a flow chart of a data processing method in one embodiment;

[0058] Figure 4 is a flow chart of a data processing method in one embodiment;

[0059] Figure 5 is a schematic diagram of a data processing method in one embodiment;

[0060] Figure 6 is a schematic diagram of a data processing method in one embodiment;

[0061] Figure 7 is a structural block diagram of a data processing device in one embodiment;

[0062] Figure 8 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0063] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0064] In one embodiment, Figure 1 As shown, a data processing method is provided. This embodiment takes the method applied to a terminal as an example. It can be understood that the method can also be applied to a server, and can also be applied to a system including a terminal and a server, and is implemented through the interaction between the terminal and the server. In this embodiment, the method includes the following steps:

[0065] Step 102: In response to a first control operation on the Excel table, determining a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table.

[0066] In the embodiment of the present disclosure, an instruction set for the device to be tested may be embedded in an Excel table, and the instruction set may include a programmable SCPI (Standard Commands for Programmable Instruments) instruction for the device to be tested. In response to a first control operation on the Excel table, the terminal may determine an acquisition instruction corresponding to the first control operation from the instruction set embedded in the Excel table, and the acquisition instruction may include an instruction for instructing the measuring device to collect data, for example: an instruction for instructing the measuring device to collect waveform images and / or collect waveform data.

[0067] Among them, the first control operation can be an operation for triggering the vector measurement device to send an acquisition instruction. For example, the first control operation can be a trigger operation for related controls in an Excel table, a trigger operation for a specified cell in an Excel table, a single-click operation or a double-click operation on the Excel table. The embodiment of the present disclosure does not specifically limit the first control operation.

[0068] Step 104: Send a collection instruction to the measurement device, so that the measurement device collects test data from the device to be tested in response to the collection instruction.

[0069] In the embodiment of the present disclosure, after determining the acquisition instruction corresponding to the first control operation, the acquisition instruction can be sent to the measuring device, so that after receiving the acquisition instruction, the measuring device performs data acquisition on the device to be tested according to the acquisition instruction, obtains test data, and feeds the test data back to the terminal. The measuring device may include a device capable of calling a measurement function to acquire signal data of the device to be tested, such as an oscilloscope or other device.

[0070] In a possible implementation, the terminal establishes a connection with the measuring device based on VISA (Virtual Instruments Software Architecture). The terminal and the measuring device can be connected through a network cable, a USB (Universal Serial Bus) cable or other data lines, and VISA is used for serial communication. That is, the terminal calls the VISA library function and configures the device parameters of the measuring device, and communicates with the measuring device through a network cable, a USB cable or other data line, thereby sending acquisition instructions to the measuring device to remotely control the measuring device.

[0071] Step 106: Receive test data sent by the measuring device.

[0072] In the embodiment of the present disclosure, after the measuring device collects the test data, the collected test data may be fed back to the terminal, that is, the terminal may receive the test data sent by the measuring device.

[0073] Step 108: Process the test data in an Excel spreadsheet to obtain a data processing result.

[0074] In the embodiment of the present disclosure, after receiving the test data sent by the measuring device, the terminal can process the test data in the Excel table according to the instruction set embedded in the Excel table to obtain the data processing result. Exemplarily, the data processing may include but is not limited to the processing operations such as denoising, corresponding operation processing, storage processing, test comparison processing, etc. for the test data. The data processing for the test data can be determined by the user embedding the corresponding instructions in the Excel table according to the test requirements. The embodiment of the present disclosure does not specifically limit the data processing.

[0075] The above-mentioned data processing method can respond to the first control operation for the Excel table, determine the collection instruction corresponding to the first control operation from the instruction set embedded in the Excel table, and send the collection instruction to the measuring device, so that the measuring device collects test data for the device to be tested in response to the collection instruction. After receiving the test data sent by the measuring device, the test data can be processed in the Excel table to obtain the data processing result. Based on the data processing method provided by the embodiment of the present disclosure, the instruction set for the device to be tested can be embedded in the Excel table to control the measuring device to collect the test data of the device to be tested, and the corresponding data processing of the test data can be directly implemented in the Excel table in real time, without the user manually performing operations such as writing relevant test data into the Excel table, which can improve the test efficiency, avoid errors that may be caused by the user manually writing relevant test data into the Excel table, etc., and improve the test accuracy.

[0076] In one embodiment, the data processing method may further include:

[0077] In response to the embedding operation for the instruction set, the instruction set for the device to be tested is embedded in the Excel table through the Visual Basic macro language VBA.

[0078] In the disclosed embodiment, the user can use VBA (Visual Basic for Applications, Visual Basic macro language) in the Excel table to embed instructions for the device to be tested in the Excel table. Exemplarily, the terminal can display a VBA code interface in response to the user's trigger operation on VBA. The user can enter the instruction code in the VBA code interface, and the terminal can obtain the instruction set for the device to be tested in response to the instruction code entered by the user, and embed the instruction set for the device to be tested in the Excel table in response to the user's save operation on the instruction set.

[0079] The embedded operations for the instruction set may include the trigger operation for VBA, the input operation for the test instruction code, and the save operation for the instruction set.

[0080] The data processing method provided by the embodiment of the present disclosure can embed an instruction set for the device to be tested in an Excel table through the Visual Basic macro language VBA, so as to control the measuring device to collect the test data of the device to be tested by embedding the instruction set for the device to be tested in the Excel table, and implement the corresponding data processing of the test data in the Excel table in real time according to the instructions in the instruction set. There is no need for the user to manually perform operations such as writing relevant test data into the Excel table, which can improve the test efficiency, avoid errors that may be caused by the user manually writing relevant test data, and improve the test accuracy.

[0081] In one embodiment, the acquisition instruction includes a waveform acquisition instruction and / or a data acquisition instruction; wherein the waveform acquisition instruction is used to instruct the measuring device to acquire a waveform image of the device to be tested; and the data acquisition instruction is used to instruct the measuring device to acquire waveform data of the device to be tested.

[0082] In the embodiment of the present disclosure, the acquisition instruction may include a waveform acquisition instruction and / or a data acquisition instruction, wherein the waveform acquisition instruction may be used to instruct the measuring device to acquire a waveform image of the device to be tested, and the data acquisition instruction may be used to instruct the measuring device to acquire waveform data of the device to be tested. Exemplarily, the terminal may obtain the corresponding waveform acquisition instruction and / or data acquisition instruction from the test instruction in response to the first control operation, and send the waveform acquisition instruction and / or data acquisition instruction to the measuring device, so that the measuring device can acquire a waveform image of the device to be tested and / or acquire waveform data of the device to be tested according to the waveform acquisition instruction.

[0083] It should be noted that whether the first control operation specifically corresponds to a waveform acquisition instruction, a data acquisition instruction, or a waveform acquisition instruction and a data acquisition instruction is specified by the user in the instruction set according to the test requirements, and the embodiments of the present disclosure do not make specific limitations on this.

[0084] The data processing method provided by the embodiment of the present disclosure can control the measuring device to perform waveform image acquisition and / or waveform data acquisition on the device to be tested by embedding waveform acquisition instructions and / or data acquisition instructions for the device to be tested in an Excel table. There is no need for the user to manually control the measuring device to perform waveform image acquisition and / or waveform data acquisition, which can improve the test efficiency.

[0085] In one embodiment, the collection instruction includes control parameters, so that the measurement device collects test data from the device to be tested according to the control parameters.

[0086] In the embodiment of the present disclosure, the acquisition instruction may include a control parameter. After receiving the acquisition instruction, the measuring device may obtain the control parameter from the acquisition instruction and collect test data for the device to be tested according to the control parameter.

[0087] Exemplarily, the control parameters may include measurement equipment parameters and / or data acquisition parameters. The measurement equipment parameters may include parameters that affect the acquisition of test data and are related to the measurement equipment, and the data acquisition parameters may be used to specify the test data that the measurement equipment needs to acquire.

[0088] For example, taking the measuring device as an oscilloscope, the measuring device parameters may include but are not limited to: the coupling mode, sensitivity, scanning speed and other parameters of the measuring device. The embodiments of the present disclosure do not specifically limit the measuring device parameters. All parameters related to the measuring device and affecting the test data collected by the measuring device are included in the measuring device parameters. Data acquisition parameters may include acquisition cycle, acquisition range, acquisition peak / trough and other parameters. The embodiments of the present disclosure do not specifically limit the data acquisition parameters. The user can specify the data acquisition parameters in the test instructions according to the test requirements.

[0089] The data processing method provided by the embodiment of the present disclosure can embed a collection instruction for the device to be tested in an Excel table, and specify a control parameter in the collection instruction, so that the measuring device can collect corresponding test data from the device to be tested according to the control parameter. The test data can be collected without the user manually operating the measuring device, which can improve the test efficiency.

[0090] In one embodiment, referring to Figure 2 In the above step 108, the test data is processed in an Excel table to obtain a data processing result, including:

[0091] Step 202, obtaining a first designated position corresponding to the first control operation, where the first designated position is used to indicate a writing position of the test data in the Excel table;

[0092] Step 204: write the test data into the first designated location.

[0093] In the embodiment of the present disclosure, after receiving the test data sent by the measuring device, the terminal can determine the first designated position corresponding to the first control operation from the instruction set, and the first designated position can be used to indicate the writing position of the test data in the Excel table, and write the test data into the first designated position. Exemplarily, the first designated position corresponding to the first control operation is a designated cell in sheet1, and after obtaining the test data, the test data can be written into the designated cell in sheet1.

[0094] In an example, the first designated position can be a designated cell in a designated sheet in the test report, that is, after obtaining the test data, the terminal can directly fill in the test data into the test report. After obtaining the test results based on the test data and writing the test results into the test report, the test report can be obtained.

[0095] The data processing method provided by the embodiment of the present disclosure can directly write the test data into the corresponding first designated position in an Excel table after receiving the test data, without the need for the user to manually write the test data into the Excel table. This can improve the test efficiency and avoid errors that may occur when the user manually writes, thereby improving the test accuracy.

[0096] In one embodiment, referring to Figure 3 In the above step 108, the test data is processed in an Excel table to obtain a data processing result, including:

[0097] Step 302, in response to a second control operation on the Excel table, determining a processing instruction corresponding to the second control operation from an instruction set;

[0098] Step 304, performing data processing on the test data according to the processing instruction to obtain a test data processing result;

[0099] Step 306, writing the test data processing result into a second designated location, wherein the processing instruction includes the second designated location, and the second designated location is used to indicate a writing location of the test data processing result in the Excel table.

[0100] In the embodiment of the present disclosure, the second control operation for the Excel table may include an operation for triggering a processing instruction, which may include but is not limited to a trigger operation for related controls in the Excel table, a trigger operation for a specified cell in the Excel table, a single-click operation, a double-click operation, and the like for the Excel table. The embodiment of the present disclosure does not make specific limitations on the second control operation, and it can be distinguished from the first control operation.

[0101] The terminal can respond to the second control operation on the Excel table and determine the processing instructions corresponding to the second control operation from the test instructions. The processing instructions are used to instruct the terminal to perform corresponding data processing on the test data, and may include but are not limited to instructing the terminal to perform denoising, corresponding calculation processing, and other processing on the test data. The processing instructions for the test data can be determined by the user by embedding corresponding instructions in the Excel table according to the test requirements. The embodiments of the present disclosure do not specifically limit the processing instructions.

[0102] After determining the processing instruction corresponding to the second control operation, corresponding data processing can be performed on the test data in response to the processing instruction to obtain the corresponding test data processing result. For example, if the test data is a waveform image within a cycle, the processing instruction can be to perform denoising on the waveform image, and the obtained test data processing result can be a smoothed waveform image after denoising.

[0103] The processing instruction may include a second designated location in the Excel table where the test data processing result is to be written. After the test data processing result is obtained, the test data processing result may be written into the second designated location.

[0104] The data processing method provided by the embodiment of the present disclosure can, after receiving the test data, directly perform corresponding data processing on the test data in an Excel table in response to the processing instruction to obtain the test data result, and write the test data processing result into a second designated location in the Excel table. There is no need for the user to manually perform data processing on the test data and write the processing result into the Excel table, which can improve the test efficiency and avoid the errors that may be generated when the user manually writes into the Excel table, thereby improving the test accuracy.

[0105] In one embodiment, referring to Figure 4 In the above step 108, the test data is processed in an Excel table to obtain a data processing result, including:

[0106] Step 402, in response to a third control operation on the Excel table, determining a test instruction corresponding to the third control operation from an instruction set;

[0107] Step 404, test the test data according to the test instruction to obtain the test result;

[0108] Step 406, writing the test result into a third designated location to obtain a test report, wherein the test instruction includes a third designated location, and the third designated location is used to indicate a writing location of the test result in the Excel table.

[0109] In the embodiment of the present disclosure, the third control operation for the Excel table may include an operation for triggering a test instruction, which may include but is not limited to a trigger operation for related controls in the Excel table, a trigger operation for a specified cell in the Excel table, a single-click operation, a double-click operation, and the like for the Excel table. The embodiment of the present disclosure does not make specific limitations on the third control operation, and it can be distinguished from the first control operation and the second control operation.

[0110] The terminal may determine, in response to the third control operation on the Excel table, a test instruction corresponding to the third control operation from the instruction set, and the test instruction is used to instruct the terminal to perform test processing on the test data (or the test data processing result in the aforementioned embodiment). Exemplarily, the test instruction may include a test reference standard, and the terminal may compare the test data with the test reference standard in response to the test instruction to obtain a corresponding test result, and the test result may include a comparison result of the test data with the test reference standard and / or a test conclusion obtained based on the comparison result, including: passing the integrity test or failing the integrity test, etc.

[0111] After obtaining the test result, the terminal can write the test result into the position corresponding to the test report according to the third specified position to obtain the test report. For example, the test data, test reference standard and test result can be written into the corresponding positions in the sheet corresponding to the test report, and the test report can be obtained in real time.

[0112] The data processing method provided by the embodiment of the present disclosure can directly perform corresponding test operations on the test data in an Excel table in response to a test instruction after receiving the test data, obtain the test results, and write the test results to a third designated location in the Excel table to obtain a test report. Based on the data processing method provided by the embodiment of the present disclosure, a test report can be obtained without the user manually performing a test comparison operation on the test data and a write operation on the test results, which can improve the test efficiency and avoid errors that may occur when the user manually writes, thereby improving the test accuracy.

[0113] In one embodiment, Figure 5 As shown, a data processing system is provided, the data processing system 500 includes a terminal 502, a measuring device 504 and a device to be tested 506, wherein:

[0114] The terminal 502 and the measuring device 504 are connected based on the virtual instrument software structure system VISA, the measuring device 504 and the device to be tested 506 are connected through a connecting line, and the terminal 502 has an instruction set for the device to be tested embedded in an Excel table;

[0115] In response to the first control operation on the Excel table, the terminal 502 determines the collection instruction corresponding to the first control operation from the instruction set embedded in the Excel table, and sends the collection instruction to the measuring device 504; the measuring device 504 collects test data from the device to be tested 506 in response to the collection instruction, and sends the test data to the terminal 502; the terminal 502 receives the test data sent by the measuring device 504, and processes the test data in the Excel table to obtain the data processing result.

[0116] In the embodiment of the present disclosure, the terminal 502 establishes a connection with the measuring device 504 based on VISA, and transmits data through a network cable, a USB cable, etc. (the specific process can be referred to the relevant description in the above embodiment, and the present disclosure embodiment will not repeat it). The measuring device 504 is connected to the device to be tested 506 through a connecting line, and the connecting line may include a coaxial cable, that is, the measuring device 504 is connected to the coaxial cable through a BNC (Bayonet Nut Connector, snap-fit ​​connector) connector, and is connected to the device to be tested 506 through the coaxial cable for signal transmission.

[0117] The terminal 502 may embed an instruction set for the device under test 506 in the Excel table, for example, by embedding the instruction set for the device under test in the Excel table through VBA of the Excel table. Then, in response to the first control operation for the Excel table, a collection instruction corresponding to the first control operation may be obtained from the instruction set, and the collection instruction may be sent to the vector test device 504.

[0118] After receiving the acquisition instruction sent by the terminal 502, the measuring device 504 can collect test data such as waveform images and / or signal data from the device to be tested 506 according to the acquisition instruction, and feed the collected test data back to the terminal 502. The specific process can refer to the relevant description in the above embodiment, and the embodiment of the present disclosure will not be repeated here.

[0119] After receiving the test data sent by the measuring device 504, the terminal 502 can respond to the instruction set embedded in the Excel table, perform corresponding data processing on the test data in the Excel table, and obtain the data processing result. Exemplarily, the terminal 502 can write the test data into the corresponding first indicated position in the Excel table, or can perform data processing on the test data in the Excel table to obtain the test data processing result, and write the test data processing result into the second designated position in the Excel table, or can perform test processing on the test data or the test data processing result to obtain the test result, and write the test result into the third designated position in the Excel table to obtain a test report. The specific process can also refer to the relevant description in the aforementioned embodiment, and the embodiment of the present disclosure will not be repeated here.

[0120] The data processing system provided by the embodiment of the present disclosure can enable the terminal to embed an instruction set for the device to be tested 506 in an Excel table to control the measurement device 504 to collect test data for the device to be tested 506, and can directly implement corresponding data processing of the test data in real time in the Excel table, without the need for the user to manually write relevant test data into the Excel table, thereby improving the test efficiency, avoiding errors that may be caused by the user manually writing relevant test data, and improving the test accuracy.

[0121] In order to enable those skilled in the art to better understand the embodiments of the present disclosure, the embodiments of the present disclosure are described below through specific examples.

[0122] Reference Figure 6As shown, when performing a signal integrity test, the SCPI test instruction code can be written in the VBA of the terminal's Excel spreadsheet according to the test items. The terminal and the oscilloscope (measuring device) establish a connection based on VISA, and data is transmitted through the network cable, USB cable and other data cables connecting the terminal and the oscilloscope. After the device to be tested is turned on, the test phase is entered, and the embedded instruction set is run in the Excel spreadsheet of the terminal to control the oscilloscope to automatically call the measurement function to collect test data. For example: after the waveform is stable, the oscilloscope is controlled to automatically read the waveform image of the device to be tested, and the waveform image is stored in the specified position in the Excel spreadsheet, the signal data of the device to be tested is automatically collected, and the signal data is automatically filled in the specified position in the Excel spreadsheet. The terminal can respond to the test instruction to compare the test data with the test standard, obtain the test results, and automatically write the test results to the specified position to obtain a test report.

[0123] After completing the test of the current test item, the instruction set in the VBA currently embedded in the Excel spreadsheet of the terminal can be used as needed to execute the test of the next test item for the device to be tested, or the test of the next test item can be executed through the instruction set for the next test item of the device to be tested in the VBA embedded in the Excel spreadsheet of the terminal.

[0124] The disclosed embodiment embeds a programmable instruction set in the VBA of the Excel table, controls the measuring device through the embedded instruction set to automatically call the measuring function to automatically access the waveform image to the specified position of the Excel table and / or automatically collect the waveform data to the specified position of the test report in the Excel table, and automatically performs the test processing to obtain the test results, and automatically writes the test results into the test report. The data processing method provided by the disclosed embodiment can tailor the test instructions for different test items through the VBA of the Excel table, can automatically access the waveform image and waveform data in real time, avoids the user manually repeating tedious operation steps, greatly improves the efficiency and accuracy of the signal integrity test, and shortens the verification cycle.

[0125] It should be understood that although Figure 1-6 The steps in the flowchart are shown in sequence as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified in this document, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Moreover, Figure 1-6At least part of the steps may include multiple steps or multiple stages. These steps or stages are not necessarily performed at the same time, but can be performed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed in turn or alternately with other steps or at least part of the steps or stages in other steps.

[0126] In one embodiment, Figure 7 As shown, a data processing device is provided, including: a determination module 702, a sending module 704, a receiving module 706 and a processing module 708, wherein:

[0127] A determination module 702 is configured to, in response to a first control operation on an Excel table, determine a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table;

[0128] The sending module 704 is used to send the acquisition instruction to the measurement device, so that the measurement device collects test data from the device to be tested in response to the acquisition instruction;

[0129] The receiving module 706 is used to receive the test data sent by the measuring device;

[0130] The processing module 708 is used to perform data processing on the test data in the Excel table to obtain data processing results.

[0131] Based on the data processing device provided by the embodiment of the present disclosure, an instruction set for the device to be tested can be embedded in an Excel table to control the measuring device to collect test data of the device to be tested, and corresponding data processing of the test data can be implemented directly in the Excel table in real time. There is no need for the user to manually perform operations such as writing relevant test data into the Excel table, which can improve the test efficiency, avoid errors that may be caused by the user manually writing relevant test data into the Excel table, and improve the test accuracy.

[0132] In one embodiment, the data processing device further includes:

[0133] The embedding module is used for embedding the instruction set for the device to be tested in the Excel table through Visual Basic macro language VBA in response to the embedding operation for the instruction set.

[0134] In one embodiment, the processing module 708 is further configured to:

[0135] Acquire a first designated position corresponding to the first control operation, where the first designated position is used to indicate a writing position of the test data in an Excel table;

[0136] The test data is written into the first designated location.

[0137] In one embodiment, the processing module 708 is further configured to:

[0138] In response to a second control operation on the Excel table, determining a processing instruction corresponding to the second control operation from the instruction set;

[0139] Performing data processing on the test data according to the processing instruction to obtain a test data processing result;

[0140] The test data processing result is written into a second designated location, wherein the processing instruction includes the second designated location, and the second designated location is used to indicate a writing location of the test data processing result in the Excel table.

[0141] In one embodiment, the processing module 708 is further configured to:

[0142] In response to a third control operation on the Excel table, determining a test instruction corresponding to the third control operation from the instruction set;

[0143] Performing test processing on the test data according to the test instruction to obtain a test result;

[0144] The test result is written into a third designated location to obtain a test report, wherein the test instruction includes the third designated location, and the third designated location is used to indicate the writing location of the test result in the Excel table.

[0145] In one embodiment, the acquisition instruction includes a waveform acquisition instruction and / or a data acquisition instruction; wherein the waveform acquisition instruction is used to instruct the measuring device to acquire a waveform image of the device to be tested; and the data acquisition instruction is used to instruct the measuring device to acquire waveform data of the device to be tested.

[0146] In one embodiment, the acquisition instruction includes control parameters, so that the measurement device acquires test data from the device to be tested according to the control parameters.

[0147] For the specific definition of the data processing device, please refer to the definition of the data processing method above, which will not be repeated here. Each module in the above data processing device can be implemented in whole or in part by software, hardware and a combination thereof. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0148] In one embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as follows: Figure 8 As shown. The computer device includes a processor, a memory, a communication interface, a display screen and an input device connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be achieved through WIFI, an operator network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a data processing method is implemented. The display screen of the computer device can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covered on the display screen, or a button, trackball or touchpad set on the computer device housing, or an external keyboard, touchpad or mouse, etc.

[0149] Those skilled in the art will understand that Figure 8 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0150] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0151] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0152] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM).

[0153] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0154] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.

Claims

1. A data processing method, characterized in that: The method comprises: In response to a first control operation on an Excel table, determining a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table; the Excel table embeds a collection instruction for the device to be tested, and control parameters are specified in the collection instruction, the control parameters including measurement device parameters and data collection parameters; Sending the acquisition instruction to the measurement device, so that the measurement device collects test data from the device to be tested in response to the acquisition instruction; Receiving test data sent by the measuring device; Acquire a first designated position corresponding to the first control operation, where the first designated position is used to indicate a writing position of the test data in an Excel table; Writing the test data into the first designated location; In response to a third control operation on the Excel table, determining a test instruction corresponding to the third control operation from the instruction set; Performing test processing on the test data according to the test instruction to obtain a test result; The test result is written into a third designated location to obtain a test report, wherein the test instruction includes the third designated location, and the third designated location is used to indicate the writing location of the test result in the Excel table.

2. The method according to claim 1, characterized in that The method further comprises: In response to the embedding operation for the instruction set, the instruction set for the device to be tested is embedded in the Excel table through Visual Basic macro language VBA.

3. The method according to claim 1, characterized in that The method further comprises: In response to a second control operation on the Excel table, determining a processing instruction corresponding to the second control operation from the instruction set; Performing data processing on the test data according to the processing instruction to obtain a test data processing result; The test data processing result is written into a second designated location, wherein the processing instruction includes the second designated location, and the second designated location is used to indicate a writing location of the test data processing result in the Excel table.

4. The method according to any one of claims 1 to 3, characterized in that The acquisition instructions include waveform acquisition instructions and / or data acquisition instructions; wherein, The waveform acquisition instruction is used to instruct the measuring device to acquire a waveform image of the device to be tested; The data acquisition instruction is used to instruct the measuring device to acquire waveform data from the device to be tested.

5. The method according to any one of claims 1 to 3, characterized in that The acquisition instruction includes control parameters, so that the measuring device acquires test data of the device to be tested according to the control parameters.

6. A data processing system, characterized in that: The data processing system includes a terminal, a measuring device and a device to be tested, wherein: The terminal and the measuring device establish a connection based on the virtual instrument software structure system VISA, the measuring device and the device to be tested are connected through a connecting line, and the terminal has an instruction set for the device to be tested embedded in an Excel table; the Excel table has an acquisition instruction for the device to be tested embedded, and control parameters are specified in the acquisition instruction, and the control parameters include measurement device parameters and data acquisition parameters; In response to the first control operation on the Excel table, the terminal determines a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table, and sends the collection instruction to the measurement device; The measuring device collects test data from the device to be tested in response to the collection instruction, and sends the test data to the terminal; The terminal acquires a first designated position corresponding to the first control operation, where the first designated position is used to indicate a writing position of the test data in an Excel table; and writes the test data into the first designated position; In response to a third control operation on the Excel table, the terminal determines, from the instruction set, a test instruction corresponding to the third control operation; Performing test processing on the test data according to the test instruction to obtain a test result; The test result is written into a third designated location to obtain a test report, wherein the test instruction includes the third designated location, and the third designated location is used to indicate the writing location of the test result in the Excel table.

7. A data processing device, characterized in that: The device comprises: a determination module, configured to, in response to a first control operation on an Excel table, determine a collection instruction corresponding to the first control operation from an instruction set embedded in the Excel table; A sending module is used to send the acquisition instruction to the measurement device, so that the measurement device collects test data of the device to be tested in response to the acquisition instruction; the acquisition instruction for the device to be tested is embedded in the Excel table, and control parameters are specified in the acquisition instruction, and the control parameters include measurement device parameters and data acquisition parameters; A receiving module, used for receiving the test data sent by the measuring device; A processing module, used for acquiring a first designated position corresponding to the first control operation, where the first designated position is used for indicating a writing position of the test data in an Excel table; Writing the test data into the first designated location; In response to a third control operation on the Excel table, determining a test instruction corresponding to the third control operation from the instruction set; Performing test processing on the test data according to the test instruction to obtain a test result; The test result is written into a third designated location to obtain a test report, wherein the test instruction includes the third designated location, and the third designated location is used to indicate the writing location of the test result in the Excel table.

8. The device according to claim 7, characterized in that The device also includes: The embedding module is used for embedding the instruction set for the device to be tested in the Excel table through Visual Basic macro language VBA in response to the embedding operation for the instruction set.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 5 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 5 are implemented.

Citation Information

Patent Citations

  • Excel-based boundary layer parameter computing method and system

    CN108009359A

  • Implementation method and device for intelligent document, computer equipment and storage medium

    CN108334477A

  • Signal integrity testing method and device

    CN109342927A