Table processing method and device, terminal and storage medium

Abstract

The present disclosure provides a table processing method, device, terminal and storage medium. The table processing method comprises: in response to a first operation event, creating one or more content fields in a table, the content fields being pre-associated with content types, and the content fields being associated with a target field configuration in the table; obtaining content of a file in a cell of the target field, and writing the content of the file into a cell of the content field; wherein content corresponding to the content type associated with the content field is written into the cell of the content field; the file is an attachment in the cell of the target field, or the file is a file pointed to by an address recorded in the cell of the target field. The method of the present disclosure can improve processing efficiency.

Description

TECHNICAL FIELD

[0001] The present disclosure relates to the technical field of computer, and particularly relates to a table processing method and device, a terminal and a storage medium. BACKGROUND

[0002] A table, such as a table in a table document or a table in a text document, has cells corresponding to fields. A field is a property of a row or a column of cells, which describes the type of content that can be carried in the cell with the property. The field is usually displayed in the form of a column name. For example, a date field indicates that the content carried in the cell with the field is a date. SUMMARY

[0003] The present disclosure provides a table processing method and device, a terminal and a storage medium.

[0004] The present disclosure adopts the following technical solutions.

[0005] In some embodiments, the present disclosure provides a table processing method, comprising:

[0006] In response to a first operation event, one or more content fields are created in a table, the content fields are pre-associated with content types, and the content fields are associated with a target field in the table;

[0007] The content of a file in a cell of the target field is obtained, and the content of the file is written into a cell of the content field;

[0008] In the cell of the content field, content corresponding to the content type associated with the content field is written; the file is an attachment in the cell of the target field, or the file is a file pointed to by an address recorded in the cell of the target field.

[0009] In some embodiments, the present disclosure provides a table processing device, comprising:

[0010] A creation unit is configured to, in response to a first operation event, create one or more content fields in a table, the content fields are pre-associated with content types, and the content fields are associated with a target field in the table;

[0011] A control unit is configured to obtain the content of a file in a cell of the target field, and write the content of the file into a cell of the content field;

[0012] In the cell of the content field, content corresponding to the content type associated with the content field is written; the file is an attachment in the cell of the target field, or the file is a file pointed to by an address recorded in the cell of the target field.

[0013] In some embodiments, the present disclosure provides a terminal, comprising: at least one memory and at least one processor;

[0014] The memory is configured to store program code, and the processor is configured to invoke the program code stored in the memory to execute the method described above.

[0015] In some embodiments, the present disclosure provides a computer readable storage medium for storing program code, which, when executed by a computer, causes the computer to execute the method described in any one of the above.

[0016] The table processing method provided by the embodiments of the present disclosure can identify the content of the file in the cell of the target field, and then write the content therein into the cell of the corresponding content field according to the content type. In this way, the user does not need to manually check the content of the file and write it into the cell of the content field, reducing the user's operation and greatly improving the processing efficiency of the file. In particular, when multiple files need to be extracted according to the content type, the processing efficiency can be greatly improved. BRIEF DESCRIPTION OF DRAWINGS

[0017] The above and other features, advantages, and aspects of the embodiments of the present disclosure will become more apparent by describing in detail the embodiments thereof with reference to the attached drawings. The same or similar components are denoted by the same or similar reference numerals throughout the drawings. It should be understood that the drawings are not necessarily to scale, and elements and features are not necessarily drawn to scale.

[0018] Figure 1 is a flowchart of the table processing method of the embodiments of the present disclosure.

[0019] Figures 2 to 15 is a schematic diagram of a display interface of the embodiments of the present disclosure.

[0020] Figure 16 is a structural schematic diagram of an electronic device of the embodiments of the present disclosure. DETAILED DESCRIPTION

[0021] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although some embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure can be implemented in various forms, and should not be interpreted as being limited to the embodiments set forth herein, but rather, these embodiments are provided to more thoroughly and completely understand the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes, and are not intended to limit the scope of protection of the present disclosure.

