CN113704257B

CN113704257B - Data table updating method and device

Info

Publication number: CN113704257B
Application number: CN202110904395.8A
Authority: CN
Inventors: 王忠攀
Original assignee: Netease Hangzhou Network Co Ltd
Current assignee: Netease Hangzhou Network Co Ltd
Priority date: 2021-08-06
Filing date: 2021-08-06
Publication date: 2023-09-26
Anticipated expiration: 2041-08-06
Also published as: CN113704257A

Abstract

The invention discloses a data table updating method and device. Wherein the method comprises the following steps: determining a first target item from a plurality of first items, and determining a field to be linked from a plurality of fields contained in the first target item, wherein the plurality of first items are a plurality of items in a first data table displayed by a graphical user interface; acquiring a plurality of second entries associated with fields to be linked, wherein the plurality of second entries are a plurality of entries in a second data table displayed by a graphical user interface, and the first data table is different from the second data table; determining a second target entry from the plurality of second entries; and assigning the key name corresponding to the second target item to the field to be linked, and updating the first data table. The invention solves the technical problem of low management efficiency in the prior art that the data table is required to be manually managed.

Description

Data table updating method and device

Technical Field

The present invention relates to the field of computers, and in particular, to a method and apparatus for updating a data table.

Background

In game development, excel files are accepted by a wide range of game developers as the most common data configuration mode. At present, most game development needs Excel files as data carriers to realize the docking with game program data. The editing software of the Excel file comprises Office, WPS and the like, has a powerful function, can realize rich operations, and is particularly efficient in a batch editing mode.

However, with the development of the game industry, for a common game, hundreds or even thousands of Excel data tables are required, and only a developer manually maintains the Excel table structure and the relation chain among the Excel tables, so that the requirements cannot be met.

In addition, in game development, an Excel table is generally used as a data table, and its format is divided into a header field in units of columns and data contents in units of rows, for example, in the schematic diagram of the Excel table shown in fig. 1, the header field includes fields such as a field description, a bounding box number, and a bounding box description, and the data contents include data contents such as a right thigh of a tiger, a right calf of a tiger, and the like. To define the role of each column header field, description text, data type, field type, key name, default value, etc. are defined; to define the role of each row of data content, key names, descriptive text, field data, etc. are defined.

In order to link up the game program, the Excel table defines the data types, and in practical application, the data content needs to be filled with data in a corresponding format, for example, in fig. 1, the range type corresponding to the siren is int, that is, the range type corresponding to the siren is an integer. Furthermore, there are implicit limitations in the data table, for example, some fields have data ranges between [0,2], and these limitations require manual maintenance by a human. In addition, in the same Excel table, a plurality of fields have relevance, for example, in the shape_type field, the capsule body has a height field, and the sphere has no height.

For the same data content multiplexing, excel tables also typically have a reference relationship, i.e., a relationship chain, e.g., a bone bounding box for each part of the monster in FIG. 1, while in another Excel table there is a reference to the key name of each part. This relationship chain across Excel sheets also requires that the developer open multiple Excel sheets, copy the key names, and then close the Excel sheets. However, the above-described operation method is complicated in operation, and the editing efficiency of the data table is low.

In view of the above problems, no effective solution has been proposed at present.

Disclosure of Invention

The embodiment of the invention provides a method and a device for updating a data table, which are used for at least solving the technical problem of low management efficiency in the prior art that the data table is required to be manually managed.

According to an aspect of an embodiment of the present invention, there is provided a method for updating a data table, including: determining a first target item from a plurality of first items, and determining a field to be linked from a plurality of fields contained in the first target item, wherein the plurality of first items are a plurality of items in a first data table displayed by a graphical user interface; acquiring a plurality of second entries associated with fields to be linked, wherein the plurality of second entries are a plurality of entries in a second data table displayed by a graphical user interface, and the first data table is different from the second data table; determining a second target entry from the plurality of second entries; and assigning the key name corresponding to the second target item to the field to be linked, and updating the first data table.

Further, the updating of the data table further includes: after the key name corresponding to the second target item is assigned to the field to be linked, a plurality of first fields contained in the first target item and the key names corresponding to the plurality of first fields are displayed in the graphical user interface, wherein the key name corresponding to the field to be linked is the key name corresponding to the second target item.

Further, the updating of the data table further includes: after the key name corresponding to the second target entry is assigned to the field to be linked, responding to a reset instruction, and recovering the first data table to an initial data table and/or recovering the entry in the first data table to an initial entry, wherein the initial data table is the data table before updating the first data table, and the initial entry is the entry before updating the entry in the first data table.

Further, the updating of the data table further includes: after the key name corresponding to the second target item is assigned to the field to be linked, responding to a reload instruction, reading a third data table, and copying the third data table to obtain a copied third data table, wherein the third data table is obtained after updating the first data table stored in the configuration file; and loading the copied third data table to perform covering operation on the first data table.

Further, the updating of the data table further includes: after the key name corresponding to the second target item is assigned to the field to be linked, responding to the pulling instruction, and acquiring a fourth data table from the version control system; combining the fourth data table with a third data table to obtain a combined data table, wherein the third data table is a data table obtained after updating the first data table stored in the configuration file; copying the merged data table to obtain a copied merged data table; and loading the copied merging data table to perform covering operation on the first data table.

Further, the updating of the data table further includes: after the key name corresponding to the second target item is assigned to the field to be linked, the updated first data table is saved, and the updated first data table is uploaded to the client and the server.

Further, the updating of the data table further includes: reading a data table file before determining a first target entry from a plurality of first entries, wherein the data table file contains a plurality of data tables; splitting the data table file by taking the worksheet as a unit to obtain a plurality of data tables; and displaying table identifiers corresponding to the plurality of data tables in a first display area of the graphical user interface.

Further, the updating of the data table further includes: after table identifiers corresponding to the plurality of data tables are displayed in a first display area of the graphical user interface, determining a first data table from the table identifiers corresponding to the plurality of data tables; copying the first data table to obtain a copied first data table; analyzing the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries; displaying a plurality of first items within a second display area of the graphical user interface; and displaying a plurality of fields and values corresponding to the plurality of fields contained in the first target item in a third display area of the graphical user interface.

Further, the updating of the data table further includes: after resolving the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries, resolving preset fields at preset positions in the first data table, and determining target types corresponding to the preset fields; determining an original type corresponding to preset data input into a preset field; determining a type conversion function according to preset data; the original type is converted into the target type according to the type conversion function.

