Table data processing method and apparatus, and device and storage medium

Abstract

Provided in the embodiments of the present disclosure are a table data processing method and apparatus, and a device and a storage medium. The method comprises: in response to a trigger operation on a field control in a table page, displaying a field interface; in response to a field component and a first field that are selected on the field interface, determining at least one second field, wherein the first field is a field that has been created in the table page; and displaying the at least one second field on the table page, and generating second data in a data column corresponding to the second field, wherein the second data is data acquired on the basis of first data in a data column corresponding to the first field and by using the field component. Therefore, the usage efficiency of a user is improved.

Description

Tabular data processing methods, apparatus, equipment and storage media

[0001] Cross-references to related applications

[0002] This application claims priority to Chinese Patent Application No. 202410796848.3, filed on June 19, 2024, entitled "Method, Apparatus, Device and Storage Medium for Processing Tabular Data", the entire contents of which are incorporated herein by reference. Technical Field

[0003] The disclosed embodiments relate to the technical field of computers, and more particularly to a method, apparatus, device, and storage medium for processing tabular data. Background Technology

[0004] Users can use tables to store and manage data. A table can be an online database in tabular form to enable data storage, analysis, and visualization.

[0005] Currently, when updating data in a table, users need to manually input the data into the relevant application for processing, and then manually input the processing results from the application into the corresponding positions in the table, until all data has been processed and the processing results are manually input into the corresponding positions in the table to complete the table update and maintenance.

[0006] In practical applications, users need to manually process information when maintaining tables, which is a large workload and results in low user efficiency. Summary of the Invention

[0007] This disclosure provides a method, apparatus, device, and storage medium for processing tabular data, in order to solve the problem that users need to manually process information when using tables, resulting in a large workload and low user efficiency.

[0008] In a first aspect, embodiments of this disclosure provide a method for processing tabular data, including:

[0009] In response to a triggering action on a field control in the table page, display the field interface;

[0010] In response to the field component and the first field selected in the field interface, at least one second field is determined, wherein the first field is a field that has been created in the table page;

[0011] The table page displays at least one second field, and generates second data in the data column corresponding to the second field. The second data is data obtained by using the field component based on the first data in the data column corresponding to the first field.

[0012] Secondly, embodiments of this disclosure provide a tabular data processing apparatus, comprising:

[0013] The display module is used to display the field interface in response to triggering operations on field controls in the table page;

[0014] A determination module is configured to determine at least one second field in response to a field component and a first field selected in the field interface, wherein the first field is a field that has been created in the table page.

[0015] The processing module is used to display at least one second field on the table page and generate second data in the data column corresponding to the second field. The second data is data obtained by using the field component based on the first data in the data column corresponding to the first field.

[0016] Thirdly, embodiments of this disclosure provide an electronic device, including: a processor and a memory;

[0017] The memory stores computer-executed instructions;

[0018] The processor executes computer execution instructions stored in the memory, causing the at least one processor to perform the tabular data processing method as described in the first aspect and various possible designs of the first aspect.

[0019] Fourthly, embodiments of this disclosure provide a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, implement the tabular data processing method described in the first aspect and various possible designs of the first aspect.

[0020] Fifthly, embodiments of this disclosure provide a computer program product, including a computer program that, when executed by a processor, implements the tabular data processing method described in the first aspect and various possible designs of the first aspect.

[0021] The table data processing method, apparatus, device, and storage medium provided in this embodiment display a field interface in response to a trigger operation on a field control in a table page. In response to the selection of a field component and a first field in the field interface, at least one second field is determined. The first field is a field already created in the table page. At least one second field is displayed on the table page, and second data is generated in the data column corresponding to the second field. The second data is data obtained using the field component based on the first data in the data column corresponding to the first field. In this way, users do not need to manually input data from the table into a preset application for processing; they can directly process and generate data corresponding to at least one second field in the field component based on the data in the first field, thus improving user efficiency. Attached Figure Description

[0022] To more clearly illustrate the technical solutions in the embodiments of this disclosure or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this disclosure. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0023] Figure 1 is a schematic diagram of an application scenario provided by an embodiment of this disclosure;

[0024] Figure 2 is a schematic flowchart of a tabular data processing method provided in an embodiment of this disclosure;

[0025] Figure 3 is a schematic diagram of a table page provided in an embodiment of this disclosure;

[0026] Figure 4 is a schematic diagram of a field interface provided in an embodiment of this disclosure;

[0027] Figure 5 is a schematic diagram of another tabular data processing method provided in an embodiment of this disclosure;

[0028] Figure 6 is a schematic diagram of a component selection control provided in an embodiment of this disclosure;

[0029] Figure 7 is a schematic diagram of a field selection control provided in an embodiment of this disclosure;

[0030] Figure 8 is a schematic diagram of another field interface provided in an embodiment of this disclosure;

