CN112036124A

CN112036124A - Table conversion method, device, computer equipment and storage medium

Info

Publication number: CN112036124A
Application number: CN202010890061.5A
Authority: CN
Inventors: 钟志清
Original assignee: Ping An Property and Casualty Insurance Company of China Ltd
Current assignee: Ping An Property and Casualty Insurance Company of China Ltd
Priority date: 2020-08-28
Filing date: 2020-08-28
Publication date: 2020-12-04

Abstract

The application relates to the technical field of data processing, and through a preset form conversion strategy, form conversion is carried out on data content and format attributes corresponding to each cell, and obtained target data are rendered into a webpage, so that the efficiency and convenience of converting a to-be-converted form into a target webpage form on a line under the line can be improved. And more particularly, to a table conversion method, apparatus, computer device and storage medium, the table conversion method comprising: acquiring a table to be converted, and extracting data content and format attributes corresponding to each cell in the table to be converted; performing format conversion on the data content and the format attribute corresponding to each cell according to a preset format conversion strategy to obtain target data corresponding to a table to be converted; and rendering the character string array and the key value pair array in the target data to a webpage to obtain a target webpage table corresponding to the table to be converted. In addition, the application also relates to a block chain technology, and the target webpage table can be stored in the block chain.

Description

Table conversion method, device, computer equipment and storage medium

Technical Field

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

Background

With the rapid development trend of the internet industry, the conversion of electronic documents of complex offline scenes to online electronic documents becomes a new hot spot, and for example, there is a high frequency demand for the conversion of offline forms to online forms.

The existing method for converting the offline table into the online table mainly comprises two realization methods: one is to create a new form directly on-line and edit it, and the other is to submit the form data through a form. Although online table editing is very convenient, strong platform support is required, and an ordinary online system cannot be supported at all. The form is generated by submitting data through the form, various limiting conditions exist, the conversion efficiency is low, and the conversion requirement of complex offline forms cannot be met.

Therefore, how to convert the offline table into the online table conveniently and improve the conversion efficiency of the table becomes an urgent problem to be solved.

Disclosure of Invention

The application provides a form conversion method, a form conversion device, computer equipment and a storage medium, according to a preset form conversion strategy, form conversion is carried out on data content and format attributes corresponding to each cell, obtained target data are rendered into a webpage, and efficiency and convenience of converting a form to be converted into a webpage form on a line under the line can be improved.

In a first aspect, the present application provides a table conversion method, including:

acquiring a table to be converted, and extracting data content and format attributes corresponding to each cell in the table to be converted;

performing format conversion on data content and format attributes corresponding to each cell according to a preset format conversion strategy to obtain target data corresponding to the table to be converted, wherein the target data comprises a character string array and a key value pair array;

and rendering the character string array and the key value pair array in the target data to a webpage to obtain a target webpage table corresponding to the table to be converted.

In a second aspect, the present application further provides a table conversion apparatus, including:

the data acquisition module is used for acquiring a table to be converted and extracting data content and format attributes corresponding to each cell in the table to be converted;

the form conversion module is used for carrying out form conversion on the data content and the format attribute corresponding to each cell according to a preset form conversion strategy to obtain target data corresponding to the table to be converted, wherein the target data comprises a character string array and a key value pair array;

and the data rendering module is used for rendering the character string array and the key value pair array in the target data to a webpage to obtain a target webpage table corresponding to the table to be converted.

In a third aspect, the present application further provides a computer device comprising a memory and a processor;

the memory for storing a computer program;

the processor is configured to execute the computer program and implement the table conversion method as described above when executing the computer program.

In a fourth aspect, the present application also provides a computer-readable storage medium storing a computer program which, when executed by a processor, causes the processor to implement the table conversion method as described above.

The application discloses a form conversion method, a form conversion device, computer equipment and a storage medium, wherein data content and format attributes corresponding to each cell in a form to be converted can be extracted by acquiring the form to be converted; form conversion is carried out on the data content and the format attribute corresponding to each cell according to a preset form conversion strategy, so that target data corresponding to a table to be converted can be obtained, form conversion of a complex table under a line is realized, and no additional limiting condition exists; the character string array and the key value pair array in the target data are rendered into the webpage to obtain a target webpage table corresponding to the table to be converted, so that the efficiency and convenience of converting the table to be converted under the line into the target webpage table on the line are improved.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings needed to be used in the description of the embodiments are 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 flow chart diagram of a table conversion method provided by an embodiment of the present application;

FIG. 2 is a schematic flow diagram of the substeps of formalizing the data content and format attributes of FIG. 1;

FIG. 3 is a schematic flow diagram of the substeps of rendering target data to a web page of FIG. 1;

FIG. 4 is a schematic flow chart diagram of another table conversion method provided by an embodiment of the present application;

FIG. 5 is a schematic diagram of an input box provided by an embodiment of the present application;

FIG. 6 is a schematic block diagram of a pop-up window provided by embodiments of the present application;

FIG. 7 is a schematic diagram of a web page table to be edited after a cell is hidden according to an embodiment of the application;

fig. 8 is a schematic block diagram of a table conversion apparatus provided in an embodiment of the present application;

fig. 9 is a schematic block diagram of a structure of a computer device according to an embodiment of the present application.

Detailed Description