Further, the updating of the data table further includes: after resolving the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries, detecting whether data corresponding to a preset field at a preset position in the first data table is empty or not; and when the data corresponding to the preset field is detected to be empty, determining the data corresponding to the preset field as preset data.

Further, the updating of the data table further includes: after resolving the copied first data table to obtain a plurality of first fields corresponding to the first data table and numerical values corresponding to the plurality of first fields, resolving preset fields at preset positions in the first data table, and determining field functions corresponding to the preset fields; when the field function is a construction function of the relation chain, constructing the relation chain between the first data table and the second data table based on a preset field; when the field function defines a function for a data range, determining a numerical range corresponding to a preset field based on the field type of the preset field; when the field function is a field association function, constructing an association relationship between a third field and a second target item, wherein the third field is a field associated with the second target item in the plurality of first fields; when the field function is an enumeration function, building enumeration content corresponding to a preset field.

According to another aspect of the embodiment of the present invention, there is also provided an apparatus for updating a data table, including: the first determining module is used for determining a first target item from a plurality of first items and determining a field to be linked from a plurality of fields contained in the first target item, wherein the plurality of first items are a plurality of items in a first data table displayed by a graphical user interface; the acquisition module is used for acquiring a plurality of second entries associated with the fields to be linked, wherein the plurality of second entries are a plurality of entries in a second data table displayed by the graphical user interface, and the first data table is different from the second data table; a second determining module for determining a second target entry from a plurality of second entries; and the updating module is used for assigning the key name corresponding to the second target item to the field to be linked and updating the first data table.

According to another aspect of the embodiments of the present invention, there is also provided a storage medium having a computer program stored therein, wherein the computer program is configured to perform the above-described data table updating method at runtime.

According to another aspect of an embodiment of the present invention, there is also provided an electronic device including one or more processors; and a storage device for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement a method for running the programs, wherein the programs are configured to perform the data table updating method described above when run.

In the embodiment of the invention, a data table editing tool is adopted to manage a data table, after a first target item is determined from a plurality of first items and a field to be linked is determined from a plurality of fields contained in the first target item, a plurality of second items associated with the field to be linked are acquired, a second target item is determined from the plurality of second items, and finally, a key name corresponding to the second target item is assigned to the field to be linked and the first data table is updated. The first entries are entries in a first data table displayed by the graphical user interface, and the second entries are entries in a second data table displayed by the graphical user interface, and the first data table is different from the second data table.

In the above process, the field to be linked is associated with the plurality of second entries in the second data table, and the field to be linked is a field in the plurality of fields included in the first target entry in the first data table, so that the field to be linked can realize association between the first data table and the second data table, and a user can realize field linking between the cross tables without frequently opening and closing the data tables, thereby improving editing efficiency between the data tables and further improving management efficiency of the data tables.

Therefore, the scheme provided by the application achieves the aim of managing the data table, thereby realizing the technical effect of improving the management efficiency of the data table, and further solving the technical problem of low management efficiency in the prior art that the data table is required to be manually managed.

Drawings

The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute a limitation on the application. In the drawings:

FIG. 1 is a schematic diagram of an EXCEL table according to the prior art;

FIG. 2 is a flow chart of a method for updating a data table according to an embodiment of the application;

FIG. 3 is a graphical user interface schematic of an alternative editing tool according to an embodiment of the application;

FIG. 4 is a graphical user interface schematic of an alternative editing tool according to an embodiment of the present application;

FIG. 5 is a graphical user interface schematic of an alternative editing tool according to an embodiment of the application;

FIG. 6 is a graphical user interface schematic of an alternative editing tool according to an embodiment of the present application;

FIG. 7 is a data flow diagram of an alternative editing tool according to an embodiment of the present application;

FIG. 8 is a graphical user interface schematic of an alternative editing tool according to an embodiment of the present invention;

FIG. 9 is a schematic diagram of an alternative MVC framework in accordance with an embodiment of the present invention;

FIG. 10 is an alternate edit graph of interworking between multiple tools according to an embodiment of the present invention;

fig. 11 is a schematic diagram of an updating apparatus for a data table according to an embodiment of the present invention.

Detailed Description

In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.

It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

According to an embodiment of the present invention, there is provided an embodiment of a method for updating a data table, it being noted that the steps shown in the flowchart of the figures may be performed in a computer system such as a set of computer executable instructions, and that although a logical order is shown in the flowchart, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

In addition, it should be noted that a data table editing tool (hereinafter referred to as an editing tool) may be used as an execution subject of the present embodiment, where the editing tool may be editing software or an application of a data table, and may implement requirements for managing, editing, etc. multiple tables, cross-tables, and single tables.

FIG. 2 is a flowchart of a method for updating a data table according to an embodiment of the present invention, as shown in FIG. 2, the method includes the steps of:

step S202, determining a first target item from a plurality of first items, and determining a field to be linked from a plurality of fields contained in the first target item, wherein the plurality of first items are a plurality of items in a first data table displayed by a graphical user interface.

In step S202, the first data table may be, but is not limited to, an EXCEL data table, where the first data table may be any one of data tables in a data table file containing a plurality of data tables. Optionally, the first data table is a data table selected by a user through operation in a graphical user interface corresponding to the editing tool. For example, as can be seen from the graphical user interface of the editing tool shown in fig. 3, the graphical user interface of the editing tool mainly includes three windows, namely a data table directory window, an entry window and an entry data window, where the data table directory window shows identification information (for example, each data table name) of each data table included in the data table file; the entry window shows entry information of entries contained in the data table selected by the user, for example, each entry contained in the "MZ hit determination table" is shown in the entry window in fig. 3; the item data window shows the fields and values corresponding to the fields included in the target item selected by the user, for example, the fields and values corresponding to the fields corresponding to the "double-tap first segment-first-click" item (for example, the value corresponding to the "injury event number" field is "3010111") are shown in the item data window in fig. 3.

It should be noted that the data table may include a plurality of entries, and each entry may be composed of a plurality of fields and values corresponding to the plurality of fields.

In addition, the first data table is a data table selected by the user from a plurality of data tables displayed on the graphical user interface of the editing tool, for example, the first data table may be the "MZ hit determination table" in fig. 3. The first entry is an entry included in the first data table, and the first target entry is a target entry selected by the user from a plurality of first entries in the first data table, for example, in fig. 3, if the user selects an "double-knife-flick first segment-first-click" entry from a plurality of entries displayed in the entry window, the entry is the first target entry.