[0022] It should be understood that each of the steps recited in the method embodiments of the present disclosure can be performed in sequence and / or in parallel. In addition, the method embodiments can include additional steps and / or omit performing the steps shown. The scope of the present disclosure is not limited in this respect.

[0023] The term "comprising" and variations thereof as used herein are open-ended, that is, mean "including but not limited to". The term "based on" means "based, at least in part, on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Related terms are defined in the description that follows.

[0024] It should be noted that the terms "first", "second", and the like in the present disclosure are merely intended to distinguish different devices, modules or units, and do not imply the order or the mutual dependency of the functions performed by these devices, modules or units.

[0025] It should be noted that the modification "one" mentioned in the present disclosure is illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise explicitly indicated in the context, it should be understood as "one or more".

[0026] The names of the messages or information exchanged between the plurality of devices in the embodiments of the present disclosure are only for illustrative purposes, and are not intended to limit the scope of the messages or information.

[0027] The schemes provided by the embodiments of the present application will be described in detail below with reference to the accompanying drawings.

[0028] As shown in Figure 1 , Figure 1 is a flowchart of a table processing method according to an embodiment of the present disclosure, comprising the following steps.

[0029] S11, in response to a first operation event, creating one or more content fields in a table.

[0030] In some embodiments, the executor of the method proposed by the present disclosure can be a terminal, a server, etc. The terminal can be a mobile phone, a computer, etc. The first operation event can include one or more operations. The table can be a table in a table document or a table in a non-table document (e.g. a text document). The table document or the non-table document can be a local document or an online document. A field is a property of a cell, which usually describes the type of the content stored in the cell. The field is usually displayed in the form of a column name, indicating that the cells in this column all have this field as a property. The content field is pre-associated with a content type, and the content field is associated with a target field in the table. One or more content fields are created in the table through the first operation event, and the target field is also determined.

[0031] S12, obtaining the content of the file in the cell of the target field, and writing the content of the file into the cell of the content field.

[0032] In some embodiments, the file is an attachment in a cell of the target field, i.e. the cell of the target field can be used to store the file itself, or the file is a file pointed by an address recorded in the cell of the target field, i.e. the file in the cell of the target field refers to a file found by the address stored in the cell of the target field. The content corresponding to the content type associated with the content field is written in the cell of the content field. The content in the file can be recognized by an optical character recognition technique, and then the recognized content of the file is written in the cell of the content field according to the content type. For example, the content type associated with the content field is an invoice header, and then the specific content of the invoice header in the content of the file is written in the cell of the content field. If the content type associated with another content field is an invoice number, then the specific content of the invoice number in the content of the file is written in the cell of the content field. In some embodiments, the cell of the target field is also in the table, and the content of the file is written in the cell of the content field in the same record as the file, e.g. one row is one record, and the content of the file is written in the cell of the content field in the same row as the file. The cell of the target field can be multiple, and can be in multiple different records. There can be files in multiple cells, and then the step S12 is performed on the files in the multiple cells of the target field to recognize the content in the multiple files and write the content in the cells of the content fields in the respective records. In some embodiments, when the content field is created, the content field associated with the required content type can be selected, and then the content in the file does not need to be all written in the cell of the content field, and part of the content in the file can not be written in the cell of the content field. Of course, the content field corresponding to each content type can also be selected, and then the content of each content type in the content of the file is written in the cell of the corresponding content field. In addition, the content type associated with the content field is not limited to one, and one content field can correspond to one or more content types, so that multiple content types of content can be written in one cell of the content field, which facilitates the processing of the content with strong relevance in the same cell. In some embodiments, the content type associated with the content field can be pre-set, which can be related to the content type of the file, e.g. when the file is an invoice, the content type associated with the content field can be an invoice header, an invoice amount, etc.

[0033] In some embodiments of the present disclosure, a table processing method is provided, which can identify the content of a file in a cell of a target field, and then write the content in the cell according to the content type, so that the user does not need to manually check the content of the file and write it into the cell of the content field, reducing the user's operation and greatly improving the processing efficiency of the file. In particular, when the content of the file in multiple different records needs to be extracted according to the content type, the processing efficiency can be greatly improved.