[0031] Figure 9 is a schematic diagram of another tabular data processing method provided in an embodiment of this disclosure;

[0032] Figure 10 is a schematic diagram of another table page provided in an embodiment of this disclosure;

[0033] Figure 11 is a schematic diagram of yet another form page provided in an embodiment of this disclosure;

[0034] Figure 12 is a schematic diagram of the structure of a tabular data processing device provided in an embodiment of this disclosure;

[0035] Figure 13 is a schematic diagram of the hardware structure of the information display device provided in an embodiment of this disclosure. Detailed Implementation

[0036] To make the objectives, technical solutions, and advantages of the embodiments of this disclosure clearer, the technical solutions of the embodiments of this disclosure will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this disclosure, and not all embodiments. Based on the embodiments of this disclosure, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this disclosure.

[0037] The following describes application scenarios of the embodiments of this disclosure with reference to Figure 1.

[0038] Figure 1 is a schematic diagram of an application scenario provided by an embodiment of this disclosure. Please refer to Figure 1, which includes tables and fields.

[0039] The table can be an online database in tabular form. Tables can be used to store and manage data. Table pages can be used to display the data in the table to users.

[0040] Fields can be "columns" of a table. Different field types can be set within a table to ensure standardized formatting of the content entered in each column. Field types can include general types, business types, and advanced types. General types can include text, attachment, and formula types; business types can include process, auto-numbering, and progress types; advanced types can include bidirectional association types and unidirectional association types.

[0041] The column containing a field can store the data corresponding to that field. Each data entry is a row of data entered within the column containing the field. At least one data entry must have the same data type as the field containing it. For example, a field with the type "attachment" will contain data for uploaded file types.

[0042] In related technologies, when users update data in a table, they need to manually input the data into a relevant application for processing, and then manually input the processing results from the application into the corresponding positions in the table, until all data has been processed and the processing results are manually input into the corresponding positions in the table to complete the table update and maintenance.

[0043] In practical applications, users need to manually process information when maintaining tables, which is a large workload and results in low user efficiency.

[0044] To address the technical problems in related technologies, this disclosure provides a method for processing tabular data. In response to a trigger operation on a field control in a table page, a field interface is displayed. In response to the selection of a field component and a first field in the field interface, at least one second field is determined. The first field is a field already created in the table page. At least one second field is displayed on the table page, and second data is generated in the data column corresponding to the second field. The second data is data obtained using the field component based on the first data in the data column corresponding to the first field. This eliminates the need for users to manually input data from the table into a preset application for processing. Instead, the data is directly processed in the field component based on the data in the first field, generating data corresponding to at least one second field, thus improving user efficiency.

[0045] The technical solutions of this disclosure and how they solve the aforementioned technical problems will be described in detail below with specific embodiments. These specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. The embodiments of this disclosure will now be described with reference to the accompanying drawings.

[0046] Referring to Figure 2, Figure 2 is a schematic flowchart of a tabular data processing method provided in an embodiment of this disclosure. The executing entity of this embodiment can be a terminal device or a tabular data processing device installed in the terminal device. The tabular data processing device can be implemented in software, or it can be implemented using a combination of software and hardware; this embodiment does not limit this implementation. The tabular data processing method includes:

[0047] S201. In response to a trigger operation on the field control in the table page, display the field interface.

[0048] The table page includes field controls.

[0049] Field controls can be used to add new fields. Clicking a field control will generate a field interface, which can be used to configure the new field.

[0050] The following section, with reference to Figure 3, explains the table page.

[0051] Figure 3 is a schematic diagram of a table page provided in an embodiment of this disclosure. Referring to Figure 3, it includes: field controls.

[0052] The field control can be represented by the icon "+" or other icons, and there is no limitation here.

[0053] The triggering action can be an interaction between the user and the field control through mouse clicks, screen touch, or other input devices.

[0054] The field interface can be used to configure the specific settings of newly added fields.

[0055] The field interface can include component selection controls, field selection controls, etc.

[0056] The following example, with reference to Figure 4, illustrates the field interface.

[0057] Figure 4 is a schematic diagram of a field interface provided in an embodiment of this disclosure. Please refer to Figure 4, which includes: a field interface.

[0058] The field interface may include a component selection control, a field selection control, a cancel control, and an confirm control.

[0059] The component selection control can be used to select a field component from multiple preset components.

[0060] The field selection control can be used to determine the first field to be processed.

[0061] The cancel control can be used to end the field interface.

[0062] The "determine control" function can be used to determine the user's selection of each control.

[0063] Users can determine the configuration information corresponding to a field based on the editing operations of each control in the field interface, so as to generate the field and realize the corresponding function.

[0064] Users can trigger operations on field controls in the table page. In response to these trigger operations, the corresponding code for the field control is executed, and the field interface is displayed on the table page.