It is easy to notice that, because the editing tool can visually display the data table, the items contained in the data table and the data contained in the items through the data table directory window, the item window and the item data window respectively, the user can clearly know the data information contained in each data table only through each window, repeated opening and closing operations on the data table are not needed, and the management efficiency of the user management data table is improved.

Step S204, a plurality of second entries associated with the fields to be linked are obtained, wherein the plurality of second entries are a plurality of entries in a second data table displayed by the graphical user interface, and the first data table is different from the second data table.

In step S204, the second data table may be any one of the data tables in the data table file. The second entries are similar to the first data table and the first entries, and are entries included in the second data table, wherein each of the plurality of second entries also includes a field and a value corresponding to the field.

It should be noted that, chain links may be established between the data tables through the fields to be linked, where chain links between the data tables are implemented through the fields to be linked. For example, in FIG. 3, "@" indicates that the current field is the field to be linked that implements chain linking between data tables. After the user clicks on the field after "@" the editing tool automatically jumps from the graphical user interface of the first data table to the graphical user interface of the second data table, for example, as shown in fig. 4, after the user clicks on the "@ default injury value" field in fig. 3, a plurality of second entries contained in the second data table associated with the first data table are presented in an entry window of the graphical user interface of the editing tool, and a chained TAB is presented at the TAB, for example, a secondary TAB direct_damage is presented in the entry window of fig. 4. At the same time, fields in the second target items in the plurality of second items and values corresponding to the fields are displayed in an item data window of the graphical user interface, as shown in fig. 4.

Step S206, determining a second target item from the plurality of second items.

Optionally, in the graphical user interface of the editing tool shown in fig. 5, the user selects a second target item "physical harmless skills" among a plurality of second items shown in the item window. The user can determine the second target item from the plurality of second items in a mode of clicking a mouse or touching a finger. Meanwhile, fields contained in the physical harmless skills and values corresponding to the fields are displayed in an item data window.

Step S208, the key name corresponding to the second target item is assigned to the field to be linked, and the first data table is updated.

Optionally, as in fig. 5, the user selects the "physical harmless skills" item, and performs a right-click operation on the item, at this time, an item editing control is popped up in the item window, where the item editing control includes three sub-controls, for example, in fig. 5, the item editing control includes a "copy item" control, a "delete item" control, and an "apply item" control, and the user operates the three sub-controls to implement copy, delete, and apply operations on the selected item. In fig. 5, when the user operates the "application entry" control, the editing tool assigns a key name "5000000" corresponding to the "physical harmless skills" to the field to be linked, so as to update the value of the field to be linked from "3010211" to "5000000". Meanwhile, the editing tool jumps from the graphical user interface shown in fig. 5 into the graphical user interface shown in fig. 6, and the "entry window" and "entry data window" in fig. 6 show only one TAB label. As can be seen from fig. 6, through steps S202 to S208, the value corresponding to the field to be linked in the first target entry in the first data table is updated from "3010211" to "5000000", so as to update the first data table.

It should be noted that, after the modification of the values of the fields to be linked is completed, the user may also modify other fields of the data table and the values corresponding to the fields through the editing tool. After the editing tool completes the modification of all the data tables, the editing tool may update all the data tables in a unified manner.

According to the above, the fields to be linked realize the association between the data tables, and the editing tool is used for modifying the numerical values corresponding to the fields to be linked, so that the modification of the same fields in a plurality of data tables can be realized without memorizing and searching the relation chain among the plurality of data tables by a user, thereby improving the editing efficiency of the data tables. Meanwhile, the process does not need to carry out multiple opening and closing operations on a plurality of data tables, and the management efficiency of the data tables is further improved.

Based on the above-defined schemes in steps S202 to S208, it may be known that, in the embodiment of the present invention, in a manner of managing the data table by using the data table editing tool, after determining the first target entry from the plurality of first entries and determining the field to be linked from the plurality of fields included in the first target entry, the second target entry is determined from the plurality of second entries by acquiring the plurality of second entries associated with the field to be linked, and finally, the key name corresponding to the second target entry is assigned to the field to be linked and the first data table is updated. The first entries are entries in a first data table displayed by the graphical user interface, and the second entries are entries in a second data table displayed by the graphical user interface, and the first data table is different from the second data table.

It is easy to note that in the above process, since the field to be linked is associated with the plurality of second entries in the second data table, and the field to be linked is a field in the plurality of fields included in the first target entry in the first data table, the field to be linked can achieve association between the first data table and the second data table, so that a user does not need to perform frequent opening and closing operations on the data tables, field linking between the tables can be achieved, editing efficiency between the data tables is improved, and management efficiency of the data tables is further improved.

In an alternative embodiment, after assigning the key name corresponding to the second target entry to the field to be linked, the editing tool displays, in the graphical user interface, the first fields included in the first target entry and the key names corresponding to the first fields, where the key name corresponding to the field to be linked is the key name corresponding to the second target entry. For example, after the editing tool completes the assignment operation of the field to be linked, the editing tool automatically jumps to the graphical user interface shown in fig. 6, where the graphical user interface shown in fig. 6 shows a plurality of first entries included in the first data table and values corresponding to the field to be linked in the first target entry, and the values corresponding to the field to be linked are values obtained after modifying the values corresponding to the field to be linked by means of link jump.

It should be noted that, the process of updating the fields in the data table by the editing tool in the chain jump manner involves reading, writing, parsing, editing and visualizing the single data table, managing, editing and operating the batch data table, and configuring the relationship chain between the data tables. Optionally, fig. 7 shows a data flow diagram of an optional editing tool, and as can be seen from fig. 7, the editing tool reads the EXCEL file into the local memory, and then performs processes such as parsing, visualizing, editing, and saving the EXCEL file. The EXCEL file includes at least one EXCEL data table, which may be the first data table in step S202.

In an alternative embodiment, before determining the first target entry from the plurality of first entries, when detecting a read instruction, the editing tool parses the read instruction to obtain a list identifier, reads a file list corresponding to the list identifier from a preset cache, and displays the file list.

It should be noted that, the above list identifier may be set according to actual requirements, where in a game scenario, the list identifier may be determined according to a type of a model to be rendered, for example, a data table in the list a includes fields and/or data related to clothing rendering of the virtual character, and a data table in the list B includes fields and/or data related to skills of the virtual character.

Optionally, the user may need to process fields and/or data related to the skill of the avatar, at which point the user may determine the skill set of the avatar by an editing tool, e.g., the "skill set" in FIG. 8. Then, the editing tool reads all files in the skill group from the preset cache and displays the files.

