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
- pattern
- lattice
- classification
- unit lattice
- 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 24
- 238000003860 storage Methods 0.000 title claims abstract description 15
- 238000000034 method Methods 0.000 claims abstract description 27
- 238000012545 processing Methods 0.000 claims abstract description 26
- 238000004590 computer program Methods 0.000 claims description 20
- 239000000284 extract Substances 0.000 claims description 4
- 230000006870 function Effects 0.000 description 12
- 238000010276 construction Methods 0.000 description 4
- 238000000605 extraction Methods 0.000 description 4
- 238000004321 preservation Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000010485 coping Effects 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 238000013461 design 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
- 238000009434 installation Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000003825 pressing Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000029305 taxis Effects 0.000 description 1
- 238000012360 testing method 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 technical field of data processing, more specifically, be related to a kind of table batch processing method, system,
Device and can storage medium.
Background technique
With the extensive use of teleworking system, data form is more and more applied with its powerful statistical power
To middle data statistics processing field.
In data form application amount big scene, such as corporate business statistics, tax declaration, economic visa etc., due to table
The source of lattice, type, format are different, during reporting, can inevitably be related to various tables, and every table
Row, column length and the information such as title pattern be likely to it is not identical, it is therefore desirable to according to different item, type etc.
A large amount of classification informations carry out a large amount of cell processing to the table reported.
In a traditional way, existing a large amount of cell configurations, honestly can only be configured by hand, time-consuming consumption one by one
Power, influences job schedule, also be easy to cause configuration omission and mistake.Inefficiency and error rate height.
Summary of the invention
In view of the above problems, it the object of the present invention is to provide a kind of table batch processing method, system, device and can store
Medium, with solve currently with table carry out data processing during cell allocative efficiency is low, error rate is high the problems such as.
In a first aspect, the present invention provides a kind of table batch processing method, it is applied to electronic device, includes the following steps:
S110: the business table of corresponding format is generated according to preset business demand, the business table includes cell；
S120: the identification of pattern parameter is carried out to the cell in the business table, and according to the pattern parameter identified
Classify 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 list of each classification
First lattice arbitrarily determine one of as the corresponding cell style of mode unit lattice progress in multiple cells of the category
Configuration, and unify the remaining element in the refresh configuration category according to the pattern call unit lattice Format Painter of the mode unit lattice
Lattice.
Wherein, the pattern parameter includes at least text style, background color, font, literal symbol, character attibute, list
First lattice pattern and attribute information.
Wherein, preferred scheme is that the step S120 further comprises: S121: to the unit in the business table
Lattice are scanned, and extract the pattern parameter of the cell；S122: the identical cell of pattern parameter is sorted out.
The step S122 further comprises: according to extracted pattern parameter, judging whether deposit in preset classification group
In pattern parameter cell group identical with extracted pattern parameter, if it is present the cell is categorized in described
In cell group；If it does not exist, then creating pattern parameter list identical with extracted pattern parameter in the classification group
First lattice group, and the cell is categorized in newly-built cell group.
The step S130 further comprises: S131: determining simultaneously configuration mode cell, the mode unit lattice is to institutes
The remaining element lattice of class carry out the template of batch refresh pattern where stating mode unit lattice；S132: the pattern brush of class location lattice
Newly, a class is belonged to according to the pattern call unit lattice Format Painter batch refresh of the mode unit lattice and the mode unit lattice
Other other all cells.
Second aspect, the present invention provide a kind of table batch processing system, comprising:
Table configuration unit, for according to preset business demand configuration service table, the business table to include unit
Lattice；
Cell taxon, for carrying out the identification of pattern parameter to the cell in the business table, and according to knowledge
Not Chu pattern parameter classify to the cell of business table, the pattern parameter of the cell of each classification is identical；
Cell configuration unit, the pattern of the cell for configuring each classification according to preset business demand；Wherein,
To the cell of each classification, arbitrarily determine in multiple cells of the category one of carries out pair as mode unit lattice
Answer cell style configuration, and according to the pattern call unit lattice Format Painter of the mode unit lattice unify refresh configuration such
Remaining element lattice in not.
The third aspect, the present invention also provides a kind of electronic device, which includes: memory, processor and deposits
The computer program that can be run in memory and on a processor is stored up, the processor is realized when executing the computer program
The step of above table batch processing method.
Wherein, the computer program includes:
Table configurator generates the business of corresponding format according to preset also demand when for being executed by the processor
Table, the business table includes cell；
Cell sort program carries out pattern to the cell in the business table when for being executed by the processor
Parameter identification, and classified according to the pattern parameter identified to the cell of business table, the cell of each classification
Pattern parameter is identical；
Cell configurator configures each classification according to preset business demand when for being executed by the processor
The pattern of cell；Wherein, to the cell of each classification, one of work in multiple cells of the category is arbitrarily determined
For mode unit lattice, and unify in the refresh configuration category according to the pattern call unit lattice Format Painter of the mode unit lattice
Remaining element lattice.
Fourth aspect, the present invention also provides a kind of computer readable storage medium, the computer readable storage medium is deposited
Contain computer program, wherein the step of above table batch processing method is realized when the computer program is executed by processor
Suddenly.
It can be seen from the above technical scheme that table batch processing method provided by the invention, system, device and Jie can be stored
Matter is able to solve the allocation problem of a large amount of cells of diversified business table, realizes the batch of a large amount of same pattern cells
Refresh, reduce the complicated work of cell configuration, improve the configuration work efficiency and configuration data accuracy of business table, reduces
Configuration error rate.
To the accomplishment of the foregoing and related purposes, one or more aspects of the present invention includes the spy being particularly described below
Sign.Certain illustrative aspects of the invention is described in detail in the following description and the annexed drawings.However, these aspect instructions are only
It is that some of the various ways in the principles of the present invention can be used.In addition, the present invention is intended to include all such aspects with
And their equivalent.
Detailed description of the invention
By reference to the explanation below in conjunction with attached drawing, and with a more complete understanding of the present invention, of the invention is other
Purpose and result will be more clearly understood and understood.In the accompanying drawings:
Fig. 1 is the table batch processing method process according to the embodiment of the present invention；
Fig. 2 is the process classified to cell according to the embodiment of the present invention；
Fig. 3 is the process according to the pattern of the cell of each classification of configuration of the embodiment of the present invention；
Fig. 4 is to unify batch configuration operating process according to the cell style of the embodiment of the present invention；
Fig. 5 is the logical construction according to the table batch processing system of the embodiment of the present invention；
Fig. 6 is the electronic device logical construction schematic diagram according to the embodiment of the present invention.
Identical label indicates similar or corresponding feature or function in all the appended drawings.
Specific embodiment
In the following description, for purposes of illustration, it in order to provide the comprehensive understanding to one or more embodiments, explains
Many details are stated.It may be evident, however, that these embodiments can also be realized without these specific details.
The embodiment of the present invention can be applied to the electronic equipments such as computer system/server, can with it is numerous other general
Or special-purpose computing system environment or configuration operate together.Suitable for what is be used together with electronic equipments such as computer system/servers
Well-known computing system, environment and/or the example of configuration include but is not limited to: personal computer system, server calculate
Machine system, thin client, thick client computer, hand-held or laptop devices, microprocessor-based system, set-top box, programmable-consumer
Electronic product, NetPC Network PC, minicomputer system, large computer system and the distribution including above-mentioned any system
Cloud computing technology environment, etc..
The electronic equipments such as computer system/server can be in the executable finger of the computer system executed by computer system
It enables and being described under the general context of (such as program module).In general, program module may include routine, program, target program, group
Part, logic, data structure etc., they execute specific task or realize specific abstract data type.Computer system/
The electronic equipments such as server can be implemented in distributed cloud computing environment, and in distributed cloud computing environment, task is by passing through
What the remote processing devices of communication network links executed.In distributed cloud computing environment, it includes depositing that program module, which can be located at,
On the Local or Remote computing system storage medium for storing up equipment.
Hereinafter, specific embodiments of the present invention will be described in detail with reference to the accompanying drawings.It should also be noted that unless in addition specific
Illustrate, unlimited this hair of system of component and the positioned opposite of step, numerical expression and numerical value otherwise illustrated in these embodiments
Bright range.
Embodiment 1
In order to illustrate table batch processing method provided by the invention, Fig. 1 shows table according to an embodiment of the present invention
Batch processing method process.
As shown in Figure 1, table batch processing method provided by the invention, may include steps of:
S110: the business table of corresponding format is generated according to preset business demand, the business table is by multiple cells
Composition.Due to business table format can due to the difference of submitter, the specific business information being related to etc. it is different, right
Before table carries out batch processing, need in advance according to the format of preset business demand configuration service table；The business table
It is made of multiple cells, i.e., the business table includes the cell for meeting the various contents of a project of business needs and requiring, with reality
The frequently-used data statistical demand of existing service related data.
Technical solution of the present invention can be applied to the human resources system of such as enterprise's purchase and sale business statistics, enterprises and institutions
Meter, population/economic visa of government affairs department and test data statistics in process of scientific research etc..Industry in terms of due to data statistics
Business demand is varied, in order to become apparent from intuitive statement technical solution of the present invention, below temporarily with the Shen of paying taxes in tax field
Batch processing method of the invention is described in detail for report.
The tax category that are related to due to tax return, taxpayer's type are different, declare that tableau format is various, and column is many
More, content also disunity, therefore, the quantity of cell generated is very big, and pattern is also all kinds of.In this regard, configuring
Before cell, it is necessary to carry out category division to cell according to business demand, that is, tax declaration demand, determine format phase
Same cell is as similar cell, so as to batch processing.
S120: the identification of pattern parameter is carried out to the cell in the business table, and according to the pattern parameter identified
Classify to the cell of business table, the pattern parameter of the cell of each classification is identical.
In order to achieve the purpose that batch processing, in same class cell, the pattern parameter of cell is generally required
It is all identical, i.e., the text style of same class cell, background color, font, literal symbol, character attibute, cell style and
The relevant informations such as attribute are all identical, wherein the data information filled belongs to the same class number that can be processed in batches in business table
According to being designed in this way and can be only achieved the purpose for carrying out batch processing according to template.Therefore, the present invention is according to cell in table
Pattern parameter be cell batch processing classification standard, the cell with same pattern parameter is incorporated into as one kind, with
Just batch processing is carried out to similar cell.
Fig. 2 shows the processes classified to cell accord to a specific embodiment of that present invention.As shown in Fig. 2,
During the cell to business table is classified, first the cell in business table can be scanned one by one,
Extract the pattern parameter of scanned cell (as shown in step S121)；Then, the pattern parameter of extraction is identified, it will
The identical cell of pattern parameter is sorted out (as shown in step S122).
It wherein, can be in the following way: preestablishing during being sorted out according to pattern parameters on cell lattice
One for the classification group sorted out to cell, according to extracted pattern parameter, judge in preset classification group whether
There are pattern parameter cell groups identical with extracted pattern parameter, if it is present the cell is categorized in correspondence
Cell group in；If it does not exist, then creating pattern parameter unit identical with extracted pattern parameter in classification group
Lattice group, and the cell is categorized in newly-built cell group.
After the cell classification of finishing service table, so that it may enter next step:
S130: the pattern of the cell of each classification is configured according to preset business demand.
Wherein, to the cell of each classification, it is only necessary to determine one of conduct in multiple cells of the category
Mode unit lattice carry out corresponding cell style configuration, for the remaining element lattice in the category, call unit lattice Format Painter
Unified refresh configuration is carried out according to the pattern of mode unit lattice.
By taking the tax return in tax field as an example, in the unit for configuring each classification according to preset tax declaration demand
In the specific operation process of the pattern of lattice, it is first determined the cell of classification and the pattern of category cell, at such
Other unit is various arbitrarily to choose a cell to be configured as mode unit lattice, i.e., according to the list of its generic cell
First lattice pattern configures mode unit lattice, and then other in the locking category in addition to mode unit lattice need to configure this
The cell of pattern, call unit lattice pattern brush carries out pattern refreshing to other cells of the category, so that its of the category
The pattern of his cell is refreshed as pattern identical with the configured good pattern of mode unit lattice.Configuring a classification
Cell after, the cell of other classifications is configured according to same processing mode, until the cell of all categories is whole
Position is completed in configuration.
For operators, the configuration of this cell does not need matching manually for one cell of a cell
It sets, it is only necessary to which cell is classified to and determined according to preset business demand (such as tax declaration demand) cell of each classification
Pattern, each classification configures a mode unit lattice, so that it may which it is all to be automatically performed other according to the pattern of mode unit lattice
The configuration of cell.
More specifically, step S130 can be refined as two steps as shown in Figure 3 again:
S131: it is applied according to cell it needs to be determined that the simultaneously pattern of configuration mode cell.In business table, each class
Having a cell in other cell is mode unit lattice, to carry out batch refresh sample as the cell to the category
The template of formula.Met in table in king, how many class cell, with regard to how many mode unit lattice, it is necessary to configure one by one how much
A mode unit lattice.
S132: the pattern of class location lattice refreshes.According to the pattern of configured good mode unit lattice, batch refresh with should
Mode unit lattice belong to other all cells of a classification, so that it may realize the system of all cell styles of the category
Batch configuration.
In one particular embodiment of the present invention, to cell progress batch processing, detailed process is as follows.
Firstly, determining the cell an of classification and the pattern of category cell, arbitrarily selected in category cell
A fixed cell configures a kind of cell style (cell style of category cell) of needs as mode unit
Lattice, the cell style can include but is not limited to text style, background color, font, literal symbol, the character of the cell
Attribute, cell style and attribute information, specific configuration needs are depending on the specific needs of business table.Configure good model
After cell, call unit lattice pattern brush carries out pattern refreshing to other cells in category cell.
The effect that the above process is shown in operation interface is i.e. are as follows: the cell sample in Selection and call page top menu
Formula brush, while with the cell for choosing other in category cell to need to configure the pattern；Finally, by all units chosen
Lattice refresh all is at the pattern as mode unit lattice.
The batch configuration logic that the present embodiment provides includes structure design and implementation logic two parts.
In structure part is designed, the characteristics of the table of batch configuration cell as needed and batch configuration cell
It is required that defining pull-down menu, the gauge outfit of tables of data, field, relevant information, cell configuration information etc. respectively, specifically can wrap
It includes such as table of giving a definition:
1) tables of data gauge outfit defines table: for recording the gauge outfit data information of preservation business table.Such as: column name, col width, phase
The field informations such as, line number poor to column, columns, alignment thereof, format approach, EXCEL gauge outfit mapping method.
2) data sheet field defines table: for recording the field properties information of the specific data of preservation business table.Such as: field
Whether whether coding title, data type, field length, field precision, arrangement serial number, be sky, for filtering, being used for
The field informations such as access.
3) data table definitions table: for recording the related table identity information of preservation business table.Such as: table coding, title,
Whether version number table type, deactivates, arranges the field informations such as serial number.
4) data instance table: the declaration data information for being actually subjected to batch configuration cell is saved for recording.
5) pull-down menu, including being closed in cell style brush, cell span, data relationship, book relationship, table
System, table associated data, removes the function menus such as setting information at formula setting.
Realizing logical gate, i.e., in functions such as business interface setting unit lattice pattern brush, cell span, data relationships
Menu due to the present embodiment simply to illustrate that the scheme logic of batch configuration cell, therefore does not do in detail its function here
It describes in detail bright.The cell style brush can trigger system for the pattern parameter to the cell of batch configuration according to mode unit lattice
(text style, background color, font, literal symbol, character attibute, cell style and the attribute information of such as cell) system
One carries out the refresh configuration of cell style.
The interface operation process of above-mentioned realization logic is as shown in Figure 4:
Step S410: determining the cell of a classification and arbitrarily chooses a cell as mode unit wherein
Lattice configure cell style required for category cell for the mode unit lattice；
Step S420: cell style brush button is clicked；
Step S430: pinning ctrl key, while other in being put one by one with mouse need to configure the cell of the pattern；
Step S440: pressing enter enter key, i.e., call unit lattice pattern brush by all cells for choosing all brush at
The same pattern of mode unit lattice.
By with embodiment can be seen that no matter business table how many cell, as long as having divided classification, so that it may logical
Cross in the cell of each classification one mode unit lattice of configuration, so by call unit lattice Format Painter to the category its
Remaining cell carries out unified refresh process.That is, only needing to configure a cell in each classification, it can pass through
Such cell style refreshes the unified configuration for realizing such cell, can not only solve the complicated work of cell configuration
Make, provides configuration work efficiency and configuration data accuracy, additionally it is possible to configuration error rate be effectively reduced.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process
Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
Embodiment 2
It corresponds to the above method, the present invention also provides a kind of table batch processing system, Fig. 5 is shown according to the present invention
The logical construction of the table batch processing system of embodiment.
As shown in figure 5, table batch processing system 500 provided by the invention, including table configuration unit 510, cell
Taxon 520 and cell configuration unit 530.Wherein,
Table configuration unit 510, for generating the business table of corresponding format, the traffic table according to preset business demand
Lattice are made of multiple cells.Since the format of business table can be because of the difference of table source, the specific business information being related to etc.
And it is different, therefore, before carrying out batch processing to table, need in advance according to preset business demand configuration service table
Format；The business table is made of multiple cells, i.e., business table includes the various contents of a project requirement for meeting business needs
Cell, to realize the frequently-used data statistical demand of service related data；
Cell taxon 520, for carrying out the identification of pattern parameter to the cell in business table, and according to identification
Pattern parameter out classifies to the cell of business table, and the pattern parameter of the cell of each classification is identical；It is therein
Pattern parameter includes at least text style, background color, font, literal symbol, character attibute, cell style and attribute letter
Breath.
Cell configuration unit 530, the pattern of the cell for configuring each classification according to preset business demand；Its
In, to the cell of each classification, it is only necessary to arbitrarily determine one of as mode list in multiple cells of the category
First lattice carry out corresponding cell style configuration, and for the remaining element lattice in the category, call unit lattice Format Painter is according to mould
The pattern of formula cell carries out unified refresh configuration.
In the embodiment shown in fig. 5, cell taxon 520 further comprises 521 He of pattern parameter extraction unit
Sort out unit 522, for pattern parameter extraction unit 521 therein for being scanned to the cell in business table, extracting should
The pattern parameter of cell；Sort out unit 522 for sorting out to the identical cell of pattern parameter, such as according to extracted
Pattern parameter judges in preset classification group with the presence or absence of pattern parameter cell group identical with extracted pattern parameter,
If it is present the cell is categorized in the cell group；If it does not exist, then creating sample in the classification group
Formula parameter cell group identical with extracted pattern parameter, and the cell is categorized in newly-built cell group.
In addition, cell configuration unit 530 further comprises mode unit lattice configuration unit 531 and pattern refresh unit
532。
Wherein, mode unit lattice configuration unit 531 is used to be applied according to cell it needs to be determined that simultaneously configuration mode cell
Pattern, mode unit lattice are the template that the remaining element lattice of class where the mode unit lattice are carried out with batch refresh pattern.
That is, having a cell in business table, in the cell of each classification is mode unit lattice, to as right
The template of cell progress batch refresh pattern.
In business table, how many class cell, with regard to how many mode unit lattice, it is necessary to configure how many one by one
Cell.
Pattern refresh unit 532 is used for pattern call unit lattice Format Painter batch refresh and the mould according to mode unit lattice
Formula cell belongs to other all cells of a classification, to realize the unified batch of all cell styles of the category
Configuration.
The table batch processing system that the above embodiment of the present invention provides, configuration and homogeneous unit by mode unit lattice
The pattern brush of lattice operates, and realizes the unified configuration of a kind of cell, is able to solve the complicated work of cell configuration, provides and match
Working efficiency and configuration data accuracy are set, configuration error rate is reduced.
Embodiment 3
Fig. 6 is the schematic diagram for the electronic device logical construction that one embodiment of the invention provides.As shown in fig. 6, the embodiment
Electronic device 600 include processor 610, memory 620 and being stored in memory 620 and being transported on processor 610
Capable computer program 621.Processor 610 realizes table batch processing method in embodiment 1 when executing computer program 621
Each step, such as step S110 to S130 shown in FIG. 1.Alternatively, being realized when 610 executive table batch processing method of processor
The function of each module/unit in above-mentioned each Installation practice, such as table configuration unit 510 shown in fig. 5, cell grouping sheet
Member 520 and cell configuration unit 530.
Computer program 621 includes table configurator, cell sort program and cell configurator.Wherein, table
When lattice configurator is executed by processor 610, the business table of corresponding format, the industry can be generated according to preset business demand
Business table is made of multiple cells；It, can be to the unit in business table when cell sort program is executed by processor 610
Lattice carry out the identification of pattern parameter, and are classified according to the pattern parameter identified to the cell of business table, each classification
Cell pattern parameter it is identical；It, can be according to preset business demand when cell configurator is executed by processor 610
Configure the pattern of the cell of each classification；Wherein, to the cell of each classification, it is only necessary to arbitrarily determine the multiple of the category
It is one of as the corresponding cell style configuration of mode unit lattice progress in cell, for remaining list in the category
First lattice, call unit lattice Format Painter carry out unified refresh configuration according to the pattern of mode unit lattice.
Corresponding, cell sort program further comprises pattern parameter extraction program and sorting process, pattern therein
When parameter extraction program is executed by processor 610, the cell in business table can be scanned, extract the cell
Pattern parameter；Sorting process can sort out the identical cell of pattern parameter when being executed by processor 610, as according to institute
The pattern parameter of extraction judges in preset classification group with the presence or absence of pattern parameter unit identical with extracted pattern parameter
Lattice group, if it is present the cell is categorized in the cell group；If it does not exist, then in the classification group
Newly-built pattern parameter cell group identical with extracted pattern parameter, and the cell is categorized in newly-built cell
In group.
Cell configurator further comprises mode unit lattice configurator and pattern refurbishing procedure.Wherein, mode list
When first lattice configurator is executed by processor 610, it can determine and configuration mode cell, mode unit lattice are to the mode
The remaining element lattice of class carry out the template of batch refresh pattern where cell；When pattern refurbishing procedure is executed by processor 610,
A classification can be belonged to according to the pattern call unit lattice Format Painter batch refresh and the mode unit lattice of mode unit lattice
Other all cells.
Illustratively, computer program 621 can be divided into one or more module/units, one or more mould
Block/unit is stored in memory 620, and is executed by processor 610, to complete the present invention.One or more module/units
It can be the series of computation machine program instruction section that can complete specific function, the instruction segment is for describing computer program 621
Implementation procedure in electronic device 600.For example, computer program 620 can be divided into embodiment 2: table configuration
Unit 510, cell taxon 520 and cell configuration unit 530, function has a detailed description in example 2,
It will not repeat them here.
Electronic device 600 can be desktop PC, notebook, palm PC and cloud server etc. and calculate equipment.
Electronic device 600 may include, but be not limited only to, processor 610, memory 620.It will be understood by those skilled in the art that Fig. 6 is only
It is only the example of electronic device 600, does not constitute the restriction to electronic device 600, may include more more or fewer than illustrating
Component perhaps combines certain components or different components, such as electronic device can also include input-output equipment, network
Access device, bus etc..
Processor 610 can be central processing unit (Central Processing Unit, CPU), can also be other
General processor, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor
Deng.
Memory 620 can be the internal storage unit of electronic device 600, such as the hard disk or memory of electronic device 600.
Memory 620 is also possible to the plug-in type hard disk being equipped on the External memory equipment of electronic device 600, such as electronic device 600,
Intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card, flash card (Flash
Card) etc..Further, memory 620 can also both including electronic device 600 internal storage unit and also including external storage
Equipment.Memory 620 is for storing other programs and data needed for computer program and electronic equipment.Memory 620 is also
It can be used for temporarily storing the data that has exported or will export.
Embodiment 4
The present embodiment provides a computer readable storage medium, computer journey is stored on the computer readable storage medium
Sequence realizes table batch processing method in embodiment 1, to avoid repeating, here not when the computer program is executed by processor
It repeats again.Alternatively, realized when the computer program is executed by processor in embodiment 2 each module in table batch processing system/
The function of unit.Exemplary illustration has been done to the computer program in above-described embodiment 3, it is no longer superfluous here to avoid repeating
It states.
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each function
Can unit, module division progress for example, in practical application, can according to need and by above-mentioned function distribution by different
Functional unit, module are completed, i.e., the internal structure of device are divided into different functional unit or module, to complete above description
All or part of function.Each functional unit in embodiment, module can integrate in one processing unit, be also possible to
Each unit physically exists alone, and can also be integrated in one unit with two or more units, above-mentioned integrated unit
Both it can take the form of hardware realization, can also realize in the form of software functional units.In addition, each functional unit, mould
The specific name of block is also only for convenience of distinguishing each other, the protection scope being not intended to limit this application.It is single in above system
Member, the specific work process of module, can refer to corresponding processes in the foregoing method embodiment, details are not described herein.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, is not described in detail or remembers in some embodiment
The part of load may refer to the associated description of other embodiments.
The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although with reference to the foregoing embodiments
Invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each implementation
Technical solution documented by example is modified or equivalent replacement of some of the technical features；And these modification or
Replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all include
Within protection scope of the present invention.
Claims (10)
1. a kind of table batch processing method is applied to electronic device, which comprises the steps of:
S110: the business table of corresponding format is generated according to preset business demand, the business table includes cell；
S120: the identification of pattern parameter is carried out to the cell in the business table, and according to the pattern parameter identified to institute
The cell for stating business table is classified, and the pattern parameter of the cell of each classification is identical；
S130: the pattern of the cell of each classification is configured according to pre-set business demand；Wherein, to the cell of each classification,
One of them arbitrarily determined in multiple cells of the category carries out corresponding cell style configuration as mode unit lattice,
And unify the remaining element lattice in the refresh configuration category according to the pattern call unit lattice Format Painter of the mode unit lattice.
2. table batch processing method according to claim 1, which is characterized in that
The pattern parameter include at least text style, background color, font, literal symbol, character attibute, cell style and
Attribute information.
3. data form batch processing method according to claim 1, which is characterized in that the step S120 is further wrapped
It includes:
S121: being scanned the cell in the business table, extracts the pattern parameter of the cell；
S122: the identical cell of pattern parameter is sorted out.
4. data form batch processing method according to claim 3, which is characterized in that the step S122 is further wrapped
It includes:
According to extracted pattern parameter, judge in preset classification group with the presence or absence of pattern parameter and extracted pattern parameter
Identical cell group, if it is present the cell is categorized in the cell group；If it does not exist, then institute
It states and creates pattern parameter cell group identical with extracted pattern parameter in classification group, and the cell is categorized in newly
In the cell group built.
5. table batch processing method according to claim 1, which is characterized in that the step S130 further comprises:
S131: determining and configuration mode cell, and the mode unit lattice are remaining list to class where the mode unit lattice
First lattice carry out the template of batch refresh pattern；
S132: the pattern of class location lattice refreshes, and is brushed according to the pattern call unit lattice Format Painter batch of the mode unit lattice
Other all cells of a classification are newly belonged to the mode unit lattice.
6. a kind of table batch processing system characterized by comprising
Table configuration unit, for generating the business table of corresponding format, the business table packet according to preset business demand
Include cell；
Cell taxon, for carrying out the identification of pattern parameter to the cell in the business table, and according to identifying
Pattern parameter classify to the cell of the business table, the pattern parameter of the cell of each classification is identical；
Cell configuration unit, the pattern of the cell for configuring each classification according to preset business demand；Wherein, to every
The cell of a classification arbitrarily determines one of corresponding as the progress of mode unit lattice in multiple cells of the category
Cell style configuration, and unify in the refresh configuration category according to the pattern call unit lattice Format Painter of the mode unit lattice
Remaining element lattice.
7. a kind of electronic device, the electronic device include: memory, processor and storage in the memory and can be in institute
State the computer program run on processor, which is characterized in that the processor is realized when executing the computer program as weighed
Benefit require any one of 1 to 5 described in table batch processing method the step of.
8. electronic device as claimed in claim 7, which is characterized in that the computer program includes:
Table configurator generates the traffic table of corresponding format according to preset business demand when for being executed by the processor
Lattice, the business table includes cell；
Cell sort program carries out pattern parameter to the cell in the business table when for being executed by the processor
Identification, and classified according to the pattern parameter identified to the cell of business table, the pattern of the cell of each classification
Parameter is identical；
Cell configurator configures the unit of each classification according to preset business demand when for being executed by the processor
The pattern of lattice；Wherein, to the cell of each classification, one of them in multiple cells of the category is arbitrarily determined as mould
Formula cell, and unify according to the pattern call unit lattice Format Painter of the mode unit lattice remaining in the refresh configuration category
Cell.
9. electronic device as claimed in claim 8, which is characterized in that the cell configurator further comprises:
Mode unit lattice configurator, for determining that simultaneously configuration mode cell, the mode unit lattice are to the mode list
The remaining element lattice of class carry out the template of batch refresh pattern where first lattice；
Pattern refurbishing procedure, for the pattern call unit lattice Format Painter batch refresh and the mode according to the mode unit lattice
Cell belongs to other all cells of a classification.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists
In realization table batch processing method as described in any one of claims 1 to 5 when the computer program is executed by processor
The step of.
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 (2)
| 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 |
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 (3)
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110287459B (en) | 2023-12-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8799854B2 (en) | Reusing software development assets | |
| CN105243582B (en) | XBRL accounting softwares standard data interface system and method based on financial cloud | |
| CN108734561B (en) | Electronic device, order data processing method, and computer-readable storage medium | |
| CN109472568A (en) | A kind of block chain method of commerce, device, management system, equipment and storage medium | |
| US20200019541A1 (en) | Querying and projecting values within sets in a table dataset | |
| CN110287459A (en) | Table batch processing method, system, device and can storage medium | |
| CN110765101A (en) | Label generation method and device, computer readable storage medium and server | |
| CN103077192A (en) | Data processing method and system thereof | |
| Intayoad et al. | Applying process mining in manufacturing and logistic for large transaction data | |
| Tamym et al. | A big data based architecture for collaborative networks: Supply chains mixed-network | |
| US9639587B2 (en) | Social network analyzer | |
| CN201435074Y (en) | Device for generating test case based on member | |
| CN113888064A (en) | Product quality tracing method, device and equipment in food and beverage industry | |
| CN104182226B (en) | A kind of General Mobile information system adaptation method and device | |
| CN108829668A (en) | Generation method, device, computer equipment and the storage medium of text information | |
| CN114327374A (en) | Business process generation method and device and computer equipment | |
| CN114443779A (en) | Data resource management method and system based on data directory | |
| CN110266555A (en) | Method for analyzing web site service request | |
| CN109376344A (en) | The generation method and terminal device of list | |
| CN108874384A (en) | Terminal device, server, web data processing method and computer storage medium | |
| Savdur et al. | Stream modeling of an online store based on modified petri nets in consumer cooperation | |
| Al-Shoqran et al. | A review on Industry 4.0 management for sustainable technologies | |
| CN107301211B (en) | Online data processing method | |
| CN109582411A (en) | Graphical user interface creating method, device, computer equipment and storage medium | |
| Klijn et al. | Aggregating event knowledge graphs for task analysis |
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 |