[0065] Optionally, before displaying the field interface in response to a triggering operation on the field controls in the table page, the table page may be displayed in the following manner: in response to a user's initiation operation on the table, the table page is displayed.

[0066] Optionally, before displaying the field interface in response to a triggering operation on the field control in the table page, the table page may be displayed in the following manner: displaying a table list, which includes at least one table, and displaying the table page corresponding to the selected table in response to a user's selection operation on any table in the table list.

[0067] It should be noted that the terminal device can display the table page in any feasible way, and this embodiment of the disclosure does not limit this.

[0068] S202, in response to the field component and the first field selected in the field interface, determine at least one second field.

[0069] The field component is selected from several preset components. These preset components can perform different functions. For example, they can query company information or recognize invoice information, etc.

[0070] The field component can be used to generate at least one data corresponding to a second field in a preset application corresponding to the field component, based on the data in the first field.

[0071] Optionally, the field component is configured with Application Programming Interface (API) data (hereinafter referred to as API data), and the field component interacts with the preset application through the pre-configured interface based on the API data.

[0072] The first field is a field that has already been created on the table page.

[0073] The first field can be the field corresponding to the data on which the processing is based.

[0074] The second field can be a field generated by a field component. At least one second field can be used to record at least one piece of related data obtained through processing by a field component.

[0075] For example, suppose the field component is used to query company information. The first field can be the company name, and at least one second field can be the legal representative, company status, registered address, etc.

[0076] In response to the field component and the first field selected in the field interface, the selection controls corresponding to multiple candidate fields can be displayed in the field interface, and in response to at least one selection operation on the selection controls corresponding to the multiple candidate fields, at least one second field can be determined.

[0077] Optionally, the field interface includes a component selection control and a field selection control, and at least one second field can be determined in response to the field component and the first field selected in the field interface in the following ways: in response to an operation on the component selection control to select the field component; in response to an operation on the field selection control to select the first field; and based on the field component and the first field, at least one second field is determined.

[0078] S203. Display at least one second field on the table page and generate second data in the data column corresponding to the second field.

[0079] The second data is obtained using the field component based on the first data in the data column corresponding to the first field.

[0080] At least one second field can be displayed on the table page. Based on the first data in the data column corresponding to the first field, relevant data can be obtained through the field component. Based on the relevant data, the corresponding second data can be generated in the data column corresponding to the second field.

[0081] For example, suppose the field component is used to query company information. The first field can be the company name, and at least one second field can be the legal representative, company status, registered address, etc.

[0082] For cases where the second field is the legal representative field, the second data corresponding to the legal representative can be obtained from the field component based on the company name in the data column corresponding to the first field, and then the second data can be generated in the data column corresponding to the legal representative field.

[0083] This disclosure provides a method for processing tabular data. In response to a trigger operation on a field control in a table page, a field interface is displayed. In response to a field component and a first field selected in the field interface, at least one second field is determined. The first field is a field already created in the table page. At least one second field is displayed on the table page, and second data is generated in the data column corresponding to the second field. The second data is data obtained using the field component based on the first data in the data column corresponding to the first field. This eliminates the need for users to manually input data from the table into a preset application for processing. Instead, the data is directly processed in the field component based on the data in the first field, generating data corresponding to at least one second field, thus improving user efficiency.

[0084] Based on the embodiment shown in Figure 2, the process of determining at least one second field in response to the field component and the first field selected in the field interface (S202) will be described in detail below with reference to Figure 5.

[0085] Figure 5 is a schematic diagram of another tabular data processing method provided in an embodiment of this disclosure. Referring to Figure 5, the method flow may include:

[0086] S501, In response to an input operation on the component selection control, select the field component.

[0087] The component selection control can be used to display multiple preset components to the user, allowing the user to select one of the preset components as a field component.

[0088] The input operation can be that the user selects one of a number of preset components, or the user enters a component name in the component selection control, and the component selection control matches the component name from the multiple preset components and selects the component that matches the entered component name.

[0089] It can respond to user input on the component selection control, select the field component corresponding to the input operation from multiple preset components through the component selection control, and run the background code corresponding to the field component.

[0090] The component selection control will be illustrated below with reference to Figure 6.

[0091] Figure 6 is a schematic diagram of a component selection control provided in an embodiment of this disclosure. Please refer to Figure 6, which includes a component selection control.

[0092] Please refer to interface 601. Interface 601 may include a component selection control and a control title corresponding to the component selection control. Users can click on the component selection control to display interface 602 on the screen.

[0093] Please refer to interface 602. The component selection control in interface 602 can display multiple preset components to the user, and the user can select a field component from the multiple preset components.

[0094] Please refer to interface 603. In interface 603, in response to the user's click operation on the field component, the corresponding backend code of the field component can be run to display the field selection control to the user.

[0095] Optionally, in response to the user's input on the component selection control, the selected component is identified as a field component, and the corresponding backend code of the field component is executed to display multiple configuration controls corresponding to the field component. The multiple configuration controls may include the field selection control.