Further, after the file list is displayed, when a selection instruction for the file list is detected, the editing tool determines a target file to be loaded from the file list, loads the target file, and displays a data table list corresponding to the target file, wherein the data table list at least comprises identification information of at least one data table, and the target file comprises at least one data table.

The target file includes a plurality of data tables, for example, the "art group" list includes files corresponding to different art tasks, for example, the art A1 corresponds to the file B1, the art A2 corresponds to the file B2, the file B1 further includes a plurality of data tables corresponding to the art A1, the file B2 also includes a plurality of data tables corresponding to the art A2, and each data table may be an EXCEL data table.

Optionally, when the user selects "art A1" in the "art group", each data table contained in "art A1" is displayed in the data table directory window of the editing tool.

It is easy to note that the target file is determined by the editing tool after receiving the selection instruction, that is, the editing tool can selectively display the data tables required to be displayed by the user according to the requirement of the user, so that the problem of slow loading speed caused by loading all the data tables at one time is avoided.

In addition, since the number of data tables is large, frequent reading and writing of the data tables is not feasible, and therefore, the data tables after reading and analyzing need to be cached.

Furthermore, after determining the target file, the editing tool loads the target file and displays a data table list corresponding to the target file. Specifically, the editing tool performs deserialization operation on at least one data table to obtain a data structure corresponding to the at least one data table, loads the data structure, and displays the data table list based on the data structure.

Optionally, as shown in fig. 7, after reading the EXCEL file to the local memory, the editing tool performs a deserialization operation on the EXCEL file to obtain a data structure corresponding to a data table included in the EXCEL file, loads the data structure into a modification buffer, and then performs visual display on the data table based on the modification buffer. The user can edit the data content of the data table displayed in the graphical user interface of the editing tool, store the editing result in the modification buffer, write the data in the modification buffer back to the data structure, perform serialization operation on the data structure, store the data after the serialization operation in the local memory, and finally write the data in the local memory into the EXCEL file.

In an alternative embodiment, after loading the target file, the editing tool determines a first data table from at least one data table contained in the target file and performs a copy operation on the first data table.

In the process of analyzing the data table, the editing tool needs to process the original data table, read the data table, modify the logic relationship of the cache and display, so that the consistency of the data table needs to be maintained. In the process of editing the data table, the editing tool solves the problem of data conflict between the modified data table and the original data table in a file copying mode, and the data of the data table in reading can not be modified externally in the editing process. In addition, the problem that the data table cannot be edited due to the fact that the file is occupied can be avoided by performing copy operation on the data table.

The process of reading, modifying and storing the data table by the editing tool is an atomic operation, and the atomic operation is an indivisible operation, namely, all or none is performed. I.e. the original data table a, the duplicate data table B and the data table C in the memory of the editing tool ensure that the data after saving or reloading is identical, for example, if data table C is modified to c+, three data tables (A+.B+.C+) after storage, (a++++++++++++++++++++++++++); if the data table A is modified to be A+, after the three data tables are reloaded (A+, B→C), the data table A is obtained (A+, B+, C+); if both tables A and C are modified, the user may select the table to be saved or reloaded by the editing tool and discard the other table.

In an alternative embodiment, before determining the first target entry from the plurality of first entries, the editing tool reads the data table file, splits the data table file by taking the worksheet as a unit to obtain a plurality of data tables, and then displays table identifiers corresponding to the plurality of data tables in a first display area of the graphical user interface. Wherein the data table file contains one or more data tables.

In general, a data table is edited in units of files, for example, in units of EXCEL files, and when operating on EXCEL files, it is necessary to consider the problem of multiple tables and files. It is easy to note that since a plurality of data tables are located in the same file, when the data tables are operated, the editing tool needs to disassemble the file, for example, disassemble the EXCEL file into a plurality of sheet tables, which results in complicated operation. In order to solve the above-mentioned problem, in this embodiment, the editing tool splits the first data table with the sub-table as an editing unit to obtain a plurality of sub-data tables, so as to implement a multi-level unified design of the editing tool, for example, split the EXCEL into a plurality of sub-tables with the sheet as a unit.

In addition, it should be noted that, in this embodiment, the editing tool is an editor designed based on a MVC (Model View Controller) framework, where fig. 9 shows a schematic diagram of an alternative MVC, and as can be seen from fig. 9, in this embodiment, the editing tool may implement parsing, visualizing and editing operations on a data table through a model module, a view module and a control module. In addition, as can be seen from fig. 9, after the editing tool parses the data table, the parsed data table may be visually displayed, where the editing tool signals the parsed data table from the model module to the view module (as shown by the dashed line in fig. 9). The view module may display the parsed data table through the graphical user interface of the editing tool shown in fig. 8, for example, display each entry included in the data table in the entry window shown in fig. 8, and display the field included in the entry selected by the user and the value corresponding to the field in the entry data window.

In an alternative embodiment, after the table identifiers corresponding to the plurality of data tables are displayed in the first display area of the graphical user interface, the editing tool determines the first data table from the table identifiers corresponding to the plurality of data tables, copies the first data table to obtain a copied first data table, then analyzes the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries, displays the plurality of first entries in the second display area of the graphical user interface, and finally displays a plurality of fields contained in the first target entry and values corresponding to the plurality of fields in the third display area of the graphical user interface.

It should be noted that, the first display area may be the data table window in fig. 3, the second display area may be the entry window in fig. 3, and the third display area may be the entry data window in fig. 3.

Alternatively, taking fig. 3 as an example for illustration, the user selects "MZ hit determination table" from the plurality of data tables displayed in the data table directory window as the first data table, and at this time, the editing tool copies the "MZ hit determination table" and parses the copied "MZ hit determination table" to obtain the entry included in the "MZ hit determination table". Then, the editing tool shows the individual entries contained in the "MZ hit determination table" in the entry window in fig. 3. After the user selects a first target item of 'double-knife-flick first section-first click' in the item window, fields contained in the item of 'double-knife-flick first section-first click' and values corresponding to the fields are displayed in an item data window of the editing tool.

In an alternative embodiment, after resolving the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries, the editing tool resolves a preset field at a preset position in the first data table, determines a target type corresponding to the preset field, determines an original type corresponding to preset data input to the preset field, then determines a type conversion function according to the preset data, and converts the original type into the target type according to the type conversion function.

