Table processing method and apparatus, and terminal and storage medium

Abstract

Provided in the present disclosure are a table processing method and apparatus, and a terminal and a storage medium. The table processing method comprises: in response to a first operation event, creating one or more content fields in a table, wherein each content field is pre-associated with a content type, and an association relationship is configured for the content field and a target field in the table; and acquiring 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, wherein content corresponding to the content type associated with the content field is written into the cell of the content field, and 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 in the present disclosure can improve the processing efficiency.

Description

Table processing methods, devices, terminals and storage media

[0001] This application claims priority to Chinese Patent Application No. 202410796312.1, filed on June 19, 2024, the disclosure of which is incorporated herein by reference in its entirety. Technical Field

[0002] This disclosure relates to the field of computer technology, and in particular to a table processing method, apparatus, terminal, and storage medium. Background Technology

[0003] Tables, such as tables within a tabular document or a text document, have cells that correspond to fields. A field is an attribute of a row or column of cells, describing the type of content that a cell with that attribute can contain. Fields are typically displayed as column names. For example, a date field indicates that the content contained in a cell with that field is a date. Summary of the Invention

[0004] This disclosure provides a table processing method, apparatus, terminal, and storage medium.

[0005] The following technical solution is adopted in this disclosure.

[0006] In some embodiments, this disclosure provides a table processing method, including:

[0007] 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;

[0008] 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;

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

[0010] In some embodiments, this disclosure provides a form processing apparatus, including:

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

[0012] 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;

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

[0014] In some embodiments, this disclosure provides a terminal, including: at least one memory and at least one processor;

[0015] The memory is used to store program code, and the processor is used to call the program code stored in the memory to execute the above method.

[0016] In some embodiments, this disclosure provides a computer-readable storage medium for storing program code that, when executed by a computer, causes the computer to perform any of the methods described above. Attached Figure Description

[0017] The above and other features, advantages, and aspects of the embodiments of this disclosure will become more apparent from the accompanying drawings and the following detailed description. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic, and elements are not necessarily drawn to scale.

[0018] Figure 1 is a flowchart of a table processing method according to an embodiment of the present disclosure.

[0019] Figures 2 to 15 are schematic diagrams of the display interface of embodiments of this disclosure.

[0020] Figure 16 is a schematic diagram of the structure of an electronic device according to an embodiment of the present disclosure. Detailed Implementation

[0021] Embodiments of this disclosure will now be described in more detail with reference to the accompanying drawings. While some embodiments of this disclosure are shown in the drawings, it should be understood that this disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this disclosure. It should be understood that the accompanying drawings and embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of protection of this disclosure.

[0022] It should be understood that the various steps described in the method embodiments of this disclosure can be performed in sequence and / or in parallel. Furthermore, method embodiments may include additional steps and / or omit the steps shown. The scope of this disclosure is not limited in this respect.

[0023] The term "comprising" and its variations as used in this disclosure are open-ended, meaning "including but not limited to". The term "based on" means "at least partially based 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". Relevant definitions for other terms will be given in the description below.

[0024] It should be noted that the concepts of "first" and "second" mentioned in this disclosure are used only to distinguish different devices, modules or units, and are not used to limit the order of functions performed by these devices, modules or units or their interdependencies.

[0025] It should be noted that the use of the word "a" in this disclosure is illustrative rather than restrictive, and those skilled in the art should understand that it should be understood as "one or more" unless otherwise expressly indicated in the context.

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

[0027] The solutions provided by the embodiments of this disclosure will be described in detail below with reference to the accompanying drawings.

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

[0029] S11. In response to the first operation event, create one or more content fields in the table.

[0030] In some embodiments, the executor of the method proposed in this disclosure may be a terminal, a server, etc. A terminal may be, for example, a mobile phone, a computer, etc. A first operation event may include one or more operations. A table may be a table within a table document or a table within a non-table document (e.g., a text document). The table document or non-table document may be a local document or an online document. A field is an attribute of a cell, which typically describes the type of content stored in the cell. Fields are usually displayed as column names, indicating that all cells in that column have that field as an attribute. Content fields are pre-associated with content types, and content fields are configured with a relationship to target fields 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. Get the content of the file from the cell in the target field and write the file content into the cell in the content field.

[0032] In some embodiments, the file is an attachment in a cell of the target field, meaning the cell of the target field can be used to store the file itself. Alternatively, the file is the file pointed to by the address recorded in the cell of the target field, meaning the file in the cell of the target field refers to the file found through the address stored in the cell of the target field. Content corresponding to the content type associated with the content field is written into the cell of the content field. The content in the file can be identified using optical character recognition (OCR) technology, and then the identified content is written into the cell of the content field according to its content type. The content written into the cell of the content field corresponds to the content type associated with that content field. For example, if the content type associated with a content field is an invoice header, then the cell of that content field contains the specific content of the invoice header from the file's content. If another content field is associated with an invoice number, then the cell of that content field contains the specific content of the invoice number from the file's content. In some embodiments, the target field cells are also in a table. The content of the file is written into the cell of the content field in the same record as the file. For example, one row is one record, and the content of the file is written into the cell of the content field in the same row as the file. There can be multiple target field cells, and they can be located in multiple different records. Multiple cells may contain the file. In this case, step S12 is executed for all files in multiple cells of the target field to identify the content of multiple files and write it into the cell of the content field in their respective records. In some embodiments, when creating a content field, the content field managed by the required content type can be selected. In this case, not all the content of the file needs to be written into the cell of the content field; some file content may not be written into the cell of the content field. Of course, content fields corresponding to each content type can also be selected. In this case, the content of each content type in the file content will be written into the cell of the corresponding content field. Furthermore, the content type associated with a content field is not limited to one. One content field can correspond to one or more content types. In this way, the content of multiple content types can be written into one cell of a content field, which facilitates the processing of highly related content in the same cell. In some embodiments, the content type associated with the content field can be pre-set, and it can be related to the content type of the file. For example, when the file is an invoice, the content type associated with the content field can be the invoice header, invoice amount, etc.

[0033] In some embodiments of this disclosure, a table processing method is proposed that can identify the content of a file in a cell of a target field, and then write the content into the cell of the corresponding content field according to the content type. In this way, the user does not need to manually view the content of the file and write it into the cell of the content field, which reduces the user's operation and greatly improves the efficiency of file processing. When it is necessary to extract the content of files in multiple different records according to the content type, the processing efficiency can be greatly improved.

[0034] In some embodiments of this disclosure, one or more content fields include at least one of the following: content fields associated with multiple content types, or content fields associated with one content type. In some embodiments, multiple content fields can be created in a table, where one content field can be associated with multiple or even all content types, while other content fields are associated with only one content type. Thus, in one content field cell, content corresponding to multiple content types from a file can be written, while in other content fields, content corresponding to only one content type is written. Specifically, referring to Figure 8, the file in the target field cell is an invoice. In Figure 8, the fields "Invoice" and its right-hand side "Invoice Header" to "Payee" are all content fields. The "Invoice" field is associated with all content type fields in the invoice. Therefore, after recognizing the content in the file, the content of the file can be written into the cells of the "Invoice" field, and can be written in JSON or XML format for convenient subsequent processing. Other fields only write content corresponding to one content type; for example, the "Invoice Header" field only writes the content of the invoice header from the file. In some embodiments, the content of a cell associated with a field of one content type can come from a cell associated with fields of multiple or all content types, thus ensuring the synchronization of the content of the two types of cells.

[0035] In some embodiments of this disclosure, in response to a first operation event, creating one or more content fields in a table includes: in response to the first operation event, creating one or more content fields in a table, and determining one of the content fields as a target field.

[0036] In some embodiments, the target field can be one of the content fields, in which case the cell of the target field has two field attributes. The cell of the target field stores both the file and the content corresponding to its 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. Clicking the box with a plus sign to the right of "Date" triggers the creation of a new field, and then the field interface shown in Figure 4 is displayed. The field interface has a control for selecting field shortcuts. After this control is triggered, a sub-interface can be displayed. In the sub-interface, fields can be selected. The fields in the sub-interface are a special type of field that encapsulates processing logic. They can be used to process the content in the cells of other fields according to the encapsulated processing logic and write it into the cells under this field. The content field in this table can be the OCR (Optical Character Recognition) invoice recognition field shown in Figure 4. This field is used to recognize the content in the invoice using OCR technology and write it into the cells of the content field according to the content type. After selecting this field, as shown in Figure 7, the field interface changes, the title becomes "Invoice" (this field is the target field), and other selectable content fields (invoice header, etc.) are displayed. After clicking "OK", the table after adding the content field is displayed as shown in Figure 8. The invoice field serves as both a content field and a target field, and it can store invoices (files) and the corresponding target type content. Triggering the cells under the invoice field in Figure 8 allows you to add invoices, as shown in Figure 12. After adding an invoice, an invoice icon will be displayed in the cell. Then, as shown in Figure 13, the content in the invoice will be recognized and filled into the cells of other content fields in the same record. By continuing to trigger the cells under the invoice field, as shown in Figure 14, you can display a preview of the existing invoices in the cell and continue to add invoices. If two or more files are added to a cell, the content of these two or more files can be displayed separately in the cells of other content fields.

[0037] In some embodiments of this disclosure, in response to a first operation event, creating one or more content fields in a table includes: 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 a target field. In some embodiments of this disclosure, the target field may be another field different from the content fields, in which case the cells of the content fields may only be used to store content from a file, and not to store the file itself.

[0038] In some embodiments of this disclosure, in response to a first operation event, creating one or more content fields in a table and determining a field different from the content fields as a target field includes: in response to the first operation event, creating one or more content fields in a 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 a table and creating the target field.

[0039] In some embodiments, when a cell in the content field cannot store a file, it is necessary to store the file using a cell in another field. In this case, in some embodiments, an existing field can be selected. As shown in Figure 2, the table displays the field interface and sub-interface shown in Figure 2 by triggering the control to create a new field. Selecting "OCR Invoice Recognition" will make the field interface as shown in Figure 3, which displays a configuration area. In the configuration area, an existing field can be selected as the OCR recognition source, which is also the target field. Here, the "Invoice Source" field is selected as the OCR recognition source. After clicking OK, a new content field will be added to the table as shown in Figure 6. In other embodiments, a new field can be created as the target field. As shown in Figure 4, there is no "Invoice Source" field at this time, that is, there is no cell in the existing field to store the file. After selecting "OCR Invoice Recognition," as shown in Figure 5, a new field can be selected as the target field in the configuration area. After clicking OK, as shown in Figure 6, the target field and the content field will be created in the table. Therefore, in this embodiment, when a cell in the content field cannot store a file, the file can be stored using an existing or newly created cell in another field. In the cell for the target field "Invoice Source" shown in Figure 6, you can add an invoice. Then, as shown in Figure 9, the invoice content will be recognized in the cells for fields such as "Invoice" and "Invoice Title".

[0040] In some embodiments of this disclosure, 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 the content fields, wherein recommended content fields are displayed in the field interface, the recommended content fields being associated with the content recorded in the document; and creating one or more of the content fields based on a selection result of the recommended content fields.

[0041] In some embodiments, as shown in Figures 3, 4, and 7, when creating content fields, recommended content fields are displayed in the field interface. The recommended fields can be determined based on the content recorded in the file. As shown in Figures 3, 4, and 7, if the file is an invoice, the recommended content 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 content 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 the cells of a content field can be updated automatically or manually. In the case of automatic updates, if a file is added to a cell under the target field "Invoice Source" in the table shown in Figure 6, as shown in Figure 9, the content corresponding to the associated content type will be automatically written into the cell of the content field. If the content of the file changes, the content in the cell 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 that content field. Specifically, as shown in Figure 10, the options list of the content field can be brought up by, for example, right-clicking or long-pressing, and a "Update Data" control can be found. Triggering this control will identify the content of the file and update the content of the cells under that field accordingly. Alternatively, as shown in Figure 11, the properties panel of the content field can be brought up. The properties interface of the content field also has an "Update Data" control, which, when triggered, updates the content in the cells under that content field. In some embodiments, as shown in Figure 11, the content in a cell associated with a content field of one content type comes from the content in a cell associated with multiple content fields of multiple content types. Therefore, when the content in a cell associated with a content field of one content type is updated, the content in a cell associated with multiple content fields of multiple content types can be automatically updated to ensure the consistency of the content.

[0046] In some embodiments of this disclosure, the method further includes: changing the content field to a field of another field type in response to a third operation event on the content field. In some embodiments, as shown in FIG11, a control for selecting a field type is provided in the property interface of any content field. This control allows the field type of the content field to be changed. By triggering the control, as shown in FIG15, different optional field types will be displayed. Selecting a field and confirming will then change the content field to the selected field type.

[0047] To better illustrate the method proposed in this disclosure, a specific use case is presented below. In this use case, the file is an invoice. A table is created to manage invoices. The table may already have an "Invoice Source" field as the target field. The cells under the target field are used to store the invoice itself or the invoice's address. The user selects the shortcut "OCR Invoice Recognition" field (Figure 3) and can choose an existing field as the target field in the field interface (or create a new field as the target field). The field interface displays recommended content fields, and the user can select one or more of them. Each recommended content field can correspond to a content type. Then, as shown in Figure 8, a pre-set field associating multiple content types and the selected recommended content field are created as the content field. As shown in Figure 9, if the target field cell contains a file or a file address, the file will be automatically recognized, and its content will be written into the cell of the content field in the same record. The content field associating multiple content types stores the content of each content type in JSON format, and the cells of the content field store the content corresponding to its associated content type. When updating a file, the content in the content field cell can be updated automatically, or the user can choose to update it manually. For the content field, users can choose to change its field type to another type, such as changing it to a single-selection field. In this embodiment, the content of the file in the cell under the target field can be recognized and written into the cell of the content field. There can be multiple cells under the target field, with different files located in different records (rows). Then, the content of the file in each record will be written into the respective record. This can quickly complete the batch file recognition work and improve processing efficiency. Users only need to send the file to be processed to the cell of the target field.

[0048] This disclosure also proposes a table processing apparatus, including:

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

[0050] 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;

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

[0052] In some embodiments, 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.

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

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

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

[0056] In some embodiments, 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 a content field, 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.

[0057] In some embodiments, 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 associates multiple content types; or, in response to selecting a recommended content field, creating a content field in the table that associates multiple content types, and creating the selected recommended content field in the table.

[0058] In some embodiments, 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.

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

[0060] For embodiments of the apparatus, since they basically correspond to the method embodiments, relevant details can be found in the descriptions of the method embodiments. The apparatus embodiments described above are merely illustrative, and the modules described as separate modules may or may not be separate. Some or all of the modules can be selected to achieve the purpose of the embodiments of this disclosure, depending on actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0061] The methods and apparatus of this disclosure have been described above based on embodiments and application examples. Furthermore, this disclosure also provides a terminal and a storage medium, which are described below.

[0062] Referring now to FIG16, a schematic diagram of the structure of an electronic device (e.g., a terminal device or a server) 800 suitable for implementing embodiments of the present disclosure is shown. The terminal device in the embodiments of the present disclosure may include, but is not limited to, mobile terminals such as mobile phones, laptops, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. The electronic device shown in the figure is merely an example and should not be construed as limiting the functionality and scope of use of the embodiments of the present disclosure.

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

[0064] Typically, the following devices can be connected to I / O interface 805: input devices 806 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 807 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 808 including, for example, magnetic tapes, hard disks, etc.; and communication devices 809. Communication device 809 allows electronic device 800 to communicate wirelessly or wiredly with other devices to exchange data. Although an electronic device 800 with various devices is shown in the figure, it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed alternatively.

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

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