[0034] In some embodiments of the present disclosure, one or more content fields include at least one of the following: a content field associated with multiple content types, or a content field associated with a content type. In some embodiments, multiple content fields can be created in the table, one of which can be associated with multiple or even all content types, and the other content fields can be associated with only one content type. In this way, in the cell of one content field, the content corresponding to multiple content types in the file can be written, and in the cell of the other content field, only the content corresponding to one content type can be written. For details, please refer to Figure 8 , the file in the cell of the target field is an invoice, and Figure 8 The fields of "invoice" and "invoice header" to "payee" on the right side of "invoice" are content fields, and the "invoice" field is associated with the fields of all content types in the invoice. At this time, after identifying the content of the file, the content of the file can be written into the cell of the invoice field, and can be written in Json format or xml format for subsequent processing. The content of the other fields is only the content corresponding to one content type, for example, the "invoice header" field only writes the content of the invoice header in the file. In some embodiments, the content of the cell of the field associated with one content type can be from the cell of the field associated with multiple or all content types, so that the content of the two cells can be synchronized.

[0035] In some embodiments of the present disclosure, in response to a first operation event, one or more content fields are created in the table, including: in response to a first operation event, one or more content fields are created in the table, and one of the content fields is determined as a target field.

[0036] In some embodiments, the target field can be one of the content fields, and the cell of the target field has two field attributes. The cell of the target field stores the file and the content corresponding to the associated content type. In some embodiments, as shown in Figure 4 , the table in Figure 4 is a table, and the file is an invoice. By clicking the box with a plus sign inside to the right of "date", a new field is triggered, and then a table as shown in Figure 4The illustrated field interface has a control for selecting a field type, and after the control is triggered, a sub-level interface can be displayed, in which fields can be selected. The fields in the sub-level interface are a special kind of field that encapsulates processing logic, which can be used to process the content in the cells of other fields according to the encapsulated processing logic and write the content into the cells under the field. That is, the content field in the table of the present disclosure can be Figure 4 an OCR (Optical Character Recognition) invoice recognition in which the field is used to identify the content in the invoice by OCR technology and write the content into the cells of the content field according to the content type. After the field is selected, as shown in Figure 7 , the field interface changes, with the title Invoice (the field is the target field), and other content fields (invoice header, etc.) that can be selected are displayed. After clicking OK, the table with the added content field is displayed as shown in Figure 8 , in which the invoice field as a content field also serves as a target field, which can store invoices (files) and corresponding content of the target type. Triggering the cell under the Figure 8 invoice field can select to add an invoice, as shown in Figure 12 . After adding the invoice, the icon of the invoice will be displayed in the cell, and then as shown in Figure 13 , the content in the invoice will be identified and filled into the cells of other content fields in the same record. By continuing to trigger the cell under the invoice field, as shown in Figure 14 , the invoice preview of the existing invoice in the cell can be displayed, and the invoice can be continuously added. If two or more files are added in a cell, the content of the two or more files can be displayed in the cells of other content fields, respectively.

[0037] In some embodiments of the present disclosure, in response to a first operation event, one or more content fields are created in a table, including: in response to the first operation event, one or more content fields are created in the table, and a field different from the content field is determined as a target field. In some embodiments of the present disclosure, the target field can be another field different from the content field, at which time the cell of the content field can be used only to store the content in the file, but not the file.

[0038] In some embodiments of the present disclosure, in response to a first operation event, one or more content fields are created in a table, and a field different from the content field is determined as a target field, including: in response to the first operation event, one or more content fields are created in the table, and an existing field in the table is selected as the target field, or in response to the first operation event, one or more content fields are created in the table, and the target field is created.