It should be noted that, in the above process, the preset location in the first data table may be, but is not limited to, a header field of the first data table, where the header field defines a format type (i.e., an original type, for example, a string type) of the content data. The editing tool may convert the field type of the header field in the first data table by a type conversion function, wherein different field types correspond to different type conversion functions, e.g., the editing tool converts a string type to an int (bool) type (i.e., a target type) using type conversion function 1.

In addition, it should be noted that, in the present embodiment, the editing tool may implement type conversion between a string type and a base type (for example, a type such as int, bool, float, str), may implement type conversion between a string type and a container type (for example, a type such as list, act, etc.), and may implement type conversion between a string and a combination type (for example, a combination of a container type and a base type, for example, list (int)).

In an alternative embodiment, after analyzing the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries, the editing tool detects whether the data corresponding to the preset field at the preset position in the first data table is empty, and determines that the data corresponding to the preset field is preset data when the data corresponding to the preset field is detected to be empty. That is, in this embodiment, when it is detected that the content corresponding to a certain field in the sheet table is empty, default data is used for filling, so that the problem of program abnormality caused by that the data content is empty is avoided.

In an alternative embodiment, in the process of analyzing the copied first data table, the editing tool reads the first data corresponding to the cells in the copied first data table, then converts the first data format corresponding to the first data into the second data format, and displays the first data in the second data format on the graphical user interface.

It should be noted that, the editing tool may implement reading, converting, modifying, and displaying the data content corresponding to the cells in the copied first data table. Specifically, the editing tool reads the data content in the copied first data table into the memory in the form of a character string, and uses a type conversion function to perform format conversion on the data content, for example, converting the character string type (i.e., the first data format) into the int type (i.e., the second data format). After the format conversion is completed, the editing tool displays the format-converted data content in the entry data window.

In addition, it should be noted that, in addition to the format conversion of the data content, the user may modify the data content, for example, the user modifies the value corresponding to the "injury event number" field to "3010112" through the entry data window in fig. 3, and at this time, the entry data window of the editing tool displays the modified value of the "injury event number".

In an alternative embodiment, after parsing the copied first data table to obtain a plurality of first fields corresponding to the first data table and values corresponding to the plurality of first fields, the editing tool may further perform function definition on the fields in the first data table, for example, relationship chains, data range definition, association fields, enumeration, and so on.

Specifically, the editing tool parses a preset field at a preset position in the first data table, and determines a field function corresponding to the preset field. When the field function is a construction function of the relation chain, the editing tool constructs the relation chain between the first data table and the second data table based on the preset field.

When the field function defines a function for the data range, the editing tool determines a numerical range corresponding to the preset field based on the field type of the preset field. For example, if the user defines the value range corresponding to the "flash white of the hit side" field as an integer, the user can only input the integer into the value range corresponding to the field, if the user inputs the floating point number, the editing tool forcedly modifies the floating point number as an integer, for example, if the user inputs "3.1", the editing tool forcedly modifies "3.1" as "3" or "4".

When the field function is a field association function, the editing tool constructs an association relationship between a third field and the second target entry, wherein the third field is a field associated with the second target entry in the plurality of first fields. For example, field a (i.e., the third field) is associated with entry b (i.e., the second target entry).

In addition, the editing tool may also construct an association relationship between the fields, for example, when the field a is associated with the field b, and when the value corresponding to the field a is "0", the value corresponding to the field b is an invalid value, and at this time, the editing tool may automatically set the field b as a default value.

When the field function is an enumeration function, the editing tool builds enumeration contents corresponding to the preset field. For example, the numerical content corresponding to the field c can only be "0" and "1", and the editing tool sets "0" and "1" as the enumerated content of the field c.

It should be noted that, in addition to the above functional definition, the editing tool may perform functional expansion based on editing of multiple tools and multiple interfaces, for example, curve drawing, bounding box drawing, data transfer, and the like, which are not illustrated here.

In an alternative embodiment, the editing tool may further determine the first data table from the data table displayed in the data table directory window, then determine the first target entry from the plurality of entries included in the first data table, and display the field included in the first target entry and the value corresponding to the field in the entry data window. For example, in the graphical user interface shown in fig. 3, the first data table is a "MZ hit determination table", and the user determines, through a "filter" control in the entry window, that an entry with a selection number of "3010111" is selected as the first target entry from the entries contained in the "MZ hit determination table", and displays a field corresponding to the entry with a number of "3010111" and a value corresponding to the field in the entry data window.

It should be noted that, because the graphical user interface of the editing tool can display the fields of the data table and the values corresponding to the fields, the user does not need to view the data table by opening or closing the data table for multiple times. In addition, the user can edit the data table through the visual window of the editing tool.

In an alternative embodiment, the editing tool may further detect whether an instruction for editing a data table is received, and edit at least one data table in the data table catalog window in case the data table editing instruction is received.

It should be noted that, the data table editing instruction may implement operations such as searching, saving, screening, resetting, heating, reloading, and pulling the data table (including the single table and the batch table).

Optionally, after assigning the key name corresponding to the second target entry to the field to be linked, the editing tool responds to a reset instruction to restore the first data table to an initial data table and/or restore an entry in the first data table to an initial entry, where the initial data table is a data table before updating the first data table, and the initial entry is an entry before updating the entry in the first data table.

It should be noted that, the resetting operation is performed on the data table list, so that the editing tool may cancel the modification of the data table list, so as to return the data table list to the unmodified state. For example, when the user deletes the "FX flyer table" in the data table list through the editing tool, at this time, the identifier corresponding to the data table is not displayed in the data table catalog window of the editing tool, and after the user clicks the "reset" control in the graphical user interface of the editing tool, the identifier corresponding to the data table is continuously displayed in the data table catalog window of the editing tool.

In an alternative embodiment, after assigning the key name corresponding to the second target entry to the field to be linked, the editing tool responds to the reload instruction, reads the third data table, copies the third data table to obtain a copied third data table, and loads the copied third data table to perform the overlay operation on the first data table. The third data table is a data table obtained after updating the first data table stored in the configuration file.

It should be noted that, the reloading operation is performed on the data table, that is, the original data table is copied, and the copied copy is loaded into the editing tool, at this time, the editing tool obtains the modified data table, and the modification of the data table in the editing tool by the user is lost. For example, the user performs multiple modification operations on the data table through the editing tool, but during the modification process, the user finds that an error occurs in one modification step, so that the data table needs to be modified again, at this time, the user can implement reloading of the data table by clicking on the "reload all excels" control in fig. 8, and modify the data table again.

