Visualization method and device for listed weight tree hierarchical structure interaction process

By providing a visualization method of the interactive process of the list-based weight tree hierarchy in Excel tables, the problem that aircraft weight data cannot be interoperable like tree structures in Excel is solved, and efficient data editing and visualization effects are achieved.

CN119829178APending Publication Date: 2025-04-15XIAN AIRCRAFT DESIGN INST OF AVIATION IND OF CHINA
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411873343.9
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-18
Publication Date
2025-04-15

AI Technical Summary

Technical Problem

During the overall design process of aircraft, aircraft weight characteristic data exists in a tree structure, but it cannot be interactive like a tree structure in Excel table, resulting in inefficient data editing.

Method used

A list-based weight tree hierarchy interactive process visualization method is provided. By obtaining the list-based weight tree hierarchy, receiving operator interaction instructions, and visualizing the affected cell range according to the instructions, realizing interactive operations such as folding, expanding, moving and removing.

Benefits of technology

In Excel tables, tree-like structure interactions on aircraft weight data are implemented, which improves data editing efficiency and visualization effects and reduces the probability of operation errors.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119829178A_ABST
    Figure CN119829178A_ABST
Patent Text Reader

Abstract

The invention provides a listed weight tree hierarchical structure interaction process visualization method and device, and belongs to the technical field of aircraft weight data process.The method comprises the steps that S10, a listed aircraft weight tree hierarchical structure is obtained, and hierarchical identification is conducted on cells and data thereof according to assembly hierarchies in the tree hierarchical structure; and S20, receiving an interactive operation instruction of an operator on the tree-shaped hierarchical structure and a selection range in the tree-shaped hierarchical structure, and determining an affected cell range in the selection range according to the received interactive operation instruction. And S30, performing visual operation on the affected cell range according to a visual method corresponding to the interactive operation instruction to realize a display effect corresponding to the interactive operation instruction. According to the method, the data can be viewed in the Excel table like operating a tree structure, the influence of tens of thousands of rows of lower-layer data on operation can be avoided, the visualization effect is good, the efficiency of aircraft weight special effect data interaction operation is higher, and the error probability is reduced.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application belongs to the field of aircraft weight data processing, and in particular relates to a method and device for visualizing an interactive process of a weight tree hierarchy structure after being tabulated. Background Art

[0002] During the overall aircraft design process, the aircraft weight characteristic data is often exported from different 3D design software. When the data is summarized in the weight specialty, the tree structure of the data has been tabulated, and it is impossible to interact like a tree structure. Since tens of thousands of rows of aircraft weight special effect data are flattened in Excel tables, and technicians must edit and process the data, the data needs to be displayed and managed like a tree structure, but it cannot be converted into a tree structure in structured software and lose the convenience of editing data in Excel tables.

[0003] Therefore, the field of aircraft overall design requires a visualization method that can correspond to each interactive operation instruction of the tree structure in a table, laying a technical foundation for editing and processing weight data in a table. Summary of the invention

[0004] The purpose of the present application is to provide a method and device for visualizing an interactive process of a weight tree hierarchy structure after listing, so as to solve or alleviate at least one problem in the background technology.

[0005] The technical solution of the present application is: a method for visualizing the interactive process of a weight tree hierarchy structure after tabulation, including:

[0006] S10, obtaining a tabulated tree-like hierarchical structure of aircraft weight, in which cells and data thereof are hierarchically identified according to assembly levels;

[0007] S20, receiving an operator's interactive operation instruction for the tree hierarchy structure and a selection range in the tree hierarchy structure, and determining an affected cell range within the selection range according to the received interactive operation instruction.

[0008] S30: Performing a visualization operation on the affected cell range according to the visualization method corresponding to the interactive operation instruction to achieve a display effect corresponding to the interactive operation instruction.

[0009] Preferably, the tabulated tree-like hierarchical structure of aircraft weight is an Excel spreadsheet file.

[0010] Preferably, the interactive operation instructions include folding, expanding, moving and removing, and the affected cell range is divided into single node and multiple nodes.

[0011] Preferably, the single node folding and unfolding visualization process includes:

[0012] Taking the weight or center of gravity cell in the tree hierarchy as the starting column, obtain the interactive operation instruction when clicking the weight or center of gravity cell;

[0013] Detect the state of the cell's subordinate node. If the state of the cell's subordinate node is expanded, determine the row number of the cell's subordinate node and hide the data in the row where the subordinate node is located.

[0014] If the data in the row number where the subordinate node of the detected cell is located is collapsed, the data in the row where the subordinate node is located is displayed.

[0015] Preferably, the folding and unfolding visualization process of multiple nodes includes:

[0016] Get the selection range in the tree hierarchy, the highest assembly level in the selection range is the intended operation level T0;

[0017] Get the row r2 corresponding to the last child node of the node corresponding to the last level T0 to be operated;

[0018] Expand the lower boundary of the selection range to row r2;

[0019] Determine the range of child node rows of each node corresponding to the intended operation level T0 within the selection range, and set the data rows in all child nodes to be displayed;

[0020] In response to the interactive operation instruction, it is determined whether all child nodes are to be folded. If so, the rows where all child node data are located are hidden using a hide command. Otherwise, the process ends, that is, the selected multiple nodes are expanded and displayed.

[0021] Preferably, the visualization process of the single node and / or multiple nodes carrying their own sub-nodes up and down movement operation includes:

[0022] Obtain the node to be moved selected in the tree hierarchy structure, and determine the node row r1 to be moved;

[0023] Get the row r2 where the last child node of the node to be moved is located;

[0024] Select the target row r3 to be moved in the tree hierarchy;

[0025] Obtaining hidden states of all rows in the node to be moved from the tree hierarchy structure, constructing a state array, and storing hidden states of all rows in the node to be moved through the state array;

[0026] Get up and down movement instructions, move the node to be moved to the target row according to the up and down movement instructions, and then set the hidden display properties of all rows in the moving node row by row in the tree hierarchy structure according to the state array.

[0027] Preferably, in the process of storing the hidden states of all rows in the node to be moved through the state array, the state array is transformed, and the changing method includes:

[0028] S1: Determine the position of the target row r3 and the row r2 where the last child node of the node to be moved is located. If the target row r3 is behind the row r2, it means that the target row r3 moves downward, and execute step S3. If the target row r3 is in front of the row r2, it means that the target row r3 moves upward, and execute the next step.

[0029] S2: Perform a shift row parameter transformation, setting r4 = r1, r1 = r3 + 1, r3 = r2, r2 = r4 - 1;

[0030] S3: Obtain the state array of the hidden and displayed status of the row data from the node row r1 to be moved to the target row r3 in the tree hierarchy structure;

[0031] S4: swap the positions of the elements from 1 to r3-r2 in the state array with the elements from r3-r2+1 to r3-r1+1 to obtain a new state array;

[0032] S5: Perform visualization operations on the data in the row according to the new state array.

[0033] Preferably, the visualization process of the removal operation of the single node and / or multiple nodes carrying the child nodes thereof includes:

[0034] First, determine the range of child nodes of the branch node, then clear the hierarchical identifiers of all rows corresponding to the branch node and child nodes and hide the row data of the branch node and child nodes to achieve the display effect of the node removal operation in the tree structure.

[0035] In a second aspect, the present application provides a device for visualizing an interactive process of a weight tree hierarchy structure after being tabulated, including:

[0036] A hierarchical identification module is used to obtain a tree-like hierarchical structure of aircraft weight after being tabulated, in which cells and their data are hierarchically identified according to the assembly level;

[0037] The selection range determination module is used to receive an interactive operation instruction for the tree hierarchy structure and a selection range in the tree hierarchy structure, and determine an affected cell range within the selection range according to the received interactive operation instruction.

[0038] The visualization processing module is used to perform visualization operations on the affected cell range according to the visualization method corresponding to the interactive operation instruction, so as to achieve the display effect corresponding to the interactive operation instruction.

[0039] Preferably, the tabulated tree-like hierarchical structure of aircraft weight is an Excel spreadsheet file.

[0040] Preferably, the interactive operation instructions include folding, expanding, moving and removing, and the affected cell range is divided into single node and multiple nodes.