[0039] In some embodiments, when the cell of the content field cannot store the file, the file needs to be stored through the cell of other fields, at this time, some embodiments can select an existing field. As shown in Figure 2 , the table displays the field interface and the sub-interface as shown in Figure 2 by triggering the control of creating a new field. Selecting “OCR invoice recognition” in the field interface will make the field interface display the configuration area as shown in Figure 3 , in which the existing field can be selected as the OCR recognition source, that is, the target field. Here, the “invoice source” field is selected as the OCR recognition source, and then after clicking OK, the content field will be added in the table as shown in Figure 6 . In some other embodiments, a new field can be created as the target field, as shown in Figure 4 , at this time, there is no “invoice source” field, that is, there is no cell of the existing field to store the file. After selecting “OCR invoice recognition”, a new field can be selected as the target field in the configuration area, as shown in Figure 5 , and after clicking OK, the target field and the content field will be created in the table as shown in Figure 6 . Therefore, in this embodiment, when the cell of the content field cannot store the file, the file can be stored through the cell of the existing or newly created field of other fields. In the cell of the target field “invoice source” as shown in Figure 6 , the invoice can be added, and then the content of the invoice can be recognized in the cells of the content fields “invoice” and “invoice header” as shown in Figure 9 .

[0040] In some embodiments of the present disclosure, in response to a first operation event, one or more content fields are created in a table, including: in response to an operation of creating a content field, a field interface is displayed, wherein a recommended content field is displayed in the field interface, the recommended content field is associated with the content recorded in the file; and according to the selection result of the recommended content field, one or more content fields are created.

[0041] In some embodiments, as shown in Figure 3 , Figure 4 and Figure 7 , when the content field is created, the recommended content field is displayed in the field interface. The recommended field can be determined according to the content recorded in the file, as shown in Figure 3 , Figure 4 and Figure 7 .As shown, if the file is an invoice, the recommended fields are "Invoice Title", "Invoice Number", "Invoice Amount", "Total Amount", "Total Tax Amount", and "Payee". Users can select one or more of these fields as needed and then click "OK" to create the selected recommended fields.

[0042] In some embodiments of this disclosure, one or more of the content fields are created based on the selection result of the recommended content field, including: in response to not selecting a recommended content field, creating a content field in the table that is associated with multiple content types; or, in response to selecting a recommended content field, creating a content field in the table that is associated with multiple content types, and creating the selected recommended content field in the table.

[0043] In some embodiments, regardless of whether a recommended content field is selected, a content field associated with multiple content types is created by default. These associated content types can be pre-defined and are related to the file type. If a recommended content field is selected, it is created as part of the newly created content field.

[0044] In some embodiments of this disclosure, obtaining the content of a file in a cell of the target field and writing the content of the file into a cell of the content field includes: automatically executing the step of obtaining the content of the file in the cell of the target field and writing the content of the file into a cell of the content field in response to a new file being added to a cell of the target field, a new file address being added to a cell of the target field, or a change in an existing file in a cell of the target field; or, executing the step of obtaining the content of the file in a cell of the target field and writing the content of the file into a cell of the content field in response to a second operation event that updates the content field.

[0045] In some embodiments, the content in a cell of a content field can be updated automatically or manually. In the case of automatic updates, if... Figure 6 Add the file to the cell under the target field "Invoice Source" in the table shown, and it will be as follows: Figure 9 As shown, the content corresponding to the associated content type is automatically written into the cells of the content field. If the content of the file changes, the content in the cells of the content field will also be automatically updated. In other embodiments, the user can also manually select the content field to be updated, and then update the content of the cells under the content field to be updated. Specifically, as shown... Figure 10As shown, the option list of the content field can be called up by, for example, right-clicking or long-pressing, which has a "update data" control, and after triggering the control, the content of the file will be identified and the content of the cells under the field will be updated accordingly. Alternatively, as shown, the attribute panel of the content field can be called up, and the "update data" control is also provided in the attribute interface of the content field, and after triggering the control, the content of the cells under the content field will be updated. In some embodiments, as shown, the content in the cells of the content field associated with one content type is derived from the content in the cells of the content field associated with multiple content types, and therefore, when the content in the cells of the content field associated with one content type is updated, the content in the cells of the content field associated with multiple content types can be automatically updated to ensure consistency of the content of the two. Figure 11 Figure 11