[0096] S502, Determine the multiple fields corresponding to the field component.

[0097] Multiple fields can be the fields corresponding to the data processed in the preset application corresponding to the field component.

[0098] Multiple fields can be fields that exist on the table page.

[0099] For example, suppose the field component is used to query company information, and multiple fields can be legal representative, registered address, company name, etc.

[0100] You can run the code of the field component to determine the multiple fields corresponding to the field component.

[0101] S503. In response to a click operation on the field selection control, display the field list component.

[0102] A field selection control can be used to display multiple fields to a user, allowing the user to select one as the first field. A field list component includes multiple fields, any of which can be used as the first field.

[0103] The following example, with reference to Figure 7, illustrates the field selection control.

[0104] Figure 7 is a schematic diagram of a field selection control provided in an embodiment of this disclosure. Please refer to Figure 7, which includes a field selection control.

[0105] Please refer to interface 701. Interface 701 may include a field selection control, a control title corresponding to the field selection control, and a confirmation control. Users can click on the field selection control to display interface 702 on the screen.

[0106] Please refer to interface 702. The field selection control in interface 702 can display a field list component to the user, and the user can select any field from the field list component as the first field.

[0107] S504. In response to the selection operation of the field input in the field list component, the selected field is determined as the first field.

[0108] For example, assuming the field component is used to query company information, the fields in the field list component can be company name, legal representative, registered address, unified social credit code, etc.

[0109] If a user selects the field corresponding to the company name in the field list component, in response to the selection operation of the field corresponding to the company name in the field list component, the field corresponding to the company name will be determined as the first field.

[0110] S505. Determine the multiple fields corresponding to the field component.

[0111] The execution process of S505 can be found in the execution process of S502, and will not be repeated here.

[0112] S506. Determine at least one second field in at least one selection field.

[0113] Among them, at least one selection field is a field other than the first field among multiple fields.

[0114] It is possible to determine a first field, remove the first field from multiple fields to obtain at least one selected field, and determine at least one second field from the at least one selected field.

[0115] For example, suppose the field component is used to query company information. The first field is the company name, and at least one second field can be the data corresponding to the legal representative, registered address, and unified social credit code obtained through the field component query.

[0116] Assuming the first field is the unified social credit code, at least one second field can be the data corresponding to the legal representative, registered address, and company name obtained through field component processing.

[0117] Optionally, at least one second field can be determined in at least one selection field by displaying at least one selection field and a checkbox corresponding to each selection field in the field interface; in response to an operation of inputting to the checkbox corresponding to the selection field, the selected selection field is determined as at least one second field.

[0118] The process of determining at least one second field will be illustrated below with reference to Figure 8.

[0119] Figure 8 is a schematic diagram of another field interface provided in an embodiment of this disclosure. Referring to Figure 8, the field interface may include a component selection control, a field selection control, display of at least one selection field, and check boxes corresponding to each selection field.

[0120] Assuming the field component is a business information query component, the field selection control can be used to select the first field.

[0121] Assuming the first field is the company name, at least one selectable field can include the legal representative, registered address, unified social credit code, etc.

[0122] The field interface displays at least one selection field and a checkbox corresponding to each selection field, allowing the user to select at least one selection field and define the selected selection field as at least one second field.

[0123] The implementation details of each step in this embodiment can be found in the description of the corresponding steps or operations in the above method embodiments; repeated content will not be repeated.

[0124] This disclosure provides a method for processing tabular data. In response to an input operation on a component selection control, a field component is selected, multiple fields corresponding to the field component are determined, a field list component is displayed in response to a click operation on the field selection control, and a field selection operation is performed on a field in the field list component. The selected field is designated as a first field, multiple fields corresponding to the field component are determined, and at least one second field is determined from at least one selected field. This eliminates the need for users to manually input data from the table into a preset application for processing. Instead, data corresponding to at least one second field is directly generated within the field component based on the data in the first field, improving user efficiency.

[0125] In one embodiment of this disclosure, based on the embodiment shown in FIG2, the process of generating second data in the data column corresponding to the second field (S203) will be described in detail below with reference to FIG9.

[0126] Referring to Figure 9, which is a schematic diagram of another tabular data processing method provided in an embodiment of this disclosure, the tabular data processing method includes:

[0127] S901. Retrieve the first data in the data column corresponding to the first field.

[0128] The first data can be data located in any row of the data column containing the first field.

[0129] You can determine the data column corresponding to the first field and retrieve the first data in that data column.

[0130] S902. Determine the preset application corresponding to the field component.

[0131] Pre-configured applications can connect to field components through pre-configured interfaces.

[0132] Field components can access and request preset applications for processing through pre-configured interfaces.

[0133] It can retrieve API data from field components and determine the preset application corresponding to the field component based on the API data.