[0041] Preferably, the single node folding and unfolding visualization process includes:

[0042] Taking the weight or center of gravity cell in the tree hierarchy as the starting column, obtain the interactive operation instruction when clicking the weight or center of gravity cell;

[0043] Detect the state of the cell's subordinate node. If the state of the cell's subordinate node is expanded, determine the row number of the cell's subordinate node and hide the data in the row where the subordinate node is located.

[0044] If the data in the row number where the subordinate node of the detected cell is located is collapsed, the data in the row where the subordinate node is located is displayed.

[0045] Preferably, the folding and unfolding visualization process of multiple nodes includes:

[0046] Get the selection range in the tree hierarchy, the highest assembly level in the selection range is the intended operation level T0;

[0047] Get the row r2 corresponding to the last child node of the node corresponding to the last level T0 to be operated;

[0048] Expand the lower boundary of the selection range to row r2;

[0049] Determine the range of child node rows of each node corresponding to the intended operation level T0 within the selection range, and set the data rows in all child nodes to be displayed;

[0050] In response to the interactive operation instruction, it is determined whether all child nodes are to be folded. If so, the rows where all child node data are located are hidden using a hide command. Otherwise, the process ends, that is, the selected multiple nodes are expanded and displayed.

[0051] Preferably, the visualization process of the single node and / or multiple nodes carrying their own sub-nodes up and down movement operation includes:

[0052] Obtain the node to be moved selected in the tree hierarchy structure, and determine the node row r1 to be moved;

[0053] Get the row r2 where the last child node of the node to be moved is located;

[0054] Select the target row r3 to be moved in the tree hierarchy;

[0055] Obtaining hidden states of all rows in the node to be moved from the tree hierarchy structure, constructing a state array, and storing hidden states of all rows in the node to be moved through the state array;

[0056] Get up and down movement instructions, move the node to be moved to the target row according to the up and down movement instructions, and then set the hidden display properties of all rows in the moving node row by row in the tree hierarchy structure according to the state array.

[0057] Preferably, in the process of storing the hidden states of all rows in the node to be moved through the state array, the state array is transformed, and the changing method includes:

[0058] S1: Determine the position of the target row r3 and the row r2 where the last child node of the node to be moved is located. If the target row r3 is behind the row r2, it means that the target row r3 moves downward, and execute step S3. If the target row r3 is in front of the row r2, it means that the target row r3 moves upward, and execute the next step.

[0059] S2: Perform a shift row parameter transformation, setting r4 = r1, r1 = r3 + 1, r3 = r2, r2 = r4 - 1;

[0060] S3: Obtain the state array of the hidden and displayed status of the row data from the node row r1 to be moved to the target row r3 in the tree hierarchy structure;

[0061] S4: swap the positions of the elements from 1 to r3-r2 in the state array with the elements from r3-r2+1 to r3-r1+1 to obtain a new state array;

[0062] S5: Perform visualization operations on the data in the row according to the new state array.

[0063] Preferably, the visualization process of the removal operation of the single node and / or multiple nodes carrying the child nodes thereof includes:

[0064] First, determine the range of child nodes of the branch node, then clear the hierarchical identifiers of all rows corresponding to the branch node and child nodes and hide the row data of the branch node and child nodes to achieve the display effect of the node removal operation in the tree structure.

[0065] In a third aspect, the present application provides an electronic device, including:

[0066] one or more processors;

[0067] Memory;

[0068] One or more applications, the one or more applications are stored in the memory and are configured to be executed by the one or more processors, the one or more applications are configured to implement the interactive process visualization method of the listed aircraft weight tree hierarchy as described in any one of the above items.

[0069] Finally, the present application provides a computer storage medium, characterized in that the computer storage medium stores at least one instruction, at least one program, a code set or an instruction set, and the at least one instruction, the at least one program, the code set or the instruction set is loaded and executed by a processor to implement the method for visualizing the interactive process of the listed aircraft weight tree hierarchy structure as described in any of the above items.