The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of 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 flow diagrams depicted in the figures are merely illustrative and do not necessarily include all of the elements and operations/steps, nor do they necessarily have to be performed in the order depicted. For example, some operations/steps may be decomposed, combined or partially combined, so that the actual execution sequence may be changed according to the actual situation.

It is to be understood that the terminology used in the description of the present application herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in the specification of the present application and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.

It should also be understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.

The embodiment of the application provides a table conversion method, a table conversion device, computer equipment and a storage medium. The form conversion method can be applied to a server or a terminal, realizes form conversion on data content and format attributes corresponding to each cell through a preset form conversion strategy, renders the obtained target data to a webpage, and can improve the efficiency and convenience of converting a form to be converted into a target webpage form on a line.

The server may be an independent server or a server cluster. The terminal can be an electronic device such as a smart phone, a tablet computer, a notebook computer, a desktop computer and the like.

Some embodiments of the present application will be described in detail below with reference to the accompanying drawings. The embodiments described below and the features of the embodiments can be combined with each other without conflict.

As shown in fig. 1, the table conversion method includes steps S10 through S30.

Step S10, obtaining the table to be converted, and extracting the data content and the format attribute corresponding to each cell in the table to be converted.

Illustratively, the background of the server or the terminal comprises an uploading interface, wherein the uploading interface is used for acquiring the table to be converted.

It should be noted that, in the embodiment of the present application, the form to be converted may be uploaded to a background of the server or the terminal through an upload interface; and after the form conversion processing is carried out in the background, rendering the processed target data to a front-end webpage to obtain a webpage table.

In some embodiments, the form uploaded by the user is received through the uploading interface, and the uploaded form is taken as the form to be converted. The table to be converted may include, but is not limited to, an excel table, a word table, a csv table, and the like. In the embodiment of the present application, a table to be converted is described in detail as an excel table.

Illustratively, the table to be converted is shown in Table 1:

table 1 is a table to be converted

Note that, in table 1, cells including a header and a non-header; wherein, the cell of the header is distinguished by thickening the frame.

Specifically, data content and format attributes corresponding to each cell in the table to be converted are extracted, and the cells in the table to be converted can be sequentially obtained; and then extracting the information in each cell through an information extraction tool to obtain the data content and the format attribute corresponding to the table to be converted.

The format attribute comprises parameters such as column width and row width of the cells and whether the cells are headers.

Illustratively, each cell in the table to be converted can be read sequentially from left to right and from top to bottom according to the row and column traversal mode.

Jar tool may be jxl. The jxl. jar tool is a tool class library for operating excel tables through java and is developed by java language. jar tool can realize creating files, reading files, modifying files, formatting data, operating cells and the like on excel tables.

Specifically, extracting data content and format attributes corresponding to a first cell in a table to be converted through a jxl. Illustratively, a jxl jar tool is used to extract data content and format attributes corresponding to a second cell in a table to be converted, and the obtained data content is "test header 1", the format attributes are "column width is 2, line width is 1, and header".

By sequentially extracting the data content and the format attribute corresponding to each cell in the table to be converted, the form conversion can be directly performed on the data content and the format attribute corresponding to each cell subsequently, so that the table conversion efficiency is improved.

Step S20, performing format conversion on the data content and the format attribute corresponding to each cell according to a preset format conversion policy to obtain target data corresponding to the table to be converted, where the target data includes a character string array and a key value pair array.

The preset form conversion policy may include: and converting the data content in the cell into a character string form, and converting the format attribute corresponding to the cell into a key value pair form. Wherein, the parameter field and the field value in the format attribute are expressed in the form of a key value pair.

Illustratively, the target data includes a plurality of arrays of character strings and a plurality of arrays of key value pairs; and the data content in each row of cells is converted to obtain character strings which are distributed to the corresponding character string arrays, and the key value pairs obtained by converting the format attributes corresponding to each row of cells are distributed to the corresponding key value pair arrays. By distinguishing the character string arrays and the key value array in different rows of cells, when target data are rendered to a webpage, each character string array correspondingly generates data content in one row of cells in a webpage table, and each key value array is used for formatting the format of the corresponding row of cells. Therefore, the efficiency of rendering the target data to the webpage can be improved, and the data content and the format attribute corresponding to each row of cells are prevented from being mixed up.

Referring to fig. 2, in some embodiments, before performing format conversion on the data content and the format attribute corresponding to each cell according to a preset format conversion policy, the following steps S201 and S202 may be specifically included.

Step S201, judging whether the table to be converted has a merging cell or not according to the format attribute corresponding to the cell.

Specifically, whether a cell is a merged cell may be determined according to two parameters, namely, a column width and a line width, in the format attribute.

For example, if the column width and the row width of the a cell are 2 and 1, respectively, the a cell may be determined to be a merged cell of two columns. For example, if the column width and the row width of the B cell are 2 and 2, the B cell may be determined to be a merged cell with two rows and two columns. For another example, if the column width and the row width of the C cell are 1 and 1, the C cell can be determined to be a single row and a single column.

Step S202, if the merged cells exist, splitting the merged cells into single-row single-column cells to obtain the data content and format attributes corresponding to the single-row single-column cells.

Specifically, the merged cell may be split into a plurality of single-row single-column cells based on a preset splitting policy. The preset splitting strategy may include splitting the merged cell according to a single row and single column principle.

For example, if the a cell is a merged cell of two columns, the a cell may be split into two sub-cells, a1 and a 2.

For example, if the B cell is a merged cell with two rows and two columns, the B cell may be split into four sub-cells of B1, B2, B3 and B4.

In some embodiments, matching the data content and format attributes corresponding to the single row and single column of cells may include: acquiring data content and format attributes corresponding to the merging cells, and assigning the data content and the format attributes corresponding to the merging cells to the split first cell; and setting the data content corresponding to the residual split cells as a null value and setting the line width and the column width in the format attribute as zero.

For example, if the a cell is a merged cell with two columns, and the data content corresponding to the a cell is "test header 1", and the format attribute is "column width is 2, row width is 1, header", the two sub-cells a1 and a2 are obtained by splitting, then the a1 sub-cell is the first split cell. At this time, the data content and the format attribute corresponding to the a cell may be assigned to the a1 sub-cell, and the data content corresponding to the a1 sub-cell is "test header 1", and the format attribute is "column width is 2, line width is 1, header". The a2 sub-cell is the rest of the split cell, so the data content corresponding to the a2 sub-cell can be set to null, and the row width and column width in the format attribute corresponding to the a2 sub-cell can be set to zero; the format attribute corresponding to the a2 sub-cell is obtained as "column width is 0, line width is 0, header".

It should be noted that, by retaining the header parameter in the format attribute corresponding to the remaining split cell, the header parameter is used to indicate that the remaining cell belongs to a part of the merged cell before splitting, and subsequently, whether the remaining cell is a header cell may be determined according to the header parameter in the format attribute corresponding to the remaining cell.

For example, if the B cell is a merged cell with two rows and two columns, and the data content corresponding to the B cell is "test header 0", and the format attributes are "column width is 2, row width is 2, and header", the B1 sub-cell is the first split cell, and the four sub-cells B1, B2, B3, and B4 are obtained by splitting. At this time, the data content and the format attribute corresponding to the B cell may be assigned to the B1 sub-cell, and the data content corresponding to the B1 sub-cell is "test header 0", and the format attribute is "column width is 2, line width is 0, header". The three subcells of B2, B3 and B4 are the rest of the cells after splitting, so the data content corresponding to the three subcells of B2, B3 and B4 can be set to be null value, and the row width and column width in the format attribute corresponding to the three subcells of B2, B3 and B4 are set to be zero; the format attributes corresponding to the three sub-cells of B2, B3 and B4 are all found to be "column width is 0, line width is 0, header".

It should be noted that the data content and the format attribute corresponding to the original single-row single-column unit cell that is not split are correspondingly reserved.

For example, if the C cell is a single row and a single column of cells, the C cell does not need to be split; the C cell retains its original data content and format attributes. For example, the data content corresponding to the C cell is "test data 1", and the format attributes are "column width is 1, and row width is 1".

Specifically, the merging cells are split into single-row single-column cells, and the data content and format attributes corresponding to the single-row single-column cells are matched to obtain the split table to be converted. Illustratively, the split table to be converted is shown in table 2.

Table 2 is the split form to be converted

Test meter 0

Test meter head 1

Test meter head 2

Test meter 3

Test meter 4

Test meter head 5

Test meter head 6

Test meter head 7

Test meter 8

Test data 0

Test data 1

Test data 2

Test data 3

Test data 4

Test data 5

Test data 6

Test data 7

Test data 8

Test data 9

Test data 10

Test data 11

Test data 12

Test data 13

Test data 14

Test data 15

Test data 16

Test data 17

Test data 18

Test data 19

Test data 20

Test data 21

Test data 22

Test data 23

Test data 24

Test data 25

Test data 26

Test data 27

Test data 28

Whether the table to be converted has the merged cells is judged according to the format attributes corresponding to the cells, the merged cells can be split into single-row and single-column cells, and therefore form conversion is conveniently carried out on the data content and the format attributes corresponding to the cells.

Referring to fig. 2, fig. 2 is a schematic flowchart illustrating that in step S20, format conversion is performed on the data content and the format attribute corresponding to each cell according to a preset format conversion policy to obtain target data corresponding to a table to be converted, and specifically, the method may include the following steps S203 and S204.

And step S203, sequentially converting the data content corresponding to each row of cells into a character string form to obtain a character string array corresponding to each row of cells.

The character string array comprises character strings corresponding to each row of cells.

Specifically, data content corresponding to each row of cells is converted into a character string form, and the character strings obtained by converting each row of cells are distributed to corresponding character string arrays.

Illustratively, in the split table to be converted, the cells in the first row are shown in table 3.

Table 3 shows the cells in the first row

Test meter 0

Test meter head 1

Test meter head 2

Test meter 3

When the format of the data content corresponding to the cell is converted, the data content is represented by a null character string if the data content is null.

Illustratively, the data content corresponding to the first row of cells is converted into a character string form, and the character string obtained by converting the first row of cells is distributed into the character string array a. Character string data a: [ "test header 0", "test header 1", "test header 2", "test header 3" ].

Illustratively, the data content corresponding to the second row of cells is converted into a character string form, and the character string obtained by converting the second row of cells is distributed into the character string array b. Character string data b: "," test header 4"," test header 5"," test header 6"," test header 7"," test header 8 "].

