CN110287459A - Table batch processing method, system, device and can storage medium - Google Patents
Table batch processing method, system, device and can storage medium Download PDFInfo
- Publication number
- CN110287459A CN110287459A CN201910461737.6A CN201910461737A CN110287459A CN 110287459 A CN110287459 A CN 110287459A CN 201910461737 A CN201910461737 A CN 201910461737A CN 110287459 A CN110287459 A CN 110287459A
- Authority
- CN
- China
- Prior art keywords
- cell
- cells
- style
- mode
- business
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 16
- 238000012545 processing Methods 0.000 claims abstract description 35
- 238000000034 method Methods 0.000 claims abstract description 27
- 238000004590 computer program Methods 0.000 claims description 21
- 230000006870 function Effects 0.000 description 11
- 238000013461 design Methods 0.000 description 3
- 230000001680 brushing effect Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000003825 pressing Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000001914 filtration Methods 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 present invention relates to technical field of data processing, provide a kind of table batch processing method, system, device and can storage medium, method therein includes: S110: the business table of corresponding format is generated according to preset business demand；S120: the identification of pattern parameter is carried out to the cell in business table, and is classified according to the pattern parameter identified to the cell of business table, the pattern parameter of the cell of each classification is identical；S130: the pattern of the cell of each classification is configured according to preset business demand；Wherein, to the cell of each classification, it determines one of as the corresponding cell style configuration of mode unit lattice progress in multiple cells of the category, to the cell of each classification of configured mode unit lattice, unify the remaining element lattice in the refresh configuration category according to the pattern call unit lattice Format Painter of the mode unit lattice.Using the present invention, it is able to solve the problems such as current table allocative efficiency is low, error rate is high.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method, a system, a device, and a storage medium for batch processing of tables.
Background
With the wide application of the electronic office system, the data table is applied to the field of data statistical processing more and more with the strong statistical capability.
In a scenario where the application amount of the data table is large, such as company business statistics, tax payment declaration, economic census, and the like, because the sources, types, and formats of the tables are different, various tables are inevitably involved in the reporting process, and information such as the row length, column length, header style, and the like of each table may be different, so that a large amount of cell processing needs to be performed on the reported table 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 one by one, which is time-consuming and labor-consuming, influences the working progress and is easy to cause configuration omission and errors. Low efficiency and high error rate.
Disclosure of Invention
In view of the foregoing problems, an object of the present invention is to provide a method, a system, a device and a storage medium for batch processing of tables, so as to solve the problems of low efficiency and high error rate of cell configuration in the process of data processing by using tables.
In a first aspect, the present invention provides a method for batch processing of forms, applied to an electronic device, comprising the steps of:
s110: generating a business table with a corresponding format according to a preset business requirement, wherein the business table comprises cells;
s120: carrying out pattern parameter identification on the cells in the business table, and 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 each type of cell according to preset service requirements; and for each type of cell, randomly determining one of the multiple cells in the type as a mode cell to carry out corresponding cell style configuration, and calling a cell format brush according to the style of the mode cell to uniformly refresh and configure the rest cells in the type.
The style parameters at least comprise character style, background color, font, character labels, character attributes, cell style and attribute information.
Preferably, the step S120 further includes: s121: scanning the cells in the service table, and extracting the style parameters of the cells; s122: and classifying the cells with the same style parameters.
The step S122 further includes: judging whether a cell group with the same style parameter as the extracted style parameter exists in a preset classification group or not according to the extracted style parameter, and classifying the cells in the cell group if the cell group exists; and if not, newly building a cell group with the same style parameter as the extracted style parameter in the classification group, and classifying the cells in the newly built cell group.
The step S130 further includes: s131: determining and configuring a mode cell, wherein the mode cell is a template for carrying out batch refreshing on other cells of a class in which the mode cell is located; s132: and (4) refreshing the style of the category cell, and calling the cell format to refresh all other cells which belong to the same category as the mode cell in batch according to the style of the mode cell.
In a second aspect, the present invention provides a table batch processing system, comprising:
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 table and classifying the cells of the business table 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 style of each type of cell according to the preset service requirement; and for each type of cell, randomly determining one of the multiple cells in the type as a mode cell to carry out corresponding cell style configuration, and calling a cell format brush according to the style of the mode cell to uniformly refresh and configure the rest cells in the type.
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 table configuration program is used for generating a business table with a corresponding format according to preset requirements when being executed by the processor, and the business table comprises cells;
the cell classification program is used for carrying out pattern parameter identification on the cells in the business table when being executed by the processor, and 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;
the cell configuration program is used for configuring the style of each type of cell according to the preset service requirement when being executed by the processor; and for each type of cell, randomly determining one of the cells in the type as a mode cell, and calling a cell format brush according to the mode of the mode cell to uniformly refresh and configure the rest cells in the type.
In a fourth aspect, the present invention further provides a computer-readable storage medium, which stores a computer program, wherein the computer program, when executed by a processor, implements the steps of the above table batch processing method.
According to the technical scheme, the table batch processing method, the table batch processing system, the table batch processing device and the storage medium can solve the problem of configuration of a large number of cells of diversified service 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 service 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. Further, the present invention is intended to include all such aspects and their equivalents.
Drawings
Other objects and results of the present invention will become more apparent and more readily appreciated as the same becomes better understood by reference to the following description taken in conjunction with the accompanying drawings. In the drawings:
FIG. 1 is a flowchart of a method for batch processing of forms according to an embodiment of the 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 the style of cells of each category according to an embodiment of the present invention;
FIG. 4 is a flowchart illustrating a unified batch configuration operation for cell styles according to 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 numbers in all figures indicate 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. Examples of well known computing systems, environments, and/or configurations that may be suitable for use with electronic devices, such as 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 pcs, minicomputer systems, mainframe computer systems, distributed cloud computing environments that include any of the above systems, and the like.
The 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 practiced 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 computer 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, the numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present invention unless specifically stated otherwise.
Example 1
In order to explain the table batch processing method provided by the present invention, fig. 1 shows a table batch processing method flow according to an embodiment of the present invention.
As shown in fig. 1, the method for batch processing of tables provided by the present invention may include the following steps:
s110: and generating a business table with a corresponding format according to a preset business requirement, wherein the business table is composed of a plurality of cells. Because the formats of the service forms are different according to different submitters, related specific service information and the like, before batch processing is performed on the forms, the formats of the service forms need to be configured according to preset service requirements; the business table is composed of a plurality of cells, namely the business table comprises cells meeting the content requirements of various items of business needs so as to realize the statistical requirements of common data of business related data.
The technical scheme of the invention can be applied to business statistics of purchasing and selling of enterprises, human resource statistics of enterprises and public institutions, population/economy general survey of government departments, experimental data statistics in scientific research processes and the like. Because the business requirements in the aspect of data statistics are various, in order to express the technical scheme of the invention more clearly and intuitively, the batch processing method of the invention is explained in detail by taking tax declaration forms in the field of tax as an example.
Because tax return forms are different in tax types and taxpayers types, the return forms are various in format, numerous in column and non-uniform in content, the number of generated cells is large, and the types of the cells are also various. For this reason, before configuring the cells, the cells need to be classified according to the service requirements, i.e., the requirements for tax declaration, and the cells with the same format are determined as the cells of the same type, so as to facilitate batch processing.
S120: and carrying out pattern parameter identification on the cells in the business table, and 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.
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, that is, the related information such as the character style, background color, font, character 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 batch processed in the service form, and the purpose of batch processing according to one template can be achieved through the design. Therefore, the invention classifies the cells with the same style parameter into one type according to the style parameter of the cells in the table as the classification standard of the cell batch processing, so as to carry out the batch processing on the cells of the same type.
FIG. 2 illustrates a process for classifying cells according to an embodiment of the present invention. As shown in fig. 2, in the process of classifying the cells of the business table, the cells in the business table may be scanned one by one first, and the style parameters of the scanned cells are extracted (as shown in step S121); then, the extracted style parameters are identified, and the cells with the same style parameters are classified (as shown in step S122).
In the process of classifying the cells according to the style parameters, the following method can be adopted: pre-establishing a classification group for classifying the cells, judging whether a cell group with the same style parameter as the extracted style parameter exists in the preset classification group according to the extracted style parameter, and classifying the cell in the corresponding cell group if the cell group exists; and if not, newly building a cell group with the same style parameter as the extracted style parameter in the classification group, and classifying the cell in the newly built cell group.
After the cell classification of the business form is completed, the next step can be entered:
s130: and configuring the style of the cell of each category according to the preset service requirement.
For each type of cell, only one of the multiple cells in the type needs to be determined as a mode cell to perform corresponding cell style configuration, and for the rest of the cells in the type, a cell format brush is called to perform uniform refresh configuration according to the style of the mode cell.
Taking a tax declaration form in the tax field as an example, in a specific operation process of configuring the style of the cell of each category according to a preset tax declaration requirement, firstly determining the style of the cell of one category and the style of the cell of the category, randomly selecting one cell from the various cells of the category as a mode cell for configuration, namely configuring the mode cell according to the cell style of the cell of the category to which the cell belongs, then locking other cells needing to configure the style except the mode cell in the category, calling a cell style brush to refresh the style of the other cells in the category, and enabling the style of the other cells in the category to be refreshed into the same style as the style 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 the configuration completion positions of all the cells of all the categories are completed.
For an operator, the configuration of the cells does not need manual configuration of one cell per cell, and the configuration of all other cells can be automatically completed according to the mode of the mode cells 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 per category.
More specifically, step S130 can be further subdivided into two steps as shown in fig. 3:
s131: the style of the mode cell is determined and configured according to the cell application needs. In the business table, one cell in each category of cells is a mode cell and is used as a template for carrying out batch refreshing on the cells of the category. In the wangying table, as many types of cells and as many pattern cells exist, the number of pattern cells needs to be configured one by one.
S132: style refresh of category cells. And according to the configured style of the mode cell, refreshing all other cells which belong to the same category as the mode cell in batch, and realizing the uniform batch configuration of all cell styles of the category.
In one embodiment of the present invention, the batch processing of the cells is performed as follows.
Firstly, determining a category of cells and the style of the category of cells, randomly selecting one cell in the category of cells, configuring a required cell style (the cell style of the category of cells) as a mode cell, wherein the cell style can include but is not limited to the character style, background color, font, character label, character attribute, cell style and attribute information of the cell, and the specific configuration requirement is determined according to the specific requirement of a service form. And after the mode cell is configured, calling a cell style brush to refresh the style of other cells in the category of cells.
The effect displayed on the operation interface by the process is as follows: selecting and calling a style brush of the cells in the menu at the top end of the page, and simultaneously using other cells needing to be configured with the style in the selected cells of the category; finally, all selected cells are refreshed to the same pattern as the mode cells.
The batch configuration logic provided by the embodiment comprises two parts of structural design and implementation logic.
In the structural design part, a drop-down menu, a header of a data table, a field, related information, cell configuration information and the like are respectively defined according to the characteristics of the form requiring the batch configuration of the cells and the requirements of the batch configuration of the cells, and the method specifically comprises the following definition of the form:
1) data table header definition table: and the header data information is used for recording and storing the business table. Such as: column name, column width, relative column difference, row number, column number, alignment mode, format method, EXCEL header mapping method and other field information.
2) Data table field definition table: and the field characteristic information is used for recording and storing the specific data of the business form. Such as: field coding, name, data type, field length, field precision, sequence number, whether empty, whether filtering is used, whether access is used, and the like.
3) Data table definition table: and the related table identity information is used for recording and storing the business table. Such as: table code, name, version number, table type, whether disabled, rank number, etc.
4) Data example table: the report data information is used for recording and storing report data information of cells which are actually configured in batches.
5) The pull-down menus comprise function menus of cell style brushing, cell merging, data relation, account relation, in-table relation, formula setting, table associated data, clearing setting information and the like.
In the implementation logic portion, that is, the service interface is provided with function menus such as cell style brush, cell merge, data relationship, etc., since this embodiment is only for explaining the scheme logic of configuring cells in batch, the detailed description of the functions thereof is not provided herein. The cell style brush triggers the system to uniformly refresh and configure the cell styles of the cells to be configured in batch according to the style parameters (such as the information of the character style, the background color, the font, the character label, the character attribute, the cell style, the attribute and the like of the cells) of the mode cells.
The interface operation flow of the above implementation logic is shown in fig. 4:
step S410: determining a category of cells, randomly selecting one cell from the category of cells as a mode cell, and configuring a cell style required by the category of cells for the mode cell;
step S420: clicking a cell style brush button;
step S430: pressing a ctrl key, and simultaneously using a mouse to gradually arrange other cells of the style according to other needs;
step S440: and pressing an enter key, namely calling a cell style brush to brush all the selected cells into the same style as the mode cells.
According to the embodiment, no matter how many cells are in the service table, as long as the types are divided, one mode cell can be configured in each type of cell, and then the unified refreshing processing is performed on the other cells in the type by calling the cell format brush. That is to say, only one cell in each category needs to be configured, that is, the unified configuration of the cells can be realized through the refresh of the cell style, which not only can solve the complex work of cell configuration, provide the configuration work efficiency and the configuration data accuracy, but also can effectively reduce the configuration error rate.
It should be understood that, the sequence numbers of the steps in the foregoing embodiments do not imply an execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.
Example 2
Corresponding to the method, the invention further provides a table batch processing system, and fig. 5 shows a logic structure of the table batch processing system according to the 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 service table varies according to the source of the table, the specific service information involved, and the like, before the table is processed in batch, the format of the service table needs to be configured according to the preset service requirement; the business table is composed of a plurality of cells, namely the business table comprises cells meeting the content requirements of various items of business needs so as to realize the statistical requirements of the common data of the business related data;
a cell classifying unit 520, configured to perform pattern parameter identification on cells in the service table, and classify the cells of the service table according to the identified pattern parameters, where the pattern parameters of the cells of each category are the same; the style parameters at least comprise character style, background color, font, character label, character attribute, cell style and attribute information.
A cell configuration unit 530, configured to configure the style of the cells of each category according to the preset service requirement; for each type of cell, only one of the multiple cells in the type needs to be determined arbitrarily as a mode cell to perform corresponding cell style configuration, and for the rest cells in the type, a cell format brush is called to perform uniform refresh configuration according to the style of the mode cell.
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, wherein the style parameter extracting unit 521 is configured to scan a cell in the business table to extract a style parameter of the cell; the classifying unit 522 is configured to classify the cells with the same style parameter, for example, according to the extracted style parameter, determine whether a preset classification group has a cell group with the same style parameter as the extracted style parameter, and if yes, classify the cell in the cell group; and if not, newly building a cell group with the same style parameter as the extracted style parameter in the classification group, and classifying the cells in the newly built cell group.
In addition, the cell configuration unit 530 further includes a mode cell configuration unit 531 and a pattern refresh unit 532.
The mode cell configuration unit 531 is configured to determine and configure a style of a mode cell according to a cell application requirement, where the mode cell is a template for performing a batch refresh style on the other cells of the class where the mode cell is located. That is, in the business table, one cell in each category of cells is a mode cell, and is used as a template for performing a batch refresh style on the cells.
In the service table, as many types of cells and as many pattern cells are available, as many cells need to be allocated one by one.
The style refreshing unit 532 is configured to invoke a batch refresh of the cell format according to the style of the mode cell, and refresh all other cells belonging to the same category as the mode cell, so as to implement a uniform 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 the cells of one type through configuration of the mode cells and style brushing operation of the cells of the same type, can solve the complicated 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 operable on the processor 610. The processor 610, when executing the computer program 621, implements the steps of the table batch processing method in embodiment 1, such as steps S110 to S130 shown in fig. 1. Alternatively, the processor 610 implements the functions of the modules/units in the above-described device embodiments when executing the table batch processing method, such as the table configuration unit 510, the cell classification unit 520, and the cell configuration unit 530 shown in fig. 5.
The computer programs 621 include a table configuration program, a cell classification program, and a cell configuration program. When the form configuration program is executed by the processor 610, a service form with a corresponding format can be generated according to a preset service requirement, and the service form is composed of a plurality of cells; when executed by the processor 610, the cell classification program can identify the style parameters of the cells in the business form, and classify the cells of the business form according to the identified style parameters, wherein the style parameters of the cells of each category are the same; when executed by the processor 610, the cell configuration program can configure the style of the cells of each category according to preset service requirements; for each type of cell, only one of the multiple cells in the type needs to be determined arbitrarily as a mode cell to perform corresponding cell style configuration, and for the rest cells in the type, a cell format brush is called to perform uniform refresh configuration according to the style of the mode cell.
Correspondingly, the cell classifying program further includes a style parameter extracting program and a classifying program, wherein the style parameter extracting program, when being executed by the processor 610, can scan the cells in the service table to extract the style parameters of the cells; the classifying program, when executed by the processor 610, can classify the cells having the same style parameter, for example, according to the extracted style parameter, determine whether a preset classification group has a cell group having a style parameter identical to the extracted style parameter, and if yes, classify the cell in the cell group; and if not, newly building a cell group with the same style parameter as the extracted style parameter in the classification group, and classifying the cells in the newly built cell group.
The cell configuration program further includes a mode cell configuration program and a style refresh program. When executed by the processor 610, the mode cell configuration program may determine and configure a mode cell, where the mode cell is a template for performing a batch refresh pattern on the remaining cells of the class in which the mode cell is located; when executed by the processor 610, the style refresh program may invoke a batch refresh of the style of the pattern cells by the style-based refresh of all other cells belonging to the same category as the pattern cells.
Illustratively, the computer program 621 may be divided into one or more modules/units, which are stored in the memory 620 and executed by the processor 610 to implement the present invention. One or more of the modules/units may be a series of computer program instruction segments capable of performing specific functions, the instruction segments describing the execution of the computer program 621 in the electronic device 600. For example, the computer program 620 may be divided into: the functions of the table configuration unit 510, the cell classification unit 520, and the cell configuration unit 530 are described in detail in embodiment 2, and are not described herein again.
The electronic device 600 may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The electronic device 600 may include, but is not limited to, a processor 610, a memory 620. Those skilled in the art will appreciate that fig. 6 is merely an example of an electronic apparatus 600 and does not constitute a limitation of the electronic apparatus 600 and may include more or less components than those shown, or combine certain components, or different components, e.g., the electronic apparatus may also include input-output devices, network access devices, buses, etc.
The Processor 610 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The storage 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 Card (FlashCard), etc. 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 for storing 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
This embodiment provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the method for processing the table batch in embodiment 1 is implemented, and details are not described here again to avoid repetition. Alternatively, the computer program realizes the functions of each module/unit in the table batch processing system in embodiment 2 when executed by a processor. In the above embodiment 3, the computer program is exemplarily described, and is not described herein again to avoid repetition.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules, so as to perform all or part of the functions described above. Each functional unit and module in the embodiments may be integrated in one processing unit, or each unit may exist alone physically, or two or more units are integrated in one unit, and the integrated unit may be implemented in a form of hardware, or in a form of 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 processes of the units and modules in the system may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and reference may be made to the related descriptions of other embodiments for parts that are not described or illustrated in a certain embodiment.
The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.
Claims (10)
1. A form batch processing method is applied to an electronic device and is characterized by comprising the following steps:
s110: generating a business table with a corresponding format according to a preset business requirement, wherein the business table comprises cells;
s120: carrying out pattern parameter identification on the cells in the business table, and 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 each type of cell according to the preset service requirement; and for each type of cell, randomly determining one of the multiple cells in the type as a mode cell to carry out corresponding cell style configuration, and calling a cell format brush according to the style of the mode cell to uniformly refresh and configure the rest cells in the type.
2. The form batch processing method of claim 1,
the style parameters at least include text style, background color, font, text label, character attribute, cell style and attribute information.
3. The data form batch processing method of claim 1, wherein the step S120 further comprises:
s121: scanning the cells in the service table, and extracting the style parameters of the cells;
s122: and classifying the cells with the same style parameters.
4. The data table batch processing method of claim 3, wherein the step S122 further comprises:
judging whether a cell group with the same style parameter as the extracted style parameter exists in a preset classification group or not according to the extracted style parameter, and classifying the cells in the cell group if the cell group exists; and if not, newly building a cell group with the same style parameter as the extracted style parameter in the classification group, and classifying the cells in the newly built cell group.
5. The form batch processing method of claim 1, wherein the step S130 further comprises:
s131: determining and configuring a mode cell, wherein the mode cell is a template for carrying out batch refreshing on other cells of a class in which the mode cell is located;
s132: and (4) refreshing the style of the category cell, and calling the cell format to refresh all other cells which belong to the same category as the mode cell in batch according to the style of the mode cell.
6. A form batch processing system, comprising:
the table configuration unit is used for generating a service table with a corresponding format according to a preset service requirement, and the service table comprises cells;
the cell classification unit is used for carrying out pattern parameter identification on the cells in the business table and classifying the cells of the business table according to the identified pattern parameters, and the pattern parameters of the cells of each category are the same;
the cell configuration unit is used for configuring the style of each type of cell according to the preset service requirement; and for each type of cell, randomly determining one of the multiple cells in the type as a mode cell to carry out corresponding cell style configuration, and calling a cell format brush according to the style of the mode cell to uniformly refresh and configure the rest cells in the type.
7. An electronic device, comprising: memory, processor and computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the method of batch processing of tables according to any of claims 1 to 5 when executing the computer program.
8. The electronic device of claim 7, wherein the computer program comprises:
the table configuration program is used for generating a business table with a corresponding format according to preset business requirements when being executed by the processor, and the business table comprises cells;
the cell classification program is used for carrying out pattern parameter identification on the cells in the business table when being executed by the processor, and 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;
the cell configuration program is used for configuring the style of each type of cell according to the preset service requirement when being executed by the processor; and for each type of cell, randomly determining one of the cells in the type as a mode cell, and calling a cell format brush according to the mode of the mode cell to uniformly refresh and configure the rest cells in the type.
9. The electronic device of claim 8, wherein the cell configuration program further comprises:
the mode cell configuration program is used for determining and configuring mode cells, and the mode cells are templates for carrying out batch refreshing on other cells of the class where the mode cells are located;
and the style refreshing program is used for calling the style of the mode cell to refresh all other cells which belong to the same category as the mode cell in batch according to the style of the mode cell.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the method of batch processing of forms according to any one of claims 1 to 5.
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 true CN110287459A (en) | 2019-09-27 |
| CN110287459B 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) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112748954A (en) * | 2019-10-31 | 2021-05-04 | 北京东土科技股份有限公司 | 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 |
| CN113869015A (en) * | 2021-09-26 | 2021-12-31 | 珠海金山办公软件有限公司 | Processing method and processing device for table style and computer readable storage medium |
| CN114065710A (en) * | 2021-10-20 | 2022-02-18 | 珠海金山办公软件有限公司 | Identification correction method and device, electronic equipment and readable storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0481784A2 (en) * | 1990-10-19 | 1992-04-22 | Moore Business Forms, Inc. | Form automation system |
| US20070050699A1 (en) * | 2005-08-30 | 2007-03-01 | Microsoft Corporation | Customizable spreadsheet table styles |
| 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 |
-
2019
- 2019-05-30 CN CN201910461737.6A patent/CN110287459B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0481784A2 (en) * | 1990-10-19 | 1992-04-22 | Moore Business Forms, Inc. | Form automation system |
| US20070050699A1 (en) * | 2005-08-30 | 2007-03-01 | Microsoft Corporation | Customizable spreadsheet table styles |
| 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高效应用从新手到高手 全彩图解视频版》", 北京：中国铁道出版社, pages: 140 - 142 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112748954A (en) * | 2019-10-31 | 2021-05-04 | 北京东土科技股份有限公司 | Method and device for configuring registers in batches and computer-readable storage medium |
| CN112748954B (en) * | 2019-10-31 | 2022-08-23 | 北京东土科技股份有限公司 | 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 |
| CN113869015A (en) * | 2021-09-26 | 2021-12-31 | 珠海金山办公软件有限公司 | Processing method and processing device for table style and computer readable storage medium |
| CN114065710A (en) * | 2021-10-20 | 2022-02-18 | 珠海金山办公软件有限公司 | Identification correction method and device, electronic equipment and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110287459B (en) | 2023-12-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110287459B (en) | Form batch processing method, system, device and storage medium | |
| CN108090073B (en) | Configurable bill of material conversion method and device | |
| CN109472568A (en) | A kind of block chain method of commerce, device, management system, equipment and storage medium | |
| CN106557307B (en) | Service data processing method and system | |
| WO2022041834A1 (en) | Transaction data processing method and apparatus | |
| CN109948938A (en) | The bill of materials configuration method and device and equipment of a kind of enterprise resource planning | |
| CN111242164A (en) | Decision result determination method, device and equipment | |
| CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
| CN112527602A (en) | Business data statistical method and device, computer equipment and storage medium | |
| CN111858617A (en) | User searching method and device, computer readable storage medium and electronic equipment | |
| CN113515544B (en) | Data attribute query method and data attribute query device | |
| CN114492354A (en) | Streaming document generation method, computing device and computer readable medium | |
| CN117390011A (en) | Report data processing method, device, computer equipment and storage medium | |
| CN110704635A (en) | Conversion method and device for ternary group data in knowledge graph | |
| CN111143412A (en) | Data comparison method and device, computer and computer readable storage medium | |
| CN108460078B (en) | Auxiliary function execution method and device, storage medium and terminal | |
| CN113364632B (en) | Method, device, storage medium and apparatus for generating architecture diagram of service system | |
| CN115879980A (en) | Method and device for passenger group circle selection and comparative analysis | |
| CN112700093B (en) | Project progress Gantt chart construction method, terminal device and storage medium | |
| CN115167728A (en) | Menu bar merging and displaying method, device and computer readable storage medium | |
| CN113064928A (en) | Report data query method and device, electronic equipment and storage medium | |
| US11170164B2 (en) | System and method for cell comparison between spreadsheets | |
| CN111026705A (en) | Building engineering file management method, system and terminal equipment | |
| CN111324646A (en) | Policy information importing and analyzing method based on dynamic mapping | |
| Merelli et al. | Porting bioinformatics applications from grid to cloud: A macromolecular surface analysis application case study |
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 |