[0070] The interactive visualization method of the tree-like hierarchical structure of aircraft weight after listing provided in the present application can view data in an Excel table just like operating a tree structure, and when performing operations such as moving up and down, removing, etc. on single or multiple aircraft weight special effect data in an Excel table, only the upper-level data can be displayed like a real tree structure, avoiding the influence of tens of thousands of rows of lower-level data on the operation. Due to the better visualization effect, the interactive operation of aircraft weight special effect data is more efficient and the probability of error is reduced. BRIEF DESCRIPTION OF THE DRAWINGS

[0071] In order to more clearly illustrate the technical solution provided by the present application, the following is a brief introduction to the accompanying drawings. Obviously, the accompanying drawings described below are only some embodiments of the present application.

[0072] Figure 1 Schematic diagram of the visualization method of the interactive process of the weight tree hierarchy structure after tabulation in this application.

[0073] Figure 2 Schematic diagram of an interactive operation instruction panel in an embodiment of the present application.

[0074] Figure 3 This is a schematic diagram of a device for visualizing the interactive process of a weight tree hierarchy structure after tabulation in the present application.

[0075] Figure 4 A schematic diagram of an electronic device of the present application. DETAILED DESCRIPTION

[0076] In order to make the purpose, technical solutions and advantages of the implementation of this application clearer, the technical solutions in the embodiments of this application will be described in more detail below in conjunction with the drawings in the embodiments of this application.

[0077] The present application provides a method for visualizing aircraft weight data in a table, and provides a visualization method for interactive operations such as folding, expanding, batch folding, batch expanding, moving up and down, and removing that are commonly used in a tree hierarchy, to ensure that data that does not need to be seen during the interactive operation can be automatically hidden, without interfering with the interactive operation, so that the interactive operation can proceed smoothly.

[0078] like Figure 1 As shown, the interactive visualization method of the tree-like hierarchical structure of aircraft weight after the list provided by this application includes:

[0079] S10, obtaining a tabulated tree hierarchy structure of aircraft weight.

[0080] As shown in Table 1, an example of a tabulated tree-like hierarchical structure of aircraft weight according to an embodiment of the present application is shown. The tabulated tree-like hierarchical structure of aircraft weight is an Excel spreadsheet file. In Table 1, cells and their data are hierarchically identified according to the assembly level. The identification method may be different colors or different background patterns.

[0081] Table 1 Tabulated tree structure of aircraft weight

[0082]

[0083]

[0084] S20, receiving an operator's interactive operation instruction for the tree hierarchy structure and a selection range in the tree hierarchy structure, and determining an affected cell range within the selection range according to the received interactive operation instruction.

[0085] In this application, the interactive operation instructions include folding, expanding, moving and removing, and the affected cell ranges are divided into single nodes and multiple nodes. Figure 2 Shown is a schematic diagram of the interactive operation instruction panel in one embodiment of the present application, where the interactive operation instructions include moving up and down (i.e., moving instructions), removing nodes (i.e., removing instructions), batch folding and checking lower levels (folding instructions), and batch expanding folding levels (i.e., expanding instructions).

[0086] S30: Performing a visualization operation on the affected cell range according to the visualization method corresponding to the interactive operation instruction to achieve a display effect corresponding to the interactive operation instruction.

[0087] S31, the visualization process of the single-node folding and unfolding interactive operation in this application includes the following process:

[0088] Taking the subordinate nodes of the assembly level 1.1 node in the folding table 1 as an example, the weight column is set as the folding trigger column, and when the cell where the weight is located is clicked, the interactive operation instruction is triggered. When it is detected that its subordinate is not hidden, the row number where the subordinate node is located is determined (the row number in this embodiment of the present application is 3 to 5), and the hide command of the Excel table is called to hide the data in the row where the subordinate node is located;

[0089] On the contrary, if it is detected that the data in the row number (ie, 3 to 5) where the subordinate node is located has been folded and hidden, then after clicking the weight cell, the Show Rows command of the Excel spreadsheet is called to expand the subordinate nodes of the 1.1 node.

[0090] S32, the visualization process of the multi-node batch folding and unfolding interactive operation in this application includes the following process:

[0091] S321: Obtain the current selection range in the tree hierarchy structure, where the highest assembly level in the selection range is the intended operation level T0;