[0134] S903. Based on the first data and the preset application, obtain the second data corresponding to each second field.

[0135] The second data can be the data corresponding to the first field obtained through a preset application query.

[0136] The field component can be used to perform identity authentication with the preset application. After successful identity authentication, the first data is input into the preset application through the field component, and the second data corresponding to each second field is obtained.

[0137] S904. Display the second data corresponding to each second field on the table page.

[0138] It can determine the row position corresponding to each first data point, and display the second data corresponding to each second field based on the column position and row position of each second field.

[0139] Optionally, for any second field, the second data corresponding to the second field can be displayed on the table page in the following way: determine the target row where the first data is located and the target column where the second field is located; determine the target display position based on the target row and target column; and display the second data in the target display position.

[0140] The target display position is located in the target row and target column.

[0141] The implementation details of each step in this embodiment can be found in the description of the corresponding steps or operations in the above method embodiments; repeated content will not be repeated.

[0142] This disclosure provides a method for processing tabular data. By obtaining first data from a data column corresponding to a first field, determining a preset application corresponding to a field component, and obtaining second data corresponding to each second field based on the first data and the preset application, the method displays the second data corresponding to each second field on the table page. This eliminates the need for users to manually input data from the table into the preset application for processing. Instead, the data is directly processed within the field component based on the data in the first field, generating at least one set of data corresponding to a second field, thus improving user efficiency.

[0143] The following example, with reference to Figure 10, illustrates the process of processing tabular data.

[0144] Figure 10 is a schematic diagram of another table page provided in an embodiment of this disclosure. Assume the first field is the company name, the second field is the legal representative, registered address, and unified social credit code, and the field component is an enterprise information query component. Please refer to Figure 10, which includes interface 1001 and interface 1002.

[0145] In interface 1001, in response to a user clicking a field control, a field page is displayed. The field page includes component selection controls, field selection controls, etc. The field component is a company information query component, with the company name as the first field. At least one selectable field can include legal representative, registered address, unified social credit code, etc. The field page displays at least one selectable field and its corresponding checkboxes. Assuming the user selects the checkboxes corresponding to legal representative, registered address, and unified social credit code, these fields are designated as the second field. Clicking the "OK" control completes the field configuration.

[0146] In interface 1002, assuming the user enters company name A in the first row of the column containing the first field, the user can query the second data corresponding to each second field (legal representative, registered address, unified social credit code) in the preset application based on company name A, and enter the corresponding second data in the first row of the column containing each second field on the table page.

[0147] Below, with reference to Figure 11, we will provide an example to illustrate the process of processing tabular data.

[0148] Figure 11 is a schematic diagram of another form page provided in an embodiment of this disclosure. Assume the first field is an attachment field, used to store invoice images, and the field component is an invoice recognition component. Please refer to Figure 11, which includes interface 1101 and interface 1102.

[0149] In interface 1101, the field component is an invoice recognition component. The attachment field is designated as the first field, and it can be used by the user to upload invoice images. At least one selectable field can include invoice header, invoice date, total tax amount, etc. The field interface displays at least one selectable field and its corresponding checkboxes. Assuming the user selects the checkboxes corresponding to invoice header and total tax amount respectively, the fields corresponding to invoice header and total tax amount are designated as the second field. Clicking the "OK" control completes the field configuration.

[0150] In interface 1102, assuming the user uploaded an invoice image in the first row of the column containing the first field, the user can query the second data corresponding to each second field (invoice title, invoice number, invoice date, total tax amount) in the preset application based on the invoice image, and enter the corresponding second data in the first row of the column containing each second field in the table page.

[0151] Figure 12 is a schematic diagram of a tabular data processing device provided in an embodiment of this disclosure. Referring to Figure 12, the tabular data processing device 1200 includes a display module 1201, a determination module 1202, and a processing module 1203, wherein:

[0152] Display module 1201 is used to display the field interface in response to the trigger operation of the field control in the table page;

[0153] The determination module 1202 is configured to determine at least one second field in response to the field component and the first field selected in the field interface, wherein the first field is a field that has been created in the table page;

[0154] The processing module 1203 is used to display the at least one second field on the table page and generate second data in the data column corresponding to the second field. The second data is data obtained by using the field component based on the first data in the data column corresponding to the first field.

[0155] In one embodiment of this disclosure, the field component is configured with application programming interface (API) data, and the field component interacts with a preset application through a pre-configured interface based on the API data.

[0156] In one embodiment of this disclosure, the field interface includes a component selection control and a field selection control; the determining module 1202 is specifically used for:

[0157] In response to an input operation to the component selection control, the field component is selected;

[0158] In response to an input operation on the field selection control, the first field is selected;

[0159] The at least one second field is determined based on the field component and the first field.

[0160] In one embodiment of this disclosure, the determining module 1202 is specifically used for:

[0161] Determine the multiple fields corresponding to the field component;