In an alternative embodiment, after assigning the key name corresponding to the second target entry to the field to be linked, the editing tool further responds to a pull instruction to obtain a fourth data table from the version control system, performs a merging operation on the fourth data table and the third data table to obtain a merged data table, and then performs a copying operation on the merged data table to obtain a copied merged data table, and loads the copied merged data table to perform an overlay operation on the first data table. The third data table is a data table obtained after updating the first data table stored in the configuration file.

It should be noted that, the pulling operation is performed on the data table, that is, the data table on the SVN (i.e., the fourth data table) is pulled into the local, and is automatically combined with the data table in the local (i.e., the third data table), and the combined file covers the data table in the local memory. It is readily noted that pulling the data table may result in the loss of the user's modified contents of the data table via the editing tool. For example, other users modify the data table and submit the modified data table to the SVN. When the current user needs to use the modified data table of other users, the current user can realize the pulling of the modified data table by clicking the pull all Excel control in fig. 8.

In an alternative embodiment, after assigning the key name corresponding to the second target entry to the field to be linked, the editing tool further saves the updated first data table, and uploads the updated first data table to the client and the server.

It should be noted that, after modifying the data table, the editing tool stores the modified content in the first data table, and uploads the content in the first data table to the client (e.g., game client) and the server, so as to implement thermal modification of the data table, that is, in the process of updating the data table, the client and the server using the data table can still read the data table and operate normally.

Optionally, the editing tool may further determine a classification identifier of the first data table, and then screen a target packet in which the first data table is located from the plurality of packets according to the classification identifier, and determine the first data table from the target packet.

It should be noted that, in practical applications, a user may need to process multiple data tables at the same time, and in the present application, the user may perform batch processing on the multiple data tables through an editing tool, for example, batch screening grouping according to classification identifiers of the data tables. For example, the data table catalog window in FIG. 8 shows the data tables contained in "skill set" (e.g., "MZ hit determination table", "FX flyer table", etc.) that have the same category identification. For another example, when the user selects the "art group" control in the data table catalog window in fig. 8, all the data tables contained in the "art group" will be presented in the data table catalog window of the editing tool.

Optionally, the editing tool may further determine a target data table from at least one data table, search an entry included in the target data table to obtain an entry to be edited, and edit the entry to be edited to obtain an editing result. For example, in the graphical user interface shown in fig. 8, the "MZ hit determination table" is a target data table, and each entry included in the "MZ hit determination table" is shown in the middle "entry window". Because the items are more, the user cannot easily find the item to be edited from the plurality of items, and at this time, the user can screen the item to be edited through the screening control in the item window. For example, the item numbered as "3010111" is obtained as an item to be edited by screening through a "screening" control, and then, the user selects an operation performed on the field to be edited by right clicking, for example, an "copy item" operation, an "delete item" operation, an "apply item" operation, and the like.

Optionally, the editing tool may further determine a target data table from the at least one data table, then determine a target location in the target data table where the entry to be added is added and a target field type corresponding to a field included in the entry to be added, and add the entry to be added and the field included in the entry to be added to the target data table based on the target location and the target field type. For example, the user may make a right key at a blank position in the "entry window" in fig. 8, then select "add entry" from the pop-up dialog box, and set the target position of the new entry (i.e., the entry to be added) and the information of the target field type, the data content, and the like corresponding to the field included in the entry to be added. After the above information setting is completed, the newly added item can be displayed in the "item window" in fig. 8.

Optionally, the editing tool further determines a target data table from the at least one data table, and in case of detecting the reset instruction, performs a reset operation on a preset field in the target data table, so that the target data table resets the initial state.

It should be noted that, similar to the process of performing the reset operation on the data table list, the process of performing the reset operation on the preset field in the data table may cancel the modification of the preset field by the editing tool, so that the preset field is returned to the unmodified state. For example, when the user deletes the preset field 1 through the editing tool, at this time, the identifier corresponding to the preset field 1 is not displayed in the visual window of the editing tool, and after the user clicks the "reset" control, the identifier corresponding to the preset field 1 is continuously displayed in the graphical user interface of the editing tool.

In an alternative embodiment, fig. 10 shows an interworking editing schematic between multiple tools, where the multiple tools at least include an Excel editor, a version management tool (i.e., SVN), an Excel editing software, a table guiding tool, a client, a server, and so on. As can be seen from FIG. 10, the interworking editing between multiple tools can implement the operations of saving, resetting, heating, reloading, pulling, etc. the data table. Wherein, the data table is stored by storing the modified content in the editing tool into the Sheet of the Excel file; resetting the data table means that the modification in the editing tool is withdrawn and returned to an unmodified state; the heat of the data table refers to uploading the content in the Sheet to the game client and the server, and meanwhile, the modification in the editing tool is saved first; the reloading of the data table means that the modification in Excel is loaded into an editing tool; pulling the data table refers to pulling Excel on the SVN to the local, automatically combining with the local file, and reloading into the editor.

In an alternative embodiment, as known from the graphical user interface of the editing tool shown in fig. 8, the graphical window of the editing tool includes three windows, an Excel table directory window (i.e., a data table directory window), an Excel table entry window (i.e., an entry window), and an Excel table entry data window (i.e., an entry data window), for implementing three levels of functionality. The Excel list window is used for managing all Excel lists and is responsible for single list operation, batch operation, screening and searching and the like so as to solve the pain point of multi-list batch operation and meet the requirement of cross-tool operation; the Excel table entry window is used for managing all entries of the selected Excel table and is responsible for adding, deleting, modifying, screening, searching and the like so as to realize the requirement of quick searching and screening; the Excel table entry data window is used for selecting the display and editing functions of all data of the entries so as to meet the requirements of data editing, limiting, detecting and associating and realize the operation of a relation chain.

It should be noted that, the editing tool in the present application is not used to replace Excel editing software, but is used as a functional extension of Excel editing software to manage Excel files.

From the above, the scheme provided by the application can realize the integration and expansion of the common functions on the general Excel editing software and the customization of the characteristics of the game industry. The scheme provided by the application can also solve the pain points of batch Excel list management and editing, and greatly improves the production efficiency of game development; the pain points of configuration detection, limitation and verification of the single form are solved, and the correctness and accuracy of game configuration are improved; the management problems of multi-end tool chains such as version management tools, excel editing software, game terminals and the like are covered, and cross-tool use is realized; editing data by chain jump across an Excel table relation chain, so that editing efficiency is greatly improved; in popular terms, a tool for editing the Excel in intercommunication is provided, so that the game configuration is edited more efficiently.