[0092] Taking the 1.2.2 and 1.2.3 nodes in the folding table 1 as an example, the selection range is the rows where the nodes 1.2.2 and 1.2.3 are located, and the intended operation level T0 is the nodes 1.2.2 and 1.2.3.

[0093] S322: Obtain the row r2 corresponding to the last child node of the node corresponding to the last intended operation level T0;

[0094] For example, in this embodiment, the node 1.2.3 is the last intended operation level T0, and its last child node is 1.2.3.1. The row r2 corresponding to the node 1.2.3.1 is row number 15.

[0095] S323: Expand the lower boundary of the selection range to row r2;

[0096] That is, in this embodiment, the selection range is expanded from row numbers 10 and 13 to row numbers 10 to 15.

[0097] S324: Determine the range of the number of child nodes of each node corresponding to the intended operation level T0 within the selection range, and set the data rows in the rows of all child nodes to be displayed;

[0098] That is, in this application, node 1.2.2 and its child nodes 1.2.2.1 and 1.2.2.2 and node 1.2.3 and its child nodes 1.2.3.1 and 1.2.3.2 are set to display state;

[0099] S325: In response to the interactive operation instruction, determine whether to collapse all child nodes, if so, execute S326, otherwise end, that is, expand and display the selected multiple nodes;

[0100] S326: Hide the rows where all child node data are located using the hide command.

[0101] S33, the visualization process of the single node and / or multiple nodes carrying the sub-nodes moving up and down in the present application includes the following process:

[0102] S331: Obtain the node to be moved selected in the tree-like hierarchical structure (ie, the Excel table), and determine that the row number of the node to be moved is r1;

[0103] This application takes mobile node 1.1 as an example, the selected mobile node is node 1.1, and the row number of node 1.1 is determined to be 2.

[0104] S332: Obtain the row number r2 of the row where the last child node of the node to be moved is located;

[0105] For example, in this embodiment of the present application, the row number r2 of the row where the last child node of the node 1.1 to be moved is located is 5.

[0106] S333: Select the target row r3 to be moved in the tree hierarchy structure;

[0107] In this embodiment of the present application, taking the movement of node 1.1 to node 1.2.5 as an example, it is sufficient to select any cell of node 1.2.5 as the target row r3 to be moved.

[0108] S334: Obtain hidden states of all rows in the node to be moved from the tree hierarchy structure, construct a state array, and store hidden states of all rows in the node to be moved through the state array;

[0109] S335: Obtain up and down movement instructions, move the node to be moved to the target row according to the up and down movement instructions, and then set the hidden display attributes of all rows in the moving node row by row in the tree hierarchy structure according to the state array.

[0110] In step S334 of the present application, in the process of storing the hidden states of all rows in the node to be moved through the state array, the state array is also transformed, and the transformation method includes the following contents:

[0111] S1: Determine the position of the target row r3 and the row r2 where the last node in the moving node is located. If the target row r3 is behind the last row r2, it means that the target row r3 moves downward, and execute step S3. If the target row r3 is in front of the last row r2, it means that the target row r3 moves upward, and execute the next step.

[0112] S2: Perform a shift row parameter transformation, setting r4 = r1, r1 = r3 + 1, r3 = r2, r2 = r4 - 1;

[0113] S3: Get the state array of hiding and displaying status of the rows with moving nodes from row r1 to target row r3 in the tree hierarchy structure;

[0114] S4: swap the positions of the elements from 1 to r3-r2 in the state array with the elements from r3-r2+1 to r3-r1+1 to obtain a new state array;

[0115] S5: Perform visualization operations on subsequent row data according to the new status array.

[0116] S34, the visualization process of the removal operation of a single node and / or multiple nodes carrying their own sub-nodes in the present application includes:

[0117] Taking the removal of node 1.1 in Table 1 as an example, first determine the range of child nodes of this branch node (in this embodiment, the range of child nodes of node 1.1 is up to row 7), then clear the hierarchical identifiers of all corresponding rows of this branch node and child nodes (rows 4-7) and call the hide entire row command of the Excel table to hide the in-row data of the above nodes (i.e. rows 4-7), so as to achieve the display effect of the node removal operation in the tree structure.

