CN115292317A

CN115292317A - Form generation method, device, equipment and storage medium

Info

Publication number: CN115292317A
Application number: CN202210911316.0A
Authority: CN
Inventors: 孙靖; 何海伟; 郑相辉; 邓庆云; 张卓; 张文宝; 刘永斌; 袁洋; 钟松; 陈柯燃; 辛洋; 苏奕虹; 刘拓辰; 梁永康; 黄绿森; 王赞; 郭凤翔
Original assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd; Wuhan Kingsoft Office Software Co Ltd
Current assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd; Wuhan Kingsoft Office Software Co Ltd
Priority date: 2022-07-29
Filing date: 2022-07-29
Publication date: 2022-11-04

Abstract

The application provides a form generation method, a device, equipment and a storage medium, wherein a form interface is provided through terminal equipment, and the method comprises the following steps: displaying a first table to be processed on the table interface, wherein the first table comprises at least one non-empty cell which comprises at least one table header; and responding to the form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type. The problem that the data format cannot be specified through the table statistical information is solved.

Description

Form generation method, device, equipment and storage medium

Technical Field

The present application relates to the field of data processing technologies, and in particular, to a form generation method, apparatus, device, and storage medium.

Background

In daily work and life, filling and collection of information are often involved, such as collection of information of students on class, collection of information of masses in community, and the like.

The current information collection mode mainly comprises the steps of creating a local form, issuing the local form step by step, filling the local form, summarizing the local form step by step, creating an online form, filling the online form by cooperation of multiple persons, and the like. The above information collection method cannot achieve the standard data format.

Disclosure of Invention

The application provides a form generation method, a form generation device and a storage medium, which are used for solving the problem that a data format cannot be standardized through form statistical information.

In a first aspect, the present application provides a form generating method, where a form interface is provided through a terminal device, the method including:

displaying a first table to be processed on the table interface, wherein the first table comprises at least one non-empty cell which comprises at least one table header;

and responding to a form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type.

In a possible implementation manner, the generating, in response to the form generation operation for the first form, a target form corresponding to the first form according to each of the non-empty cells includes:

in response to the form generation operation aiming at the first form, acquiring format information of the first form, and cell positions and cell contents of the non-empty cells;

determining a header sequence of the first table according to the format information, wherein the header sequence is a sequence in which the header is positioned;

and generating the target form according to the format information, the cell positions, the cell contents and the header sequence.

In a possible implementation, the format information includes format distribution information of the first table; the determining a header sequence of the first table according to the format information includes:

determining format distribution of the first table according to the format distribution information, wherein the format distribution is row distribution or column distribution;

and determining the header sequence according to the format distribution of the first table and the cell position of each non-empty cell, wherein when the format distribution is row distribution, the header sequence belongs to a column sequence, and when the format distribution is column distribution, the header sequence belongs to a row sequence.

In a possible implementation manner, the generating the target form according to the format information, the cell position, the cell content, and the header sequence includes:

determining a cell sequence corresponding to each header and non-empty cells included in the cell sequence according to the header sequence and the cell positions;

displaying a field content interface corresponding to the first form according to at least one of the non-empty cells, the format information, the cell contents and the arrangement sequence of each cell sequence, wherein the non-empty cells, the format information, the cell contents and the arrangement sequence of each cell sequence are included in each cell sequence, and the field content interface comprises a creation control, a title name and a title corresponding to each cell sequence;

and generating the target form in response to the touch operation aiming at the creation control.

In a possible implementation manner, the displaying a field content interface corresponding to the first table according to at least one of a non-empty cell included in each of the cell sequences, the format information, a cell content of the non-empty cell, and an arrangement order of each of the cell sequences includes:

performing semantic recognition on the header of each cell sequence to obtain a semantic recognition result;

performing question matching according to the semantic recognition result, and determining a question name and a question corresponding to each cell sequence;

and displaying the field content interface according to the arrangement sequence, the title name and the title corresponding to each cell sequence.

In a possible implementation manner, the format information includes a sequence type of each cell sequence; the displaying a field content interface corresponding to the first form according to at least one of the non-empty cells, the format information, the cell contents of the non-empty cells, and the arrangement order of each cell sequence, which are included in each cell sequence, includes:

determining the title name and the title corresponding to each cell sequence according to the sequence type of each cell sequence;

carrying out feature recognition on the cell contents of the non-empty cells included in each cell sequence to obtain a feature recognition result;