According to an embodiment of the present invention, there is further provided an embodiment of a data table updating apparatus, where fig. 11 is a schematic diagram of the data table updating apparatus according to the embodiment of the present invention, and as shown in fig. 11, the apparatus includes: a first determination module 1101, an acquisition module 1103, a second determination module 1105, and an update module 1107.

The first determining module 1101 is configured to determine a first target entry from a plurality of first entries, and determine a field to be linked from a plurality of fields included in the first target entry, where the plurality of first entries are a plurality of entries in a first data table displayed by a graphical user interface; an obtaining module 1103, configured to obtain a plurality of second entries associated with the field to be linked, where the plurality of second entries are a plurality of entries in a second data table displayed by the graphical user interface, and the first data table is different from the second data table; a second determining module 1105 for determining a second target entry from a plurality of second entries; and an updating module 1107, configured to assign a key name corresponding to the second target entry to the field to be linked, and update the first data table.

It should be noted that the first determining module 1101, the acquiring module 1103, the second determining module 1105, and the updating module 1107 correspond to steps S202 to S208 in the above embodiment, and the four modules are the same as examples and application scenarios implemented by the corresponding steps, but are not limited to those disclosed in the above embodiment.

Optionally, the updating device of the data table further includes: and the first display module is used for displaying a plurality of first fields and key names corresponding to the plurality of first fields contained in the first target item in the graphical user interface after the key names corresponding to the second target item are assigned to the to-be-linked fields, wherein the key names corresponding to the to-be-linked fields are the key names corresponding to the second target item.

Optionally, the updating device of the data table further includes: and the first response module is used for responding to the reset instruction after assigning the key name corresponding to the second target entry to the field to be linked, and restoring the first data table to the initial data table and/or restoring the entry in the first data table to the initial entry, wherein the initial data table is the data table before updating the first data table, and the initial entry is the entry before updating the entry in the first data table.

Optionally, the updating device of the data table further includes: the second response module and the first loading module. The second response module is used for responding to the reloading instruction after assigning the key name corresponding to the second target item to the field to be linked, reading a third data table, and performing copy operation on the third data table to obtain a copied third data table, wherein the third data table is obtained after updating the first data table stored in the configuration file; and the first loading module is used for loading the copied third data table so as to carry out covering operation on the first data table.

Optionally, the updating device of the data table further includes: the system comprises a third response module, a merging module, a first copying module and a second loading module. The third response module is used for responding to the pulling instruction after assigning the key name corresponding to the second target item to the field to be linked and acquiring a fourth data table from the version control system; the merging module is used for merging the fourth data table with the third data table to obtain a merged data table, wherein the third data table is a data table obtained after updating the first data table stored in the configuration file; the first copying module is used for copying the merged data table to obtain a copied merged data table; and the second loading module is used for loading the copied merged data table so as to carry out covering operation on the first data table.

Optionally, the updating device of the data table further includes: and the first updating module is used for storing the updated first data table after assigning the key name corresponding to the second target item to the field to be linked, and uploading the updated first data table to the client and the server.

Optionally, the updating device of the data table further includes: the system comprises a reading module, a splitting module and a second display module. The reading module is used for reading the data table file before determining a first target entry from a plurality of first entries, wherein the data table file comprises a plurality of data tables; the splitting module is used for splitting the data table file by taking the worksheet as a unit to obtain a plurality of data tables; and the second display module is used for displaying table identifiers corresponding to the plurality of data tables in the first display area of the graphical user interface.

Optionally, the updating device of the data table further includes: the system comprises a third determining module, a second copying module, a first analyzing module, a third displaying module and a fourth displaying module. The third determining module is used for determining a first data table from table identifiers corresponding to the plurality of data tables after the table identifiers corresponding to the plurality of data tables are displayed in a first display area of the graphical user interface; the second copying module is used for copying the first data table to obtain a copied first data table; the first analysis module is used for analyzing the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries; a third display module for displaying a plurality of first items within a second display area of the graphical user interface; and the fourth display module is used for displaying a plurality of fields and values corresponding to the fields contained in the first target item in a third display area of the graphical user interface.

Optionally, the updating device of the data table further includes: the device comprises a second analysis module, a fourth determination module, a fifth determination module and a conversion module. The second analysis module is used for analyzing the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the first entries, analyzing preset fields at preset positions in the first data table and determining target types corresponding to the preset fields; a fourth determining module, configured to determine an original type corresponding to preset data input to a preset field; a fifth determining module, configured to determine a type conversion function according to preset data; and the conversion module is used for converting the original type into the target type according to the type conversion function.

Optionally, the updating device of the data table further includes: the detection module and the sixth determination module. The detection module is used for detecting whether the data corresponding to the preset field at the preset position in the first data table is empty or not after analyzing the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the first entries; and the sixth determining module is used for determining that the data corresponding to the preset field is preset data when the data corresponding to the preset field is detected to be empty.

Optionally, the updating device of the data table further includes: the system comprises a third analysis module, a first construction module, a seventh determination module, a second construction module and a third construction module. The third analysis module is used for analyzing the copied first data table to obtain a plurality of first fields corresponding to the first data table and numerical values corresponding to the plurality of first fields, analyzing preset fields at preset positions in the first data table and determining field functions corresponding to the preset fields; the first construction module is used for constructing a relation chain between the first data table and the second data table based on a preset field when the field function is a construction function of the relation chain; a seventh determining module, configured to determine, when the field function is a data range defining function, a numerical range corresponding to the preset field based on a field type of the preset field; the second construction module is used for constructing an association relation between a third field and a second target item when the field function is a field association function, wherein the third field is a field associated with the second target item in the plurality of first fields; and the third construction module is used for constructing enumeration contents corresponding to the preset field when the field function is an enumeration function.

According to another aspect of the embodiments of the present application, there is also provided a storage medium having a computer program stored therein, wherein the computer program is configured to perform the above-described data table updating method at runtime.

According to another aspect of an embodiment of the present application, there is also provided an electronic device including one or more processors; and a storage device for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement a method for running the programs, wherein the programs are configured to perform the data table updating method described above when run.

The foregoing embodiment numbers of the present application are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.

In the foregoing embodiments of the present application, the descriptions of the embodiments are emphasized, and for a portion of this disclosure that is not described in detail in this embodiment, reference is made to the related descriptions of other embodiments.