[0162] In response to a click operation on the field selection control, a field list component is displayed, the field list component including the plurality of fields;

[0163] In response to a selection operation of a field input in the field list component, the selected field is determined as the first field.

[0164] In one embodiment of this disclosure, the determining module 1202 is specifically used for:

[0165] Determine the multiple fields corresponding to the field component;

[0166] The at least one second field is determined from the at least one selection field, wherein the at least one selection field is any other field among the plurality of fields besides the first field.

[0167] In one embodiment of this disclosure, the determining module 1202 is specifically used for:

[0168] The field interface displays at least one selection field and the checkboxes corresponding to each selection field;

[0169] In response to an operation inputting into the checkbox corresponding to the selected field, the selected field is determined as the at least one second field.

[0170] In one embodiment of this disclosure, the processing module 1203 is used to:

[0171] Retrieve the first data in the data column corresponding to the first field;

[0172] Determine the preset application corresponding to the field component;

[0173] Based on the first data and the preset application, obtain the second data corresponding to each second field;

[0174] The second data corresponding to each second field is displayed on the table page.

[0175] In one embodiment of this disclosure, for any one of the second fields; the processing module 1203 is specifically used for:

[0176] Determine the target row containing the first data and the target column containing the second field;

[0177] The target display position is determined based on the target row and the target column, and the target display position is located in the target row and the target column;

[0178] The second data is displayed in the target display position.

[0179] The device provided in this embodiment can be used to execute the technical solutions of the above method embodiments. Its implementation principle and technical effect are similar, and will not be described again here.

[0180] To implement the above embodiments, this disclosure also provides an electronic device.

[0181] Referring to Figure 13, which is a schematic diagram of the hardware structure of an information display device provided in an embodiment of this disclosure, the electronic device 1300 can be a terminal device or a server. The terminal device can include, but is not limited to, mobile terminals such as mobile phones, laptops, digital radio receivers, personal digital assistants (PDAs), portable Android devices (PADs), portable media players (PMPs), and in-vehicle terminals (e.g., in-vehicle navigation terminals), as well as fixed terminals such as digital TVs and desktop computers. The electronic device shown in Figure 13 is merely an example and should not be construed as limiting the functionality and scope of use of the embodiments of this disclosure.

[0182] As shown in Figure 13, the electronic device 1300 may include a processing unit (e.g., a central processing unit, a graphics processing unit, etc.) 1301, which can perform various appropriate actions and processes according to a program stored in read-only memory (ROM) 1302 or a program loaded from storage device 1308 into random access memory (RAM) 1303. The RAM 1303 also stores various programs and data required for the operation of the electronic device 1300. The processing unit 1301, ROM 1302, and RAM 1303 are interconnected via a bus 1304. An input / output (I / O) interface 1305 is also connected to the bus 1304.

[0183] Typically, the following devices can be connected to I / O interface 1305: input devices 1306 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 1307 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 1308 including, for example, magnetic tapes, hard disks, etc.; and communication devices 1309. Communication device 1309 allows electronic device 1300 to communicate wirelessly or wiredly with other devices to exchange data. Although Figure 13 shows electronic device 1300 with various devices, it should be understood that it is not required to implement or possess all of the devices shown. More or fewer devices may be implemented or possessed alternatively.

[0184] In particular, according to embodiments of this disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this disclosure include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via communication device 1309, or installed from storage device 1308, or installed from ROM 1302. When the computer program is executed by processing device 1301, it performs the functions defined in the methods of embodiments of this disclosure.

[0185] It should be noted that the computer-readable medium described in this disclosure can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example,—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this disclosure, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in connection with an instruction execution system, apparatus, or device. In this disclosure, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium can be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wires, optical fibers, RF (radio frequency), etc., or any suitable combination thereof.

[0186] The aforementioned computer-readable medium may be included in the aforementioned electronic device; or it may exist independently and not assembled into the electronic device.

[0187] The aforementioned computer-readable medium carries one or more programs, which, when executed by the electronic device, cause the electronic device to perform the methods shown in the above embodiments.

[0188] Computer program code for performing the operations of this disclosure can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, and conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a Local Area Network (LAN) or a Wide Area Network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0189] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0190] The units described in the embodiments of this disclosure can be implemented in software or in hardware. The name of a unit does not necessarily limit the unit itself; for example, the first acquisition unit can also be described as "a unit that acquires at least two Internet Protocol addresses".

[0191] The functions described above in this document can be performed, at least in part, by one or more hardware logic components. For example, exemplary types of hardware logic components that can be used, without limitation, include: Field Programmable Gate Arrays (FPGAs), Application-Specific Integrated Circuits (ASICs), Application Standard Products (ASSPs), System-on-Chip (SoCs), Complex Programmable Logic Devices (CPLDs), and so on.