By sequentially converting the data content corresponding to each row of cells into a character string form, the character string arrays corresponding to each row of cells can be obtained, and the character string arrays of different rows of cells can be distinguished.

And S204, sequentially converting the format attributes corresponding to the cells of each row into key value pair forms based on preset column attribute fields, row attribute fields and header attribute fields to obtain key value pair arrays corresponding to the cells of each row.

The key value pair array comprises column attribute key value pairs, row attribute key value pairs and/or header attribute key value pairs corresponding to the cells in each row.

Illustratively, the preset column attribute field is colspan, which is used for representing a column width parameter in the format attribute; the preset line attribute field is a rowspan and is used for representing a line width parameter in the format attribute; the preset header attribute field comprises a border and a bold and is used for representing header parameters in the format attribute.

It should be noted that the header style corresponding to the header includes a frame and a frame. The header attribute field border indicates a border, and the header attribute field bold indicates a border bold. For example, if a cell is a header, the value corresponding to the header attribute field border corresponding to the cell is true and the value corresponding to the header attribute field bold is true, so as to indicate that the cell is a header cell.

Illustratively, if the corresponding format attribute of a cell is: column width is 2, line width is 2, head of table; converting the format attribute corresponding to the cell into a key-value pair form, wherein the converted key-value pair corresponding to the cell is as follows: { "colspan":2, "rowspan":2, "bowl": true, "border": true }.

Specifically, the format attributes corresponding to each row of cells are converted into a key-value pair format, and each row of cells are converted to obtain key-value pairs which are distributed to corresponding key-value pair arrays.

Illustratively, format attributes corresponding to the first row of cells of the table to be converted are respectively converted into a key-value pair form, and the key-value pairs obtained by converting the first row of cells are distributed into a key-value pair array a. The key-value pair array a corresponding to the first row of cells is obtained as follows:

[{"colspan":2,"rowspan":2,"bold":true,"border":true},{"colspan":0,"rowspan":0,"bold":true,"border":true},{"colspan":2,"rowspan":1,"bold":true,"border":true},{"colspan":0,"rowspan":0,"bold":true,"border":true},{"colspan":2,"rowspan":1,"bold":true,"border":true},{"colspan":0,"rowspan":0,"bold":true,"border":true},{"colspan":1,"rowspan":1,"bold":true,"border":true}]。

illustratively, format attributes corresponding to the third row of cells of the table to be converted are converted into key value pair forms respectively, and the key value pairs obtained by converting the third row of cells are distributed into a key value pair array c. The key-value pair array c corresponding to the first row of cells is obtained as follows:

[{"colspan":2,"rowspan":3},{"colspan":0,"rowspan":0},{"colspan":1,"rowspan":1},{"colspan":1,"rowspan":1},{"colspan":1,"rowspan":1},{"colspan":1,"rowspan":1},{"colspan":1,"rowspan":1}]。

it should be noted that when the cell is not a table head cell, the table head attribute key-value pair of the cell need not be represented by the table head attribute fields border and bold.

By sequentially converting the format attributes corresponding to the cells in each row into key value pair forms based on the preset column attribute field, row attribute field and header attribute field, formatting treatment can be carried out on the cells in each row according to the key value pair groups in the rendering process, format conversion can be carried out more conveniently and the conversion efficiency can be improved.

And S30, rendering the character string array and the key value pair array in the target data to a webpage to obtain a target webpage table corresponding to the table to be converted.

The rendering refers to a process of analyzing various resources or data by a browser rendering engine to output a visualized image or web page. The browser rendering engine comprises modules such as an HTML parser, a CSS parser, a layout and a JavaScript engine.

Referring to fig. 3, fig. 3 is a schematic flowchart of rendering the character string array and the key-value pair array in the target data to the web page in step S30 to obtain the target web page table corresponding to the table to be converted, which specifically includes the following steps S301 to S303.

And S301, acquiring a web form template.

Note that the HTML table is composed of table, one or more attribute tags tr, th, or td. Wherein, the Table attribute tag is used for defining a Table; the tr attribute tag is used for defining rows of the table; the th attribute tag is used for defining the header of the table; the td attribute tag is used to define a cell of the table.

In an embodiment of the present application, the initial web page table may include, but is not limited to, a cell attribute tag, a row attribute tag, and a header attribute tag. Wherein the cell attribute label can be denoted by td; the row attribute tag may be denoted tr; the header attribute tag may be denoted by th.

The row attribute tags are used for generating row numbers of the table, and the cell attribute tags are used for generating cells corresponding to the rows in the table. For example, if there are N row attribute tags, then N rows are generated; if there are M cell attribute tags, then M cells are generated in each row.

Step S302, adding the character string array in the target data to the webpage form template to obtain an initial webpage form.

In some embodiments, adding the array of character strings in the target data to the web page form template to obtain an initial web page form may include: determining the number corresponding to the row attribute tags in the web page table template according to the group number corresponding to the character string array in the target data; determining the number of cell attribute labels corresponding to each row in the web page table template according to the number of character strings in each character string array; determining the number of rows corresponding to the web page table template and the number of cells corresponding to each row according to the number corresponding to the row attribute tags and the number of the cell attribute tags corresponding to each row; and sequentially filling the character strings in each character string array into each row of cells corresponding to the web page table template to obtain an initial web page table.

It should be noted that, because each string array is obtained by converting the data content corresponding to each row of cells into a string form, and each row of cells corresponds to one string array, the number of rows corresponding to the row attribute tag can be determined according to the number of groups corresponding to the string array. In addition, when the data content corresponding to each row of cells is converted into a character string form, the cells in each row are single-row and single-column cells, so that the number of character strings in each character string array is the same, and the number of the cells of the cell attribute label corresponding to each row can be determined according to the number of the character strings in each character string array.

For example, if the number of groups corresponding to the character string array is 7, it may be determined that the number of corresponding row attribute tags is 7.

For example, if the number of strings in the string array is 7, for example [ "test header 0", "", "test header 1", "", "test header 2", "test header 3" ], it can be determined that each row corresponds to 7 cell attribute tags, i.e., each row includes 7 cells.

For example, if the number of the row attribute tags is 7 and the number of the cell attribute tags corresponding to each row is 7, it may be determined that the number of the rows corresponding to the web page table template is 7 and the number of the cells corresponding to each row is 7.

Specifically, the character strings in the character string arrays are sequentially filled into the cells of each row corresponding to the web page table template to obtain an initial web page table. Illustratively, the resulting initial web page form is shown in Table 4.

Table 4 is an initial web page form

Test meter 0

Test meter head 1

Test meter head 2

Test meter 3

Test meter 4

Test meter head 5

Test meter head 6

Test meter head 7

Test meter 8

Test data 0

Test data 1

Test data 2

Test data 3

Test data 4

Test data 5

Test data 6

Test data 7

Test data 8

Test data 9

Test data 10

Test data 11

Test data 12

Test data 13

Test data 14

Test data 15

Test data 16

Test data 17

Test data 18

Test data 19

Test data 20

Test data 21

Test data 22

Test data 23

Test data 24

Test data 25

Test data 26

Test data 27

Test data 28

Step S303, formatting the cells in the initial web page table according to the key value pair group in the target data to obtain a target web page table corresponding to the table to be converted, where the target web page table is stored in the block chain.

It should be noted that, in the embodiment of the present application, the formatting process refers to merging cells of the initial web page table and adding a header style. It can be understood that, instead of merging and adding header styles to all cells in the original web page table, which cells need to be merged and added header styles are determined according to the key value pair array in the target data.

In some embodiments, formatting cells in the initial web page table according to the key value pair group in the target data to obtain a target web page table corresponding to the table to be converted may include: determining a column attribute value and a row attribute value corresponding to a cell attribute label in an initial webpage table according to a column attribute key value pair and a row attribute key value pair in the key value pair array; determining a cell carrying a header attribute label in an initial webpage table according to a header attribute key value pair in the key value pair array; adding a preset header style to the cells carrying the header attribute tags, and combining the cells according to the column attribute values and the row attribute values of the cell attribute tags corresponding to the cells to obtain a target webpage table corresponding to the table to be converted.

According to the column attribute key value pair and the row attribute key value in the key value pair array and the header attribute key value pair in the key value pair array, the column attribute value and the row attribute value corresponding to each cell attribute label and the cell carrying the header attribute label can be determined more quickly and accurately.