[0046] In some embodiments of the present disclosure, further comprising: in response to a third operation event on the content field, changing the content field into a field of other field type. In some embodiments, as shown, the attribute interface of any content field has a control for selecting the field type, by which the field type of the content field can be changed, and by triggering the control, as shown, Figure 11 Figure 15

[0047] In order to better illustrate the method proposed in the present disclosure, a specific use scenario is proposed below. In this use scenario, the file is an invoice. A table is created to manage the invoice, and the "invoice source" field in the table can be used as the target field, and the cells under the target field are used to store the invoice itself or the address of the invoice. The user selects the new "OCR invoice recognition" field shortcut, as shown, Figure 3 In the field interface, the user can select an existing field as the target field (of course, a new field can also be created as the target field), and the recommended content field is displayed in the field interface, and the user can select one or more recommended content fields, and the recommended content field can correspond to a content type, and then as shown, Figure 8 The pre-set field associated with multiple content types and the selected recommended content field are created as content fields. As shown, Figure 9 ​​​​If the cell of the target field has a file or an address of a file, the file will be automatically identified, and the content of the file will be written into the cell of the content field in the same record, where the content of each content type is stored in the cell of the content field in the form of Json, and the cell of the content field stores the content corresponding to the content type associated with the content field. When the file is updated, the content in the cell of the content field can be automatically updated, or the user can choose to manually update. For the content field, the user can choose to change the field type of the content field to another field type, for example, to a single selection field. In this embodiment, the content of the file in the cell under the target field can be identified and written into the cell of the content field. The cell under the target field can have multiple cells, and different files are located in different records (rows). Then the content in the file in each record will be written into the corresponding record, so that the batch file identification work can be quickly completed, and the processing efficiency is improved. The user only needs to put the file to be processed into the cell of the target field.

[0048] In the embodiments of the present disclosure, a table processing device is also provided, which comprises:

[0049] a creating unit configured to, in response to a first operation event, create one or more content fields in a table, the content fields being pre-associated with content types, and the content fields being associated with a target field in the table;

[0050] a control unit configured to obtain content of a file in a cell of the target field, and write the content of the file into a cell of the content field;

[0051] wherein the content corresponding to the content type associated with the content field is written into the cell of the content field; the file is an attachment in the cell of the target field, or the file is a file pointed by an address recorded in the cell of the target field.

[0052] In some embodiments, the one or more content fields comprise at least one of the following: a content field associated with multiple content types, or a content field associated with one content type.

[0053] In some embodiments, in response to the first operation event, creating one or more content fields in the table comprises: in response to the first operation event, creating one or more content fields in the table, and determining one of the content fields as the target field; or,

[0054] in response to the first operation event, creating one or more content fields in the table, and determining a field different from the content fields as the target field.

[0055] In some embodiments, in response to the first operation event, creating one or more content fields in the table and determining a field different from the content fields as the target field comprises: in response to the first operation event, creating one or more content fields in the table and selecting an existing field in the table as the target field, or in response to the first operation event, creating one or more content fields in the table and creating the target field.

[0056] In some embodiments, in response to the first operation event, creating one or more content fields in the table comprises: in response to an operation of creating a content field, displaying a field interface, wherein a recommended content field associated with the content recorded in the file is displayed in the field interface; and creating one or more content fields according to a selection result of the recommended content field.

[0057] In some embodiments, creating one or more content fields according to a selection result of the recommended content field comprises: in response to no selection of the recommended content field, creating a content field associated with multiple content types in the table; or in response to selection of the recommended content field, creating a content field associated with multiple content types in the table and creating the selected recommended content field in the table.

[0058] In some embodiments, the unit for obtaining the content of the file in the cell of the target field and writing the content of the file into the cell of the content field comprises: in response to addition of a file in the cell of the target field, addition of an address of a file in the cell of the target field, or change of an original file in the cell of the target field, automatically performing the steps of obtaining the content of the file in the cell of the target field and writing the content of the file into the cell of the content field; or in response to a second operation event of updating the content field, performing the steps of obtaining the content of the file in the cell of the target field and writing the content of the file into the cell of the content field.