[0192] In the context of this disclosure, a machine-readable medium can be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, apparatus, or device. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can be, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0193] In a first aspect, according to one or more embodiments of this disclosure, a tabular data processing method is provided, comprising:

[0194] In response to a triggering action on a field control in the table page, display the field interface;

[0195] In response to the field component and the first field selected in the field interface, at least one second field is determined, wherein the first field is a field that has been created in the table page;

[0196] The table page displays at least one second field, and generates second data in the data column corresponding to the second field. The second data is data obtained by using the field component based on the first data in the data column corresponding to the first field.

[0197] In one embodiment of this disclosure, the field component is configured with application programming interface (API) data, and the field component interacts with a preset application through a pre-configured interface based on the API data.

[0198] In one embodiment of this disclosure, the field interface includes a component selection control and a field selection control; in response to a field component and a first field selected in the field interface, determining at least one second field includes:

[0199] In response to an input operation to the component selection control, the field component is selected;

[0200] In response to an input operation on the field selection control, the first field is selected;

[0201] The at least one second field is determined based on the field component and the first field.

[0202] In one embodiment of this disclosure, in response to an input operation to the field selection control to select the first field, the method includes:

[0203] Determine the multiple fields corresponding to the field component;

[0204] In response to a click operation on the field selection control, a field list component is displayed, the field list component including the plurality of fields;

[0205] In response to a selection operation of a field input in the field list component, the selected field is determined as the first field.

[0206] In one embodiment of this disclosure, determining the at least one second field based on the field component and the first field includes:

[0207] Determine the multiple fields corresponding to the field component;

[0208] The at least one second field is determined from the at least one selection field, wherein the at least one selection field is another field among the plurality of fields besides the first field.

[0209] In one embodiment of this disclosure, determining the at least one second field from the at least one selection field includes:

[0210] The field interface displays at least one selection field and the checkboxes corresponding to each selection field;

[0211] In response to an operation inputting into the checkbox corresponding to the selected field, the selected field is determined as the at least one second field.

[0212] In one embodiment of this disclosure, generating second data in the data column corresponding to the second field includes:

[0213] Retrieve the first data in the data column corresponding to the first field;

[0214] Determine the preset application corresponding to the field component;

[0215] Based on the first data and the preset application, obtain the second data corresponding to each second field;

[0216] The second data corresponding to each second field is displayed on the table page.

[0217] In one embodiment of this disclosure, for any given second field, displaying the second data corresponding to the second field on the table page includes:

[0218] Determine the target row containing the first data and the target column containing the second field;

[0219] The target display position is determined based on the target row and the target column, and the target display position is located in the target row and the target column;

[0220] The second data is displayed in the target display position.

[0221] Secondly, according to one or more embodiments of the present disclosure, a tabular data processing apparatus is provided, comprising:

[0222] The display module is used to display the field interface in response to triggering operations on field controls in the table page;

[0223] A determination module is configured to determine at least one second field in response to a field component and a first field selected in the field interface, wherein the first field is a field that has been created in the table page.

[0224] The processing module is used to display at least one second field on the table page and generate second data in the data column corresponding to the second field. The second data is data obtained by using the field component based on the first data in the data column corresponding to the first field.

[0225] In one embodiment of this disclosure, the field component is configured with application programming interface (API) data, and the field component interacts with a preset application through a pre-configured interface based on the API data.

[0226] In one embodiment of this disclosure, the field interface includes a component selection control and a field selection control; the determining module is specifically used for:

[0227] In response to an input operation to the component selection control, the field component is selected;

[0228] In response to an input operation on the field selection control, the first field is selected;

[0229] The at least one second field is determined based on the field component and the first field.

[0230] In one embodiment of this disclosure, the determining module is specifically used for:

[0231] Determine the multiple fields corresponding to the field component;

[0232] In response to a click operation on the field selection control, a field list component is displayed, the field list component including the plurality of fields;

[0233] In response to a selection operation of a field input in the field list component, the selected field is determined as the first field.

[0234] In one embodiment of this disclosure, the determining module is specifically used for:

[0235] Determine the multiple fields corresponding to the field component;

[0236] The at least one second field is determined from the at least one selection field, wherein the at least one selection field is any other field among the plurality of fields besides the first field.

[0237] In one embodiment of this disclosure, the determining module is specifically used for:

[0238] The field interface displays at least one selection field and the checkboxes corresponding to each selection field;

[0239] In response to an operation inputting into the checkbox corresponding to the selected field, the selected field is determined as the at least one second field.

[0240] In one embodiment of this disclosure, the processing module is used to:

[0241] Retrieve the first data in the data column corresponding to the first field;

[0242] Determine the preset application corresponding to the field component;

[0243] Based on the first data and the preset application, obtain the second data corresponding to each second field;

[0244] The second data corresponding to each second field is displayed on the table page.

[0245] In one embodiment of this disclosure, for any one of the second fields; the processing module is specifically used for:

[0246] Determine the target row containing the first data and the target column containing the second field;

[0247] The target display position is determined based on the target row and the target column, and the target display position is located in the target row and the target column;

[0248] The second data is displayed in the target display position.

[0249] Thirdly, according to one or more embodiments of the present disclosure, an electronic device is provided, comprising: at least one processor and a memory;

[0250] The memory stores computer-executed instructions;

[0251] The at least one processor executes computer execution instructions stored in the memory, causing the at least one processor to perform the tabular data processing method as described in the first aspect and various possible designs of the first aspect.

[0252] Fourthly, according to one or more embodiments of the present disclosure, a computer-readable storage medium is provided, wherein computer-executable instructions are stored therein, and when a processor executes the computer-executable instructions, the tabular data processing method described in the first aspect and various possible designs of the first aspect is implemented.

[0253] Fifthly, according to one or more embodiments of this disclosure, a computer program product is provided, including a computer program that, when executed by a processor, implements the tabular data processing method described in the first aspect and various possible designs of the first aspect.

[0254] The above description is merely a preferred embodiment of this disclosure and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of this disclosure is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described concept. For example, technical solutions formed by substituting the above features with (but not limited to) technical features disclosed in this disclosure that have similar functions.

[0255] Furthermore, while the operations are described in a specific order, this should not be construed as requiring these operations to be performed in the specific order shown or in a sequential order. In certain environments, multitasking and parallel processing may be advantageous. Similarly, while several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of this disclosure. Certain features described in the context of individual embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented individually or in any suitable sub-combination in multiple embodiments.

[0256] Although the subject matter has been described using language specific to structural features and / or methodological logic, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. Rather, the specific features and actions described above are merely illustrative examples of implementing the claims.

Claims

1. A method for processing tabular data, characterized in that, include: In response to a triggering action on a field control in the table page, display the field interface; In response to the field component and the first field selected in the field interface, at least one second field is determined, wherein the first field is a field that has been created in the table page; The table page displays at least one second field, and generates second data in the data column corresponding to the second field. The second data is data obtained by using the field component based on the first data in the data column corresponding to the first field.

2. The method according to claim 1, characterized in that, The field component is configured with application programming interface (API) data, and the field component interacts with a preset application through a pre-configured interface based on the API data.

3. The method according to claim 1, characterized in that, The field interface includes a component selection control and a field selection control; in response to the field component and the first field selected in the field interface, at least one second field is determined, including: In response to an input operation to the component selection control, the field component is selected; In response to an input operation on the field selection control, the first field is selected; The at least one second field is determined based on the field component and the first field.

4. The method according to claim 3, characterized in that, In response to an input operation on the field selection control, to select the first field, the following includes: Determine the multiple fields corresponding to the field component; In response to a click operation on the field selection control, a field list component is displayed, the field list component including the plurality of fields; In response to a selection operation of a field input in the field list component, the selected field is determined as the first field.

5. The method according to claim 3 or 4, characterized in that, Determining the at least one second field based on the field component and the first field includes: Determine the multiple fields corresponding to the field component; The at least one second field is determined from the at least one selection field, wherein the at least one selection field is another field among the plurality of fields besides the first field.

6. The method according to claim 5, characterized in that, Determining the at least one second field from the at least one selection field includes: The field interface displays at least one selection field and the checkboxes corresponding to each selection field; In response to an operation inputting into the checkbox corresponding to the selected field, the selected field is determined as the at least one second field.

7. The method according to any one of claims 1-6, characterized in that, Generate second data in the data column corresponding to the second field, including: Retrieve the first data in the data column corresponding to the first field; Determine the preset application corresponding to the field component; Based on the first data and the preset application, obtain the second data corresponding to each second field; The second data corresponding to each second field is displayed on the table page.

8. The method according to claim 7, characterized in that, For any given second field; display the second data corresponding to the second field on the table page, including: Determine the target row containing the first data and the target column containing the second field; The target display position is determined based on the target row and the target column, and the target display position is located in the target row and the target column; The second data is displayed in the target display position.

9. A tabular data processing device, characterized in that, include: The display module is used to display the field interface in response to triggering operations on field controls in the table page; A determination module is configured to determine at least one second field in response to a field component and a first field selected in the field interface, wherein the first field is a field that has been created in the table page. The processing module is used to display at least one second field on the table page and generate second data in the data column corresponding to the second field. The second data is data obtained by using the field component based on the first data in the data column corresponding to the first field.

10. An electronic device, characterized in that, include: Processor and memory; The memory stores computer-executed instructions; The processor executes computer execution instructions stored in the memory, causing the processor to perform the tabular data processing method as described in any one of claims 1 to 8.

11. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, implement the tabular data processing method as described in any one of claims 1 to 8.

12. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the method for tabular data processing as described in any one of claims 1 to 8.

Images