Illustratively, if key-value pair array a is: [ { "collen": 2, "rows":2, "bold": true, "border": true }, { "collen": 0, "rows":0, "bold": true, "true": true, "border": 0, "row": 0, "bowl": true, "border": true }, { "row": 1, "bowl": tree ":1," tree ": true," box ": tree }, {" column "{" 0, "row": 0, "row" { "tree": 1, "bowl": 1, "row" -, "tree" - { "1, {" tree "-: 1, { (1) and" tree "{ (1) of the original row" { (1) of the "tree" { (1) of the "row" { (1, { (1) of the original row "{ (1) of the original row" { (of the "tree": 1) of the "row" { (1) of the original row of the "tree" } tree "{ (1, and the original row of the" tree "{ (1) of the property of the" row "{ (1) of the original row of the" tree "{ (1) of the" tree, (2,1),(0,0),(2,1),(0,0),(1,1)}.

Illustratively, the cells carrying the header attribute labels in the initial web page table are determined according to the header attribute key-value pairs in the key-value pair array. For example, the cell in which the key value pair "bold" and the key value pair "border" true exist is taken as the cell carrying the header attribute label; there is no key-value pair "bold" and both true and key-value pairs "border" and the cell of true is not the cell carrying the header attribute tag.

Specifically, adding a preset header style to a cell carrying a header attribute label; illustratively, the cells carrying the header attribute labels are framed and the frames are bolded.

Specifically, each cell is merged according to the column attribute value and the row attribute value of the cell attribute label corresponding to each cell. For example, if the column attribute value and the row attribute value of the cell attribute tag corresponding to the cell are (2,2), it indicates that the cell needs to be merged into cells in two rows and two columns. For example, the cell is merged with the cell corresponding to the next row and the cell corresponding to the next column to obtain the cells of two rows and two columns.

It should be noted that, in the process of merging the cells, merging may be performed sequentially from left to right; for the cell with the column attribute value and the row attribute value of (0,0) of the cell attribute label, the cell is not displayed.

Illustratively, the target web page table corresponding to the table to be converted is shown in table 5.

Table 5 is a target web page form

It is emphasized that, to further ensure the privacy and security of the target netpage table, the target netpage table may also be stored in a node of a blockchain.

By adding the character string array in the target data to the webpage table template and formatting the cells in the initial webpage table according to the key value pair group in the target data, the target webpage table can be generated more conveniently and more conveniently, and the table conversion efficiency is improved.

It should be noted that, in the embodiment of the present application, after the target web page table corresponding to the table to be converted is obtained, an editing operation may also be performed on the web page table in the web page.

Referring to fig. 4, the table conversion method may further include step S40.

Step S40, if the selection operation of the user on the web page table in the web page is obtained, determining the web page table to be edited according to the selection operation, and editing the web page table to be edited according to the editing operation of the user on the web page table to be edited.

Illustratively, a page includes a plurality of web pages tables; the user can select the web page form that the user wants to edit in the page. Therefore, the webpage table selected by the user can be used as the webpage table to be edited according to the selection operation of the user.

The editing operation may include, but is not limited to, operations of adding content to the cell, hiding the cell, expanding the cell, and the like.

Specifically, the cell includes two types of an input box and a popup window. The display Input box can be realized through a Span label, and the display popup can be realized through an Input label. For example, clicking on a cell may display an input box; double clicking on the cell may display a pop-up window. It should be noted that the Span tag is used to define a section in a document, and the Input tag is used to define an Input control.

In some embodiments, if the editing operation of the user for adding content to the cell in the web page table to be edited is acquired, the content is added to the cell in the web page table to be edited according to the editing operation.

For example, when the cell is clicked by the user, the cell can be switched to an input box; and displaying according to the content input by the user in the input box. For example, when the user clicks the cell "test data 1", the cell "test data 1" is switched to an input box as shown in fig. 5. The user can perform an editing operation in the input box.

In some embodiments, if the editing operation that the user sets the hidden cell in the web page table to be edited is acquired, the hidden cell is hidden according to the editing operation.

Illustratively, when the user double-click on a cell is acquired, a popup window corresponding to the cell can be displayed; and hiding the cells according to the parameters set in the pop-up window by the user. When the user double-clicks the cell "test data 1", the popup is displayed as shown in fig. 6 below; the hiding of the cells can be performed according to the hidden line number and the hidden state set in the pop-up window by the user.

Specifically, the hidden line number set in the pop-up window by the user is 2 and the hidden state is selected, which can be implemented by the following codes: mergeRules { { "2-2": { "rows":2, "hidden": true } }; it shows row 2, column 2 data as the trigger point for folding, and the lower two rows are folded, and the initial state is hidden.

Illustratively, according to the editing operation of the hidden cell set by the user, the hidden cell is performed on the web page table to be edited, and the web page table to be edited after the hidden cell is performed is shown in fig. 7.

In other embodiments, if the editing operation that the user expands the hidden cells in the web page table to be edited is acquired, the hidden cells are expanded according to the editing operation.

For example, when the user needs to re-expand the hidden cell, the user can click the folded trigger point and set the trigger point in the displayed pop-up window. For example, the number of hidden lines set is 0 and the hidden state is unselected. The method can be realized by the following codes: mergeRules { { "2-2": { "rows":0, "hidden": false } }; it shows row 2, column 2 data as the trigger point for unfolding, unfolding the two rows below, and the initial state is non-hidden.

By editing the web page table to be edited according to the editing operation of the web page table to be edited by the user, the data content in the cells can be modified, the cells can be hidden, the hidden cells can be expanded, and other application scenes can be realized, so that the user can edit the web page table more conveniently.

In the form conversion method provided by the embodiment, the data content and the format attribute corresponding to each cell in the form to be converted are sequentially extracted, and then the form conversion can be directly performed on the data content and the format attribute corresponding to each cell, so that the form conversion efficiency is improved; judging whether a table to be converted has a merging cell or not according to the format attribute corresponding to the cell, and splitting the merging cell into a single row and a single column of cells so as to conveniently perform form conversion on the data content and the format attribute corresponding to each cell; by sequentially converting the data content corresponding to each row of cells into a character string form, a character string array corresponding to each row of cells can be obtained, and the character string arrays of different rows of cells can be distinguished; the format attributes corresponding to each row of cells are sequentially converted into a key value pair form based on the preset column attribute field, the preset row attribute field and the preset header attribute field, so that each row of cells can be formatted according to the key value pair group in the rendering process, and format conversion can be performed more conveniently; by adding the character string array in the target data to the webpage table template and formatting the cells in the initial webpage table according to the key value pair group in the target data, the target webpage table can be generated more conveniently and more conveniently, and the table conversion efficiency is improved; by editing the web page table to be edited according to the editing operation of the web page table to be edited by the user, the data content in the cells can be modified, the cells can be hidden, the hidden cells can be expanded, and other application scenes can be realized, so that the user can edit the web page table more conveniently.

Referring to fig. 8, fig. 8 is a schematic block diagram of a table conversion apparatus 100 according to an embodiment of the present application, the table conversion apparatus being configured to perform the table conversion method described above. Wherein, the table conversion device can be configured in a server or a terminal.

As shown in fig. 8, the table conversion apparatus 100 includes: a data acquisition module 101, a form conversion module 102, a data rendering module 103, and a table editing module 104.

The data obtaining module 101 is configured to obtain a table to be converted, and extract data content and format attributes corresponding to each cell in the table to be converted.

The format conversion module 102 is configured to perform format conversion on the data content and the format attribute corresponding to each cell according to a preset format conversion policy to obtain target data corresponding to the table to be converted, where the target data includes a character string array and a key value pair array.

And the data rendering module 103 is configured to render the character string array and the key value pair array in the target data to a webpage, so as to obtain a target webpage table corresponding to the table to be converted.

The form editing module 104 is configured to determine, if a selection operation of a user on a web form in a web page is obtained, a web form to be edited according to the selection operation, and edit the web form to be edited according to an editing operation of the user on the web form to be edited.

It should be noted that, as will be clear to those skilled in the art, for convenience and brevity of description, the specific working processes of the apparatus and the modules described above may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.

The apparatus described above may be implemented in the form of a computer program which is executable on a computer device as shown in fig. 9.

Referring to fig. 9, fig. 9 is a schematic block diagram of a computer device according to an embodiment of the present disclosure. The computer device may be a server or a terminal.

Referring to fig. 9, the computer device includes a processor and a memory connected by a system bus, wherein the memory may include a nonvolatile storage medium and an internal memory.

The processor is used for providing calculation and control capability and supporting the operation of the whole computer equipment.

The internal memory provides an environment for running a computer program in the non-volatile storage medium, which when executed by the processor, causes the processor to perform any of the table conversion methods.

It should be understood that the Processor may be a Central Processing Unit (CPU), and the Processor may be other general purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, etc. Wherein a general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

Wherein, in one embodiment, the processor is configured to execute a computer program stored in the memory to implement the steps of:

acquiring a table to be converted, and extracting data content and format attributes corresponding to each cell in the table to be converted; performing format conversion on data content and format attributes corresponding to each cell according to a preset format conversion strategy to obtain target data corresponding to the table to be converted, wherein the target data comprises a character string array and a key value pair array; and rendering the character string array and the key value pair array in the target data to a webpage to obtain a target webpage table corresponding to the table to be converted.

In one embodiment, before the processor performs format conversion on the data content and the format attribute corresponding to each cell according to a preset format conversion policy to obtain target data corresponding to the table to be converted, the processor is further configured to:

judging whether the table to be converted has a merging cell or not according to the format attribute corresponding to the cell; and if the merged cells exist, splitting the merged cells into single-row and single-column cells, and matching the data content and the format attribute corresponding to each single-row and single-column cell.

In one embodiment, the format attribute includes a row width and a column width; when the processor is used for realizing matching of the data content and the format attribute corresponding to the single-row single-column unit cells, the processor is used for realizing:

acquiring data content and format attributes corresponding to the merging cells, and assigning the data content and the format attributes corresponding to the merging cells to the split first cell; and setting the data content corresponding to the residual split cells as a null value and setting the line width and the column width in the format attribute as zero.

In one embodiment, when implementing format conversion on the data content and the format attribute corresponding to each cell according to a preset format conversion policy to obtain target data corresponding to the table to be converted, the processor is configured to implement:

sequentially converting data contents corresponding to each row of cells into a character string form to obtain a character string array corresponding to each row of cells, wherein the character string array comprises character strings corresponding to each row of cells; sequentially converting format attributes corresponding to the cells of each row into key value pair forms based on preset column attribute fields, row attribute fields and header attribute fields to obtain key value pair arrays corresponding to the cells of each row, wherein the key value pair arrays comprise column attribute key value pairs, row attribute key value pairs and/or header attribute key value pairs corresponding to the cells of each row.

In one embodiment, the processor is configured to, when rendering a string array and a key-value pair array in the target data to a web page to obtain a target web page table corresponding to the table to be converted, implement:

acquiring a web page form template; adding the character string array in the target data to the webpage form template to obtain an initial webpage form; and formatting the cells in the initial webpage table according to the key value pair group in the target data to obtain a target webpage table corresponding to the table to be converted, wherein the target webpage table is stored in a block chain.

In one embodiment, the web page form template includes a row attribute tag, a cell attribute tag, and a header attribute tag; when the processor adds the character string array in the target data to the web page table template to obtain an initial web page table, the processor is used for realizing that:

determining the number corresponding to the row attribute tags in the web page table template according to the group number corresponding to the character string array in the target data; determining the number of cell attribute labels corresponding to each line in the web page table template according to the number of character strings in each character string array; determining the number of rows corresponding to the web page table template and the number of cells corresponding to each row according to the number corresponding to the row attribute tags and the number of the cell attribute tags corresponding to each row; and sequentially filling the character strings in each character string array into each row of cells corresponding to the web page table template to obtain an initial web page table.

In an embodiment, when the processor formats the cells in the initial web page table according to the key value pair group in the target data to obtain the target web page table corresponding to the table to be converted, the processor is configured to:

determining a column attribute value and a row attribute value of a cell attribute label corresponding to each cell in the initial webpage table according to a column attribute key value pair and a row attribute key value pair in the key value pair array; determining a cell carrying a header attribute label in the initial webpage table according to a header attribute key value pair in the key value pair array; adding a preset header style to the cells carrying the header attribute tags, and merging the cells according to the column attribute values and the row attribute values of the cell attribute tags corresponding to the cells to obtain a target webpage table corresponding to the table to be converted.

In an embodiment, after the processor renders the string array and the key-value pair array in the target data to a web page to obtain a target web page table corresponding to the table to be converted, the processor is further configured to:

if the selection operation of the user on the web page table in the web page is obtained, determining the web page table to be edited according to the selection operation, and editing the web page table to be edited according to the editing operation of the user on the web page table to be edited.

The embodiment of the application further provides a computer-readable storage medium, wherein a computer program is stored in the computer-readable storage medium, the computer program comprises program instructions, and the processor executes the program instructions to realize any table conversion method provided by the embodiment of the application.

The computer-readable storage medium may be an internal storage unit of the computer device described in the foregoing embodiment, for example, a hard disk or a memory of the computer device. The computer readable storage medium may also be an external storage device of the computer device, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital Card (SD Card), a Flash memory Card (Flash Card), and the like provided on the computer device.

Further, the computer-readable storage medium may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function, and the like; the storage data area may store data created according to the use of the blockchain node, and the like.

The block chain referred by the application is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.

While the invention has been described with reference to specific embodiments, the scope of the invention is not limited thereto, and those skilled in the art can easily conceive various equivalent modifications or substitutions within the technical scope of the invention. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.

Claims

1. A table conversion method, comprising:

2. The form conversion method according to claim 1, wherein before performing form conversion on the data content and the format attribute corresponding to each cell according to a preset form conversion policy to obtain the target data corresponding to the form to be converted, the method further comprises:

judging whether the table to be converted has a merging cell or not according to the format attribute corresponding to the cell;

and if the merged cells exist, splitting the merged cells into single-row and single-column cells, and matching the data content and the format attribute corresponding to each single-row and single-column cell.

3. The table conversion method according to claim 2, wherein the format attribute includes a line width and a column width; the matching of the data content and the format attribute corresponding to the single-row and single-column unit cells comprises:

acquiring data content and format attributes corresponding to the merging cells, and assigning the data content and the format attributes corresponding to the merging cells to the split first cell;

and setting the data content corresponding to the residual split cells as a null value and setting the line width and the column width in the format attribute as zero.

4. The form conversion method according to claim 2, wherein the form converting the data content and the format attribute corresponding to each cell according to a preset form conversion policy to obtain the target data corresponding to the form to be converted includes:

sequentially converting data contents corresponding to each row of cells into a character string form to obtain a character string array corresponding to each row of cells, wherein the character string array comprises character strings corresponding to each row of cells;

sequentially converting format attributes corresponding to the cells of each row into key value pair forms based on preset column attribute fields, row attribute fields and header attribute fields to obtain key value pair arrays corresponding to the cells of each row, wherein the key value pair arrays comprise column attribute key value pairs, row attribute key value pairs and/or header attribute key value pairs corresponding to the cells of each row.

5. The form conversion method according to claim 1, wherein the rendering the character string array and the key-value pair array in the target data to a web page to obtain a target web page form corresponding to the form to be converted includes:

acquiring a web page form template;

adding the character string array in the target data to the webpage form template to obtain an initial webpage form;

and formatting the cells in the initial webpage table according to the key value pair group in the target data to obtain a target webpage table corresponding to the table to be converted, wherein the target webpage table is stored in a block chain.

6. The form conversion method of claim 5, wherein the web form template includes a row attribute tag, a cell attribute tag, and a header attribute tag; adding the character string array in the target data to the web page table template to obtain an initial web page table, wherein the method comprises the following steps:

determining the number corresponding to the row attribute tags in the web page table template according to the group number corresponding to the character string array in the target data;

determining the number of cell attribute labels corresponding to each line in the web page table template according to the number of character strings in each character string array;

determining the number of rows corresponding to the web page table template and the number of cells corresponding to each row according to the number corresponding to the row attribute tags and the number of the cell attribute tags corresponding to each row;

filling character strings in each character string array into each row of cells corresponding to the web page table template in sequence to obtain an initial web page table;

the formatting the cells in the initial web page table according to the key value logarithm group in the target data to obtain a target web page table corresponding to the table to be converted, including:

determining a column attribute value and a row attribute value of a cell attribute label corresponding to each cell in the initial webpage table according to a column attribute key value pair and a row attribute key value pair in the key value pair array;

determining a cell carrying a header attribute label in the initial webpage table according to a header attribute key value pair in the key value pair array;

adding a preset header style to the cells carrying the header attribute tags, and merging the cells according to the column attribute values and the row attribute values of the cell attribute tags corresponding to the cells to obtain a target webpage table corresponding to the table to be converted.

7. The form conversion method according to any one of claims 1 to 6, wherein after rendering a string array and a key-value pair array in the target data to a web page to obtain a target web page form corresponding to the form to be converted, the method further comprises:

8. A form conversion apparatus, comprising:

9. A computer device, wherein the computer device comprises a memory and a processor;

the memory for storing a computer program;

the processor for executing the computer program and implementing the table conversion method according to any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program which, when executed by a processor, causes the processor to implement the table conversion method according to any one of claims 1 to 7.