[0059] In some embodiments, the control unit is further configured to: in response to a third operation event on the content field, change the content field into a field of another field type.

[0060] For the embodiments of the device, since they basically correspond to the embodiments of the method, the relevant parts are described in the part of the description of the embodiments of the method. The above-described device embodiments are only illustrative, and the modules described as separate modules can or can not be separate. Part or all of the modules can be selected according to actual needs to achieve the purpose of the embodiments. Those skilled in the art can understand and implement without creative labor.

[0061] The above describes the method and apparatus of the present disclosure based on the embodiments and application examples. In addition, the present disclosure also provides a terminal and a storage medium, which are described below.

[0062] Reference is made below to Figure 16 which shows a structural diagram of an electronic device (e.g., a terminal device or a server) 800 suitable for implementing embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure can include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (Personal Digital Assistant), a PAD (Tablet Personal Computer), a PMP (Portable Multimedia Player), a vehicle terminal (e.g., a car navigation terminal), and the like, and a fixed terminal such as a digital TV, a desktop computer, and the like. The electronic device shown in the figure is only an example, and should not impose any limitation on the functions and use range of the embodiments of the present disclosure.

[0063] As shown in Figure 16 , the electronic device 800 can include a processing device (e.g., a central processor, a graphics processor, etc.) 801, which can perform various appropriate actions and processes according to programs stored in a read-only memory (ROM) 802 or loaded into a random access memory (RAM) 803 from a storage device 808. In the RAM 803, various programs and data required for the operation of the electronic device 800 are also stored. The processing device 801, the ROM 802, and the RAM 803 are connected to each other through a bus 804. An input / output (I / O) interface 805 is also connected to the bus 804.

[0064] Generally, the following devices can be connected to the I / O interface 805: an input device 806 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, and the like; an output device 807 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, and the like; a storage device 808 including, for example, a magnetic tape, a hard disk, and the like; and a communication device 809. The communication device 809 can allow the electronic device 800 to communicate with other devices wirelessly or by wire to exchange data. Although the electronic device 800 with various devices is shown in the figure, it should be understood that it is not required to implement or have all the devices shown. More or fewer devices can be alternatively implemented or provided.

[0065] In particular, the processes described above with reference to the flowcharts can be implemented as a computer software program in accordance with embodiments of the present disclosure. 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 comprising program code for performing the methods illustrated by the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via the communication device 809, or installed from the storage device 808, or installed from the ROM 802. When the computer program is executed by the processing device 801, the above-mentioned functions defined in the methods of the embodiments of the present disclosure are performed.

[0066] It should be noted that the computer readable medium described above in the present disclosure can be a computer readable signal medium or a computer readable storage medium or any combination thereof. The computer readable storage medium can be, for example but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or apparatus, or any suitable combination of the foregoing. 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, the computer readable storage medium can be any tangible medium that contains or stores a program used by or in connection with an instruction execution system, apparatus or device. In the present disclosure, the computer readable signal medium can include a data signal carried in a baseband or as part of a carrier wave, in which the computer readable program code is carried. Such a propagated data signal can take any of a variety of forms, including but not limited to electro-magnetic, optical, or any suitable combination thereof. The computer readable signal medium can also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code contained in the computer readable medium can be transmitted by any suitable medium, including but not limited to wire, cable, optical fiber, RF, etc., or any suitable combination of the foregoing.

[0067] In some embodiments, the client, server, or other computing machines can communicate information using any known or future developed end-to-end communication protocol, such as the HyperText Transfer Protocol (HTTP), and can be interconnected via any form or medium of digital data communication (for example, a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the Internet, and peer-to-peer networks (for example, ad hoc peer-to-peer networks), as well as any current or future developed network.

[0068] The computer-readable medium described above can be included within the electronic device described above; or can exist separately from the electronic device without being assembled therein.

[0069] 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 method of the present disclosure described above.

[0070] Computer program code for carrying out operations of the present disclosure can be written in any one or combination of one or more programming languages or combinations thereof, including an object-oriented programming language such as Java, Smalltalk, C++, or a conventional procedural programming language 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).

[0071] The computer program product of the first aspect can include one or more non-transitory computer-readable media storing instructions for one or more programmable processors. The instructions are executable by the one or more programmable processors to perform the operations of the method of the first aspect.

[0072] The units described in the embodiments of the present disclosure can be implemented by hardware, software, or a combination of hardware and software. In some cases, the names of the units do not constitute a limitation on the units themselves.

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

[0074] In the context of the present 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, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium will include one or more lines of electrical connections, portable computer disks, hard disk drives, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or Flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination of the foregoing.

[0075] According to one or more embodiments of the present disclosure, a table processing method is provided, including:

[0076] In response to the first operation event, one or more content fields are created in the table, the content fields being pre-associated with content types, and the content fields being associated with the target field configuration in the table;

[0077] The content of the file in the cell of the target field is acquired, and the content of the file is written into the cell of the content field;

[0078] The content corresponding to the content type associated with the content field is written into the cell of the content field; the file is an attachment in the cell of the target field, or the file is a file pointed to by an address recorded in the cell of the target field.

[0079] According to one or more embodiments of the present disclosure, a table processing method is provided, and one or more of the content fields include at least one of the following: a content field associated with multiple content types, or a content field associated with a content type.

[0080] According to one or more embodiments of the present disclosure, a table processing method is provided, in response to a first operation event, one or more content fields are created in the table, including:

[0081] In response to the first operation event, one or more content fields are created in the table, and one of the content fields is determined as the target field; or,

[0082] In response to the first operation event, one or more content fields are created in the table, and a field different from the content field is determined as the target field.

[0083] According to one or more embodiments of the present disclosure, a table processing method is provided, in response to a first operation event, one or more content fields are created in the table, and a field different from the content field is determined as the target field, including:

[0084] In response to the first operation event, one or more content fields are created in the table, and an existing field in the table is selected as the target field, or,

[0085] In response to the first operation event, one or more content fields are created in the table, and the target field is created.

[0086] According to one or more embodiments of the present disclosure, a table processing method is provided, in response to a first operation event, one or more content fields are created in the table, including:

[0087] In response to the operation of creating a content field, a field interface is displayed, and in the field interface, a recommended content field is displayed, the recommended content field being associated with the content recorded in the file;

[0088] According to the selection result of the recommended content field, one or more content fields are created.

[0089] According to one or more embodiments of the present disclosure, a table processing method is provided, according to the selection result of the recommended content field, one or more content fields are created, including:

[0090] In response to no recommended content field being selected, a content field associated with multiple content types is created in the table; or,

[0091] In response to a recommended content field being selected, a content field associated with multiple content types is created in the table, and the selected recommended content field is created in the table.

[0092] According to one or more embodiments of the present disclosure, a table processing method is provided, the content of a file in a cell of a target field is obtained, and the content of the file is written into a cell of a content field, including:

[0093] In response to a file being added in the cell of the target field, an address of the file being added in the cell of the target field, or the original file in the cell of the target field being changed, the step of obtaining the content of the file in the cell of the target field and writing the content of the file into the cell of the content field is automatically executed;

[0094] Alternatively, in response to a second operation event of updating the content field, the step of obtaining the content of the file in the cell of the target field and writing the content of the file into the cell of the content field is executed.

[0095] According to one or more embodiments of the present disclosure, a table processing method is provided, further including:

[0096] In response to a third operation event on the content field, the content field is changed to a field of another field type.

[0097] According to one or more embodiments of the present disclosure, a table processing device is provided, including:

[0098] A creation unit is configured to create one or more content fields in a table in response to a first operation event, the content fields being pre-associated with content types, and the content fields being associated with a target field in the table;

[0099] A control unit is configured to obtain the content of a file in a cell of the target field, and write the content of the file into a cell of the content field.

[0100] Specifically, the content corresponding to the content type associated with the content field is written into the cell of the content field; the file is an attachment in the cell of the target field, or the file is the file pointed to by the address recorded in the cell of the target field.

[0101] According to one or more embodiments of the present disclosure, a terminal is provided, including: at least one memory and at least one processor;