[0118] The interactive visualization method of the tree-like hierarchical structure of aircraft weight after listing provided in the present application can view data in an Excel table just like operating a tree structure, and when performing operations such as moving up and down, removing, etc. on single or multiple aircraft weight special effect data in an Excel table, only the upper-level data can be displayed like a real tree structure, avoiding the influence of tens of thousands of rows of lower-level data on the operation. Due to the better visualization effect, the interactive operation of aircraft weight special effect data is more efficient and the probability of error is reduced.

[0119] like Figure 3 As shown, the present application also provides a device for visualizing the interactive process of a weight tree hierarchy structure after tabulation, and the device 100 includes:

[0120] A hierarchical identification module 101 is used to obtain a tabulated tree-like hierarchical structure of aircraft weight, in which cells and their data are hierarchically identified according to assembly levels;

[0121] The selection range determination module 102 is used to receive an interactive operation instruction on the tree hierarchy structure and a selection range in the tree hierarchy structure, and determine an affected cell range within the selection range according to the received interactive operation instruction.

[0122] The visualization processing module 103 is used to perform visualization operations on the affected cell range according to the visualization method corresponding to the interactive operation instruction, so as to achieve the display effect corresponding to the interactive operation instruction.

[0123] For the processing process or content of each module of the aircraft engineering data model exchange device of the present application, reference may be made to the aircraft engineering data model exchange method of the present application, and will not be repeated here.

[0124] like Figure 4 As shown, an embodiment of the present application also provides an electronic device 200, which includes a processing device 201, which can perform various appropriate actions and processes according to a program stored in a ROM (read-only memory) 202 or a program loaded from a storage device 208 to a RAM (random access memory) 203. The processing device 201 may include, for example, a general-purpose microprocessor (such as a CPU), an instruction set processor and / or a related chipset and / or a special-purpose microprocessor (for example, an application-specific integrated circuit (ASIC)), etc. The processing device 201 may also include an onboard memory for caching purposes. The processing device 201 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.

[0125] In RAM 203, various programs and data required for the operation of electronic device 200 are stored. Processing device 201, ROM 202 and RAM 203 are connected to each other via bus 204. Processing device 201 performs various operations of the method flow according to the embodiment of the present application by executing the program in ROM 202 and / or RAM 203. It should be noted that the program can also be stored in one or more memories other than ROM 202 and RAM 203. Processing device 201 can also perform various operations of the method or flow according to the embodiment of the application by executing the program stored in the one or more memories.

[0126] According to an embodiment of the present application, the electronic device 200 may further include an I / O interface 205 (input / output interface), which is also connected to the bus 204. The electronic device 200 may further include one or more of the following components connected to the I / O interface 205: an input device 206 including a keyboard, a mouse, etc.; an output device 207 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage device 208 including a hard disk, etc.; and a communication device 209 including a network interface card such as a LAN card, a modem, etc. The communication device 209 performs communication processing via a network such as the Internet. A drive is also connected to the I / O interface 205 as needed. Removable media, such as magnetic disks, optical disks, magneto-optical disks, semiconductor memories, etc., are installed on the drive as needed so that the computer program read therefrom is installed into the storage device 208 as needed.

[0127] The present application also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or may exist independently without being assembled into the device / apparatus / system. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, various operations of the above methods or processes according to the embodiments of the present application are implemented.

[0128] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed in the present application should be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.

Claims

1. A method for visualizing the interactive process of a weight tree hierarchy structure after tabulation, characterized in that: include: S10, obtaining a tabulated tree-like hierarchical structure of aircraft weight, in which cells and data thereof are hierarchically identified according to assembly levels; S20, receiving an operator's interactive operation instruction for the tree hierarchy structure and a selection range in the tree hierarchy structure, and determining an affected cell range within the selection range according to the received interactive operation instruction. S30: Performing a visualization operation on the affected cell range according to the visualization method corresponding to the interactive operation instruction to achieve a display effect corresponding to the interactive operation instruction.

2. The method for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 1, characterized in that: The listed aircraft weight tree hierarchy is an Excel spreadsheet file.

3. The method for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 2, characterized in that: The interactive operation instructions include folding, expanding, moving and removing, and the affected cell range is divided into single-node and multi-node.

