Table data processing method, device and equipment and storage medium

Abstract

Embodiments of the present disclosure provide a table data processing method and device, equipment and a storage medium, the method comprising: in response to a triggering operation on a field control in a table page, displaying a field interface; in the field interface, determining a field component and a first field; according to the field component and the first field, displaying a second field in the table page and generating second data in a data column corresponding to the second field, the second data being data generated by the field component based on first data in a data column corresponding to the first field; the field type of the second field is determined based on the field component, thereby improving the user's use efficiency.

Description

Technical Field

[0001] This disclosure relates to the field of computer technology, and more particularly to a method, apparatus, device, and storage medium for processing tabular data. Background Technology

[0002] Users can store and manage data using tables. A table can be an online database in tabular form to enable data storage, analysis, and visualization. A table can include at least one field. Fields are used to ensure that the entire column of data containing that field has the same data attributes, thus guaranteeing the formatting of the content entered in that column.

[0003] Currently, if users want to generate target fields to achieve specific functions, such as text processing and extraction, date and time calculation, and format conversion, they need to configure the target fields themselves through editing.

[0004] In practical applications, the process of users editing the code themselves is quite complex and has a high learning cost, resulting in low user efficiency. Summary of the Invention

[0005] This disclosure provides a method, apparatus, device, and storage medium for processing tabular data to address the problem that users often experience low efficiency when editing tables, due to the complexity of the process and the high learning curve.

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

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

[0008] In the field interface, determine the field component and the first field;

[0009] Based on the field component and the first field, a 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 generated using the field component based on the first data in the data column corresponding to the first field. The field type of the second field is determined based on the field component.

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

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

[0012] A determination module is used to determine the field components and the first field in the field interface;

[0013] The processing module is configured to display a second field on the table page based on the field component and the first field, and generate second data in the data column corresponding to the second field. The second data is generated by the field component based on the first data in the data column corresponding to the first field. The field type of the second field is determined based on the field component.

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

[0015] The memory stores computer-executed instructions;

[0016] 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.

[0017] 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.

[0018] 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.

[0019] 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 on a table page. Within the field interface, a field component and a first field are determined. Based on the field component and the first field, a 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 generated using the field component based on the first data in the data column corresponding to the first field. The field type of the second field is determined based on the field component. In this way, users do not need to write their own code; they only need to select a target component from multiple preset components to generate fields for implementing the corresponding functions, thus improving user efficiency. Attached Figure Description

[0020] 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.

[0021] Figure 1 This is a schematic diagram of an application scenario provided by an embodiment of the present disclosure;

[0022] Figure 2 This is a schematic flowchart of a tabular data processing method provided in an embodiment of the present disclosure;

[0023] Figure 3 A schematic diagram of a field control provided in an embodiment of this disclosure;

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

[0025] Figure 5 This is a schematic diagram of another tabular data processing method provided in an embodiment of the present disclosure;

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

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

[0028] Figure 8 This is a schematic diagram of another tabular data processing method provided in an embodiment of the present disclosure;

[0029] Figure 9 This is a schematic diagram of another tabular data processing method provided in an embodiment of the present disclosure;

[0030] Figure 10 A schematic diagram of another form page provided for an embodiment of this disclosure;

[0031] Figure 11 This is a schematic diagram of the structure of a tabular data processing device provided in an embodiment of the present disclosure;

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

[0033] 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.

[0034] For ease of understanding, the concepts involved in the embodiments of this disclosure will be explained below.

[0035] Tables: Online databases in tabular form, used to store and manage data.

[0036] Table page: Can be used to display data in a table to users.

[0037] Fields: These are the "columns" of a table. Different field types can be set within the table to ensure that the content entered in each column is formatted correctly. Field types can include general types, business types, and advanced types. General types can include text types, attachment types, formula types, etc.; business types can include process types, auto-numbering, progress types, etc.; advanced types can include bidirectional association types, one-way association types, etc.

[0038] Field data: A field data is a row of data entered in the column containing the field. At least one field data must have the same data type as the field containing it. For example, a field with the field type "attachment" will have field data that supports uploaded file types as attachments.

[0039] Below, in conjunction with Figure 1 The application scenarios of the embodiments of this disclosure will be illustrated by examples.

[0040] Figure 1 This is a schematic diagram illustrating an application scenario provided by an embodiment of this disclosure. Please refer to [link / reference]. Figure 1 This includes a table page. The table page contains formula fields and an editing component for editing these formula fields. Users can input calculation formulas in the editing component. The formula fields can then be calculated using the user-edited formulas to obtain the results and fulfill the corresponding functions.

[0041] In related technologies, when users want to generate target fields to achieve target functions, such as text processing and extraction, date and time calculation, and format conversion, they need to configure the target fields themselves through editing.

[0042] In practical applications, the process of users editing the code themselves is quite complex and has a high learning cost, resulting in low user efficiency.

[0043] To address the technical problems in related technologies, this disclosure provides a method for processing tabular data. By defining a field component and a first field in a field interface, displaying a second field on the table page based on the field component and the first field, and generating second data in the corresponding data column of the second field, the method eliminates the need for users to manually write code. Users simply select a target component from multiple preset components to generate fields for corresponding functions, thus improving user efficiency.

[0044] 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.

[0045] refer to Figure 2 , Figure 2 This is a schematic flowchart illustrating 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 approach. The tabular data processing method includes:

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

[0047] A table page can include field controls.

[0048] 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.

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

[0050] Below, in conjunction with Figure 3 This section provides an explanation of the field controls.

[0051] Figure 3 This is a schematic diagram of a field control provided in an embodiment of this disclosure. Please refer to [link / reference]. Figure 3 This includes: field controls.

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

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

[0054] The field interface may include component selection controls, field selection controls, field name editing windows, etc.

[0055] It can respond to triggering operations on field controls in the table page, run the corresponding backend code of the field control, and display the field interface.

[0056] Optionally, the form page can be displayed in response to the user's activation of the form.

[0057] Optionally, a list of tables may be displayed, which includes at least one table. In response to a user's selection of any table in the list, the corresponding table page is displayed.

[0058] 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.

[0059] S202. In the field interface, determine the field component and the first field.

[0060] Field components can be used to achieve target functions, such as text processing and extraction, date and time calculation, format conversion, etc.

[0061] The first field can be a field that already exists on the field interface and needs to be processed.

[0062] Below, in conjunction with Figure 4 The following example illustrates the field interface.

[0063] Figure 4 This is a schematic diagram of a field interface provided in an embodiment of this disclosure. Please refer to [link / reference]. Figure 4 This includes: field interface.

[0064] The field interface may include one or more of the following: a field name editing window, a component selection control, a field selection control, a cancel control, and a confirm control.

[0065] The field name editing window can be used to edit the name of a field.

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

[0067] The field selection control can be used to identify a first field in at least one field of the field interface. The first field can be the field that needs to be processed by the field component.

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

[0069] Determining controls can be used to determine a user's selection of various controls and / or editing of the editing window.

[0070] Users can determine the configuration information corresponding to a field based on the editing operations of various controls or editing windows in the field interface. The configuration information includes the first field and the field components.

[0071] For example, the first field can be a date type field or an attachment type field.

[0072] It can respond to user actions on various controls in the field interface to determine the field components and the first field.

[0073] S203. Based on the field component and the first field, display the second field on the table page and generate the second data in the data column corresponding to the second field.

[0074] The second field can be used to record the data generated by the field component. The field type of the second field is determined based on the field component.

[0075] The second field can also be used to record second data generated by processing the first data in the first field through the field component.

[0076] The second data can be data generated using field components based on the first data in the data column corresponding to the first field.

[0077] It can generate a second field in response to the user's selected field component and the first field, display the second field on the table page, and generate second data in the data column corresponding to the second field.

[0078] 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. A field component and a first field are determined in the field interface. Based on the field component and the first field, a 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 generated using the field component based on the first data in the data column corresponding to the first field. The field type of the second field is determined based on the field component. This eliminates the need for users to write their own code; they only need to select a target component from multiple preset components to generate fields for implementing corresponding functions, thus improving user efficiency.

[0079] exist Figure 2 Based on the embodiments shown, the following, in conjunction with Figure 5 The process of determining the field component and the first field in the field interface (S202) is explained in detail.

[0080] Figure 5 This is a schematic diagram illustrating another tabular data processing method provided in an embodiment of this disclosure. Please refer to [link / reference]. Figure 5 The method flow may include:

[0081] S501. In response to the user's input on the component selection control, the selected component is determined as a field component.

[0082] 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.

[0083] Multiple preset components can be used to perform different functions. These preset components can perform text processing, extraction or splitting, date and time calculation or statistics, format conversion or display, etc., without limitation.

[0084] For example, Table 1 can be used to represent multiple preset components and the functions corresponding to each preset component.

[0085] Table 1

[0086] Preset components Function Date conversion component Date data can be converted into corresponding week number data. Generate parent place name component A place name can be converted into the name of its superordinate place. Word case conversion component You can convert lowercase words to uppercase words. Extract Name Component Name information can be extracted from text data.

[0087] 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.

[0088] 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.

[0089] 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 run to display multiple configuration controls corresponding to the field component. The multiple configuration controls may include one or more of a field selection control and a conversion format selection control.

[0090] Below, in conjunction with Figure 6 The component selection control will be illustrated with an example.

[0091] Figure 6 This is a schematic diagram of a component selection control provided in an embodiment of this disclosure. Please refer to [link / reference]. Figure 6 This includes component selection controls.