In the several embodiments provided in the present application, it should be understood that the disclosed technology may be implemented in other manners. The above-described embodiments of the apparatus are merely exemplary, and the division of the units, for example, may be a logic function division, and may be implemented in another manner, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interfaces, units or modules, or may be in electrical or other forms.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.

The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.

The foregoing is merely a preferred embodiment of the present invention and it should be noted that modifications and adaptations to those skilled in the art may be made without departing from the principles of the present invention, which are intended to be comprehended within the scope of the present invention.

Claims

1. A method of updating a data table, comprising:

determining a first target item from a plurality of first items, and determining a field to be linked from a plurality of fields contained in the first target item, wherein the plurality of first items are a plurality of items in a first data table displayed by a graphical user interface;

obtaining a plurality of second entries associated with the fields to be linked, wherein the plurality of second entries are a plurality of entries in a second data table displayed by the graphical user interface, and the first data table is different from the second data table;

determining a second target entry from the plurality of second entries;

assigning a key name corresponding to the second target item to the field to be linked, and updating the first data table;

wherein prior to determining the first target entry from the plurality of first entries, the method further comprises: reading a data table file, wherein the data table file comprises a plurality of data tables; splitting the data table file by taking a worksheet as a unit to obtain a plurality of data tables; displaying table identifiers corresponding to the plurality of data tables in a first display area of the graphical user interface;

Wherein after the table identifiers corresponding to the plurality of data tables are displayed in the first display area of the graphical user interface, the method further comprises: determining the first data table from table identifiers corresponding to the plurality of data tables; copying the first data table to obtain a copied first data table; analyzing the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries; displaying the plurality of first entries within a second display area of the graphical user interface; and displaying a plurality of fields contained in the first target item and values corresponding to the plurality of fields in a third display area of the graphical user interface.

2. The method of claim 1, wherein after assigning the key name corresponding to the second target entry to the field to be linked, the method further comprises:

and displaying a plurality of first fields contained in the first target item and key names corresponding to the plurality of first fields in the graphical user interface, wherein the key name corresponding to the field to be linked is the key name corresponding to the second target item.

3. The method of claim 1, wherein after assigning the key name corresponding to the second target entry to the field to be linked, the method further comprises:

and responding to a reset instruction, recovering the first data table to an initial data table and/or recovering an entry in the first data table to an initial entry, wherein the initial data table is a data table before updating the first data table, and the initial entry is an entry before updating the entry in the first data table.

4. The method of claim 1, wherein after assigning the key name corresponding to the second target entry to the field to be linked, the method further comprises:

responding to a reload instruction, reading a third data table, and performing copy operation on the third data table to obtain a copied third data table, wherein the third data table is obtained after updating the first data table stored in a configuration file;

and loading the copied third data table to perform covering operation on the first data table.

5. The method of claim 1, wherein after assigning the key name corresponding to the second target entry to the field to be linked, the method further comprises:

Responding to the pulling instruction, and acquiring a fourth data table from the version control system;

combining the fourth data table with a third data table to obtain a combined data table, wherein the third data table is a data table obtained after updating the first data table stored in the configuration file;

copying the merged data table to obtain a copied merged data table;

and loading the copied merging data table to perform covering operation on the first data table.

6. The method of claim 1, wherein after assigning the key name corresponding to the second target entry to the field to be linked, the method further comprises:

and storing the updated first data table, and uploading the updated first data table to the client and the server.

7. The method of claim 1, wherein after parsing the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries, the method further comprises:

analyzing a preset field at a preset position in the first data table, and determining a target type corresponding to the preset field;

Determining an original type corresponding to preset data input to the preset field;

determining a type conversion function according to the preset data;

and converting the original type into the target type according to the type conversion function.

8. The method of claim 1, wherein after parsing the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries, the method further comprises:

detecting whether data corresponding to a preset field at a preset position in the first data table is empty or not;

and when the data corresponding to the preset field is detected to be empty, determining that the data corresponding to the preset field is preset data.

9. The method of claim 1, wherein after parsing the copied first data table to obtain a plurality of first fields corresponding to the first data table and values corresponding to the plurality of first fields, the method further comprises:

analyzing a preset field at a preset position in the first data table, and determining a field function corresponding to the preset field;

When the field function is a construction function of a relation chain, constructing the relation chain between the first data table and the second data table based on the preset field;

when the field function defines a function for a data range, determining a numerical range corresponding to the preset field based on the field type of the preset field;

when the field function is a field association function, constructing an association relationship between a third field and the second target entry, wherein the third field is a field associated with the second target entry in the plurality of first fields;

and when the field function is an enumeration function, building enumeration content corresponding to the preset field.

10. An apparatus for updating a data table, comprising:

the first determining module is used for determining a first target item from a plurality of first items and determining a field to be linked from a plurality of fields contained in the first target item, wherein the plurality of first items are a plurality of items in a first data table displayed by a graphical user interface;

the acquisition module is used for acquiring a plurality of second entries associated with the field to be linked, wherein the plurality of second entries are a plurality of entries in a second data table displayed by the graphical user interface, and the first data table is different from the second data table;

A second determining module for determining a second target entry from the plurality of second entries;

the updating module is used for assigning the key name corresponding to the second target item to the field to be linked and updating the first data table;

wherein the apparatus further comprises: the reading module is used for reading a data table file, wherein the data table file comprises a plurality of data tables; the splitting module is used for splitting the data table file by taking the worksheet as a unit to obtain the plurality of data tables; the display module is used for displaying table identifiers corresponding to the plurality of data tables in a first display area of the graphical user interface;

wherein the apparatus further comprises: a third determining module, configured to determine the first data table from table identifiers corresponding to the plurality of data tables; the copying module is used for carrying out copying operation on the first data table to obtain a copied first data table; the analysis module is used for analyzing the copied first data table to obtain a plurality of first entries corresponding to the first data table and data corresponding to the plurality of first entries; the display module is further configured to display the plurality of first entries within a second display area of the graphical user interface; the display module is further configured to display, in a third display area of the graphical user interface, a plurality of fields included in the first target entry and values corresponding to the plurality of fields.

11. A storage medium, characterized in that the storage medium has stored therein a computer program, wherein the computer program is arranged to perform the method of updating a data table as claimed in any of the claims 1 to 9 at run-time.

12. An electronic device, the electronic device comprising one or more processors; storage means for storing one or more programs which when executed by the one or more processors cause the one or more processors to implement a method for running a program, wherein the program is arranged to perform the method of updating a data table as claimed in any one of claims 1 to 9 when run.