CN113010588A - Data table processing method - Google Patents
Data table processing method Download PDFInfo
- Publication number
- CN113010588A CN113010588A CN201911328407.6A CN201911328407A CN113010588A CN 113010588 A CN113010588 A CN 113010588A CN 201911328407 A CN201911328407 A CN 201911328407A CN 113010588 A CN113010588 A CN 113010588A
- 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.)
- Granted
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 relationship 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, and the preset format data file is a format data file which can be directly input into an information system; and inputting the preset format data file into the 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, information data exchange means are more and more diversified. From a thick server thin client mode taking a large computer as a center at the beginning of a computer to a thin server thick client mode developed by the development of later personal computer technology, and then gradually returning to the thick server thin client mode by the development of the current cloud computing and network transmission technology; the data information exchange is interacted and transmitted up and down through a formatting means. The up-down interaction and transmission of data information require a user to install data entry software in a client computer or open a specified entry webpage for format data filling, and then the data is transmitted in a network or offline mode. Namely, the data is filled in a specified format by using software, and the efficiency of data filling is ensured.
However, data filling software may not be installed due to factors such as information security, network limitations, technical quality of computer users, and the like, and effectively fills in data. In the related art, the common product adopts a table component in Office software as the substitute software of data filling software. The Office data table component is widely used by users, and avoids the images of factors such as information security, network limitation, technical quality of computer users and the like.
However, after the data entry operator collects the data to be entered through the office form assembly, the form data needs to be manually entered on a data entry interface of the information entry system; the recording efficiency is low, and the data recording error rate is high.
Disclosure of Invention
In view of the above, the present invention provides a method for processing a data form, so as to solve the problem that in the related art, after a data entry user collects data to be entered through an office form component, form data needs to be manually entered on a data entry interface of an information entry system; the problems of low input efficiency and high data input error rate are caused.
To achieve the above object, according to an aspect of the present invention, there is provided a data table processing method, 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 the association relationship between the first data table and a first resolver 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 an alternative, before the obtaining the identification information of the first data table, the method further includes:
setting attribute information of the first data table according to business requirements, wherein the attribute information comprises at least one of the following information: the unit lattice style, the position of the numeric unit lattice, the position of the title unit lattice corresponding to the numeric unit lattice and the repeated relation of a plurality of unit lattices;
when a saving instruction for saving 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;
and writing the identification information into the first resolver file to establish an association relationship between the first resolver file and the first data table.
In an optional manner, 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 preset format data file includes:
acquiring first position information of the value-taking cell and second position information of the title cell in the first parser file;
acquiring the value of the value 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 to 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 a cell in a preset range of the target cell.
In an optional manner, before the filling the value to 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, according to the repeated relation, repeatedly filling the value corresponding to the repeated field in a second preset position of the first parser file, and constructing a plurality of data records to obtain the preset format file.
In an optional manner, before the obtaining the first location information of the value cell and the second location information of the title cell in the first parser file, the method further includes:
when the first data table is a plurality of tables, summarizing the first parser file according to the first data table to obtain an initialized data set;
the obtaining of the first location information of the value cell and the second location information of the title cell in the first parser file includes:
and acquiring the first position information and the second position information from the initialization data set.
In an optional manner, after the searching for the first parser file according to the identification information, the method further includes:
under the condition that the first resolver file is not found, a second title of a title cell of the first data table is obtained;
matching the second title with the title of the title cell in the first parser file in sequence;
and under the condition that the titles of the title cells in the first parser file all exist 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, after entering the preset-format data file into the information system, the method further comprises:
when a table data export instruction is received, acquiring table data 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 a subset or a complete set 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, the building a second data table according to the second parser file and populating the second data table with the table data 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 table data to a third preset position of the second data table.
In an alternative, in a case that the table data export instruction is to export a plurality of data tables, the building a second data table according to the second parser file and populating the second data table with the table data includes:
summarizing the second parser file according to the plurality of data tables to obtain a second parser file data set;
looking up cell data in the second parser file data set according to data table names and/or field names of a plurality of said data tables,
populating the cell data to the second data table.
In an alternative, the building a second data table according to the second parser file and populating the second data table with the table data includes:
and if a repeated data row exists in the second parser file, adding a table row at a fourth preset position of the second data table, 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 relationship 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, and the preset format data file is a format data file which can be directly input into an information system; and inputting the preset format data file into the information system. Therefore, when a data entry person collects and uploads a first data form, a first parser file corresponding to the identification information is searched for through the identification information of the first data form, the first form data is parsed into a preset format data file capable of being directly entered into an information system by using the first parser file, 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 entering form data in a data entry interface of the information system by the data entry person is low and the error rate is high are solved. The accuracy and the efficiency of data form entry are improved.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
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 refer to like parts throughout the drawings.
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 embodiments 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 apparatus for a data table according to an embodiment of the present application.
Detailed Description
To make the objects, technical solutions and advantages of the embodiments of the present invention clearer, 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 the embodiments of the present invention, the terms "first" and "second" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implying any number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present invention, "a plurality" means at least two, e.g., two, three, etc., unless specifically limited otherwise.
Fig. 1 is a flowchart of an implementation of a data table processing method according to an embodiment of the present application. Fig. 2 is an exemplary style of a template form provided in an embodiment of the present application.
Referring to fig. 1 and fig. 2, the processing method of the data table provided in the embodiment of the present application is specifically applied to import table data collected by an office data table component into an information system, or export 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 data table processing method comprises the following steps:
The identification information is used for determining the association relationship between the first data table and the first resolver file.
Specifically, in the embodiment of the present application, the first data table may be a data table generated by a data logger when collecting table data; specifically, the data logger generates the identification information of the data table after collecting and storing the table 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 serve as a unique identifier for the first data table.
And 102, searching a first parser file according to the identification information.
Specifically, in the embodiment of the application, the first parser file also has identification information that is the same as the identification information of 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.
And 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 preset format data file.
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 application, an association relationship is established between the first parser file and the first data table through the identification information, and when a data entry user uploads the first data table, the corresponding first parser file is found through the identification information, for example, a GUID number, so that the first parser file is the parser file corresponding to the first data table, and the first data table can be parsed into a data file in a preset format, so that the information system can be directly entered.
And 104, inputting the preset format data file into an information system.
According to the data form processing method provided by the embodiment of the application, when a data logger collects and uploads a first data form, a first parser file corresponding to identification information is searched through the identification information of the first data form, and the first form data is parsed into a preset format data file capable of being directly logged into an information system by using the first parser file, so that the preset format data file obtained through parsing can be directly uploaded into the information system, and the problems of low efficiency and high error rate of manual logging of form data in a data logging interface of the information system by the data logger are solved. The accuracy and the efficiency of data form entry 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 embodiment, referring to fig. 3, the method for processing a data table provided in this embodiment includes the following steps:
Wherein the attribute information includes at least one of the following information: the unit lattice style, the position of the numeric unit lattice, the position of the title unit lattice corresponding to the numeric unit lattice and the repeated relation of a plurality of unit lattices.
Specifically, in this embodiment, the business requirement may be a requirement of an information system user, such as a business requirement related to a certain enterprise.
In some specific examples, the designer opens a new form configuration sheet through the Dev Express component, designs the form through the designer or opens an existing Excel form, adjusts the cell style of the template form, such as font, color, merge, border, etc. Referring to fig. 2, the position of the title cell (e.g., "name", "gender" shown in fig. 2), the position of the value cell (e.g., "name", "gender" on the right side or below the cell shown in fig. 2), and the repetitive relationship (e.g., "family member" or "educational background" shown in fig. 2) or the repetitive range of the cell are set. Thus, when the template form is saved after the template form is designed, the identification information corresponding to the template form is generated. And when the data logger finishes data acquisition in the template table and uploads the first data table, acquiring the identification information of the first data table.
In the embodiment of the application, the attribute information of the first data form is set according to the business requirements 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 business requirements of the information system user are changed, the template form only needs to be redesigned without redeveloping the information system, so that the business expandability of the information system is improved, the time requirements of the information system user are ensured, and the development cost of the information system is saved.
Specifically, in the embodiment of the present application, after the template form is designed, when a designer stores the template form, the identification information of the template form is randomly generated, and in some optional examples, the identification information may include a GUID number; in other alternative examples, the identification information of the template table may be sequentially generated according to the storage order. The generation order of the identification information is not particularly limited in the embodiments of the present application.
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 for completing data collection), 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.
And step 306, under the condition that the first parser file is found, parsing the first data table according to the first parser file to obtain a preset format data file.
In some specific examples, the attribute information includes a value cell and a title cell. Step 306, parsing the first data table according to the first parser file to obtain a preset format data file, including:
and acquiring first position information of the value cell in the first parser file and second position information of the title cell.
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 application, since the first parser file and the first data table have a corresponding relationship, the first parser file records first location information of a value cell in the first data table (for example, a cell on the right side of the name shown in fig. 2), and after the first parser file corresponding to the first data table is found, a value is taken from a 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 obtained from the corresponding position in the first data table.
In some optional embodiments, when the fields of the data table are repetitive fields, according to the repetitive relationship, values corresponding to the repetitive fields are repeatedly filled in a second preset position of the first parser file, a plurality of data records are constructed, and a preset format file is obtained.
Specifically, referring to the "education background" shown in fig. 2, the data are searched for in the repeated range according to the second preset position with respect to the "education background", so that a plurality of data records can be constructed.
And filling the value to 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 a cell in a preset range of the target cell.
In some specific examples, the first preset location may include a subsequent character string of the target cell, a cell on the right side of the target cell, and a cell on the lower side of the target cell. In some possible examples, the first preset location may further include a cell on the left side of the target cell.
In some optional embodiments, in a case that the first data table is a plurality of tables, the first parser file is summarized according to the first data table, and the initialized data set is obtained.
Specifically, when a plurality of first data tables are operated simultaneously, a plurality of first parser files can be found; at this time, the first parser files are collected to generate an initialized parser file set.
First location information and second location information are obtained from the initialization data set.
Specifically, the value is taken according to first position information of a value cell configured in the parser file set, and a first title is obtained according to second position information of a title cell.
In an alternative embodiment, referring to fig. 3, after the step 305 finds the first parser file according to the identification information, the method further includes:
Specifically, in some possible examples, after the design of the template form is completed, the generated identification information may not be written into the first parser file due to a failure or the like; at this time, in the case that the first parser file may not be found, the matching search is performed through the second header in the header cell in the first data table.
Specifically, when the template table is designed, the first parser file records the title in the title cell in the template table. At this time, the acquired second title is sequentially matched with the first parser file.
In this embodiment, the second header in the header cell of the first data table is extracted and matched 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, thereby avoiding a situation that the corresponding first parser file cannot be found by the identification information in the case of a fault, and ensuring normal parsing of the first data table.
It should be noted that the present embodiment has the same or corresponding beneficial technical effects as the other embodiments of the present application, and details are not 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 embodiment, 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 comprises table fields of the data to be acquired, and the table fields are subsets or complete sets of the table fields of the first data table.
In some specific examples, data in the information system needs to be exported, for example, to an Excel table for printing, for viewing during the use of the information system. At this time, the style and data of the table that need to be reconstructed are designed according to the data export requirement. Specifically, when the fields of the form are reconstructed, the style of the reconstructed form may be rearranged and defined as needed, and after the design is completed, the export template form and the second parser file are generated, where the second parser file and the export template form both have 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 by using an Apose.cell component according to the parser file to obtain a second data form. At this time, the second data table is an empty table.
Specifically, after the second data table is constructed, table data is acquired from the information system according to the table fields recorded in the second parser file, and the table data is filled to 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 from the second parser file and populating the second data table with table data, includes:
and acquiring third position information corresponding to the table data and/or a second title corresponding to the table data.
Specifically, the third location information is the corresponding location information of 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 table data to a third preset position of the second data table.
Specifically, the third preset location may be a location in the second table data corresponding to third location information of the second parser file.
In an alternative embodiment, in the case that 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 second data table with the table data, includes:
summarizing a second resolver file according to a plurality of data tables to obtain a second resolver file data set;
looking up 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 cell data is populated into a second data table.
In an alternative embodiment, step 402, building a second data table from the second parser file and populating the second data table with table data, includes:
and in the case that a repeated data row exists in the second parser file, adding a table row in a fourth preset position of the second data table, wherein the repeated data row is 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 embodiments, the method for processing a table provided in this embodiment further includes:
at step 403, the second data table is saved.
In the embodiment, the apose.cell component is used for reconstructing the template table according to the parser file, and the data is filled in the constructed template table according to the setting of the parser file, so that required table data can be completely reproduced in the style of the parser. The required table data and parser file are matched so that the data table file of the original imported data can be completely reproduced. In addition, in some specific examples, some fields which are not needed can be deleted, only needed field data is exported, and the screenability of the table data is improved.
Fig. 5 is a schematic structural diagram of a processing apparatus for a data table according to an embodiment of the present application.
Based on the foregoing embodiments, referring to fig. 5, a processing device 50 for a data table provided in an embodiment of the present application includes:
the obtaining module 51 is configured to obtain, when an upload instruction of a first data table is received, identification information of the first data table, where the identification information is used to determine an association relationship between the first data table and a first parser file;
the searching module 52 is configured to search the first parser file according to the identification information;
the parsing module 53 is configured to, in a case that the first parser file is found, 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 entered into an information system;
and an entry module 54 for entering the preset format data file 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 a service requirement, where the attribute information includes at least one of the following information: the unit lattice style, the position of the numeric unit lattice, the position of the title unit lattice corresponding to the numeric unit lattice and the repeated relation of a plurality of unit lattices;
the generating module 56 is configured to generate the identification information of the first data table and a first parser file corresponding to the first data table when receiving a saving instruction for saving the first data table;
and the establishing module is used for writing the identification information into the first resolver file so as to establish the association relationship between the first resolver file and the first data table.
In an optional implementation manner, 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 the preset format data file includes:
the parsing module 53 is further configured to obtain first location information of the value cell and second location information of the title cell in the first parser file;
the analysis module 53 is further configured to obtain a value of the value cell in the first data table according to the first location information;
the parsing module 53 is further configured to obtain a first title of the title cell in the first data table according to the second location information;
the parsing module 53 is further configured to fill the 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 optional implementation manner, the parsing module 53 is further configured to, when the fields of the data table are repeated fields, repeatedly fill values corresponding to the repeated fields in a second preset position of the first parser file according to a repetition relationship, 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 multiple 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 optional embodiment, the obtaining module 51 is further configured to obtain a second title of the title cell of the first data table if the first parser file is not found;
the apparatus 50 further comprises: a matching module 58, configured to match the second title with the titles of the title cells in the first parser file in sequence;
the parsing module 53 is further configured to, when the titles of the title cells in the first parser file all exist in the first data table, parse the first data table according to the first parser file to obtain a preset format data file.
In an optional embodiment, the obtaining module 51 is further configured to, when receiving a table data export instruction, obtain the table data from the information system according to a second parser file, where the second parser file includes table fields of the data to be obtained, and the table fields are a subset or a full set of the table fields of the first data table;
the apparatus 50 further comprises: and a building module 59, configured to build a second data table according to the second parser file, and fill the table data into the second data table.
In an optional implementation manner, the obtaining module 51 is further configured to obtain third location information corresponding to the table data and/or a second title corresponding to the table data;
a building module 59, further configured to build a second data table according to the third location information and/or the second title;
the apparatus 50 further comprises: and a filling module 510, configured to fill the table data to a third preset location of the second data table.
In an optional manner, the summarizing module 57 is further configured to summarize the second parser file according to a plurality of data tables to obtain a second parser file data set;
a lookup module 52, further configured to lookup 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 a filling module 510, configured to fill the cell data into the second data table.
In an alternative, the apparatus 50 further comprises: the adding module 511 is configured to, when a duplicate data row exists in the second parser file, add a table row in a fourth preset location of the second data table, where the duplicate data row is used to fill the table row.
It should be noted that the device embodiment and the method embodiment of the present application have the same or corresponding technical effects, and are not described in detail in this embodiment.
In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, devices and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
The algorithms and displays presented herein are not inherently related to any particular computer, virtual machine, or other apparatus. Various general purpose systems may also be used with the teachings herein. The required structure for constructing such a system will be apparent from the description above. Moreover, the present invention is not directed to any particular programming language. It is appreciated that a variety of programming languages may be used to implement the teachings of the present invention as described herein, and any descriptions of specific languages are provided above to disclose the best mode of the invention.
In the description provided herein, numerous specific details are set forth. It is understood, however, 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 interpreted as reflecting an intention that: that the invention as claimed 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 device in an embodiment may be adaptively changed and disposed in one or more devices different from the embodiment. 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. All of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where at least some of such features and/or processes or elements 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 included in other embodiments, rather than other features, 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 may be used in any combination.
The 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 of a method, apparatus, and/or device for processing a data table according to embodiments of the present invention. The present invention may also be embodied as devices or device programs (e.g., computer programs and computer program products) for performing some or all of the methods described herein. Such programs implementing the present invention may be stored on computer-readable media or may be in the form of one or more signals. Such a signal may be downloaded from an internet website or provided on a carrier signal or 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 usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.
Claims (10)
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 the association relationship between the first data table and a first resolver 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.
2. The method of claim 1, wherein prior to said obtaining identification information for said first data table, said method further comprises:
setting attribute information of the first data table according to business requirements, wherein the attribute information comprises at least one of the following information: the unit lattice style, the position of the numeric unit lattice, the position of the title unit lattice corresponding to the numeric unit lattice and the repeated relation of a plurality of unit lattices;
when a saving instruction for saving 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;
and writing the identification information into the first resolver file to establish an association relationship between the first resolver file and the first data table.
3. The method of 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 preset format data file includes:
acquiring first position information of the value-taking cell and second position information of the title cell in the first parser file;
acquiring the value of the value 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 to 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 a cell in a preset range of the target cell.
4. The method of claim 3, wherein before the populating the value to the first preset location of the first parser file, the method further comprises:
and under the condition that the data table field is a repeated field, according to the repeated relation, repeatedly filling the value corresponding to the repeated field in a second preset position of the first parser file, and constructing a plurality of data records to obtain the preset format file.
5. The method according to claim 3 or 4, wherein before the obtaining the first location information of the value cell and the second location information of the title cell in the first parser file, the method further comprises:
when the first data table is a plurality of tables, summarizing the first parser file according to the first data table to obtain an initialized data set;
the obtaining of the first location information of the value cell and the second location information of the title cell in the first parser file includes:
and acquiring the first position information and the second position information from the initialization data set.
6. The method according to any of claims 1-4, wherein after finding the first parser file according to the identification information, the method further comprises:
under the condition that the first resolver file is not found, a second title of a title cell of the first data table is obtained;
matching the second title with the title of the title cell in the first parser file in sequence;
and under the condition that the titles of the title cells in the first parser file all exist 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 any of claims 1-4, wherein after entering the pre-formatted data file into the information system, the method further comprises:
when a table data export instruction is received, acquiring table data 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 a subset or a complete set 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.
8. The method of claim 7, wherein building a second data table from the second parser file and populating the second data table with the table data 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 table data to a third preset position of the second data table.
9. The method of claim 7, wherein in the case that the table data export instruction is to export a plurality of data tables, the building a second data table according to the second parser file and populating the second data table with the table data comprises:
summarizing the second parser file according to the plurality of data tables to obtain a second parser file data set;
looking up cell data in the second parser file data set according to data table names and/or field names of a plurality of said data tables,
populating the cell data to the second data table.
10. The method of claim 7, wherein building a second data table from the second parser file and populating the second data table with the table data comprises:
and if a repeated data row exists in the second parser file, adding a table row at a fourth preset position of the second data table, wherein the repeated data row is used for filling the table row.
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 true CN113010588A (en) | 2021-06-22 |
| CN113010588B 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 (14)
| 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 |
| 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 |
| 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 |
| US20180157467A1 (en) * | 2016-12-03 | 2018-06-07 | Thomas STACHURA | Spreadsheet-Based Software Application Development |
| 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 |
-
2019
- 2019-12-20 CN CN201911328407.6A patent/CN113010588B/en active Active
Patent Citations (14)
| 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 |
| 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 |
| 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 |
| US20180157467A1 (en) * | 2016-12-03 | 2018-06-07 | Thomas STACHURA | Spreadsheet-Based Software Application Development |
| 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 |
|---|
| ZHU MIN等: "Data Self-checking Word Template Design and Information Extraction Technology", 《RESEARCH AND EXPLORATION IN LABORATORY》 * |
| 余靖: "内容管理中云表单平台研究", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
| 王海林: "基于Spark的社交网络数据分析平台", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113010588B (en) | 2023-07-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11294968B2 (en) | Combining website characteristics in an automatically generated website | |
| US20240078217A1 (en) | Systems and Methods of Generating Analytical Data Based on Captured Audit Trails | |
| US11792257B2 (en) | Form engine | |
| CN109376291B (en) | Website fingerprint information scanning method and device based on web crawler | |
| US9910858B2 (en) | System and method for providing contextual analytics data | |
| CN107526755B (en) | Data processing method and device | |
| CN105589922A (en) | Page display method, device and system and page display assisting method and device | |
| CN107220274A (en) | One kind visualization data-interface fairground implementation method | |
| CN109978629A (en) | Advertisement putting method and device, electronic equipment and storage medium | |
| CN111737443B (en) | Answer text processing method and device and key text determining method | |
| US20130260350A1 (en) | Electronic reader for enhancing interactive online learning experience | |
| CN109255587A (en) | A kind of cooperative processing method and device of operational data | |
| CN109542890B (en) | Data modification method, device, computer equipment and storage medium | |
| CN111507405A (en) | Picture labeling method and device, electronic equipment and computer readable storage medium | |
| CN111488386A (en) | Data query method and device | |
| CN111459943A (en) | Data processing method, device, system, equipment and storage medium | |
| CN113010588B (en) | Data form processing method | |
| CN102681883B (en) | Resource calling method and system in media asset searching and browsing system | |
| CN117009430A (en) | Data management method, device, storage medium and electronic equipment | |
| CN115016754A (en) | Method and device for synchronously displaying pages among devices, electronic device and medium | |
| CN114328947A (en) | Knowledge graph-based question and answer method and device | |
| CN109522211A (en) | Interface parameters transmission method, device, electronic equipment and storage medium | |
| CN113094287A (en) | Page compatibility detection method, device, equipment and storage medium | |
| CN112417295A (en) | Education cloud information pushing method, storage medium and system | |
| CN107861994B (en) | Log sorting method and device |
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 |