[0067] In some implementations, clients and servers can communicate using any currently known or future-developed network protocol such as HTTP (Hypertext Transfer Protocol), and can interconnect with digital data communication (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks (“LANs”), wide area networks (“WANs”), the Internet (e.g., the Internet of Things), and end-to-end networks (e.g., ad hoc end-to-end networks), as well as any currently known or future-developed networks.

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

[0069] The aforementioned computer-readable medium carries one or more programs, which, when executed by the electronic device, cause the electronic device to perform the methods of the present disclosure.

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

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

[0072] The units described in the embodiments of this disclosure can be implemented in software or hardware. The names of the units are not, in some cases, intended to limit the specific unit.

[0073] The functions described above in this disclosure can be performed at least in part by one or more hardware logic components. For example, exemplary types of hardware logic components that can be used, without limitation, include: field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), system-on-a-chip (SoCs), complex programmable logic devices (CPLDs), and so on.

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

[0075] According to one or more embodiments of this disclosure, a table processing method is provided, comprising:

[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 configured with association relationships with target fields in the table;

[0077] 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;

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

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

[0080] According to one or more embodiments of this disclosure, a table processing method is provided, which, in response to a first operation event, creates one or more content fields in a table, including:

[0081] 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,

[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 fields is identified as the target field.

[0083] According to one or more embodiments of this disclosure, a table processing method is provided, which, in response to a first operation event, creates one or more content fields in a table and determines a field different from the content fields as a 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, create one or more content fields in the table, and create the target field.

[0086] According to one or more embodiments of this disclosure, a table processing method is provided, which, in response to a first operation event, creates one or more content fields in a table, including:

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

[0088] Based on the selection results of the recommended content fields, create one or more of the content fields.

[0089] According to one or more embodiments of this disclosure, a table processing method is provided, which creates one or more content fields based on the selection result of a recommended content field, including:

[0090] In response to the absence of a recommended content field, create a content field in the table that associates multiple content types; or,

[0091] In response to the selection of a recommended content field, a content field that associates multiple content types is created in the table, and the selected recommended content field is also created in the table.

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

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

[0094] Alternatively, 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.

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

[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 this disclosure, a form processing apparatus is provided, comprising:

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

[0099] 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;

[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 an 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 this disclosure 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, comprising: 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.

2. The method of claim 1, wherein, The one or more content fields comprise at least one of: a content field associated with multiple content types, or a content field associated with a content type.

3. The method of claim 1 or 2, wherein, in response to a first operation event, creating one or more content fields in a table, comprising: in response to a first operation event, creating one or more content fields in a table, and determining one of the content fields as a target field; or, in response to a first operation event, creating one or more content fields in a table, and determining a field different from the content fields as a target field.

4. The method of claim 3, wherein, in response to a first operation event, creating one or more content fields in a table, and determining a field different from the content fields as a target field, comprising: in response to a first operation event, creating one or more content fields in a table, and selecting an existing field in the table as the target field, or, in response to a first operation event, creating one or more content fields in a table, and creating the target field.

5. The method of claim 1 or 2, wherein, in response to a first operation event, creating one or more content fields in a table, comprising: in response to the 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; creating one or more content fields according to the selection result of the recommended content field.

6. The method of claim 5, wherein, creating one or more content fields according to the selection result of the recommended content field, comprising: in response to not selecting a recommended content field, creating a content field associated with multiple content types in the table; or, in response to selecting a 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.

7. The method according to any one of claims 1 to 6, wherein, 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, comprising: in response to a file being added in the cell of the target field, an address of a file being added in the cell of the target field, or an existing file in the cell of the target field being changed, automatically performing obtaining 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 obtaining 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. 8.The method of any one of claims 1-7, further comprising: in response to a third operation event on the content field, changing the content field to a field of another field type. 9.A table processing apparatus, comprising: 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 a content type, the content fields being associated with a target field configuration in the table; a control unit configured to acquire 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; wherein the control unit is further configured to write content corresponding to the content type associated with the content field into the cell of the content field; the file being an attachment in the cell of the target field, or the file being a file pointed to by an address recorded in the cell of the target field. 10.A terminal, comprising: at least one memory and at least one processor; wherein the at least one memory is configured to store program code, and the at least one processor is configured to invoke the program code stored in the at least one memory to execute the table processing method of any one of claims 1-8. 11.A computer-readable storage medium configured to store program code, the program code, when executed by a computer, causing the computer to execute the table processing method of any one of claims 1-8.

Images