determining the title name and the title corresponding to each cell sequence according to the feature identification result;

and displaying the field content interface according to the arrangement sequence, the title name and the title corresponding to the cell sequence.

In a possible implementation manner, the displaying, according to at least one of the non-empty cells included in each of the cell sequences, the format information, the cell contents of the non-empty cells, and the arrangement order of each of the cell sequences, a field content interface corresponding to the first table includes:

aiming at any cell sequence, carrying out duplication elimination processing on the cell contents of non-empty cells in the cell sequence to obtain options corresponding to the cell sequence;

when the number of the options is lower than a first preset threshold value, determining the question type of the cell sequence as a selection question, and determining a question name and a question corresponding to the cell sequence according to the options;

when the number of the options is not lower than the first preset threshold, determining the question type of the cell sequence as a blank filling question, and determining a question name and a question corresponding to the cell sequence;

In one possible embodiment, the method further comprises:

acquiring the title of the first table and the cell content in the first table according to a preset time interval;

performing word segmentation processing on the title and the cell content to obtain word segmentation results;

matching the word segmentation result based on the form characteristic word library to obtain a corresponding matched word;

and when the number of the matched words is larger than or equal to a first threshold value, displaying prompt information on the form interface, wherein the prompt information is used for prompting the first form to generate the target form.

In a second aspect, the present application provides a form generation apparatus, including:

the display module is used for displaying a first table to be processed on a table interface provided by the terminal equipment, wherein the first table comprises at least one non-empty cell which comprises at least one table header;

and the processing module is used for responding to the form generation operation aiming at the first form, generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each header and a title corresponding to the title name, and the title comprises a title type.

In a possible implementation, the processing module is specifically configured to:

in response to the form generation operation for the first form, obtaining format information of the first form, and cell positions and cell contents of the non-empty cells;

determining a header sequence of the first table according to the format information, wherein the header sequence is a sequence in which the header is located;

and generating the target form according to the format information, the cell position, the cell content and the header sequence.

In a possible implementation, the format information includes format distribution information of the first table; the processing module is specifically configured to:

In a possible implementation manner, the format information includes a sequence type of each cell sequence; the processing module is specifically configured to:

In a possible implementation manner, the processing module is specifically configured to:

In one possible implementation, the display module is further configured to:

In a third aspect, the present application provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor implements the form generation method according to any one of the first aspect when executing the program.

In a fourth aspect, the present application provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the form generation method of any of the first aspects.

In a fifth aspect, the present application provides a computer program product comprising a computer program which, when executed by a processor, implements the form generation method of any of the first aspects.

According to the form generation method, the form generation device, the form generation equipment and the storage medium, a form interface is provided through terminal equipment, a first form to be processed is displayed on the form interface, the first form comprises at least one non-empty cell, and the at least one non-empty cell comprises at least one form header; and then responding to the form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type. After the target form is generated, the target form can be distributed to each client, information collection or statistics is achieved after the target form is filled by a user, data privacy of each user can be effectively guaranteed as the target form is independently sent to each client, the question corresponding to each question name is set in the form, the user can complete filling of information according to the question corresponding to each question name, and data formats can be standardized.

Drawings

In order to more clearly illustrate the technical solutions in the present application or the prior art, the drawings needed for the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

FIG. 1 is a schematic diagram of a statistical form of information;

fig. 2 is a schematic view of an application scenario applicable to the embodiment of the present application;

fig. 3 is a schematic flowchart of a form generation method according to an embodiment of the present application;

FIG. 4 is a diagram illustrating a target form generated according to an embodiment of the present application;

FIG. 5 is a table interface diagram provided by an embodiment of the present application;

FIG. 6 is a schematic flowchart of generating a target form according to an embodiment of the present application;

fig. 7 is a schematic diagram of determining a header sequence according to an embodiment of the present application;

FIG. 8 is a diagram of a first table provided in an embodiment of the present application;

FIG. 9 is a schematic diagram of a field content interface provided by an embodiment of the present application;

FIG. 10 is a diagram illustrating form information provided by an embodiment of the present application;

fig. 11 is a schematic structural diagram of a form generation apparatus according to an embodiment of the present application;

fig. 12 is a schematic physical structure diagram of an electronic device according to an embodiment of the present application.

Detailed Description

