CN113010588B - Data form processing method - Google Patents
Data form processing method Download PDFInfo
- Publication number
- CN113010588B CN113010588B CN201911328407.6A CN201911328407A CN113010588B CN 113010588 B CN113010588 B CN 113010588B CN 201911328407 A CN201911328407 A CN 201911328407A CN 113010588 B CN113010588 B CN 113010588B
- Authority
- CN
- China
- Prior art keywords
- data
- file
- data table
- parser
- cell
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a processing method of a data table, which comprises the following steps: when an uploading instruction of a first data table is received, acquiring identification information of the first data table, wherein the identification information is used for determining the association relation between the first data table and a first parser file; searching a first parser file according to the identification information; under the condition that the first parser file is found, the first data table is parsed according to the first parser file to obtain a preset format data file, wherein the preset format data file is a format data file capable of being directly input into an information system; and recording the preset format data file into an information system.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a data table processing method.
Background
With the development and popularization of modern computer software technology, means for information data exchange are also becoming more and more diversified. From a fat server thin client mode taking a large computer as a center at the beginning of a computer, to a thin server fat client mode which is changed by the development of the later personal computer technology, and to a fat server thin client mode which is gradually returned by the development of the current cloud computing and network transmission technology; the exchange of data information is interacted and transferred up and down by means of formatting. The up-down interaction and transmission of the data information all require the user to install data entry software in the client computer or open a designated entry webpage to carry out format data reporting, and then the data is transmitted in a network or off-line mode. That is, the software is used to fill in data in a prescribed format, thereby ensuring the efficiency of data filling.
However, the data filling software may not be installed due to information security, network limitations, technical quality of the computer user, etc., and may effectively fill the data. In the related art, a table component in Office software is adopted as a substitute software of data reporting software. The Office data form component has wide use, and avoids the factors such as information security, network limitation, technical quality of computer users and the like.
However, after the data to be recorded is collected through the office form component, the data recorder needs to manually record form data on a data recording interface of the information recording system; resulting in low entry efficiency and high data entry error rate.
Disclosure of Invention
In view of the above, the invention provides a method for processing a data form, so as to solve the problem that in the related art, after a data logger acquires data to be logged through an office form component, the data logger needs to manually log the form data on a data logging interface of an information logging system; the method has the advantages of low input efficiency and high data input error rate.
To achieve the above object, according to one aspect of the present invention, there is provided a method for processing a data table, including:
when an uploading instruction of a first data table is received, acquiring identification information of the first data table, wherein the identification information is used for determining an association relation between the first data table and a first parser file;
searching the first parser file according to the identification information;
under the condition that the first parser file is found, the first data table is parsed according to the first parser file to obtain a preset format data file, wherein the preset format data file is a format data file capable of being directly input into an information system;
and inputting the preset format data file into the information system.
In one alternative, before the acquiring the identification information of the first data table, the method further includes:
setting attribute information of the first data table according to service requirements, wherein the attribute information comprises at least one of the following information: cell pattern, position of value cell, position of title cell corresponding to value cell, and repeating relation of multiple cells;
when a storage instruction for storing the first data table is received, generating identification information of the first data table and a first parser file corresponding to the first data table;
writing the identification information into the first parser file to establish an association relationship between the first parser file and the first data table.
In an optional manner, the attribute information includes a value unit and a title unit, and the parsing the first data table according to the first parser file to obtain a data file with a preset format includes:
acquiring first position information of the value unit cell and second position information of the title unit cell in the first parser file;
acquiring the value of the value unit cell in the first data table according to the first position information;
acquiring a first title of the title cell in the first data table according to the second position information;
and filling the value into a first preset position of the first parser file to obtain the preset format file, wherein the first preset position comprises a target cell matched with the title and/or cells within a preset range of the target cell.
In an optional manner, before the filling the value into the first preset position of the first parser file to obtain the preset format file, the method further includes:
and under the condition that the data table field is a repeated field, repeatedly filling values corresponding to the repeated field at a second preset position of the first parser file according to the repeated relation, and constructing a plurality of data records to obtain the preset format file.
In an optional manner, before the obtaining the first position information of the value unit cell and the second position information of the title unit cell in the first parser file, the method further includes:
summarizing the first parser file according to the first data table to obtain an initialized data set under the condition that the first data table is a plurality of tables;
the obtaining the first position information of the value cell and the second position information of the title cell in the first parser file includes:
the first position information and the second position information are acquired from the initialization data set.
In an optional manner, after the searching the first parser file according to the identification information, the method further includes:
acquiring a second title of a title cell of the first data table under the condition that the first parser file is not found;
sequentially matching the second title with the titles of the title cells in the first parser file;
and under the condition that the titles of the title cells in the first parser file are all in the first data table, parsing the first data table according to the first parser file to obtain a preset format data file.
In an alternative manner, after the entering of the preset format data file into the information system, the method further comprises:
when a table data export instruction is received, table data is acquired from the information system according to a second parser file, wherein the second parser file comprises table fields of the data to be acquired, and the table fields are subsets or whole sets of the table fields of the first data table;
and constructing a second data table according to the second parser file, and filling the table data into the second data table.
In an alternative manner, the constructing a second data table according to the second parser file, and filling the table data into the second data table, includes:
acquiring third position information corresponding to the table data and/or a second title corresponding to the table data;
constructing the second data table according to the third position information and/or the second title;
and filling the form data into a third preset position of the second data form.
In an alternative manner, in a case that the table data export instruction is to export a plurality of data tables, the constructing a second data table according to the second parser file, and populating the table data into the second data table includes:
summarizing the second parser file according to a plurality of data tables to obtain a second parser file data set;
searching cell data in the second parser file data set according to data table names and/or field names of a plurality of the data tables,
and filling the cell data into the second data table.
In an alternative manner, the constructing a second data table according to the second parser file, and filling the table data into the second data table, includes:
and adding a table row at a fourth preset position of the second data table under the condition that a repeated data row exists in the second parser file, wherein the repeated data row is used for filling the table row.
The invention provides a processing method of a data table, which comprises the following steps: when an uploading instruction of a first data table is received, acquiring identification information of the first data table, wherein the identification information is used for determining the association relation between the first data table and a first parser file; searching a first parser file according to the identification information; under the condition that the first parser file is found, the first data table is parsed according to the first parser file to obtain a preset format data file, wherein the preset format data file is a format data file capable of being directly input into an information system; and recording the preset format data file into an information system. When the data entry person collects the first data form and uploads the first data form, the first analyzer file corresponding to the identification information is searched through the identification information of the first data form, the first analyzer file is utilized to analyze the first form data into the preset format data file which can be directly input into the information system, and therefore the preset format data file obtained through analysis can be directly uploaded into the information system, and the problems of low efficiency and high error rate of manually inputting the form data in a data input interface of the information system by the data entry person are avoided. The accuracy and the input efficiency of data form input are improved.
The foregoing description is only an overview of the present invention, and is intended to be implemented in accordance with the teachings of the present invention in order that the same may be more clearly understood and to make the same and other objects, features and advantages of the present invention more readily apparent.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to designate like parts throughout the figures.
FIG. 1 is a flowchart of an implementation of a method for processing a data table according to an embodiment of the present application;
FIG. 2 is an exemplary style of a template form provided by an embodiment of the present application;
FIG. 3 is a flowchart of an implementation of a method for processing a data table according to another embodiment of the present application;
FIG. 4 is a flowchart of an implementation of a method for processing a data table according to another embodiment of the present application;
fig. 5 is a schematic structural diagram of a processing device for a data table according to an embodiment of the present application.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
In the description of embodiments of the present invention, the terms "first," "second," and the like are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include at least one such feature. In the description of the present invention, the meaning of "plurality" means at least two, for example, two, three, etc., unless specifically defined otherwise.
Fig. 1 is a flowchart of an implementation of a method for processing a data table according to an embodiment of the present application. FIG. 2 is an example style of a template form provided by embodiments of the present application.
Referring to fig. 1 and fig. 2, the method for processing a data table provided in the embodiments of the present application is specifically applied to importing form data acquired by an office data table component into an information system, or exporting an office data table from the information system; specifically, the data table processing method provided by the embodiment of the application can be applied to electronic equipment such as a computer, a notebook computer, a tablet computer or a mobile terminal; the processing method of the data table comprises the following steps:
The identification information is used for determining the association relation between the first data table and the first parser file.
Specifically, in the embodiment of the present application, the first data table may be a data table generated by the data logger when the data logger collects the table data; specifically, the data entry person generates the identification information of the data form after collecting and storing the form data. In some alternative embodiments, the identification information may be a randomly generated identifier, such as a GUID number, which is not repeated and may be used as a unique identifier for the first data table.
Specifically, in the embodiment of the present application, the first parser file also has the same identification information as the first data table, and when the first data table needs to be uploaded, the first parser file is searched through the identification information, and the first data table is parsed by using the first parser file.
Step 103, under the condition that the first parser file is found, parsing the first data table according to the first parser file to obtain a data file with a preset format.
The preset format data file is a format data file which can be directly input into an information system.
Specifically, in the embodiment of the present application, an association relationship is established between the first parser file and the first data table through the identification information, and when the data logger uploads the first data table, the corresponding first parser file is found through the identification information, for example, the GUID number, so that the first parser file is a parser file corresponding to the first data table, and the first data table can be parsed into a data file with a preset format, so that the data system can be directly logged.
And 104, inputting the data file with the preset format into an information system.
According to the processing method for the data form, when the data logger collects the first data form and uploads the first data form, the first parser file corresponding to the identification information is searched through the identification information of the first data form, the first parser file is utilized to parse the first form data into the preset format data file which can be directly input into the information system, and therefore the preset format data file obtained through parsing can be directly uploaded into the information system, and the problems that the efficiency of manually inputting the form data in a data input interface of the information system by the data logger is low and the error rate is high are avoided. The accuracy and the input efficiency of data form input are improved.
Fig. 3 is a flowchart of an implementation of a method for processing a data table according to another embodiment of the present application.
Based on the foregoing embodiments, referring to fig. 3, the processing method of the data table provided in this embodiment includes the following steps:
Wherein the attribute information includes at least one of the following information: cell style, position of the valued cell, position of the title cell corresponding to the valued cell, and repeating relation of the plurality of cells.
Specifically, in this embodiment, the service requirement may be a requirement of an information system user, for example, a service requirement related to a certain enterprise, etc.
In some specific examples, a designer opens a new form configuration form through the Dev Express component, designs a form through the designer, or opens an existing Excel form, adjusts the cell style of the template form, e.g., font, color, merging, bounding box, etc. Referring to fig. 2, the positions of the title cells (such as "name", "gender" shown in fig. 2), the positions of the value cells (such as "name", "gender" right side or below cells shown in fig. 2), and the repetition relationship (such as "family member" or "educational background" shown in fig. 2) or the repetition range of the cells are set. Thus, after the template table is designed, when the template table is stored, the identification information corresponding to the template table is generated. And when the data entry person finishes data acquisition in the template form and uploads the first data form, acquiring the identification information of the first data form.
In the embodiment of the application, the attribute information of the first data form is set according to the service requirement of the information system user, so that after the template form is generated, the information system user only needs to fill in the acquired data in the template form and upload the template form to the information system, and after the service requirement of the information system user changes, only needs to redesign the template form, and the information system is not required to be redeveloped, so that the service expandability of the information system is improved, the time requirement of the information system user is ensured, and meanwhile, the development cost of the information system is saved.
In step 302, when a save instruction for saving the first data table is received, identification information of the first data table and a first parser file corresponding to the first data table are generated.
Specifically, in the embodiment of the present application, after completing the design of the template table, when the designer saves the template table, the designer randomly generates the identification information of the template table, and in some alternative examples, the identification information may include a GUID number; in other alternative examples, the identification information of the template table may be sequentially generated in the preservation order. The generation order of the identification information in the embodiment of the present application is not particularly limited.
In some specific examples, the identification information of the generated template table is written into the first parser file to determine the association relationship between the template table and the first parser file, so that when the data logger uploads the first data table (i.e. the template table with data acquisition completed), the first parser file corresponding to the first data table can be quickly found through the identification information, so as to parse the first data table.
In some specific examples, the attribute information includes a value cell and a title cell. Step 306, according to the first parser file, parse the first data table to obtain a data file in a preset format, including:
and acquiring the first position information of the value cell and the second position information of the title cell in the first parser file.
And acquiring the value of the value cell in the first data table according to the first position information.
Specifically, in this embodiment of the present application, since the first parser file has a correspondence with the first data table, the first parser file stores first location information (for example, a cell on the right side of the name shown in fig. 2) of a value cell in the first data table, and after the first parser file corresponding to the first data table is found, the value is taken from the location corresponding to the first data table through the first location information of the value cell recorded in the first parser file.
And acquiring a first title of the title cell in the first data table according to the second position information.
Specifically, after the second position information of the title cell in the first data table is determined through the first parser file, the first title is acquired from the corresponding position in the first data table.
In some optional embodiments, when the data table field is a repeated field, repeatedly filling values corresponding to the repeated field in a second preset position of the first parser file according to the repeated relation, and constructing a plurality of data records to obtain the preset format file.
Specifically, referring to the "educational background" shown in fig. 2 as a repetitive data line, data is searched in the repetitive range according to a second preset position for the "educational background", and thus, a plurality of data records can be constructed.
And filling the value into a first preset position of the first parser file to obtain a preset format file, wherein the first preset position comprises target cells matched with the title and/or cells within a preset range of the target cells.
In some specific examples, the first preset location may include a subsequent string of the target cell, a right cell of the target cell, a lower cell of the target cell. In some possible examples, the first preset location may also include a cell to the left of the target cell.
In some alternative embodiments, in the case that the first data table is a plurality of tables, the first parser file is summarized according to the first data table to obtain the initialized data set.
Specifically, when a plurality of first data tables are operated at the same time, a plurality of first parser files are searched; at this time, the first parser file is summarized, and an initialized parser file set is generated.
First location information and second location information are obtained from an initialization data set.
Specifically, the value is taken according to the first position information of the value cell configured in the parser file set, and the first title is acquired according to the second position information of the title cell.
In an alternative embodiment, referring to fig. 3, step 305 further includes, after searching the first parser file according to the identification information:
in step 307, in the case that the first parser file is not found, the second header of the header cell of the first data table is obtained.
Specifically, in some possible examples, after the design of the template table is completed, the generated identification information may not be written into the first parser file due to a fault or the like; at this time, in the case where the first parser file may not be found, a matching search may be performed through the second header in the header cell in the first data table.
Specifically, when designing the template table, the first parser file records the titles in the title cells in the template table. At this time, the acquired second titles are sequentially matched with the first parser file.
In step 309, when the titles of the title cells in the first parser file are all in the first data table, the first data table is parsed according to the first parser file, so as to obtain a data file with a preset format.
In this embodiment, the second header in the header cell of the first data table is extracted to match with the header in the first parser file, so as to obtain a matched parser file, and the first data table is parsed by the parser file, which avoids the situation that the corresponding first parser file cannot be found by the identification information under the condition of failure, and ensures the normal parsing of the first data table.
It should be noted that, the present embodiment has the same or corresponding beneficial technical effects as other embodiments of the present application, and will not be described herein.
Fig. 4 is a flowchart of an implementation of a method for processing a data table according to another embodiment of the present application.
Based on the foregoing embodiments, referring to fig. 4, a method for processing a data table according to another embodiment of the present application includes the following steps:
The second parser file includes a table field of the data to be obtained, where the table field is a subset or a whole set of the table field of the first data table.
In some specific examples, data in the information system needs to be exported, e.g., exported, into an Excel form for printing for viewing during use of the information system. At this time, according to the data export requirement, the style and data of the table to be reconstructed are designed. Specifically, when the fields of the table are reconstructed, the subset or the whole set of the first data table can be rearranged and defined according to the requirements, and after the design is completed, an export template table and a second parser file are generated, wherein the second parser file and the export template table are provided with identification information, such as GUID numbers.
Specifically, the parser file is parsed, and corresponding table data is obtained from the information system according to the content of the parser. And reconstructing the form template according to the parser file by using an Apose. Cell component to obtain a second data form. At this time, the second data table is an empty table.
Specifically, after the second data table is built, table data is obtained from the information system according to the table fields recorded in the second parser file, and the table data is filled into the position corresponding to the second data table, so that the second data table is derived.
In an alternative embodiment, step 402, building a second data table according to the second parser file, and populating the table data to the second data table, includes:
and acquiring third position information corresponding to the form data and/or a second title corresponding to the form data.
Specifically, the third location information is location information corresponding to the table data in the second parser file.
Constructing a second data table according to the third position information and/or the second title;
and filling the form data into a third preset position of the second data form.
Specifically, the third preset position may be a position corresponding to third position information of the second parser file in the second table data.
In an alternative embodiment, in a case where the table data export instruction is to export a plurality of data tables, step 402, building a second data table according to the second parser file, and populating the table data to the second data table, includes:
summarizing the second parser file according to the plurality of data tables to obtain a second parser file data set;
searching the cell data in the second parser file data set according to the data table names and/or field names of the plurality of data tables,
and filling the cell data into a second data table.
In an alternative embodiment, step 402, building a second data table according to the second parser file, and populating the table data to the second data table, includes:
and adding a table row at a fourth preset position of the second data table under the condition that repeated data rows exist in the second parser file, wherein the repeated data rows are used for filling the table row.
Specifically, referring to the "educational background" shown in fig. 2, in the embodiment of the present application, the fourth preset position may include a cell on the right side of the educational background, and may also include a cell below the educational background.
In some optional implementations, the method for processing a data table provided in this embodiment further includes:
In this embodiment, the apose. Cell component is used to reconstruct the template table according to the parser file, and fill the data into the constructed template table according to the setting of the parser file ", so that the required table data can be completely reproduced in the form of the parser. The required form data and parser file are matched, and thus, the data form file of the original imported data can be completely reproduced. In addition, in some specific examples, some unnecessary fields can be deleted, only the needed field data is exported, and the filterability of the table data is improved.
Fig. 5 is a schematic structural diagram of a processing device for a data table according to an embodiment of the present application.
Based on the foregoing embodiments, referring to fig. 5, the processing apparatus 50 for a data table provided in the embodiment of the present application includes:
the obtaining module 51 is configured to obtain, when receiving an upload instruction of the first data table, identification information of the first data table, where the identification information is used to determine an association relationship between the first data table and the first parser file;
a searching module 52, configured to search the first parser file according to the identification information;
the parsing module 53 is configured to parse the first data table according to the first parser file to obtain a preset format data file, where the preset format data file is a format data file that can be directly input into the information system;
an entry module 54 for entering a data file of a preset format into the information system.
In an alternative embodiment, the apparatus 50 further comprises:
a setting module 55, configured to set attribute information of the first data table according to the service requirement, where the attribute information includes at least one of the following information: cell pattern, position of value cell, position of title cell corresponding to value cell, and repeating relation of multiple cells;
the generation module 56 generates identification information of the first data table and a first parser file corresponding to the first data table when receiving a save instruction to save the first data table;
the establishing module is used for writing the identification information into the first parser file so as to establish the association relation between the first parser file and the first data table.
In an alternative embodiment, the attribute information includes a value cell and a title cell, and the parsing the first data table according to the first parser file to obtain a data file in a preset format includes:
the parsing module 53 is further configured to obtain first location information of a value cell and second location information of a title cell in the first parser file;
the parsing module 53 is further configured to obtain a value of a value unit cell in the first data table according to the first location information;
the parsing module 53 is further configured to obtain a first header of the header cell in the first data table according to the second location information;
the parsing module 53 is further configured to populate a value to a first preset position of the first parser file to obtain a preset format file, where the first preset position includes a target cell matched with the title and/or a cell within a preset range of the target cell.
In an alternative embodiment, the parsing module 53 is further configured to, in case that the field of the data table is a repeated field, repeatedly fill, according to the repetition relationship, a value corresponding to the repeated field in a second preset position of the first parser file, and construct a plurality of data records, so as to obtain a preset format file.
In an alternative embodiment, the apparatus 50 further comprises:
a summarizing module 57, configured to summarize the first parser file according to the first data table to obtain an initialized data set when the first data table is a plurality of tables;
the obtaining module 51 is further configured to obtain the first location information and the second location information from the initialization data set.
In an alternative embodiment, the obtaining module 51 is further configured to obtain, if the first parser file is not found, a second header of the header cell of the first data table;
the apparatus 50 further comprises: a matching module 58, configured to match the second header with the headers of the header cells in the first parser file in sequence;
the parsing module 53 is further configured to parse the first data table according to the first parser file to obtain a data file with a preset format when the titles of the title cells in the first parser file are all in the first data table.
In an alternative embodiment, the obtaining module 51 is further configured to obtain, when receiving the table data export instruction, table data from the information system according to a second parser file, where the second parser file includes a table field of data to be obtained, and the table field is a subset or a complete set of table fields of the first data table;
the apparatus 50 further comprises: a construction module 59 is configured to construct a second data table according to the second parser file, and populate the table data into the second data table.
In an alternative embodiment, the obtaining module 51 is further configured to obtain third location information corresponding to the table data and/or a second header corresponding to the table data;
a construction module 59, configured to construct a second data table according to the third location information and/or the second header;
the apparatus 50 further comprises: and a filling module 510, configured to fill the table data into a third preset position of the second data table.
In an alternative manner, the summarizing module 57 is further configured to summarize the second parser file according to the plurality of data tables to obtain a second parser file data set;
the lookup module 52 is further configured to lookup the cell data in the second parser file data set based on the data table names and/or field names of the plurality of data tables,
the filling module 510 is further configured to fill the cell data into the second data table.
In one alternative, the apparatus 50 further comprises: the adding module 511 is configured to add a table row at a fourth preset position of the second data table in the case where there is a repeated data row in the second parser file, where the repeated data row is used to fill the table row.
It should be noted that, the embodiments of the apparatus and the embodiments of the method have the same or corresponding technical effects, and are not described in detail in this embodiment.
In the foregoing embodiments, the descriptions of the embodiments are emphasized, and for parts of one embodiment that are not described in detail, reference may be made to related descriptions of other embodiments.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not described in detail herein.
The algorithms and displays presented herein are not inherently related to any particular computer, virtual system, or other apparatus. Various general-purpose systems may also be used with the teachings herein. The required structure for a construction of such a system is apparent from the description above. In addition, the present invention is not directed to any particular programming language. It will be appreciated that the teachings of the present invention described herein may be implemented in a variety of programming languages, and the above description of specific languages is provided for disclosure of enablement and best mode of the present invention.
In the description provided herein, numerous specific details are set forth. However, it is understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.
Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be construed as reflecting the intention that: i.e., the claimed invention requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.
Those skilled in the art will appreciate that the modules in the apparatus of the embodiments may be adaptively changed and disposed in one or more apparatuses different from the embodiments. The modules or units or components of the embodiments may be combined into one module or unit or component and, furthermore, they may be divided into a plurality of sub-modules or sub-units or sub-components. Any combination of all features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or units of any method or apparatus so disclosed, may be used in combination, except insofar as at least some of such features and/or processes or units are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings), may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.
Furthermore, those skilled in the art will appreciate that while some embodiments described herein include some features but not others included in other embodiments, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments can be used in any combination.
Various component embodiments of the invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art will appreciate that a microprocessor or Digital Signal Processor (DSP) may be used in practice to implement some or all of the functions of some or all of the components in a method, apparatus for processing a data table according to embodiments of the present invention. The present invention can also be implemented as an apparatus or an apparatus program (e.g., a computer program and a computer program product) for performing a part or all of the methods described herein. Such a program embodying the present invention may be stored on a computer readable medium, or may have the form of one or more signals. Such signals may be downloaded from an internet website, provided on a carrier signal, or provided in any other form.
It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The use of the words first, second, third, etc. do not denote any order. These words may be interpreted as names.
Claims (8)
1. A method for processing a data table, comprising:
when an uploading instruction of a first data table is received, acquiring identification information of the first data table, wherein the identification information is used for determining an association relation between the first data table and a first parser file;
searching the first parser file according to the identification information;
under the condition that the first parser file is found, the first data table is parsed according to the first parser file to obtain a preset format data file, wherein the preset format data file is a format data file capable of being directly input into an information system;
inputting the preset format data file into the information system;
after the preset format data file is input to the information system, the method further comprises:
when a table data export instruction is received, table data is acquired from the information system according to a second parser file, wherein the second parser file comprises table fields of the data to be acquired, and the table fields are subsets or whole sets of the table fields of the first data table;
constructing a second data table according to the second parser file, and filling the table data into the second data table;
the constructing a second data table according to the second parser file, and filling the table data into the second data table, including:
and adding a table row at a fourth preset position of the second data table under the condition that a repeated data row exists in the second parser file, wherein the repeated data row is used for filling the table row.
2. The method of claim 1, wherein prior to said obtaining the identification information of the first data table, the method further comprises:
setting attribute information of the first data table according to service requirements, wherein the attribute information comprises at least one of the following information: cell pattern, position of value cell, position of title cell corresponding to value cell, and repeating relation of multiple cells;
when a storage instruction for storing the first data table is received, generating identification information of the first data table and a first parser file corresponding to the first data table;
writing the identification information into the first parser file to establish an association relationship between the first parser file and the first data table.
3. The method according to claim 2, wherein the attribute information includes a value cell and a title cell, and the parsing the first data table according to the first parser file to obtain a data file in a preset format includes:
acquiring first position information of the value unit cell and second position information of the title unit cell in the first parser file;
acquiring the value of the value unit cell in the first data table according to the first position information;
acquiring a first title of the title cell in the first data table according to the second position information;
and filling the value into a first preset position of the first parser file to obtain a preset format file, wherein the first preset position comprises a target cell matched with the title and/or cells within a preset range of the target cell.
4. The method of claim 3, wherein the populating the value to a first preset location of the first parser file with the value, the method further comprising, prior to obtaining the preset format file:
and under the condition that the data table field is a repeated field, repeatedly filling values corresponding to the repeated field at a second preset position of the first parser file according to the repeated relation, and constructing a plurality of data records to obtain the preset format file.
5. The method of claim 3 or 4, wherein before the obtaining the first location information of the valued cell and the second location information of the title cell in the first parser file, the method further comprises:
summarizing the first parser file according to the first data table to obtain an initialized data set under the condition that the first data table is a plurality of tables;
the obtaining the first position information of the value cell and the second position information of the title cell in the first parser file includes:
the first position information and the second position information are acquired from the initialization data set.
6. The method according to any one of claims 1-4, wherein after searching for the first parser file based on the identification information, the method further comprises:
acquiring a second title of a title cell of the first data table under the condition that the first parser file is not found;
sequentially matching the second title with the titles of the title cells in the first parser file;
and under the condition that the titles of the title cells in the first parser file are all in the first data table, parsing the first data table according to the first parser file to obtain a preset format data file.
7. The method of claim 1, wherein constructing a second data table from the second parser file and populating the table data to the second data table comprises:
acquiring third position information corresponding to the table data and/or a second title corresponding to the table data;
constructing the second data table according to the third position information and/or the second title;
and filling the form data into a third preset position of the second data form.
8. The method of claim 1, wherein in the case where the table data export instruction is to export a plurality of data tables, the constructing a second data table from the second parser file and populating the table data to the second data table comprises:
summarizing the second parser file according to a plurality of data tables to obtain a second parser file data set;
searching cell data in the second parser file data set according to data table names and/or field names of a plurality of the data tables,
and filling the cell data into the second data table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911328407.6A CN113010588B (en) | 2019-12-20 | 2019-12-20 | Data form processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911328407.6A CN113010588B (en) | 2019-12-20 | 2019-12-20 | Data form processing method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113010588A CN113010588A (en) | 2021-06-22 |
| CN113010588B true CN113010588B (en) | 2023-07-04 |
Family
ID=76382840
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911328407.6A Active CN113010588B (en) | 2019-12-20 | 2019-12-20 | Data form processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113010588B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1109117A1 (en) * | 1999-12-14 | 2001-06-20 | Sun Microsystems, Inc. | Method for converting table data between a database representation and a representation in tag language |
| EP1151405A1 (en) * | 1998-12-16 | 2001-11-07 | Cvbase AG | Method and system for structured processing of personal information |
| CN101661512A (en) * | 2009-09-25 | 2010-03-03 | 万斌 | System and method for identifying traditional form information and establishing corresponding Web form |
| CN102629263A (en) * | 2012-02-29 | 2012-08-08 | 上海安捷力信息系统有限公司 | Method and system for format conversion of interactive business data among enterprises |
| CN104239366A (en) * | 2013-06-21 | 2014-12-24 | 苏州精易会信息技术有限公司 | Spreadsheet data management method based on C/S mode |
| CN107784049A (en) * | 2016-12-05 | 2018-03-09 | 上海壹账通金融科技有限公司 | The method and apparatus of multi-format document parsing |
| CN108280056A (en) * | 2017-12-26 | 2018-07-13 | 北京市天元网络技术股份有限公司 | A kind of Excel file analytic method |
| CN108509658A (en) * | 2018-04-28 | 2018-09-07 | 中国联合网络通信集团有限公司 | A kind of analysis method and device of XML file |
| CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技（深圳）有限公司 | Batch data processing method, device, computer equipment and storage medium |
| CN109614601A (en) * | 2018-10-23 | 2019-04-12 | 深圳微迅信息科技有限公司 | Form processing method, device, equipment and readable medium based on web |
| CN110399420A (en) * | 2019-07-30 | 2019-11-01 | 广州吉信网络科技开发有限公司 | A kind of deriving method, electronic equipment and the medium of configurableization Excel format |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070198910A1 (en) * | 2002-03-26 | 2007-08-23 | Aatrix Software, Inc. | Method and apparatus for creating and filing forms |
| US20070220415A1 (en) * | 2006-03-16 | 2007-09-20 | Morgan Mao Cheng | Excel spreadsheet parsing to share cells, formulas, tables or entire spreadsheets across an enterprise with other users |
| US10216494B2 (en) * | 2016-12-03 | 2019-02-26 | Thomas STACHURA | Spreadsheet-based software application development |
-
2019
- 2019-12-20 CN CN201911328407.6A patent/CN113010588B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1151405A1 (en) * | 1998-12-16 | 2001-11-07 | Cvbase AG | Method and system for structured processing of personal information |
| EP1109117A1 (en) * | 1999-12-14 | 2001-06-20 | Sun Microsystems, Inc. | Method for converting table data between a database representation and a representation in tag language |
| CN101661512A (en) * | 2009-09-25 | 2010-03-03 | 万斌 | System and method for identifying traditional form information and establishing corresponding Web form |
| CN102629263A (en) * | 2012-02-29 | 2012-08-08 | 上海安捷力信息系统有限公司 | Method and system for format conversion of interactive business data among enterprises |
| CN104239366A (en) * | 2013-06-21 | 2014-12-24 | 苏州精易会信息技术有限公司 | Spreadsheet data management method based on C/S mode |
| CN107784049A (en) * | 2016-12-05 | 2018-03-09 | 上海壹账通金融科技有限公司 | The method and apparatus of multi-format document parsing |
| CN108280056A (en) * | 2017-12-26 | 2018-07-13 | 北京市天元网络技术股份有限公司 | A kind of Excel file analytic method |
| CN108509658A (en) * | 2018-04-28 | 2018-09-07 | 中国联合网络通信集团有限公司 | A kind of analysis method and device of XML file |
| CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技（深圳）有限公司 | Batch data processing method, device, computer equipment and storage medium |
| CN109614601A (en) * | 2018-10-23 | 2019-04-12 | 深圳微迅信息科技有限公司 | Form processing method, device, equipment and readable medium based on web |
| CN110399420A (en) * | 2019-07-30 | 2019-11-01 | 广州吉信网络科技开发有限公司 | A kind of deriving method, electronic equipment and the medium of configurableization Excel format |
Non-Patent Citations (3)
| Title |
|---|
| Data Self-checking Word Template Design and Information Extraction Technology;Zhu Min等;《Research and Exploration in Laboratory》;第第31卷卷(第第3期期);第75页 * |
| 内容管理中云表单平台研究;余靖;《中国优秀硕士学位论文全文数据库信息科技辑》;I138-1267 * |
| 基于Spark的社交网络数据分析平台;王海林;《中国优秀硕士学位论文全文数据库信息科技辑》;I138-1816 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113010588A (en) | 2021-06-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111522922B (en) | Log information query method and device, storage medium and computer equipment | |
| CN108009243B (en) | Multi-user synchronous editing processing system and processing method for same document | |
| CN111290956B (en) | Brain graph-based test method and device, electronic equipment and storage medium | |
| CN109740129B (en) | Report generation method, device and equipment based on blockchain and readable storage medium | |
| CN109978629A (en) | Advertisement putting method and device, electronic equipment and storage medium | |
| CN106547658A (en) | A kind of automated testing method and device | |
| CN104750463B (en) | A kind of developing plug method and system | |
| CN106021052A (en) | GJB289A bus testing system and method | |
| CN108460068A (en) | Method, apparatus, storage medium and the terminal that report imports and exports | |
| CN117112408A (en) | Method, device and medium for generating automatic test case script | |
| CN117171108B (en) | Virtual model mapping method and system | |
| CN103595747A (en) | User-information recommending method and system | |
| CN111124883B (en) | Test case library introduction method, system and equipment based on tree form | |
| CN113010588B (en) | Data form processing method | |
| CN113760894A (en) | Data calling method and device, electronic equipment and storage medium | |
| US20060248443A1 (en) | System and method for exporting spreadsheet data | |
| CN116155597A (en) | Access request processing method and device and computer equipment | |
| CN116186116A (en) | Asset problem analysis method based on equal protection assessment | |
| CN107894942A (en) | The monitoring method and device of tables of data visit capacity | |
| CN117009430A (en) | Data management method, device, storage medium and electronic equipment | |
| CN109522211A (en) | Interface parameters transmission method, device, electronic equipment and storage medium | |
| CN111459943A (en) | Data processing method, device, system, equipment and storage medium | |
| CN116737698B (en) | Distributed database configuration comparison method, device, equipment and storage medium | |
| CN112532424B (en) | Service system, service end and information processing method | |
| CN115080817B (en) | Process data organization and display method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |