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 for a field control on a table page, displaying a field interface (S201); in the field interface, determining a field component and a first field (S202); and on the basis of the field component and the first field, displaying a second field on the table page, and generating second data in a data column corresponding to the second field (S203), wherein the second data is data generated by using the field component and on the basis of first data in the data column corresponding to the first field, and the field type of the second field is determined on the basis of the field component.

Description

Table data processing method, device, equipment and storage medium

[0001] Cross-reference to Related Applications

[0002] This application claims priority to the Chinese Patent Application No. 202410797889.4, filed on June 19, 2024, and entitled "Table data processing method, device, equipment and storage medium", the content of which is incorporated herein by reference in its entirety. TECHNICAL FIELD

[0003] Embodiments of the present disclosure relate to the technical field of computers, and particularly relate to a table data processing method, device, equipment and storage medium. BACKGROUND

[0004] A user can store and manage data through a table. The table can be an online database in the form of a table to realize storage, analysis and visualization of data. The table can include at least one field. The field can be used to determine that the entire column data of the column where the field is located has the same data attribute, so as to ensure the format specification of the content filled in the column. SUMMARY

[0005] In a first aspect, the embodiments of the present disclosure provide a table data processing method, comprising:

[0006] In response to a triggering operation of a field control in a table page, a field interface is displayed.

[0007] In the field interface, a field component and a first field are determined.

[0008] According to the field component and the first field, a second field is displayed in the table page, and second data is generated in a data column corresponding to the second field. The second data is generated by using 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.

[0009] In a second aspect, the embodiments of the present disclosure provide a table data processing device, comprising:

[0010] A display module is configured to display a field interface in response to a triggering operation of a field control in a table page.

[0011] A determination module is configured to determine a field component and a first field in the field interface.

[0012] 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 is determined based on the field component.

[0013] In a third aspect, an electronic device is provided, including a processor and a memory.

[0014] The memory stores computer-executable instructions.

[0015] The processor executes the computer-executable instructions stored in the memory, so that the at least one processor executes the table data processing method according to the first aspect and various possible designs of the first aspect.

[0016] In a fourth aspect, a computer-readable storage medium is provided, and the computer-readable storage medium stores computer-executable instructions. When a processor executes the computer-executable instructions, the table data processing method according to the first aspect and various possible designs of the first aspect is implemented.

[0017] In a fifth aspect, a computer program product is provided, and the computer program product includes a computer program. When a processor executes the computer program, the table data processing method according to the first aspect and various possible designs of the first aspect is implemented. BRIEF DESCRIPTION OF DRAWINGS

[0018] In order to more clearly illustrate the technical solutions of the embodiments of the present disclosure or the prior art, the drawings needed in the embodiments or the prior art description will be briefly introduced. Obviously, the drawings in the following description are some embodiments of the present disclosure, and other drawings can be obtained by those skilled in the art without creative labor.

[0019] FIG. 1 is a schematic diagram of an application scenario according to an embodiment of the present disclosure;

[0020] FIG. 2 is a schematic diagram of a table data processing method according to an embodiment of the present disclosure;

[0021] FIG. 3 is a schematic diagram of a field control according to an embodiment of the present disclosure;

[0022] FIG. 4 is a schematic diagram of a field interface according to an embodiment of the present disclosure;

[0023] FIG. 5 is another schematic diagram of a table data processing method according to an embodiment of the present disclosure;

[0024] FIG. 6 is a schematic diagram of an assembly selection control according to an embodiment of the present disclosure;

[0025] FIG. 7 is a schematic diagram of a field selection control according to an embodiment of the present disclosure;

[0026] FIG. 8 is a schematic diagram of another table data processing method according to an embodiment of the present disclosure;

[0027] FIG. 9 is a schematic diagram of another table data processing method according to an embodiment of the present disclosure;

[0028] FIG. 10 is a schematic diagram of another table page according to an embodiment of the present disclosure;

[0029] FIG. 11 is a schematic diagram of a table data processing apparatus according to an embodiment of the present disclosure;

[0030] FIG. 12 is a schematic diagram of a hardware structure of an information display device according to an embodiment of the present disclosure. DETAILED DESCRIPTION

[0031] In order to make the objects, technical solutions and advantages of the embodiments of the present disclosure clearer, the technical solutions in the embodiments of the present disclosure will be described clearly and completely below with reference to the drawings in the embodiments of the present disclosure. Obviously, the described embodiments are some but not all of the embodiments of the present disclosure. Based on the embodiments in the present disclosure, all other embodiments obtained by a person of ordinary skill in the art without creative work fall within the protection scope of the present disclosure.

[0032] In order to facilitate understanding, the concepts related to the embodiments of the present disclosure are described below.

[0033] Table: an online database in the form of a table, used to store and manage data.

[0034] Table page: can be used to show data in the table to the user.

[0035] Field: a "column" of the table, different field types can be set in the table to ensure the format specification of the content filled in each column. The field types can include general types, business types and advanced types. The general types can include text types, attachment types, formula types, etc.; the business types can include process types, automatic numbering, progress types, etc.; the advanced types can include bidirectional association types, single-item association types, etc.

[0036] Field data: a field data is a row of data filled in the column where the field is located. The data type of at least one field data is the same as the field type of the field where the field data is located. For example, the field type of the field is an attachment type, and the field data corresponding to the field is an attachment supporting the uploading of file types.

[0037] Currently, in the process of using a table, if a user wants to generate a target field to implement a target function, such as text processing and extraction, calculation of date and time, format conversion, and the like, the user needs to configure the target field by means of self-editing. In actual application, the process of self-editing of the user is relatively complex and has a high learning cost, resulting in a low use efficiency of the user.

[0038] Embodiments of the present disclosure provide a table data processing method, apparatus, device, and storage medium to solve the problem that the process of self-editing of a user is relatively complex and has a high learning cost in the process of using a table, resulting in a low use efficiency of the user. The table data processing method, apparatus, device, and storage medium provided by the embodiments display a field interface in response to a triggering operation on a field control in a table page, determine a field component and a first field in the field interface, 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 data generated by the field component based on first data in a data column corresponding to the first field; and the field type of the second field is determined based on the field component. In this way, the user does not need to write by himself / herself, but only needs to select a target component from a plurality of preset components to generate a field to implement a corresponding function, thereby improving the use efficiency of the user.

[0039] Next, the application scenario of the embodiments of the present disclosure is exemplarily described in combination with FIG. 1.

[0040] FIG. 1 is a schematic diagram of an application scenario provided by an embodiment of the present disclosure. Please refer to FIG. 1, which includes a table page. The table page includes a formula field and an editing component for editing the formula field. The user can input a calculation formula in the editing component. The formula field can calculate a field by means of the calculation formula edited by the user to obtain a calculation result, so as to implement a corresponding function.

[0041] In related technologies, in the process of using a table, if a user wants to generate a target field to implement a target function, such as text processing and extraction, calculation of date and time, format conversion, and the like, the user needs to configure the target field by means of self-editing.

[0042] In actual application, the process of self-editing of the user is relatively complex and has a high learning cost, resulting in a low use efficiency of the user.

[0043] To solve the technical problems in the related art, the embodiment of the present disclosure provides a table data processing method. By determining a field component and a first field in a field interface, a second field is displayed in a table page according to the field component and the first field, and second data is generated in a data column corresponding to the second field. In this way, the user does not need to write by himself / herself, but only needs to select a target component in a plurality of preset components to generate a field for realizing a corresponding function, thereby improving the use efficiency of the user.

[0044] The technical solutions of the present disclosure and how the technical solutions of the present disclosure solve the above technical problems will be described in detail below with specific embodiments. The following specific embodiments can be combined with each other, and the same or similar concepts or processes can not be described again in some embodiments. The embodiments of the present disclosure will be described below with reference to the drawings.

[0045] Referring to FIG. 2, FIG. 2 is a flowchart of a table data processing method provided by an embodiment of the present disclosure. The execution subject of the embodiment of the present disclosure can be a terminal device, or a table data processing apparatus provided in the terminal device. The table data processing apparatus can be implemented according to software, or the table data processing apparatus can be implemented according to the combination of software and hardware, which is not limited in the embodiment of the present disclosure. The table data processing method comprises the following steps.

[0046] S201, in response to a triggering operation of a field control in a table page, a field interface is displayed.

[0047] The table page can include the field control.

[0048] The field control can be used to add a field. By clicking the field control, a field interface can be generated, and the field interface can be used to configure the added field.

[0049] The triggering operation can be an interactive operation of the user with the field control through a mouse click, a touch screen, or other input devices.

[0050] Next, the field control will be described with reference to FIG. 3.

[0051] FIG. 3 is a schematic diagram of a field control provided by an embodiment of the present disclosure. Please refer to FIG. 3, which includes a field control.

[0052] The field control can be represented by an icon "+" or other icons, which is not limited herein.

[0053] The field interface can be used for specific configuration of the added field.

[0054] The field interface can include a component selection control, a field selection control, a field name editing window, and the like.

[0055] The field control corresponding background code can be run in response to a triggering operation on the field control in the table page, and the field interface is displayed.

[0056] Optionally, the table page can be displayed in response to a starting operation of the user on the table.

[0057] Optionally, a table list can be displayed, the table list including at least one table, and the table page corresponding to any one table in the table list can be displayed in response to a selection operation of the user on the table.

[0058] It should be noted that the terminal device can display the table page according to any feasible implementation manner, and the embodiments of the present disclosure do not limit this.

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

[0060] The field component can be used to implement a target function, such as text processing and extraction, date and time calculation, format conversion, etc.

[0061] The first field can be an existing field in the field interface and needs to be processed.

[0062] Next, the field interface will be illustrated by combining FIG. 4.

[0063] FIG. 4 is a schematic diagram of a field interface provided by an embodiment of the present disclosure. Please refer to FIG. 4, which includes a field interface.

[0064] The field interface can include one or more of a field name editing window, a component selection control, a field selection control, a cancel control, and a determination control.

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

[0066] The component selection control can be used to determine the field component from a plurality of preset components.

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

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

[0069] The determination control can be used to determine the selection operation of the user on each control and / or the editing operation on the editing window.

[0070] The user can determine the configuration information corresponding to the field based on the editing operation of each control or the editing window in the field interface, and the configuration information includes the first field and the field component.

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

[0072] The field component and the first field can be determined in response to a triggering operation of a user on a control in the field interface.

[0073] S203, according to the field component and the first field, display the second field in 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 processing, and the field type of the second field is determined based on the field component.

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

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

[0077] The second field can be generated in response to the user selecting the field component and the first field, displayed in the table page, and the second data can be generated in the data column corresponding to the second field.

[0078] The embodiments of the present disclosure provide a table data processing method, which displays a field interface in response to a triggering operation of a field control in a table page, determines a field component and a first field in the field interface, displays a second field in the table page according to the field component and the first field, and generates 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, and the field type of the second field is determined based on the field component. In this way, the user does not need to write himself, but only needs to select a target component from a plurality of preset components to generate a field to realize the corresponding function, thereby improving the user's use efficiency.

[0079] Based on the embodiment shown in FIG. 2, the process of determining the field component and the first field in the field interface (S202) will be described in detail below in conjunction with FIG. 5.

[0080] FIG. 5 is a schematic diagram of another table data processing method provided by an embodiment of the present disclosure. Referring to FIG. 5, the method flow can include:

[0081] S501, in response to the operation input by the user on the component selection control, determine the selected component as the field component.

[0082] The component selection control can be used to display a plurality of preset components to the user, so that the user selects one of the preset components as the field component.

[0083] The plurality of preset components can be used to implement different functions respectively. The preset components can implement text processing, extraction or separation, can implement date and time calculation or statistics, can implement format conversion or display, etc., which are not limited herein.

[0084] For example, the plurality of preset components and the functions corresponding to each preset component can be represented by Table 1.

[0085] Table 1

[0086] The input operation can be that the user performs a selection operation on one of the plurality of preset components, or that the user inputs a component name in the component selection control, and the component selection control performs a selection operation on a component consistent with the component name in the plurality of preset components according to the input component name.

[0087] The field component corresponding to the input operation can be determined in the plurality of preset components through the component selection control in response to the operation input by the user to the component selection control, and the background code corresponding to the field component is run.

[0088] Optionally, in response to the operation input by the user to the component selection control, the selected component is determined as the field component, and the background code corresponding to the field component is run to display a plurality of configuration controls corresponding to the field component, which can include one or more of a field selection control and a format conversion selection control.

[0089] Next, the component selection control is illustrated by taking FIG. 6 as an example.

[0090] FIG. 6 is a schematic diagram of a component selection control provided by an embodiment of the present disclosure. Please refer to FIG. 6, which includes a component selection control.

[0091] Please refer to interface 601, which can include a component selection control and a control title corresponding to the component selection control. The user can perform a click operation on the component selection control to make the display screen display interface 602.

[0092] Please refer to interface 602, in which the component selection control can display a plurality of preset components to the user, and the user can select a field component from the plurality of preset components.

[0093] Please refer to interface 603, in which in response to the click operation of the user on the field component, the background code corresponding to the field component can be run to display a field selection control to the user.

[0094] Optionally, in response to the click operation of the user on the field component, the background code corresponding to the field component can be run to display a field selection control and a format conversion selection control to the user.

[0095] S502, in response to the operation input to the field selection control, selecting a first field in at least one field of the field interface.

[0096] The field selection control can be used to show the user at least one field in the field interface, so that the user selects one of the fields as the first field.

[0097] The input operation can be that the user selects one of the at least one field, or that the user inputs an input field in the field selection control, and the field selection control matches a field consistent with the input field in the at least one field as the first field according to the input field.

[0098] The selected field corresponding to the input operation can be determined in the at least one field of the field interface by the field selection control in response to the operation input by the user to the field selection control, and the selected field is determined as the first field.

[0099] In the following, the field selection control is illustrated in conjunction with FIG. 7.

[0100] FIG. 7 is a schematic diagram of a field selection control according to an embodiment of the present disclosure. Please refer to FIG. 7, which includes a field selection control.

[0101] Please refer to interface 701, which can include a field selection control, a control title corresponding to the field selection control, and a determination control. The user can perform a click operation on the field selection control, so that the display screen displays interface 702.

[0102] Please refer to interface 702, in which the field selection control can show the user at least one field in the field interface respectively corresponding to the selection sub-control. The user can select a target sub-control from the at least one field respectively corresponding to the selection sub-control, and the field corresponding to the target sub-control can be determined as the first field.

[0103] The implementation of each step in the embodiments of the present disclosure can refer to the description of the corresponding steps or operations of the above method embodiments, and repeated contents will not be described here.

[0104] The embodiment of the present disclosure provides a table data processing method, which determines a selected component as a field component in response to the operation input by the user to the component selection control, and selects a first field in at least one field of the table page in response to the operation input to the field selection control. In this way, the user does not need to write himself, but only needs to select a target component from a plurality of preset components to generate a field to realize the corresponding function, thereby improving the user's use efficiency.

[0105] On the basis of the embodiment shown in FIG. 2, the following, in combination with FIG. 8, will describe in detail the process (S203) of displaying the second field in the table page according to the field component and the first field.

[0106] Referring to FIG. 8, which is a schematic diagram of another table data processing method provided by an embodiment of the present disclosure, the field interface further includes a field name editing window and a confirmation control, and the table data processing method includes:

[0107] S801: obtaining a target name input in the field name editing window.

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

[0109] The target name can be a name input by the user in the field name editing window.

[0110] Optionally, the target name input in the field name editing window can be obtained in response to the input operation of the user on the field name editing window.

[0111] Optionally, a preset name corresponding to the field component can be determined in the field name editing window according to the field component, and the target name input in the field name editing window can be determined according to the preset name.

[0112] For example, the target name is the number of weeks converted from the date.

[0113] S802: generating the second field according to the target name in response to the click operation on the confirmation control.

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

[0115] The second field can be generated according to the target name in response to the click operation on the confirmation control by running the background code of the field interface.

[0116] S803: 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.

[0117] The binding relationship can include a first binding relationship between the first field and the field component and a second binding relationship between the second field and the field component.

[0118] The first binding relationship can be to take the first data in the first field as the input data of the field component.

[0119] The second binding relationship can be to take the output data of the field component as the second data in the second field.

[0120] The first field and the field component can be created in a first binding relationship, and the second field and the field component can be created in a second binding relationship, so that the field component generates the second data according to the first data.

[0121] Optionally, the second field can be displayed in the table page in the following manner: a new column is created after the column where the first field is located in the table page; and the field of the new column is set as the second field.

[0122] The new column can be a new column of data, and the new column can be created in one or more columns after the column where the first field is located in the table page.

[0123] For example, the new column is the fifth column, and the field corresponding to the fifth column can be set as the second field.

[0124] The implementation of each step in the embodiments of the present disclosure can refer to the description of the corresponding steps or operations of the above method embodiments, and repeated contents will not be described herein.

[0125] The embodiments of the present disclosure provide a table data processing method. The target name input in the field name editing window is obtained, and in response to a click operation on the confirmation control, the second field is generated according to the target name. The name of the second field is the target name. The binding relationship between the field component, the first field and the second field is created, and the second field is displayed in the table page, so that the field component generates the second data according to the first data. In this way, the user does not need to write by himself, but only needs to select the target component from a plurality of preset components to generate the field to realize the corresponding function, thereby improving the use efficiency of the user.

[0126] Based on the embodiment shown in FIG. 2, the process (S203) of generating the second data in the data column corresponding to the second field will be described in detail below in combination with FIG. 9.

[0127] Referring to FIG. 9, FIG. 9 is a schematic diagram of another table data processing method provided by the embodiments of the present disclosure. The data processing method comprises:

[0128] S901, determining a target data format corresponding to the second field.

[0129] The target data format can be pre-set or selected and determined by the user, which is not limited herein.

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

[0131] Optionally, the field interface can further include a format selection control, which can be used to provide a plurality of preset data formats corresponding to the field component to the user, and the user can select a target data format from the plurality of preset data formats, so that the data format of the second field is the target data format.

[0132] S902, generating, according to the target data format, the second data corresponding to the first data through the field component.

[0133] The data format of the second data is the target data format.

[0134] Each first data can be converted into corresponding second data through the field component, and the second data is format-processed according to the target data format to obtain processed second data.

[0135] 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 manner: the first data is input into formula data corresponding to the field component, and output data corresponding to the formula data is output; and the output data is converted into the second data according to the target data format.

[0136] The formula data can be stored in the field component in the form of code. The formula data can include a preset formula.

[0137] S903, displaying the second data corresponding to the first data in the table page.

[0138] The second data can be located in the column where the second field is located.

[0139] For any one first data, the second data corresponding to the first data is displayed in the field interface, the first data and the second data are located in the same row, the first data is located in the column where the first field is located, and the second data is located in the column where the second field is located.

[0140] The implementation content of each step in the embodiments of the present disclosure can refer to the description of the corresponding steps or operations of the above method embodiments, and repeated content will not be described again.

[0141] The embodiments of the present disclosure provide a table data processing method, which determines a target data format corresponding to a second field, generates, according to the target data format, second data corresponding to first data through a field component, the data format of the second data is the target data format, and displays the second data corresponding to the first data in a table page. In this way, the user does not need to write himself, but only needs to select a target component from a plurality of preset components to generate a field to realize the corresponding function, thereby improving the user's use efficiency.

[0142] Next, the process of S901-S903 will be illustrated with reference to FIG. 10.

[0143] FIG. 10 is a schematic diagram of another table page provided by an embodiment of the present disclosure. It is assumed that the first field is a date field, the second field is a date conversion field, and the field component is a date conversion component. Referring to FIG. 10, it includes the date field and the date conversion field.

[0144] It is assumed that 2024 / 04 / 01 is input in the second row of the date field;

[0145] It is determined that the target data format corresponding to the date conversion field is

··· year

[0146] According to the target data format, the date conversion component is used to convert 2024 / 04 / 01 input in the second row of the date field into 【2024 year】th 14th week;

[0147] 【2024 year】th 14th week is displayed in the second row in the column where the date conversion field is located.

[0148] The implementation of each step in the embodiment of the present disclosure can refer to the description of the corresponding step or operation of the above method embodiment, and the repeated content will not be described herein.

[0149] FIG. 11 is a structural schematic diagram of a table data processing apparatus provided by an embodiment of the present disclosure. Referring to FIG. 11, the table data processing apparatus 1100 includes a display module 1101, a determination module 1102, and a processing module 1103, wherein:

[0150] The display module 1101 is configured to display a field interface in response to a triggering operation of a field control in a table page.

[0151] The determination module 1102 is configured to determine a field component and a first field in the field interface.

[0152] The processing module 1103 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 by the field component based on first data in a data column corresponding to the first field; and a field type of the second field is determined based on the field component.

[0153] In an embodiment of the present disclosure, a formula data is configured in the field component, and the field component processes the first data based on the formula data to generate the second data.

[0154] In an embodiment of the present disclosure, the field interface includes a component selection control and a field selection control; and the determination module 1102 is specifically configured to:

[0155] In response to an operation input by a user to the component selection control, determine the selected component as the field component;

[0156] In response to an operation input by a user to the field selection control, select the first field in at least one field of the table page.

[0157] In an embodiment of the present disclosure, the field interface further includes a field name editing window and a confirmation control, and the processing module 1103 is specifically configured to:

[0158] Obtain a target name input in the field name editing window;

[0159] In response to a click operation on the confirmation control, generate a second field according to the target name, and the name of the second field is the target name;

[0160] 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 according to the first data.

[0161] In an embodiment of the present disclosure, the processing module 1103 is specifically configured to:

[0162] In the table page, create a new column after the column where the first field is located;

[0163] Set the field of the new column as the second field.

[0164] In an embodiment of the present disclosure, the processing module 1103 is specifically configured to:

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

[0166] According to the target data format, generate second data corresponding to the first data through the field component, and the data format of the second data is the target data format;

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

[0168] In an embodiment of the present disclosure, the processing module 1103 is specifically configured to:

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

[0170] According to the target data format, convert the output data into second data.

[0171] The device provided by the embodiment can be used to execute the technical solutions of the method embodiments, and has similar implementation principles and technical effects. Details are not described herein.

[0172] To implement the above embodiments, the electronic device is also provided by the embodiments of the present disclosure.

[0173] Referring to FIG. 12, FIG. 12 is a schematic diagram of a hardware structure of an information display device according to an embodiment of the present disclosure. The electronic device 1200 can be a terminal device or a server. The terminal device can include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a personal digital assistant (PDA), a tablet computer (PAD), a portable media player (PMP), a car terminal (for example, a car navigation terminal), and the like, and a stationary terminal such as a digital TV, a desktop computer, and the like. The electronic device shown in FIG. 12 is only an example, and should not impose any limitation on the functions and use range of the embodiments of the present disclosure.

[0174] As shown in FIG. 12, the electronic device 1200 can include a processing device (for example, a central processing unit, a graphic processing unit, or the like) 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 to a random access memory (RAM) 1203. In the RAM 1203, various programs and data required for the operation of the electronic device 1200 are also stored. The processing device 1201, the ROM 1202, and the RAM 1203 are connected to each other through a bus 1204. An input / output (I / O) interface 1205 is also connected to the bus 1204.

[0175] In general, the following devices can be connected to the I / O interface 1205: input devices 1206 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, and the like; output devices 1207 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage devices 1208 including, for example, a magnetic tape, a hard disk, and the like; and communication devices 1209. The communication devices 1209 can allow the electronic device 1200 to communicate wirelessly or wiredly with other devices to exchange data. While FIG. 12 shows the electronic device 1200 with various devices, it is understood that all of the illustrated devices are not required to be implemented or present. More or less devices can alternatively be implemented or present.

[0176] In particular, according to embodiments of the present disclosure, the processes described above with reference to the flowcharts can be implemented as a computer software program. For example, embodiments of the present disclosure include a computer program product comprising a computer program carried on a computer readable medium, the computer program containing program code for executing the methods illustrated by the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network through the communication devices 1209, or installed from the storage devices 1208, or installed from the ROM 1202. When the computer program is executed by the processing devices 1201, the above-described functions defined in the methods of the embodiments of the present disclosure are performed.

[0177] It should be noted that the computer-readable medium in the above disclosure can be a computer-readable signal medium or a computer-readable storage medium or any combination of the two. The computer-readable storage medium may, for example, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or apparatus, or any combination of the above. More specific examples of the computer-readable storage medium can include, but are not limited to, an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, the computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, device or apparatus. In the present disclosure, the computer-readable signal medium can include a data signal carried in a baseband or as a part of a carrier wave, which carries computer-readable program code. Such a propagated data signal can take many forms, including but not limited to an electromagnetic signal, an optical signal or any suitable combination of the above. The computer-readable signal medium can also be any computer-readable medium other than the computer-readable storage medium, which can send, propagate or transmit a program for use by or in conjunction with an instruction execution system, device or apparatus. The program code contained in the computer-readable medium can be transmitted by any suitable medium, including but not limited to a wire, a cable, an RF (radio frequency) or the like, or any suitable combination of the above.

[0178] The computer-readable medium described above can be contained in the electronic device described above; or can exist separately and not be assembled into the electronic device.

[0179] The computer-readable medium described above 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.

[0180] Computer program code for carrying out operations of the present disclosure can be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C++ or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider).

[0181] The flow diagrams and the block diagrams in the drawings are illustrations of architectures, functionalities, and operations of possible implementations of systems, methods, and computer program products according to various embodiments of present disclosure. In this regard, each block in the flow diagrams or block diagrams can represent a module, a procedure, or a part of code, which comprises one or more executable instructions for implementing the specified logical functions. It should also be noted that in some alternative implementations, the functions noted in the blocks can occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently or in the reverse order, depending on the functionality involved. It is also noted that each block in the block diagrams and / or flow diagrams and combinations of blocks in the block diagrams and / or flow diagrams can be implemented by special-purpose hardware-based systems that perform the specified functions or operations, or combinations of special-purpose hardware and computer instructions.

[0182] The units described in the embodiments of the present disclosure can be implemented by software, or by hardware. In some cases, the name of the unit does not constitute a limitation on the unit itself. For example, the first obtaining unit can also be described as a unit for obtaining at least two Internet protocol addresses.

[0183] The functions described in this specification can be implemented in part or in whole by one or more hardware logic components. For example, and without limitation, illustrative types of hardware logic components that can be used include Field-programmable Gate Arrays (FPGAs), Program-specific Integrated Circuits (ASICs), Program-specific Standard Products (ASSPs), System-on-a-chip systems (SOCs), Complex Programmable Logic Devices (CPLDs), etc.

[0184] In the context of this disclosure, a machine-readable medium can be a tangible medium that contains or stores a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can include but is not limited to an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of the machine-readable storage medium will include one or more of: a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0185] In a first aspect, according to one or more embodiments of the present disclosure, a table data processing method is provided, comprising:

[0186] In response to a triggering operation on a field control in a table page, a field interface is displayed;

[0187] In the field interface, a field component and a first field are determined;

[0188] According to the field component and the first field, a second field is displayed in the table page, and second data is generated 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.

[0189] According to one or more embodiments of the present 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.

[0190] According to one or more embodiments of the present disclosure, the field interface includes a component selection control and a field selection control; in the field interface, the field component and the first field are determined, comprising:

[0191] In response to an operation input by a user on the component selection control, a selected component is determined as the field component;

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

[0193] According to one or more embodiments of the present disclosure, the field interface further includes a field name editing window and a confirmation control, and a second field is displayed in the table page according to the field component and the first field, including:

[0194] Obtaining a target name input in the field name editing window;

[0195] In response to a click operation on the confirmation control, a second field is generated according to the target name, and the name of the second field is the target name;

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

[0197] According to one or more embodiments of the present disclosure, the second field is displayed in the table page, including:

[0198] In the table page, a new column is created after the column where the first field is located;

[0199] The field of the new column is set to the second field.

[0200] According to one or more embodiments of the present disclosure, the second data is generated in the data column corresponding to the second field, including:

[0201] Determining a target data format corresponding to the second field;

[0202] According to the target data format, the first data corresponding to the second data is generated by the field component, and the data format of the second data is the target data format;

[0203] The second data corresponding to the first data is displayed in the table page.

[0204] According to one or more embodiments of the present disclosure, the second data corresponding to the first data is generated by the field component according to the target data format, including:

[0205] The first data is input into the formula data corresponding to the field component, and the output data corresponding to the formula data is output;

[0206] According to the target data format, the output data is converted into second data.

[0207] In a second aspect, according to one or more embodiments of the present disclosure, a table data processing apparatus is provided, including:

[0208] The display module is configured to display a field interface in response to a triggering operation on a field control in a table page.

[0209] The determination module is configured to determine a field component and a first field in the field interface.

[0210] 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 by the field component based on first data in a data column corresponding to the first field; and a field type of the second field is determined based on the field component.

[0211] According to one or more embodiments of the present 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.

[0212] According to one or more embodiments of the present disclosure, the field interface includes a component selection control and a field selection control; and the determination module is specifically configured to:

[0213] determine the selected component as the field component in response to an operation input by a user on the component selection control;

[0214] select the first field in at least one field of the table page in response to an operation input on the field selection control.

[0215] According to one or more embodiments of the present disclosure, the field interface further includes a field name editing window and a confirmation control; and the processing module is specifically configured to:

[0216] obtain a target name input in the field name editing window;

[0217] generate a second field according to the target name in response to a click operation on the confirmation control, the name of the second field being the target name;

[0218] create a binding relationship among 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 according to the first data.

[0219] According to one or more embodiments of the present disclosure, the processing module is specifically configured to:

[0220] create a new column after a column where the first field is located in the table page;

[0221] set a field of the new column as the second field.

[0222] According to one or more embodiments of the present disclosure, the processing module is specifically configured to:

[0223] determine a target data format corresponding to the second field;

[0224] generate, according to the target data format, second data corresponding to the first data through the field component, the second data being in the target data format;

[0225] display the second data corresponding to the first data in the table page.

[0226] According to one or more embodiments of the present disclosure, the processing module is specifically configured to:

[0227] input the first data into formula data corresponding to the field component, and output output data corresponding to the formula data;

[0228] convert the output data into second data according to the target data format.

[0229] In a third aspect, according to one or more embodiments of the present disclosure, an electronic device is provided, comprising at least one processor and a memory;

[0230] The memory stores computer-executable instructions;

[0231] The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor executes the table data processing method as described in the above first aspect and various possible designs of the first aspect.

[0232] In a fourth aspect, according to one or more embodiments of the present disclosure, a computer-readable storage medium is provided, and the computer-readable storage medium stores computer-executable instructions, when a processor executes the computer-executable instructions, the table data processing method as described in the above first aspect and various possible designs of the first aspect is implemented.

[0233] In a fifth aspect, according to one or more embodiments of the present disclosure, a computer program product is provided, comprising a computer program, when a processor executes the computer program, the table data processing method as described in the above first aspect and various possible designs of the first aspect is implemented

[0234] The above description merely illustrates the preferred embodiments of the disclosure and a principle for applying the technologies. It is understood by those skilled in the art that the disclosed scope of the disclosure is not limited to the technical solutions formed by the specific combinations of the technical features described above, and should also cover other technical solutions formed by the combinations of the technical features described above or their equivalent features without departing from the disclosed concept. For example, the technical solutions formed by the mutual replacement of the above-described features and the technical features with similar functions disclosed in the disclosure (but not limited to) can be used.

[0235] Further, although operations are depicted in a particular, sequential order, this should not be understood as requiring or implying that the operations are performed in the order illustrated or sequentially. In certain circumstances, multitasking and parallel processing can be advantageous. Likewise, although specific implementation details are included for the purpose of providing a thorough disclosure, these should not be construed as limitations on the scope of the disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable sub-combination.

[0236] Although the subject matter has been described in language specific to structural features and / or methodological acts, it is to be understood that the subject defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.

Claims

1. A method for processing tabular data, comprising: In response to a triggering action on a field control in the table page, display the field interface; In the field interface, determine the field component and the first field; 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 data 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.

2. The method according to 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, wherein, 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: In response to the user's input on the component selection control, the selected component is determined as the field component; 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.

4. The method according to any one of claims 1-3, wherein, The field interface also includes a field name editing window and a confirmation control. Based on the field component and the first field, a second field is displayed on the table page, including: Get the target name entered in the field name editing window; 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; 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.

5. The method according to claim 4, wherein, The second field, displayed on the table page, includes: In the table page, a new column is created after the column containing the first field; Set the field of the newly added column to the second field.

6. The method according to any one of claims 1-5, wherein, Generate second data in the data column corresponding to the second field, including: Determine the target data format corresponding to the second field; 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; The second data corresponding to the first data is displayed on the table page.

7. The method according to claim 6, wherein, Based on the target data format, the second data corresponding to the first data is generated through the field component, including: Input the first data into the formula data corresponding to the field component, and output the output data corresponding to the formula data; The output data is converted into second data according to the target data format.

8. A tabular data processing apparatus, comprising: 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 used to determine the field components and the first field in the field interface; 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 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.

9. An electronic device, comprising: 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 7.

10. A computer-readable storage medium storing computer-executable instructions that, when executed by a processor, implement the tabular data processing method as described in any one of claims 1 to 7.

11. A computer program product comprising a computer program that, when executed by a processor, implements the method for tabular data processing as described in any one of claims 1 to 7.

Images