To make the objects, technical solutions and advantages of the present application clearer, the technical solutions of the present application will be described clearly and completely with reference to the accompanying drawings in the present application, and it is obvious that the described embodiments are some, but not all embodiments of the present application. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.

The basic concepts involved in the present application will be first introduced.

Table (b): the table can input and output and display data, and also can calculate some simple addition and subtraction methods by using formulas. The method can help a user to make various complex table documents, can perform data calculation, can display the input data as a table with excellent visibility after performing various complex statistical operations, and can vividly display the data as multiple charts, thereby enhancing the visibility of the data.

A meter head: is the beginning of the table for categorizing the properties of some data. Most forms are conventionally reflected by the profile of the respondent, such as the respondent's sex, age, school calendar, income, family member composition, political background, economic status, etc. Such questions are typically arranged at the beginning of the questionnaire, called the "header". The header design should be based on different investigation contents, and the items listed in the header are essential items for analyzing the result.

Form: the method is a tool for collecting the standardized information, and the statistics of the standardized information can be quickly completed mainly through point pulling and dragging.

The table is widely applied to information collection scenes, such as information collection in epidemic situation prevention and control, school statistical student information and the like. At present, two main implementation modes are provided for collecting information through a form, one is to create a local form, then gradually send the local form to an object of the collected information to be filled, and then gradually gather the local form; and the other method is to create an online form, distribute the online form to a client, and then collaboratively fill the form on the client by the object of the collected information to realize the collection of the information.

The two implementations described above can be understood in conjunction with fig. 1. Fig. 1 is a schematic diagram of an information statistics table, as shown in fig. 1, the table may be used for statistics of information such as "name", "gender", "identification number", "age", and the like, and the table may be a local table in the first implementation manner or an online table in the second implementation manner.

Whether a local form or an online form, when used for statistical information, it cannot be used for standardizing data formats and ensuring data privacy. For example, in fig. 1, for the statistics of the list of "age", some users fill in chinese numbers (for example, those filled in twenty-three years old by zhang-three), and some users fill in arabic numbers (for example, those filled in liquad-24), and the data formats cannot be unified. The subsequent users can see the information filled by the previous users when filling the form, for example, the information filled by Zhang three and Li four can be seen when filling the form by Wang Wu, and the like.

Based on this, embodiments of the present application provide a form generation method, apparatus, device, and storage medium, so as to solve the problem that a data format cannot be specified and data privacy cannot be guaranteed through table statistical information at present.

First, an application scenario of the embodiment of the present application is described with reference to fig. 2.

Fig. 2 is a schematic view of an application scenario applicable to the embodiment of the present application, as shown in fig. 2, including a terminal device 20, a client 21, a client 22, and a client 23, where the terminal device 20 and each client are connected by a wired or wireless connection.

A form can be displayed on the interface of the terminal device 20, and then a corresponding form is generated according to the form and distributed to the client 21, the client 22 and the client 23. User a may fill in on a form displayed on client 21, similarly, user B may fill in on a form displayed on client 22, and user C may fill in on a form displayed on client 23, each user filling in independently.

An application scenario of the embodiment of the present application is described in fig. 2, and a solution of the embodiment of the present application is described below with reference to fig. 3 based on the application scenario illustrated in fig. 2.

Fig. 3 is a schematic flowchart of a form generation method provided in an embodiment of the present application, where a form interface is provided by a terminal device, and as shown in fig. 3, the method may include:

s31, displaying a first table to be processed on a table interface, wherein the first table comprises at least one non-empty cell, and the at least one non-empty cell comprises at least one table header.

The form interface is an interface displayed on a display screen of the terminal device, and the form interface can fill the whole display screen of the terminal device or occupy a part of the display screen of the terminal device. And displaying a first table on the table interface, wherein the first table is an online table or a local offline table and is used for information statistics or information collection.

The first form comprises a plurality of cells, wherein the cells are basic composition units of the form, and each cell can be used for filling corresponding information. The cells filled with the corresponding information are non-empty cells, and the corresponding cells not filled with any information are empty cells.

In an embodiment of the application, the first table includes at least one non-empty cell, and the at least one non-empty cell includes at least one header. The header is used to classify the nature of some data in the first table, for example, in fig. 1, "name", "gender", "identification number", and "age" are all the headers of the table. The at least one non-empty cell in the first table may include a normal non-empty cell, that is, a non-empty cell other than the header, in addition to the header. For example, in fig. 1, the cells of "zhang san," "lie xi," "twenty-three year old," etc. are ordinary non-empty cells.