4. The method for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 3, characterized in that: The single node folding and unfolding visualization process includes: Taking the weight or center of gravity cell in the tree hierarchy as the starting column, obtain the interactive operation instruction when clicking the weight or center of gravity cell; Detect the state of the cell's subordinate node. If the state of the cell's subordinate node is expanded, determine the row number of the cell's subordinate node and hide the data in the row where the subordinate node is located. If the data in the row number where the subordinate node of the detected cell is located is collapsed, the data in the row where the subordinate node is located is displayed.

5. The method for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 3, characterized in that: The folding and unfolding visualization process of multiple nodes includes: Get the selection range in the tree hierarchy, the highest assembly level in the selection range is the intended operation level T0; Get the row r2 corresponding to the last child node of the node corresponding to the last level T0 to be operated; Expand the lower boundary of the selection range to row r2; Determine the range of child node rows of each node corresponding to the intended operation level T0 within the selection range, and set the data rows in all child nodes to be displayed; In response to the interactive operation instruction, it is determined whether all child nodes are to be folded. If so, the rows where all child node data are located are hidden using a hide command. Otherwise, the process ends, that is, the selected multiple nodes are expanded and displayed.

6. The method for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 5, characterized in that: The visualization process of the single node and / or multiple nodes carrying their own sub-level nodes up and down movement operation includes: Obtain the node to be moved selected in the tree hierarchy structure, and determine the node row r1 to be moved; Get the row r2 where the last child node of the node to be moved is located; Select the target row r3 to be moved in the tree hierarchy; Obtaining hidden states of all rows in the node to be moved from the tree-like hierarchical structure, constructing a state array, and storing hidden states of all rows in the node to be moved through the state array; Get up and down movement instructions, move the node to be moved to the target row according to the up and down movement instructions, and then set the hidden display properties of all rows in the moving node row by row in the tree hierarchy structure according to the state array.

7. The method for visualizing the interactive process of the tree-like hierarchical structure of the listed aircraft weight according to claim 6, characterized in that: In the process of storing the hidden states of all rows in the node to be moved through the state array, the state array is transformed, and the changing method includes: S1: Determine the position of the target row r3 and the row r2 where the last child node of the node to be moved is located. If the target row r3 is behind the row r2, it means that the target row r3 moves downward, and execute step S3. If the target row r3 is in front of the row r2, it means that the target row r3 moves upward, and execute the next step. S2: Perform a shift row parameter transformation, setting r4 = r1, r1 = r3 + 1, r3 = r2, r2 = r4 - 1; S3: Obtain the state array of the hidden and displayed status of the row data from the node row r1 to be moved to the target row r3 in the tree hierarchy structure; S4: swap the positions of the elements from 1 to r3-r2 in the state array with the elements from r3-r2+1 to r3-r1+1 to obtain a new state array; S5: Perform visualization operations on the data in the row according to the new state array.

8. The method for visualizing the interactive process of the tree-like hierarchical structure of the listed aircraft weight according to claim 3, characterized in that: The visualization process of the removal operation of the single node and / or multiple nodes carrying the child nodes includes: First, determine the range of child nodes of the branch node, then clear the hierarchical identifiers of all rows corresponding to the branch node and child nodes and hide the row data of the branch node and child nodes to achieve the display effect of the node removal operation in the tree structure.

9. A device for visualizing the interactive process of the weight tree hierarchy structure after tabulation, characterized in that: include: A hierarchical identification module is used to obtain a tree-like hierarchical structure of aircraft weight after being tabulated, in which cells and their data are hierarchically identified according to the assembly level; The selection range determination module is used to receive an interactive operation instruction for the tree hierarchy structure and a selection range in the tree hierarchy structure, and determine an affected cell range within the selection range according to the received interactive operation instruction. The visualization processing module is used to perform visualization operations on the affected cell range according to the visualization method corresponding to the interactive operation instruction, so as to achieve the display effect corresponding to the interactive operation instruction.

10. The apparatus for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 9, characterized in that: The listed aircraft weight tree hierarchy is an Excel spreadsheet file.