[0102] The at least one memory is used to store program code, and the at least one processor is used to call the program code stored in the at least one memory to execute the method described in any one of the above.

[0103] According to one or more embodiments of the present disclosure, a computer-readable storage medium is provided for storing program code that, when executed by a computer, causes the computer to perform any of the methods described above.

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

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

[0106] 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 table processing method, characterized in that, include: In response to the first operation event, one or more content fields are created in the table, the content fields being pre-associated with content types and configured with association relationships with target fields in the table; Obtain the content of the file from the cell of the target field, and write the content of the file into the cell of the content field; Specifically, the content corresponding to the content type associated with the content field is written into the cell of the content field; the file is an attachment in the cell of the target field, or the file is the file pointed to by the address recorded in the cell of the target field; In response to a first operation event, creating one or more content fields in a table includes: displaying a field interface in response to the operation of creating content fields, wherein a recommended content field is displayed in the field interface, the recommended content field being associated with the content recorded in the document; and creating one or more of the content fields based on the selection result of the recommended content field. Based on the selection result of the recommended content field, create one or more of the content fields, including: in response to not selecting a recommended content field, create a content field in the table that is associated with multiple content types; or, in response to selecting a recommended content field, create a content field in the table that is associated with multiple content types, and create the selected recommended content field in the table.

2. The method according to claim 1, characterized in that, One or more of the content fields include at least one of the following: content fields associated with multiple content types, or content fields associated with one content type.

3. The method according to claim 1, characterized in that, In response to the first action event, create one or more content fields in the table, including: In response to the first operation event, create one or more content fields in the table and determine one of said content fields as the target field; or, In response to the first operation event, one or more content fields are created in the table, and a field different from the content fields is identified as the target field.

4. The method according to claim 3, characterized in that, In response to the first operation event, one or more content fields are created in the table, and a field different from the content fields is identified as the target field, including: In response to the first operation event, one or more content fields are created in the table, and an existing field in the table is selected as the target field, or... In response to the first operation event, create one or more content fields in the table, and create the target field.

5. The method according to claim 1, characterized in that, Retrieving the content of a file from a cell in the target field and writing the file content into a cell in the content field includes: In response to the addition of a file to the cell of the target field, the addition of a file address to the cell of the target field, or the change of an existing file in the cell of the target field, the steps of retrieving the content of the file in the cell of the target field and writing the content of the file into the cell of the content field are automatically executed. or, In response to a second operation event that updates the content field, the steps of retrieving the content of a file from a cell in the target field and writing the content of the file into a cell in the content field are performed.

6. The method according to claim 1, characterized in that, Also includes: In response to a third operation event on the content field, the content field is changed to a field of another field type.

7. A form processing device, characterized in that, include: A creation unit is used to create one or more content fields in a table in response to a first operation event. The content fields are pre-associated with content types and are configured to be associated with target fields in the table. The control unit is used to obtain the content of the file in the cell of the target field and write the content of the file into the cell of the content field; Specifically, the content corresponding to the content type associated with the content field is written into the cell of the content field; the file is an attachment in the cell of the target field, or the file is the file pointed to by the address recorded in the cell of the target field; In response to a first operation event, creating one or more content fields in a table includes: displaying a field interface in response to the operation of creating content fields, wherein a recommended content field is displayed in the field interface, the recommended content field being associated with the content recorded in the document; and creating one or more of the content fields based on the selection result of the recommended content field. Based on the selection result of the recommended content field, create one or more of the content fields, including: in response to not selecting a recommended content field, create a content field in the table that is associated with multiple content types; or, in response to selecting a recommended content field, create a content field in the table that is associated with multiple content types, and create the selected recommended content field in the table.

8. A terminal, comprising: At least one memory and at least one processor; The at least one memory is used to store program code, and the at least one processor is used to call the program code stored in the at least one memory to execute the method of any one of claims 1 to 6.

9. A computer-readable storage medium for storing program code that, when executed by a computer, causes the computer to perform the method of any one of claims 1 to 6.

Images