And S32, responding to the form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type.

The form generation operation may be a touch operation for a display screen on the terminal device, a voice operation for the terminal device, or other possible operations. Taking touch control as an example, one implementation manner is that an operation control is displayed on a table interface, a user clicks the operation control, and the terminal device responds to the touch control operation for the operation control, that is, triggers a form generation operation. Taking voice operation as an example, the user may issue a corresponding voice instruction, such as "generate a form," and the terminal device recognizes the voice instruction, thereby triggering the form generation operation.

The terminal device, in response to the form generation operation for the first form, generates a target form corresponding to the first form according to each non-empty cell in the first form, and a process of generating the target form may be understood, for example, with reference to fig. 4.

Fig. 4 is a schematic diagram of generating a target form according to an embodiment of the present application, as shown in fig. 4, a first table 41 includes a plurality of non-empty cells, which relate to the collection of three items of information, namely name, gender, and grade, and some users fill in related information in the first table 41, where the non-empty cells with the cell contents of "name", "gender", and "grade" are headers of the first table 41, and other non-empty cells are ordinary non-empty cells.

According to the first table 41, a target form 42 can be generated, where the target form 42 includes topic names corresponding to the headers and topics corresponding to each topic name, and the topics include topic types. As shown in fig. 4, the header "name" in the first table 41 corresponds to the title name "in the target form 42, the header" gender "in the first table 41 corresponds to the title name" gender "in the target form 42, and the header" grade "in the first table 41 corresponds to the title" grade "in the target form 42.

In the generated target form, the question type of the question can comprise a selection question, a blank filling question, an uploading question and the like, wherein the selection question can comprise one or more options, the uploading question can comprise an uploading control, a corresponding file is uploaded by operating the uploading control, and the blank filling question does not comprise the options and the uploading control. For example, in fig. 4, the title type of the title name "is a blank filling question, and the information of the title name" is input in the input field below the title name "in the target form 42, which requires the user to fill in the input field. For the title name "gender", the title type is a choice title, and the choices include "male" and "female", and the user can select one of the two choices when filling in the gender item. For the title name "grade", the title type is a choice title, the options include "grade one", "grade two", and "grade three", and the user can select one of the three options when filling in the grade item.

According to the form generation method provided by the embodiment of the application, a form interface is provided through terminal equipment, a first form to be processed is displayed on the form interface, the first form comprises at least one non-empty cell, and the at least one non-empty cell comprises at least one header; and then responding to the form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type. After the target form is generated, the target form can be distributed to each client, information collection or statistics is achieved after the target form is filled by a user, data privacy of each user can be effectively guaranteed as the target form is independently sent to each client, the question corresponding to each question name is set in the form, the user can complete filling of information according to the question corresponding to each question name, and data formats can be standardized. Further, compared with the current implementation scheme that only a user is supported to create a form from the beginning and then manually set the title and the question type of the form, the scheme of the embodiment of the application can directly and automatically generate the title and the question type of the form according to the existing first form without manually setting the title and the question type of the generated form, so that the operation complexity of the user can be reduced, and the operation efficiency can be improved.

In addition, the information filled in by the user through the target form can be directly filled into the corresponding cell in the first form; or a form can be newly created, and then the information filled in by the user through the target form is filled in the corresponding cell in the newly created form.

The scheme of the application is further detailed below with reference to the attached drawings.

Fig. 5 is a table interface diagram provided in the embodiment of the present application, and as shown in fig. 5, the first table 51 includes a plurality of cells, and a user can edit the first table 51.

In the process of opening the first table 51 or editing the first table 51 by the user, the terminal device may obtain the title of the first table 51 and the cell content in the first table 51 according to the preset time interval. The preset time interval may be set as needed, and may be, for example, 1s, 3s, or the like.

After the title and the cell content of the first table 51 are obtained, the terminal device performs word segmentation processing on the title and the cell content to obtain a word segmentation result. For example, in fig. 5, the title is "basic information statistics of first pupils", the cell contents include "name", "gender", "grade", and so on, and after performing the word segmentation processing on the title and the cell contents, the word segmentation result may include "first pupils basic information statistics of name, gender and grade", for example.

