CN110287459B - Form batch processing method, system, device and storage medium - Google Patents
Form batch processing method, system, device and storage medium Download PDFInfo
- Publication number
- CN110287459B CN110287459B CN201910461737.6A CN201910461737A CN110287459B CN 110287459 B CN110287459 B CN 110287459B CN 201910461737 A CN201910461737 A CN 201910461737A CN 110287459 B CN110287459 B CN 110287459B
- Authority
- CN
- China
- Prior art keywords
- cells
- cell
- category
- mode
- style
- 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
- 238000003672 processing method Methods 0.000 title claims description 15
- 238000012545 processing Methods 0.000 claims abstract description 34
- 238000000034 method Methods 0.000 claims abstract description 27
- 238000004590 computer program Methods 0.000 claims description 21
- 230000006870 function Effects 0.000 description 8
- 238000013461 design Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000003825 pressing Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000001680 brushing effect Effects 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
- G06F40/109—Font handling; Temporal or kinetic typography
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the technical field of data processing, and provides a method, a system, a device and a storable medium for processing forms in batches, wherein the method comprises the following steps: s110: generating a business form in a corresponding format according to preset business requirements; s120: carrying out pattern parameter identification on the cells in the business form, classifying the cells of the business form according to the identified pattern parameters, wherein the pattern parameters of the cells of each category are the same; s130: configuring the style of the cell of each category according to the preset service requirement; and for the cells of each category, determining one of a plurality of cells of the category as a mode cell to carry out corresponding cell pattern configuration, and calling cell format brushes to uniformly refresh and configure the rest cells of the category according to the patterns of the mode cells for the cells of each category of the configured mode cells. The invention can solve the problems of low efficiency, high error rate and the like of the prior table configuration.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method, a system, an apparatus, and a storable medium for batch processing of tables.
Background
With the wide application of electronic office systems, data tables are increasingly applied to the field of medium data statistics processing with strong statistical capability.
In the scenario of large application amount of the data form, such as company business statistics, tax declaration, economic census and the like, various forms are inevitably involved in the reporting process due to different sources, types and formats of the forms, and the information such as the row length, the column length, the header style and the like of each form may be different, so that a large amount of cell processing is required to be performed on the reported forms according to a large amount of classification information such as different names, types and the like.
According to the traditional mode, the existing configuration of a large number of cells can only be manually configured by old and old people, so that the time and the labor are consumed, the working progress is influenced, and the configuration omission and the configuration error are easy to cause. Inefficiency and high error rate.
Disclosure of Invention
In view of the above problems, the present invention is to provide a method, a system, an apparatus, and a storage medium for batch processing of tables, so as to solve the problems of low cell configuration efficiency, high error rate, etc. in the current process of using tables for data processing.
In a first aspect, the present invention provides a form batch processing method, applied to an electronic device, including the following steps:
s110: generating a business form in a corresponding format according to a preset business requirement, wherein the business form comprises cells;
s120: carrying out pattern parameter identification on the cells in the business table, classifying the cells of the business table according to the identified pattern parameters, wherein the pattern parameters of the cells of each category are the same;
s130: configuring the style of the cell of each category according to the preset service requirement; and for the cells of each category, optionally determining one of a plurality of cells of the category as a mode cell to carry out corresponding cell pattern configuration, and calling cell format brushes according to the patterns of the mode cells to uniformly refresh and configure the rest cells in the category.
The style parameters at least comprise a text style, a background color, a font, a text label, a character attribute, a cell style and attribute information.
In a preferred embodiment, the step S120 further includes: s121: scanning the cells in the business form, and extracting style parameters of the cells; s122: the cells with the same style parameters are classified.
The step S122 further includes: judging whether a cell group with the same style parameters as the extracted style parameters exists in a preset classifying group according to the extracted style parameters, and classifying the cells into the cell group if the cell group exists; if not, a cell group with the same style parameters as the extracted style parameters is newly built in the classifying group, and the cells are classified in the newly built cell group.
The step S130 further includes: s131: determining and configuring mode cells, wherein the mode cells are templates for refreshing the rest cells in the class of the mode cells in batches; s132: and refreshing the patterns of the category cells, calling the cell format brush batch to refresh all other cells belonging to the same category as the mode cell according to the patterns of the mode cell.
In a second aspect, the present invention provides a form batch processing system, comprising:
the system comprises a table configuration unit, a service table configuration unit and a service management unit, wherein the table configuration unit is used for configuring a service table according to preset service requirements, and the service table comprises cells;
the cell classification unit is used for identifying the style parameters of the cells in the business form, classifying the cells of the business form according to the identified style parameters, and the style parameters of the cells of each category are the same;
the cell configuration unit is used for configuring the patterns of the cells of each category according to preset service requirements; and for the cells of each category, optionally determining one of a plurality of cells of the category as a mode cell to carry out corresponding cell pattern configuration, and calling cell format brushes according to the patterns of the mode cells to uniformly refresh and configure the rest cells in the category.
In a third aspect, the present invention also provides an electronic device, including: the system comprises a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the processor realizes the steps of the table batch processing method when executing the computer program.
Wherein the computer program comprises:
the form configuration program is used for generating a business form in a corresponding format according to preset requirements when being executed by the processor, and the business form comprises cells;
the cell classification program is used for identifying the style parameters of the cells in the business form when being executed by the processor, classifying the cells of the business form according to the identified style parameters, and the style parameters of the cells of each category are the same;
the cell configuration program is used for configuring the style of the cells of each category according to the preset service requirement when being executed by the processor; and for the cells of each category, one of a plurality of cells of the category is arbitrarily determined as a mode cell, and a cell format brush is called according to the mode cell style to uniformly refresh and configure the rest cells in the category.
In a fourth aspect, the present invention also provides a computer readable storage medium storing a computer program, wherein the computer program when executed by a processor implements the steps of the table batch processing method described above.
According to the technical scheme, the method, the system, the device and the storage medium for processing the table in batches can solve the configuration problem of a large number of cells of diversified business tables, realize batch refreshing of a large number of cells with the same style, reduce the complex work of cell configuration, improve the configuration work efficiency and the configuration data accuracy of the business tables and reduce the configuration error rate.
To the accomplishment of the foregoing and related ends, one or more aspects of the invention comprise the features hereinafter fully described. The following description and the annexed drawings set forth in detail certain illustrative aspects of the invention. These aspects are indicative, however, of but a few of the various ways in which the principles of the invention may be employed. Furthermore, the invention is intended to include all such aspects and their equivalents.
Drawings
Other objects and attainments together with a more complete understanding of the invention will become apparent and appreciated by referring to the following description taken in conjunction with the accompanying drawings. In the drawings:
FIG. 1 is a flow chart of a method for batch processing of forms according to an embodiment of the present invention;
FIG. 2 is a flow chart of classifying cells according to an embodiment of the present invention;
FIG. 3 is a flow of configuring a style of a cell for each category according to an embodiment of the present invention;
FIG. 4 is a flow chart of a unified batch configuration operation for a cell pattern in accordance with an embodiment of the present invention;
FIG. 5 is a logical structure of a table batch processing system according to an embodiment of the present invention;
fig. 6 is a schematic diagram of a logic structure of an electronic device according to an embodiment of the invention.
The same reference numerals will be used throughout the drawings to refer to similar or corresponding features or functions.
Detailed Description
In the following description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of one or more embodiments. It may be evident, however, that such embodiment(s) may be practiced without these specific details.
Embodiments of the invention are operational with numerous other general purpose or special purpose computing system environments or configurations with electronic devices, such as computer systems/servers. Examples of well known computing systems, environments, and/or configurations that may be suitable for use with electronic devices, e.g., computer systems/servers, include, but are not limited to: personal computer systems, server computer systems, thin clients, thick clients, hand-held or laptop devices, microprocessor-based systems, set-top boxes, programmable consumer electronics, network personal computers, minicomputer systems, mainframe computer systems, and distributed cloud computing technology environments that include any of the above systems, and the like.
An electronic device, such as a computer system/server, may be described in the general context of computer-system-executable instructions, such as program modules, being executed by a computer system. Generally, program modules may include routines, programs, objects, components, logic, data structures, etc., that perform particular tasks or implement particular abstract data types. Electronic devices such as computer systems/servers may be implemented in distributed cloud computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed cloud computing environment, program modules may be located in both local and remote computing system storage media including memory storage devices.
Specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that: the relative arrangement of the components and steps, numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present invention unless it is specifically stated otherwise.
Example 1
In order to illustrate the table batch processing method provided by the invention, fig. 1 shows a flow of the table batch processing method according to an embodiment of the invention.
As shown in FIG. 1, the form batch processing method provided by the invention can comprise the following steps:
s110: and generating a business form in a corresponding format according to a preset business requirement, wherein the business form is composed of a plurality of cells. Because the format of the business form will be different according to the submitter, the related specific business information and the like, the format of the business form needs to be configured according to the preset business requirement before batch processing of the form; the business form is composed of a plurality of cells, namely, the business form comprises cells meeting the content requirements of various items of business needs so as to realize the common data statistics requirements of business related data.
The technical scheme of the invention can be applied to enterprise purchase and sale business statistics, human resource statistics of enterprises and institutions, population/economic census of government departments, experimental data statistics in scientific research process and the like. Because of various business requirements in the aspect of data statistics, in order to clearly and intuitively express the technical scheme of the invention, the batch processing method of the invention is described in detail by taking tax declaration in the tax field as an example.
The tax declaration forms are different in tax types and tax payer types, the formats of the tax declaration forms are various, the contents of the tax declaration forms are not uniform, and therefore, the number of generated cells is large, and the styles of the tax declaration forms are various. In this regard, before the cells are configured, the cells need to be classified according to the service requirement, i.e., the requirement of tax declaration, and the cells with the same format are determined to be the same type of cells for batch processing.
S120: and carrying out pattern parameter identification on the cells in the business table, classifying the cells of the business table according to the identified pattern parameters, wherein the pattern parameters of the cells in each category are the same.
In order to achieve the purpose of batch processing, in the same type of cells, the style parameters of the cells are generally required to be the same, namely, the related information such as the text style, background color, font, text label, character attribute, cell style and attribute of the same type of cells are the same, wherein the filled data information belongs to the same type of data which can be processed in batch in a business form, and the purpose of batch processing according to a template can be achieved through the design. Therefore, according to the classification standard that the style parameters of the cells in the table are used for the batch processing of the cells, the cells with the same style parameters are classified into one type, so that the batch processing of the cells of the same type is carried out.
FIG. 2 illustrates a flow for classifying cells according to one embodiment of the invention. As shown in fig. 2, in the process of classifying the cells of the service table, the cells in the service table may be scanned one by one first, and style parameters of the scanned cells may be extracted (as shown in step S121); then, the extracted style parameters are identified, and the cells with the same style parameters are categorized (as shown in step S122).
In the process of classifying the cells according to the style parameters, the following manner may be adopted: a classifying group for classifying the cells is established in advance, whether the cell group with the same style parameter as the extracted style parameter exists in the preset classifying group is judged according to the extracted style parameter, and if the cell group with the same style parameter as the extracted style parameter exists in the preset classifying group, the cell is classified into the corresponding cell group; if not, a cell group with the same style parameters as the extracted style parameters is newly built in the classifying group, and the cell is classified in the newly built cell group.
After completing the cell sorting of the business form, the next step may be entered:
s130: and configuring the style of the cell of each category according to the preset service requirement.
For each category of cells, only one of a plurality of cells in the category is required to be determined as a mode cell to carry out corresponding cell pattern configuration, and for the rest cells in the category, a cell pattern brush is called to carry out unified refreshing configuration according to the patterns of the mode cells.
Taking tax declaration form in tax field as an example, in the specific operation process of configuring the patterns of the cells of each category according to the preset tax declaration requirement, firstly determining the cell of one category and the patterns of the cell of the category, configuring one cell selected at will as a mode cell in the cell of the category, namely configuring the mode cell according to the cell patterns of the cell of the category to which the cell belongs, then locking the cells of the category except the cell of the mode, which need to configure the patterns, calling the cell pattern brush to refresh the patterns of the other cells of the category, so that the patterns of the other cells of the category are refreshed to be the same as the patterns of the configured mode cell. After the cells of one category are configured, the cells of other categories are configured according to the same processing mode until all the cells of all the categories are configured to complete positions.
For operators, the configuration of the cells does not need manual configuration of one cell by one cell, and the configuration of all other cells can be automatically completed according to the mode of the mode cell only by classifying the cells according to preset service requirements (such as tax declaration requirements) and determining the mode of the cells of each category and configuring one mode cell of each category.
More specifically, step S130 may be further refined into two steps as shown in fig. 3:
s131: the pattern of the mode cells is determined and configured according to the cell application needs. In the business table, one cell in each category is a mode cell and is used as a template for refreshing the cells in the category in batches. In the Wang Ying table, how many types of cells are, how many pattern cells are, and how many pattern cells need to be arranged one by one.
S132: and refreshing the style of the category cell. According to the configured patterns of the mode cells, all other cells belonging to the same class as the mode cells are refreshed in batches, so that the unified batch configuration of all cell patterns of the class can be realized.
In one embodiment of the present invention, the specific process of batch processing cells is as follows.
First, a category of cells and a style of the category of cells are determined, one cell is arbitrarily selected in the category of cells, a required cell style (a cell style of the category of cells) is configured as a mode cell, and the cell style may include, but is not limited to, a text style, a background color, a font, a text label, a character attribute, a cell style and attribute information of the cell, and specific configuration requirements are determined according to specific requirements of a business form. After the mode cells are configured, calling a cell pattern brush to carry out pattern refreshing on other cells in the class of cells.
The effect displayed on the operation interface in the process is as follows: selecting and calling a cell style brush in a top menu of the page, and simultaneously using other cells needing to be configured with the style in the selected cells; finally, all selected cells are refreshed to the same pattern as the pattern cells.
The batch configuration logic provided by the embodiment comprises two parts, namely structural design and implementation logic.
In the structural design part, according to the characteristics of the tables of the batch configuration cells and the requirements of the batch configuration cells, respectively defining a drop-down menu, the header, the field, the related information, the cell configuration information and the like of the data table, wherein the method specifically comprises the following steps of defining the table:
1) Data table header definition table: for recording header data information of the save service table. Such as: column name, column width, relative column difference, number of rows, column number, alignment, format method, EXCEL header mapping method, etc.
2) Data table field definition table: and the field characteristic information is used for recording and storing specific data of the business form. Such as: field coding, name, data type, field length, field precision, sequence number, null, filter, fetch, etc.
3) Data table definition table: for recording the relevant form identity information of the save business form. Such as: table code, name, version number, table type, whether to deactivate, rank number, etc.
4) Data instance table: and the method is used for recording and storing declaration data information of the actual batch configuration cells.
5) And the drop-down menu comprises functional menus such as cell style brushes, cell merges, data relations, account relations, in-table relations, formula setting, table association data, clearing setting information and the like.
In the implementation logic section, that is, in the service interface, functional menus such as cell pattern brushes, cell merges, and data relationships are set, and since this embodiment is only for illustrating the scheme logic of configuring cells in batches, the functions thereof will not be described in detail herein. The cell pattern brush triggers the system to uniformly update and configure the cell patterns according to the pattern parameters (such as the text patterns, background colors, fonts, text labels, character attributes, cell patterns, attributes and the like) of the mode cells.
The interface operation flow for implementing the logic is shown in fig. 4:
step S410: determining a category of cells, and arbitrarily selecting one of the cells as a mode cell, and configuring a cell pattern required by the category of cells for the mode cell;
step S420: clicking a cell pattern brush button;
step S430: pressing the ctrl key, and simultaneously using a mouse to configure other cells in a point by point, which need to be configured with the pattern;
step S440: and pressing an enter key, namely calling a cell pattern brush to brush all selected cells into the same pattern as the mode cells.
By the embodiment, no matter how many cells are in the business table, as long as the category is divided, one mode cell can be configured in each category cell, and then the rest cells in the category can be subjected to unified refreshing processing by calling a cell format brush. That is, only one cell in each category needs to be configured, and unified configuration of the cells can be realized through refreshing of the cell patterns, so that complex work of cell configuration can be solved, configuration work efficiency and configuration data accuracy are provided, and configuration error rate can be effectively reduced.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic, and should not limit the implementation process of the embodiment of the present invention.
Example 2
Corresponding to the method, the invention also provides a table batch processing system, and fig. 5 shows a logic structure of the table batch processing system according to an embodiment of the invention.
As shown in fig. 5, the table batch processing system 500 provided by the present invention includes a table configuration unit 510, a cell classification unit 520, and a cell configuration unit 530. Wherein,
the table configuration unit 510 is configured to generate a service table in a corresponding format according to a preset service requirement, where the service table is composed of a plurality of cells. Because the format of the business form will be different according to the form source, the related specific business information and the like, the format of the business form needs to be configured according to the preset business requirement before the batch processing of the form; the business form consists of a plurality of cells, namely, the business form comprises cells meeting the content requirements of various items required by business so as to realize the common data statistics requirement of business related data;
the cell classification unit 520 is configured to identify style parameters of cells in the service table, and classify the cells of the service table according to the identified style parameters, where style parameters of cells of each class are the same; the style parameters at least comprise a text style, a background color, a font, a text label, a character attribute, a cell style and attribute information.
A unit cell configuration unit 530, configured to configure a style of a unit cell of each category according to a preset service requirement; for each category of cells, only one of a plurality of cells in the category is required to be determined as a mode cell to carry out corresponding cell pattern configuration, and for the rest cells in the category, a cell pattern brush is called to carry out unified refreshing configuration according to the patterns of the mode cells.
In the embodiment shown in fig. 5, the cell classifying unit 520 further includes a style parameter extracting unit 521 and a classifying unit 522, where the style parameter extracting unit 521 is configured to scan cells in the business table and extract style parameters of the cells; the classifying unit 522 is configured to classify the cells with the same style parameters, for example, determine whether a preset classifying group has a cell group with the style parameters same as the extracted style parameters according to the extracted style parameters, and if so, classify the cells in the cell group; if not, a cell group with the same style parameters as the extracted style parameters is newly built in the classifying group, and the cells are classified in the newly built cell group.
In addition, the cell configuration unit 530 further includes a pattern cell configuration unit 531 and a pattern refresh unit 532.
The pattern cell configuration unit 531 is configured to determine and configure a pattern of a pattern cell according to a cell application requirement, where the pattern cell is a template for performing batch refreshing on other cells in a class where the pattern cell is located. That is, in the business table, one cell in each category of cells is a pattern cell, which is used as a template for refreshing the cells in batches.
In the service table, how many types of cells are provided, how many mode cells are provided, and how many cells need to be configured one by one.
The style refreshing unit 532 is configured to invoke a cell format brush to refresh all other cells belonging to a category with the mode cell in batch according to the style of the mode cell, so as to implement unified batch configuration of all cell styles of the category.
The form batch processing system provided by the embodiment of the invention realizes unified configuration of one type of cells through configuration of the mode cells and style brushing operation of the same type of cells, can solve complex work of cell configuration, provides configuration work efficiency and configuration data accuracy, and reduces configuration error rate.
Example 3
Fig. 6 is a schematic diagram of a logic structure of an electronic device according to an embodiment of the invention. As shown in fig. 6, the electronic device 600 of this embodiment includes a processor 610, a memory 620, and a computer program 621 stored in the memory 620 and executable on the processor 610. The processor 610, when executing the computer program 621, implements the respective steps of the table batch processing method in embodiment 1, such as steps S110 to S130 shown in fig. 1. Alternatively, the processor 610 performs the functions of the modules/units in the above-described apparatus embodiments when performing the table batch processing method, for example, the table configuration unit 510, the cell classification unit 520, and the cell configuration unit 530 shown in fig. 5.
The computer program 621 includes a table configuration program, a cell classification program, and a cell configuration program. When the table configuration program is executed by the processor 610, a service table in a corresponding format can be generated according to a preset service requirement, and the service table is composed of a plurality of cells; when the cell classification program is executed by the processor 610, it can identify the style parameters of the cells in the service table, and classify the cells of the service table according to the identified style parameters, where the style parameters of the cells of each category are the same; when the cell configuration program is executed by the processor 610, the style of the cell of each category can be configured according to the preset service requirement; for each category of cells, only one of a plurality of cells in the category is required to be determined as a mode cell to carry out corresponding cell pattern configuration, and for the rest cells in the category, a cell pattern brush is called to carry out unified refreshing configuration according to the patterns of the mode cells.
Correspondingly, the cell classification program further comprises a style parameter extraction program and a classification program, wherein when the style parameter extraction program is executed by the processor 610, the style parameter extraction program can scan cells in the business form and extract style parameters of the cells; the classifying program when executed by the processor 610 can classify the cells with the same style parameters, for example, according to the extracted style parameters, judging whether a preset classifying group has a cell group with the same style parameters as the extracted style parameters, if so, classifying the cells in the cell group; if not, a cell group with the same style parameters as the extracted style parameters is newly built in the classifying group, and the cells are classified in the newly built cell group.
The cell configuration program further includes a mode cell configuration program and a style refresh program. When the mode cell configuration program is executed by the processor 610, the mode cell can be determined and configured, and the mode cell is a template for refreshing the rest cells of the class of the mode cell in batches; when executed by the processor 610, the pattern refresh program can invoke a cell format brush batch refresh of all other cells belonging to the same category as the pattern cell according to the pattern of the pattern cell.
By way of example, computer program 621 may be partitioned into one or more modules/units that are stored in memory 620 and executed by processor 610 to perform the present invention. One or more of the modules/units may be a series of computer program instruction segments capable of performing particular functions to describe the execution of the computer program 621 in the electronic device 600. For example, the computer program 620 may be split into embodiments 2: the functions of the table configuration unit 510, the cell sorting unit 520 and the cell configuration unit 530 are described in detail in embodiment 2, and are not described in detail herein.
The electronic device 600 may be a computing device such as a desktop computer, a notebook computer, a palm computer, and a cloud server. The electronic device 600 may include, but is not limited to, a processor 610, a memory 620. It will be appreciated by those skilled in the art that fig. 6 is merely an example of an electronic apparatus 600 and is not intended to limit the electronic apparatus 600, and may include more or fewer components than shown, or may combine certain components, or different components, e.g., the electronic apparatus may further include input-output devices, network access devices, buses, etc.
The processor 610 may be a central processing unit (Central Processing Unit, CPU), but may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), off-the-shelf programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory 620 may be an internal storage unit of the electronic device 600, such as a hard disk or a memory of the electronic device 600. The memory 620 may also be an external storage device of the electronic apparatus 600, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like, which are provided on the electronic apparatus 600. Further, the memory 620 may also include both internal storage units and external storage devices of the electronic apparatus 600. The memory 620 is used to store computer programs and other programs and data required by the electronic device. The memory 620 may also be used to temporarily store data that has been output or is to be output.
Example 4
The present embodiment provides a computer readable storage medium, on which a computer program is stored, which when executed by a processor, implements the table batch processing method in embodiment 1, and in order to avoid repetition, a detailed description is omitted here. Alternatively, the computer program, when executed by a processor, performs the functions of the various modules/units in the table batch processing system of embodiment 2. The above embodiment 3 exemplifies the computer program, and is not repeated here.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions. The functional units and modules in the embodiment may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit, where the integrated units may be implemented in a form of hardware or a form of a software functional unit. In addition, specific names of the functional units and modules are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present application. The specific working process of the units and modules in the above system may refer to the corresponding process in the foregoing method embodiment, which is not described herein again.
In the foregoing embodiments, the descriptions of the embodiments are emphasized, and in part, not described or illustrated in any particular embodiment, reference is made to the related descriptions of other embodiments.
The above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.
Claims (8)
1. The table batch processing method is applied to an electronic device and is characterized by comprising the following steps of:
s110: generating a business form in a corresponding format according to a preset business requirement, wherein the business form comprises cells; before configuring the cells, classifying the cells according to service requirements, and determining the cells with the same format as the similar cells;
s120: carrying out pattern parameter identification on the cells in the service table, classifying the cells of the service table according to the identified pattern parameters, wherein the pattern parameters of the cells of each category are the same;
the step S120 further includes: s121: scanning the cells in the business form, and extracting style parameters of the cells; s122: classifying the cells with the same style parameters;
the step S122 further includes: judging whether a cell group with the same style parameters as the extracted style parameters exists in a preset classifying group according to the extracted style parameters, and classifying the cells into the cell group if the cell group exists; if not, a cell group with the same style parameters as the extracted style parameters is newly built in the classifying group, and the cells are classified in the newly built cell group;
s130: configuring the style of the cell of each category according to the preset service requirement; and for the cells of each category, optionally determining one of a plurality of cells of the category as a mode cell to carry out corresponding cell pattern configuration, and calling cell format brushes according to the patterns of the mode cells to uniformly refresh and configure the rest cells in the category.
2. The method for batch processing of forms according to claim 1, wherein,
the style parameters at least comprise a text style, a background color, a font, a text label, a character attribute, a cell style and attribute information.
3. The method for batch processing of forms according to claim 1, wherein the step S130 further comprises:
s131: determining and configuring mode cells, wherein the mode cells are templates for refreshing the rest cells in the class of the mode cells in batches;
s132: and refreshing the patterns of the category cells, calling the cell format brush batch to refresh all other cells belonging to the same category as the mode cell according to the patterns of the mode cell.
4. A form batch processing system, comprising:
the system comprises a table configuration unit, a table configuration unit and a service management unit, wherein the table configuration unit is used for generating a service table in a corresponding format according to a preset service requirement, and the service table comprises cells; before configuring the cells, classifying the cells according to service requirements, and determining the cells with the same format as the similar cells;
the cell classification unit is used for identifying the style parameters of the cells in the business form, classifying the cells of the business form according to the identified style parameters, and the style parameters of the cells of each category are the same;
the cell configuration unit is used for configuring the patterns of the cells of each category according to preset service requirements; and for the cells of each category, optionally determining one of a plurality of cells of the category as a mode cell to carry out corresponding cell pattern configuration, and calling cell format brushes according to the patterns of the mode cells to uniformly refresh and configure the rest cells in the category.
5. An electronic device, the electronic device comprising: a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the form batch processing method according to any one of claims 1 to 3 when the computer program is executed.
6. The electronic device of claim 5, wherein the computer program comprises:
the table configuration program is used for generating a business table in a corresponding format according to a preset business requirement when being executed by the processor, and the business table comprises cells; before configuring the cells, classifying the cells according to service requirements, and determining the cells with the same format as the similar cells;
the cell classification program is used for identifying the style parameters of the cells in the business form when being executed by the processor, classifying the cells of the business form according to the identified style parameters, and the style parameters of the cells of each category are the same;
the cell configuration program is used for configuring the style of the cells of each category according to the preset service requirement when being executed by the processor; and for the cells of each category, one of a plurality of cells of the category is arbitrarily determined as a mode cell, and a cell format brush is called according to the mode cell style to uniformly refresh and configure the rest cells in the category.
7. The electronic device of claim 6, wherein the cell configuration procedure further comprises:
the system comprises a mode cell configuration program, a mode cell configuration program and a display program, wherein the mode cell configuration program is used for determining and configuring mode cells, and the mode cells are templates for refreshing the rest cells of the class where the mode cells are located in batches;
and the style refreshing program is used for calling the cell format brush to refresh all other cells belonging to the same category as the mode cell in batch according to the style of the mode cell.
8. A computer-readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of the form batch processing method of any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910461737.6A CN110287459B (en) | 2019-05-30 | 2019-05-30 | Form batch processing method, system, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910461737.6A CN110287459B (en) | 2019-05-30 | 2019-05-30 | Form batch processing method, system, device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110287459A CN110287459A (en) | 2019-09-27 |
| CN110287459B true CN110287459B (en) | 2023-12-22 |
Family
ID=68002926
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910461737.6A Active CN110287459B (en) | 2019-05-30 | 2019-05-30 | Form batch processing method, system, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110287459B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115080118A (en) * | 2019-10-31 | 2022-09-20 | 北京东土科技股份有限公司 | Method and device for configuring registers in batches and computer-readable storage medium |
| CN112784560A (en) * | 2020-05-26 | 2021-05-11 | 珠海金山办公软件有限公司 | Data display method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0481784A2 (en) * | 1990-10-19 | 1992-04-22 | Moore Business Forms, Inc. | Form automation system |
| CN101615193A (en) * | 2009-07-07 | 2009-12-30 | 北京大学 | A kind of based on the integrated inquiry system of encyclopaedia data extract |
| CN103279455A (en) * | 2013-06-28 | 2013-09-04 | 中国农业银行股份有限公司 | Spreadsheet style processing method and device |
| CN108509188A (en) * | 2018-03-30 | 2018-09-07 | 武汉斗鱼网络科技有限公司 | A kind of method for building up of list, device and electronic equipment |
| CN109559141A (en) * | 2017-09-27 | 2019-04-02 | 北京国双科技有限公司 | A kind of automatic classification method, the apparatus and system of intention pattern |
| CN109739546A (en) * | 2018-12-26 | 2019-05-10 | 深圳乐信软件技术有限公司 | Property parameters acquisition methods, device, storage medium and server |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8549392B2 (en) * | 2005-08-30 | 2013-10-01 | Microsoft Corporation | Customizable spreadsheet table styles |
-
2019
- 2019-05-30 CN CN201910461737.6A patent/CN110287459B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0481784A2 (en) * | 1990-10-19 | 1992-04-22 | Moore Business Forms, Inc. | Form automation system |
| CN101615193A (en) * | 2009-07-07 | 2009-12-30 | 北京大学 | A kind of based on the integrated inquiry system of encyclopaedia data extract |
| CN103279455A (en) * | 2013-06-28 | 2013-09-04 | 中国农业银行股份有限公司 | Spreadsheet style processing method and device |
| CN109559141A (en) * | 2017-09-27 | 2019-04-02 | 北京国双科技有限公司 | A kind of automatic classification method, the apparatus and system of intention pattern |
| CN108509188A (en) * | 2018-03-30 | 2018-09-07 | 武汉斗鱼网络科技有限公司 | A kind of method for building up of list, device and electronic equipment |
| CN109739546A (en) * | 2018-12-26 | 2019-05-10 | 深圳乐信软件技术有限公司 | Property parameters acquisition methods, device, storage medium and server |
Non-Patent Citations (1)
| Title |
|---|
| 启典文化编著.《非常实用！Excel 2013高效应用从新手到高手 全彩图解视频版》. 北京：中国铁道出版社,2015,第140-142页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110287459A (en) | 2019-09-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN115061721A (en) | Report generation method and device, computer equipment and storage medium | |
| CN110287459B (en) | Form batch processing method, system, device and storage medium | |
| US20210390496A1 (en) | Method for model-based project scoring classification and reporting | |
| CN111209374A (en) | Data query display method and device, computer system and readable storage medium | |
| CN110765101A (en) | Label generation method and device, computer readable storage medium and server | |
| CN115408546A (en) | Time sequence data management method, device, equipment and storage medium | |
| WO2016093839A1 (en) | Structuring of semi-structured log messages | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN111625567A (en) | Data model matching method, device, computer system and readable storage medium | |
| CN111324594A (en) | Data fusion method, device, equipment and storage medium for grain processing industry | |
| US10824803B2 (en) | System and method for logical identification of differences between spreadsheets | |
| CN115617790A (en) | Data warehouse creation method, electronic device and storage medium | |
| US20180165267A1 (en) | System and method for cell comparison between spreadsheets | |
| CN111667214A (en) | Goods information acquisition method and device based on two-dimensional code and electronic equipment | |
| CN111553133A (en) | Report generation method and device, electronic equipment and storage medium | |
| CN117608839A (en) | Task processing method, device, electronic equipment and storage medium | |
| CN116431698B (en) | Data extraction method, device, equipment and storage medium | |
| US20230342542A1 (en) | Automated document parsing to determine common component identifiers for consolidation of component orders | |
| CN113364632B (en) | Method, device, storage medium and apparatus for generating architecture diagram of service system | |
| CN116578583B (en) | Abnormal statement identification method, device, equipment and storage medium | |
| WO2023185377A1 (en) | Multi-granularity data pattern mining method and related device | |
| US11036927B1 (en) | Relative positional parsing of documents using trees | |
| CN116339733B (en) | Application page generation method, system, electronic device and medium | |
| US20230343084A1 (en) | Data processing apparatus, data processing method, and data processing program | |
| CN115374178A (en) | User portrait acquisition method applied to government affair service field |
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 |