11. The apparatus for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 10, characterized in that: The interactive operation instructions include folding, expanding, moving and removing, and the affected cell range is divided into single-node and multi-node.

12. The apparatus for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 11, characterized in that: The single node folding and unfolding visualization process includes: Taking the weight or center of gravity cell in the tree hierarchy as the starting column, obtain the interactive operation instruction when clicking the weight or center of gravity cell; Detect the state of the cell's subordinate node. If the state of the cell's subordinate node is expanded, determine the row number of the cell's subordinate node and hide the data in the row where the subordinate node is located. If the data in the row number where the subordinate node of the detected cell is located is collapsed, the data in the row where the subordinate node is located is displayed.

13. The apparatus for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 11, characterized in that: The folding and unfolding visualization process of multiple nodes includes: Get the selection range in the tree hierarchy, the highest assembly level in the selection range is the intended operation level T0; Get the row r2 corresponding to the last child node of the node corresponding to the last level T0 to be operated; Expand the lower boundary of the selection range to row r2; Determine the range of child node rows of each node corresponding to the intended operation level T0 within the selection range, and set the data rows in all child nodes to be displayed; In response to the interactive operation instruction, it is determined whether all child nodes are to be folded. If so, the rows where all child node data are located are hidden using a hide command. Otherwise, the process ends, that is, the selected multiple nodes are expanded and displayed.

14. The apparatus for visualizing the interactive process of the weight tree hierarchy structure after tabulation as claimed in claim 13, characterized in that: The visualization process of the single node and / or multiple nodes carrying their own sub-level nodes up and down movement operation includes: Obtain the node to be moved selected in the tree hierarchy structure, and determine the node row r1 to be moved; Get the row r2 where the last child node of the node to be moved is located; Select the target row r3 to be moved in the tree hierarchy; Obtaining hidden states of all rows in the node to be moved from the tree-like hierarchical structure, constructing a state array, and storing hidden states of all rows in the node to be moved through the state array; Get up and down movement instructions, move the node to be moved to the target row according to the up and down movement instructions, and then set the hidden display properties of all rows in the moving node row by row in the tree hierarchy structure according to the state array.

15. The device for visualizing the interactive process of the tree-like hierarchical structure of the listed aircraft weight according to claim 14, characterized in that: In the process of storing the hidden states of all rows in the node to be moved through the state array, the state array is transformed, and the changing method includes: S1: Determine the position of the target row r3 and the row r2 where the last child node of the node to be moved is located. If the target row r3 is behind the row r2, it means that the target row r3 moves downward, and execute step S3. If the target row r3 is in front of the row r2, it means that the target row r3 moves upward, and execute the next step. S2: Perform a shift row parameter transformation, setting r4 = r1, r1 = r3 + 1, r3 = r2, r2 = r4 - 1; S3: Obtain the state array of the hidden and displayed status of the row data from the node row r1 to be moved to the target row r3 in the tree hierarchy structure; S4: swap the positions of the elements from 1 to r3-r2 in the state array with the elements from r3-r2+1 to r3-r1+1 to obtain a new state array; S5: Perform visualization operations on the data in the row according to the new state array.

16. The apparatus for visualizing the interactive process of the tree-like hierarchical structure of the listed aircraft weight according to claim 11, characterized in that: The visualization process of the removal operation of the single node and / or multiple nodes carrying the child nodes includes: First, determine the range of child nodes of the branch node, then clear the hierarchical identifiers of all rows corresponding to the branch node and child nodes and hide the row data of the branch node and child nodes to achieve the display effect of the node removal operation in the tree structure.

17. An electronic device, characterized in that: include: one or more processors; Memory; One or more applications, the one or more applications are stored in the memory and configured to be executed by the one or more processors, the one or more applications are configured to implement the method for visualizing an interactive process of a tree-like hierarchy structure of listed aircraft weights according to any one of claims 1 to 8.

18. A computer storage medium, characterized in that: The computer storage medium stores at least one instruction, at least one program, a code set or an instruction set, and the at least one instruction, the at least one program, the code set or the instruction set are loaded and executed by the processor to implement the method for visualizing the interactive process of the tabulated aircraft weight tree hierarchy structure as described in any one of claims 1 to 8.