[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 a user's click on a field component, the corresponding backend code for the field component can be run to display a field selection control and a format conversion selection control to the user.

[0096] S502, In response to an operation on the field selection control input, select the first field in at least one field of the field interface.

[0097] A field selection control can be used to display at least one field in a field interface to a user, allowing the user to select one of the fields as the first field.

[0098] The input operation can be that the user selects one of the fields in at least one field, or the user enters an input field in the field selection control, and the field selection control matches the field that matches the input field in at least one field as the first field.

[0099] It can respond to the user's input operation on the field selection control, determine the selected field corresponding to the input operation in at least one field of the field interface through the field selection control, and determine the selected field as the first field.

[0100] Below, in conjunction with Figure 7 The following example illustrates the field selection control.

[0101] Figure 7 This is a schematic diagram of a field selection control provided in an embodiment of this disclosure. Please refer to [link / reference]. Figure 7 This includes field selection controls.

[0102] 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.

[0103] Please refer to interface 702. The field selection control in interface 702 can display to the user the selection sub-controls corresponding to at least one field in the field interface. The user can select the target sub-control from the selection sub-controls corresponding to at least one field and determine the field corresponding to the target sub-control as the first field.

[0104] 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.

[0105] This disclosure provides a method for processing tabular data. By responding to a user's input on a component selection control, the selected component is determined as a field component. Then, responding to an input on a field selection control, a first field is selected from at least one field on the table page. This eliminates the need for users to write their own code; they simply select a target component from multiple preset components to generate a field for the corresponding function, thus improving user efficiency.

[0106] exist Figure 2 Based on the embodiments shown, the following, in conjunction with Figure 8 The process of displaying the second field on the table page based on the field component and the first field (S203) is described in detail.

[0107] refer to Figure 8 , Figure 8 This diagram illustrates yet another tabular data processing method provided in this embodiment. The field interface also includes a field name editing window and a confirmation control. The tabular data processing method includes:

[0108] S801. Get the target name entered in the field name editing window.

[0109] The field name editing window can be used to edit the field name of the second field.

[0110] The target name can be the name entered by the user in the field name editing window.

[0111] Optionally, the target name entered in the field name editing window can be obtained in response to the user's input operation on the field name editing window.

[0112] Optionally, based on the field component, a preset name corresponding to the field component can be determined in the field name editing window, and based on the preset name, the target name entered in the field name editing window can be determined.

[0113] For example, the target name is date to week number conversion.

[0114] S802, In response to a click operation on the confirmation control, generate a second field based on the target name.

[0115] The name of the second field is the target name.

[0116] It can respond to a click on the confirmation control, run the background code of the field interface, and generate a second field based on the target name.

[0117] S803. Create a field component, a binding relationship between the first field and the second field, and display the second field on the table page so that the field component generates the second data based on the first data.

[0118] The binding relationship can include a first binding relationship between a first field and a field component, and a second binding relationship between a second field and a field component.

[0119] The first binding relationship can be that the first data in the first field is used as the input data for the field component.

[0120] The second binding relationship can be that the output data of the field component is used as the second data in the second field.

[0121] You can create a first binding relationship between a first field and a field component, and a second binding relationship between a second field and a field component, so that the field component can generate second data based on the first data.

[0122] Alternatively, the second field can be displayed on the table page as follows: create a new column after the column containing the first field on the table page; set the field of the new column as the second field.

[0123] The new column can be a new column of data. You can create a new column in the table page, in one or more columns after the column containing the first field.

[0124] For example, if a new column is added as the 5th column, the field corresponding to the 5th column can be set as the second field.

[0125] 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.

[0126] This disclosure provides a method for processing tabular data. By obtaining the target name entered in the field name editing window, and in response to a click operation on the confirmation control, a second field is generated based on the target name. The name of the second field is the target name. A binding relationship is created between the field component, the first field, and the second field, and the second field is displayed on the table page, so that the field component generates the second data based on the first data. In this way, the user does not need to write the code themselves; they only need to select the target component from multiple preset components to generate the field to achieve the corresponding function, thus improving the user's efficiency.

[0127] exist Figure 2 Based on the embodiments shown, the following, in conjunction with Figure 9 The process of generating the second data in the data column corresponding to the second field (S203) is explained in detail.

[0128] refer to Figure 9 , Figure 9 This diagram illustrates another tabular data processing method provided in an embodiment of the present disclosure. The data processing method includes:

[0129] S901. Determine the target data format corresponding to the second field.

[0130] The target data format can be preset or selected by the user; no restriction is imposed here.

[0131] Optionally, a preset data format corresponding to the field component can be determined, and a target data format corresponding to the second field can be determined based on the preset data format.

[0132] Optionally, the field interface may also include a format selection control, which can be used to provide the user with multiple preset data formats corresponding to the field component. The user can select the target data format from the multiple preset data formats so that the data format of the second field is the target data format.

[0133] S902. Based on the target data format, generate the second data corresponding to the first data through the field component.

[0134] The second data is in the target data format.

[0135] The field component can be used to convert each piece of first data into corresponding second data. The second data can then be formatted according to the target data format to obtain the processed second data.

[0136] Optionally, the second data corresponding to the first data can be generated through the field component according to the target data format in the following way: input the first data into the formula data corresponding to the field component, and output the output data corresponding to the formula data; convert the output data into the second data according to the target data format.

[0137] Formula data can be stored in the field component as code. Formula data can include preset formulas.

[0138] S903. Display the second data corresponding to the first data in the table page.

[0139] The second data can be located in the same column as the second field.

[0140] For any given first data, display the corresponding second data in the field interface. The first data and the second data are in the same row, with the first data in the column containing the first field and the second data in the column containing the second field.

[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 determining the target data format corresponding to a second field, and generating second data corresponding to the first data based on the target data format using a field component, the second data is in the target data format and is displayed on the table page. This eliminates the need for users to write their own data; they only need to select a target component from multiple preset components to generate fields for implementing the corresponding functions, thus improving user efficiency.

[0143] Below, in conjunction with Figure 10 The process of S901-S903 will be illustrated with examples.

[0144] Figure 10 This is a schematic diagram of another table page provided in an embodiment of this disclosure. Assume the first field is a date field, the second field is a date conversion field, and the field component is a date conversion component. See also... Figure 10 This includes: date fields and date conversion fields.

[0145] Suppose we enter 2024 / 04 / 01 in the second row of the date field;

[0146] The target data format for the date conversion field is determined to be [Year] Week No. ;

[0147] Based on the target data format, the date conversion component will convert "2024 / 04 / 01" entered in the second row of the date field into "

[2024] Week 14".

[0148] The second row in the column containing the date conversion field displays "

[2024] Week 14".

[0149] 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.

[0150] Figure 11 This is a schematic diagram of a tabular data processing apparatus provided in an embodiment of this disclosure. Please refer to [link / reference]. Figure 11 The table data processing device 1100 includes a display module 1101, a determination module 1102, and a processing module 1103, wherein:

[0151] Display module 1101 is used to display the field interface in response to a trigger operation on the field control in the table page;

[0152] The determination module 1102 is used to determine the field component and the first field in the field interface;

[0153] The processing module 1103 is used to display a second field on the table page according to the field component and the first field, and generate second data in the data column corresponding to the second field. The second data is data generated by the field component based on the first data in the data column corresponding to the first field. The field type of the second field is determined based on the field component.

[0154] In one embodiment of this disclosure, the field component is configured with formula data, and the field component processes the first data based on the formula data to generate the second data.

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

[0156] In response to the user's input on the component selection control, the selected component is determined as the field component;

[0157] In response to an input operation to the field selection control, the first field is selected in at least one field of the table page.

[0158] In one embodiment of this disclosure, the field interface further includes a field name editing window and a confirmation control, and the processing module 1103 is specifically used for:

[0159] Get the target name entered in the field name editing window;

[0160] In response to a click operation on the confirmation control, a second field is generated based on the target name, wherein the name of the second field is the target name;

[0161] Create a binding relationship between the field component, the first field, and the second field, and display the second field in the table page so that the field component generates the second data based on the first data.

[0162] In one embodiment of this disclosure, the processing module 1103 is specifically used for:

[0163] In the table page, a new column is created after the column containing the first field;

[0164] Set the field of the newly added column to the second field.

[0165] In one embodiment of this disclosure, the processing module 1103 is specifically used for:

[0166] Determine the target data format corresponding to the second field;

[0167] Based on the target data format, second data corresponding to the first data is generated through the field component, and the data format of the second data is the target data format;

[0168] The second data corresponding to the first data is displayed on the table page.

[0169] In one embodiment of this disclosure, the processing module 1103 is specifically used for:

[0170] Input the first data into the formula data corresponding to the field component, and output the output data corresponding to the formula data;

[0171] The output data is converted into second data according to the target data format.

[0172] 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.

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

[0174] refer to Figure 12 , Figure 12 This is a schematic diagram of the hardware structure of the information display device provided in this embodiment of the disclosure. The electronic device 1200 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 broadcast receivers, personal digital assistants (PDAs), portable Android devices (PADs), portable media players (PMPs), and in-vehicle terminals (such as in-vehicle navigation terminals), as well as fixed terminals such as digital TVs and desktop computers. Figure 12 The electronic device shown is merely an example and should not be construed as limiting the functionality and scope of the embodiments disclosed herein.

[0175] like Figure 12As shown, the electronic device 1200 may include a processing unit (e.g., a central processing unit, a graphics processor, etc.) 1201, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1202 or a program loaded from a storage device 1208 into a random access memory (RAM) 1203. The RAM 1203 also stores various programs and data required for the operation of the electronic device 1200. The processing unit 1201, ROM 1202, and RAM 1203 are interconnected via a bus 1204. An input / output (I / O) interface 1205 is also connected to the bus 1204.

[0176] Typically, the following devices can be connected to I / O interface 1205: input devices 1206 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 1207 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 1208 including, for example, magnetic tapes, hard disks, etc.; and communication devices 1209. Communication device 1209 allows electronic device 1200 to communicate wirelessly or wiredly with other devices to exchange data. Although Figure 12 An electronic device 1200 with various devices is shown; however, 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.

[0177] 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 1209, or installed from storage device 1208, or installed from ROM 1202. When the computer program is executed by processing device 1201, it performs the functions defined in the methods of embodiments of this disclosure.

[0178] 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.

[0179] 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.

[0180] 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.

[0181] 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).

[0182] 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.

[0183] 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".

[0184] 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.

[0185] 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.

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

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

[0188] In the field interface, determine the field component and the first field;

[0189] Based on the field component and the first field, a 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 generated using the field component based on the first data in the data column corresponding to the first field. The field type of the second field is determined based on the field component.

[0190] According to one or more embodiments of this disclosure, the field component is configured with formula data, and the field component processes the first data based on the formula data to generate the second data.

[0191] According to one or more embodiments of this disclosure, the field interface includes a component selection control and a field selection control; in the field interface, determining the field component and the first field includes:

[0192] In response to the user's input on the component selection control, the selected component is determined as the field component;

[0193] In response to an input operation to the field selection control, the first field is selected in at least one field of the table page.

[0194] According to one or more embodiments of this disclosure, the field interface further includes a field name editing window and a confirmation control, and displays a second field on the table page based on the field component and the first field, including:

[0195] Get the target name entered in the field name editing window;

[0196] In response to a click operation on the confirmation control, a second field is generated based on the target name, wherein the name of the second field is the target name;

[0197] Create a binding relationship between the field component, the first field, and the second field, and display the second field in the table page so that the field component generates the second data based on the first data.

[0198] According to one or more embodiments of this disclosure, displaying the second field on the table page includes:

[0199] In the table page, a new column is created after the column containing the first field;

[0200] Set the field of the newly added column to the second field.

[0201] According to one or more embodiments of this disclosure, generating second data in the data column corresponding to the second field includes:

[0202] Determine the target data format corresponding to the second field;

[0203] Based on the target data format, second data corresponding to the first data is generated through the field component, and the data format of the second data is the target data format;

[0204] The second data corresponding to the first data is displayed on the table page.

[0205] According to one or more embodiments of this disclosure, generating second data corresponding to the first data through the field component according to the target data format includes:

[0206] Input the first data into the formula data corresponding to the field component, and output the output data corresponding to the formula data;

[0207] The output data is converted into second data according to the target data format.

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

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

[0210] A determination module is used to determine the field components and the first field in the field interface;

[0211] The processing module is configured to display a second field on the table page based on the field component and the first field, and generate second data in the data column corresponding to the second field. The second data is generated by the field component based on the first data in the data column corresponding to the first field. The field type of the second field is determined based on the field component.

[0212] According to one or more embodiments of this disclosure, the field component is configured with formula data, and the field component processes the first data based on the formula data to generate the second data.

[0213] According to one or more embodiments of this disclosure, the field interface includes a component selection control and a field selection control; the determining module is specifically used for:

[0214] In response to the user's input on the component selection control, the selected component is determined as the field component;

[0215] In response to an input operation to the field selection control, the first field is selected in at least one field of the table page.

[0216] According to one or more embodiments of this disclosure, the field interface further includes a field name editing window and a confirmation control, and the processing module is specifically used for:

[0217] Get the target name entered in the field name editing window;

[0218] In response to a click operation on the confirmation control, a second field is generated based on the target name, wherein the name of the second field is the target name;

[0219] Create a binding relationship between the field component, the first field, and the second field, and display the second field in the table page so that the field component generates the second data based on the first data.

[0220] According to one or more embodiments of this disclosure, the processing module is specifically used for:

[0221] In the table page, a new column is created after the column containing the first field;

[0222] Set the field of the newly added column to the second field.

[0223] According to one or more embodiments of this disclosure, the processing module is specifically used for:

[0224] Determine the target data format corresponding to the second field;

[0225] Based on the target data format, second data corresponding to the first data is generated through the field component, and the data format of the second data is the target data format;

[0226] The second data corresponding to the first data is displayed on the table page.

[0227] According to one or more embodiments of this disclosure, the processing module is specifically used for:

[0228] Input the first data into the formula data corresponding to the field component, and output the output data corresponding to the formula data;

[0229] The output data is converted into second data according to the target data format.

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

[0231] The memory stores computer-executed instructions;

[0232] 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.

[0233] 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.

[0234] 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.

[0235] 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.

[0236] 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.

[0237] 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 tabular data processing method, characterized by, The method comprises: in response to a triggering operation on a field control in a table page, displaying a field interface; in the field interface, determining a field component and a first field; in the table page, displaying a second field according to the field component and the first field, and generating second data in a data column corresponding to the second field, the second data being generated by the field component based on first data in a data column corresponding to the first field; a field type of the second field is determined based on the field component; the field interface further comprises a field name editing window and a confirmation control, and in the table page, the second field is displayed according to the field component and the first field, comprising: obtaining a target name input in the field name editing window; in response to a click operation on the confirmation control, generating a second field according to the target name, and the name of the second field is the target name; creating a binding relationship between the field component, the first field and the second field, and displaying the second field in the table page, so that the field component generates the second data according to the first data.

2. The method of claim 1, wherein, The field component is configured with formula data, and the field component processes the first data based on the formula data to generate the second data.

3. The method according to claim 1 or 2, characterized in that, The field interface comprises a component selection control and a field selection control; in the field interface, the field component and the first field are determined, comprising: in response to an operation input by a user on the component selection control, determining the selected component as the field component; in response to an operation input on the field selection control, selecting the first field in at least one field of the table page.

4. The method of claim 1, wherein, Displaying the second field in the table page comprises: in the table page, creating a new column after the column where the first field is located; setting the field of the new column as the second field.

5. The method according to any of claims 1-2, 4, characterized in that, Generating second data in the data column corresponding to the second field comprises: determining a target data format corresponding to the second field; generating second data corresponding to the first data through the field component according to the target data format, the data format of the second data being the target data format; displaying the second data corresponding to the first data in the table page.

6. The method of claim 5, wherein, Generating second data corresponding to the first data through the field component according to the target data format comprises: inputting the first data into formula data corresponding to the field component to output output data corresponding to the formula data; converting the output data into second data according to the target data format.

7. A tabular data processing apparatus, characterized by comprising: The method comprises: a display module configured to display a field interface in response to a triggering operation on a field control in a table page; a determination module configured to determine a field component and a first field in the field interface; The processing module is configured to display a second field in the table page according to the field component and the first field, and generate second data in a data column corresponding to the second field, the second data being generated based on first data in a data column corresponding to the first field and the data generated by the field component, and a field type of the second field being determined based on the field component; The field interface further includes a field name editing window and a confirmation control, and the processing module is specifically configured to obtain a target name input in the field name editing window; In response to a click operation on the confirmation control, a second field is generated according to the target name, and a name of the second field is the target name; A binding relationship is created between the field component, the first field and the second field, and the second field is displayed in the table page, so that the field component generates the second data according to the first data.

8. An electronic device, comprising: Comprise: A processor and a memory; The memory stores computer execution instructions; The processor executes the computer execution instructions stored in the memory, so that the processor executes the table data processing method according to any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that, The computer readable storage medium stores computer execution instructions, and when the processor executes the computer execution instructions, the table data processing method according to any one of claims 1 to 6 is realized.

10. A computer program product comprising a computer program, characterized in that, The computer program is executed by the processor to realize the table data processing method according to any one of claims 1 to 6.

Images