After the word segmentation result is obtained, matching the word segmentation result based on a form characteristic word bank to obtain a corresponding matched word, wherein the form characteristic word bank is a set comprising a plurality of form characteristic words, the form characteristic words are common words in the form, and the form characteristic word bank can be updated irregularly. And matching the segmentation results based on the form characteristic word bank, namely determining which words in the segmentation results belong to the form characteristic word bank. Taking the example that the form feature word library includes "primary school", "student", "information", "name", "sex", "grade", and "age", the matching words obtained after matching the word segmentation results based on the form feature word library include "primary school", "student", "information", "name", "sex", and "grade".

After the matching words are obtained, the number of the matching words can be judged. When the number of the matching words is larger than or equal to the first threshold value, prompt information can be displayed on the form interface for prompting the first form to generate a target form. For example, in fig. 5, a prompt message "please use [ generate a form according to a form ] function is displayed on a form interface, the form content is quickly converted into a form title, the information collection is easily completed in a few steps, and meanwhile, a control 52 is included, and the operation of generating the form can be triggered by clicking the control 52.

It should be noted that fig. 5 illustrates a process of identifying the feature of the generated form and prompting the user through prompt information that the operation of generating the form can be performed during the process of opening or editing the first form by the user, which is not a necessary step of generating the form.

After initiating the form generating operation, the terminal device may perform the form generating operation, and the process is described below with reference to fig. 6.

Fig. 6 is a schematic flowchart of generating a target form according to an embodiment of the present application, and as shown in fig. 6, the flowchart includes:

and S61, responding to the form generation operation aiming at the first form, and acquiring the format information of the first form, and the cell position and the cell content of each non-empty cell.

After initiating the form generating operation, the terminal device responds to the form generating operation to obtain current form data of the first form, wherein the current form data comprises format information of the first form, and cell positions and cell contents of each non-empty cell. The format information comprises format distribution information of the first table and sequence types of each cell sequence, the cell position comprises a row position and a column position of the cell, and the cell content is content filled in the cell by a user.

And S62, determining a header sequence of the first table according to the format information, wherein the header sequence is a sequence in which the header is positioned.

The format information includes format distribution information, and the format distribution of the first table can be determined according to the format distribution information, and the format distribution of the first table is row distribution or column distribution. The line distribution means that each line in the first table corresponds to a header, the statistics of each line is the same type of information, and the statistics of different lines is different types of information; the column distribution means that each column in the first table corresponds to a header, each column is counted by the same type of information, and different columns are counted by different types of information.

After the format distribution of the first table is determined, a header sequence of the first table can be determined according to the format distribution of the first table and the cell positions of each non-empty cell in the first table, wherein the header sequence is a sequence in which a header in the first table is located. When the format distribution is row distribution, the header sequence belongs to the column sequence, that is, each header is located in the same column, and when the format distribution is column distribution, the header sequence belongs to the row sequence, that is, each header is located in the same row.

The process of determining the sequence of headers can be understood in conjunction with fig. 7. Fig. 7 is a schematic diagram of determining a header sequence according to an embodiment of the present application, in fig. 7, a format distribution of a first table is taken as an example of a column distribution, and a plurality of cells are illustrated in a first table 71, where a part of the cells are non-empty cells.

According to the cell positions of the non-empty cells, the cells at the upper left corner and the upper right corner of the first table 71 can be determined respectively, because the first table 71 is distributed in columns, the header sequence belongs to a row sequence, and then the uppermost row in the first table 71 is determined as the header sequence, the header sequence is the row from the cell at the upper left corner to the cell at the upper right corner of the first table 71, as indicated by the dashed box in fig. 7.

The process of determining the header sequence is described in fig. 7 by taking column distribution as an example, and when the first table is in row distribution, the process of determining the header sequence is similar, that is, the cells at the upper left corner and the lower left corner of the first table are determined according to the cell positions of each non-empty cell, and then the column from the cell at the upper left corner to the cell at the lower left corner of the first table is determined as the header sequence.

And S63, generating a target form according to the format information, the cell position, the cell content and the form header sequence.

Specifically, after the header sequence is determined, according to the header sequence and the cell positions of the non-empty cells, the cell sequence corresponding to each header and the non-empty cells included in each cell sequence can be determined. When the list head sequence is a row sequence, the cell sequence is a column sequence, and the cell sequence corresponding to any list head is a column where the list head is located; when the list head sequence is a column sequence, the cell sequence is a row sequence, and the cell sequence corresponding to any list head is a row in which the list head is located.

Fig. 8 is a schematic diagram of a first table provided in an embodiment of the present application, and as shown in fig. 8, the header sequence is a first row of the first table, and the first table includes 4 headers, which are a header 81, a header 82, a header 83, and a header 84.

The cell sequence corresponding to the header 81 is the 1 st column, the cell sequence corresponding to the header 82 is the 2 nd column, the cell sequence corresponding to the header 83 is the 3 rd column, and the cell sequence corresponding to the header 84 is the 4 th column.

After the cell sequence corresponding to each table head is determined, a field content interface corresponding to the first table is displayed on the terminal equipment according to at least one of non-empty cells, format information, cell contents and arrangement sequence of each cell sequence included in each cell sequence.

Specifically, for a cell sequence in which a header is set and a sequence type is not set in the first table, semantic recognition may be performed on the header of the cell sequence to obtain a semantic recognition result. And then, performing title matching according to the semantic recognition result, determining the title name and the title corresponding to the cell sequence, and further displaying a field content interface according to the arrangement sequence of each cell sequence, the title name and the title corresponding to each cell sequence.

For example, in fig. 8, if the table header 81 is set as "your mailbox" for the cell sequence corresponding to the table header 81, performing semantic identification on "your mailbox" to obtain a semantic identification result as content related to the mailbox, and performing topic matching at this time to match "mailbox questions" in the form, thereby determining that the topic name corresponding to the cell sequence is "mailbox", and the topic corresponding to the topic name is "mailbox questions". For example, if the header is "gender", then semantic recognition can be performed on "gender" and topic matching can be performed to match "gender topic", so that the topic name corresponding to the cell sequence is "gender" and the topic is "gender topic", and since "gender topic" belongs to one of the choice topics, the corresponding option is automatically set as "male" and "female" as the option of "gender topic".

For the cell sequences with the sequence types set in the first table, the title names and titles corresponding to the cell sequences can be determined according to the sequence types of the cell sequences, so that a field content interface is displayed according to the arrangement sequence of each cell sequence, the title names and titles corresponding to each cell sequence.

For example, in fig. 8, the specific contents of the header 82 are not set in the cell sequence corresponding to the header 82, but the sequence type in which the cell sequence corresponding to the header 82 is set is "mobile phone number". Therefore, according to the sequence type, the corresponding title is the 'mobile phone number title' and the title is the 'mobile phone number' can be determined. If the sequence type is "date", the corresponding title can be determined to be "date", the title name is "date", and the like according to the sequence type.

For a cell sequence including a non-empty cell in the first table, feature recognition can be performed on the cell content of the non-empty cell to obtain a feature recognition result, and then a title name and a title corresponding to the cell sequence are determined according to the feature recognition result, so that a field content interface is displayed according to the arrangement sequence of each cell sequence, the title name and the title corresponding to each cell sequence.

For example, in fig. 8, the cell sequence corresponding to the header 83 includes a plurality of non-empty cells, and the cell contents of the plurality of non-empty cells have a low repetition degree, but have a certain rule that the cell contents are all 18 digits and conform to the id card verification rule. Therefore, the cell contents of the plurality of non-empty cells are subjected to feature recognition, and the matched corresponding subjects are 'identity card subjects', the subject names are 'identity card numbers', and the like.

For a cell sequence including a non-empty cell in the first table and having a high repetition degree of the cell content of the non-empty cell, the cell content of each non-empty cell may be subjected to deduplication processing to obtain an option corresponding to the cell sequence.

And when the number of the options corresponding to the cell sequence is lower than a first preset threshold value, determining the topic type of the cell sequence as a selection topic, and further determining the topic name and the topic corresponding to the cell sequence according to the options corresponding to the cell sequence.

Taking the first preset threshold as 10 as an example, for example, in fig. 8, for the cell sequence corresponding to the header 84, which includes a plurality of non-empty cells, the cell contents of the plurality of non-empty cells have a high repetition degree, including 2 "first-grade", 3 "second-grade", and 2 "third-grade", at this time, the cell contents may be subjected to a deduplication processing to obtain three options, which are "first-grade", "second-grade", and "third-grade", respectively, and then obtain a topic of "year-grade topic", where the number of the options is smaller than the first preset threshold, so as to determine the topic type as a choice topic and the topic name as "year-grade". The order of the options may be set randomly, or may be set according to the frequency of the options or the pinyin sorting of the first character, which is not limited in this embodiment.

And when the number of the options corresponding to the cell sequence is not lower than a first preset threshold, determining the question type of the cell sequence as a blank filling question, and determining the question name and the question corresponding to the cell sequence.

And after the title name and the title corresponding to the cell sequence are determined, displaying a field content interface according to the arrangement sequence of each cell sequence, the title name and the title corresponding to each cell sequence.

In the embodiment of the present application, the topic types mainly include several major categories, for example, including choice topics, fill-in-blank topics, upload topics, and the like. The choice questions are the question types which are provided with the determined options during the statistical information and selected by the user, under the broad category of the choice questions, common choice questions and special choice questions can be included, for example, the common choice questions can include gender questions, year-level questions and the like, the common choice questions can be selected directly by providing fixed options, the special choice questions can include date questions and the like, the date questions are not provided directly with fixed options, but need to select year, month and day in turn, and the like. The blank filling questions are question types which need to be filled by the user when information is counted, the blank filling questions also comprise common blank filling questions and special blank filling questions, the common blank filling questions can comprise name questions and names of the user, the special blank filling questions can comprise mobile phone numbers, identity card numbers and the like, certain rules are set, certain rules need to be met during filling, for example, the mobile phone numbers require 11 digits to be input, and filling can be successful only if the certain rules are met. Uploading questions may include, for example, uploading photographs, uploading two-dimensional codes, etc., which types require the user to upload the corresponding attachments.

For the cell sequence capable of generating the option questions and filling in blank questions simultaneously, in the embodiment of the application, the option questions are generated preferentially, so that the data format can be more effectively normalized. In some embodiments, if the number of options of the generated topic is greater than or equal to the preset threshold, that is, if there are too many options, the topic type of the topic may be updated to be a blank filling topic, thereby avoiding a situation that the user is difficult to select due to too many options.

The field content interface corresponding to the first form includes a title name and a title corresponding to each cell sequence, and further includes a creation control, which is described below with reference to fig. 9. Fig. 9 is a field content interface schematic diagram provided in the embodiment of the present application, and as shown in fig. 9, a field content interface 90 includes title names corresponding to each cell sequence, that is, "name", "gender", "mobile phone number", "date of birth", "identification number", and "mailbox". The field content interface 90 also includes a title corresponding to each title name, such as "name title" for "name", "gender title" for "gender", and so forth.

After the field content interface is displayed on the terminal equipment, a user can select a corresponding topic name and a topic corresponding to the selected topic name in the field content interface, so that a target form is generated according to the selected topic name and the topic. For example, in fig. 9, the total includes 6 topic names of "name", "gender", "mobile phone number", "birth date", "identification number" and "mailbox", and 6 topics corresponding to the 6 topic names, a user may select a part of the topic names and corresponding partial topics in the field content interface 90, so as to generate a corresponding target form, and a user may also select all the topic names and corresponding topics in the field content interface 90, so as to generate a corresponding target form.

If the sequence of the topic names or the topic types corresponding to the topic names need to be modified, corresponding editing and modification can be performed on the field content interface 90. A creation control 91 is further included on the field content interface 90, the user can click the creation control 91 to create a target form, and the terminal device generates the target form in response to a touch operation directed to the creation control 91.

After the target form is generated, the final form information can also be displayed on the form interface. Fig. 10 is a schematic diagram of form information provided in an embodiment of the present application, and as shown in fig. 10, the form information may include various items of information of a target form, and further includes an editing area, where titles may be added, deleted, modified, and the like in the editing area, and a user may perform an editing operation in the editing area to edit the form. The form interface further comprises a completion control 101, and the whole editing operation can be completed by clicking the completion control 101, so that the target form is obtained.

In summary, in the present solution, a first table to be processed is first displayed on a table interface, where the first table includes at least one non-empty cell, and the at least one non-empty cell includes at least one header; and then responding to the form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type. After the target form is generated, the target form can be distributed to each client, information collection or statistics is achieved after the target form is filled by a user, data privacy of each user can be effectively guaranteed as the target form is independently sent to each client, the question type and the option of the form sequence where each header is located are arranged in the form, the user can complete filling of information according to the question type and the option, and the data format can be standardized.

Fig. 11 is a schematic structural diagram of a form generating apparatus according to an embodiment of the present application, and as shown in fig. 11, the form generating apparatus includes:

the display module 111 is configured to display a first table to be processed on a table interface provided by a terminal device, where the first table includes at least one non-empty cell, and the at least one non-empty cell includes at least one header;

a processing module 112, configured to generate, in response to a form generation operation for the first form, a target form corresponding to the first form according to each non-empty cell, where the target form includes a title name corresponding to each header and a title corresponding to the title name, and the title includes a title type.

In a possible implementation, the processing module 112 is specifically configured to:

In a possible implementation, the format information includes format distribution information of the first table; the processing module 112 is specifically configured to:

In a possible implementation manner, the format information includes a sequence type of each cell sequence; the processing module 112 is specifically configured to:

carrying out feature recognition on the cell contents of the non-empty cells in each cell sequence to obtain a feature recognition result;

In a possible implementation, the display module 111 is further configured to:

acquiring a title of the first table and cell contents in the first table according to a preset time interval;

The form generation apparatus provided in the embodiment of the present application is configured to execute the method embodiment, and the implementation principle and the technical effect are similar, which are not described herein again.

Fig. 12 illustrates a physical structure diagram of an electronic device, which may include, as shown in fig. 12: a processor (processor) 1210, a communication Interface (Communications Interface) 1220, a memory (memory) 1230, and a communication bus 1240, wherein the processor 1210, the communication Interface 1220, and the memory 1230 communicate with each other via the communication bus 1240. Processor 1210 may invoke logic instructions in memory 1230 to perform a form generation method comprising: displaying a first table to be processed on the table interface, wherein the first table comprises at least one non-empty cell which comprises at least one table head; and responding to the form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type.

In addition, the logic instructions in the memory 1230 may be implemented in software functional units and stored in a computer readable storage medium when the logic instructions are sold or used as a stand-alone product. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.

In another aspect, the present invention also provides a computer program product, the computer program product comprising a computer program, the computer program being storable on a non-transitory computer-readable storage medium, the computer program, when executed by a processor, being capable of executing the form generation method provided by the above methods, the method comprising: displaying a first table to be processed on the table interface, wherein the first table comprises at least one non-empty cell which comprises at least one table header; and responding to the form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type.

In yet another aspect, the present invention also provides a non-transitory computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements a method of generating forms provided by the above methods, the method comprising: displaying a first table to be processed on the table interface, wherein the first table comprises at least one non-empty cell which comprises at least one table header; and responding to a form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type.

The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.

Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.

Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims

1. A form generation method is characterized in that a form interface is provided through terminal equipment, and the method comprises the following steps:

and responding to the form generation operation aiming at the first form, and generating a target form corresponding to the first form according to each non-empty cell, wherein the target form comprises a title name corresponding to each form head and a title corresponding to the title name, and the title comprises a title type.

2. The method of claim 1, wherein the generating a target form corresponding to the first table from each of the non-empty cells in response to the form generation operation for the first table comprises:

3. The method according to claim 2, wherein the format information includes format distribution information of the first table; the determining the header sequence of the first table according to the format information includes:

4. The method of claim 2, wherein generating the target form based on the format information, the cell location, the cell contents, and the header sequence comprises:

5. The method according to claim 4, wherein the displaying a field content interface corresponding to the first table according to at least one of the non-empty cells included in each of the cell sequences, the format information, the cell contents of the non-empty cells, and the arrangement order of each of the cell sequences includes:

6. The method according to claim 4, wherein the format information includes a sequence type of each of the cell sequences; the displaying a field content interface corresponding to the first form according to at least one of the non-empty cells, the format information, the cell contents of the non-empty cells, and the arrangement order of each cell sequence, which are included in each cell sequence, includes:

7. The method according to claim 4, wherein the displaying a field content interface corresponding to the first table according to at least one of the non-empty cells included in each of the cell sequences, the format information, the cell contents of the non-empty cells, and the arrangement order of each of the cell sequences includes:

determining the title name and title corresponding to each cell sequence according to the feature recognition result;

8. The method according to claim 4, wherein the displaying a field content interface corresponding to the first table according to at least one of the non-empty cells included in each of the cell sequences, the format information, the cell contents of the non-empty cells, and the arrangement order of each of the cell sequences includes:

9. The method according to any one of claims 1-8, further comprising:

performing word segmentation processing on the title and the cell content to obtain a word segmentation result;

10. A form generation apparatus, comprising:

11. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the form generation method of any of claims 1 to 9 when executing the program.

12. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the form generation method according to any one of claims 1 to 9.