CN109857998A - A kind of intelligence generates the method and device of EXCEL table - Google Patents

A kind of intelligence generates the method and device of EXCEL table Download PDF

Info

Publication number
CN109857998A
CN109857998A CN201711235152.XA CN201711235152A CN109857998A CN 109857998 A CN109857998 A CN 109857998A CN 201711235152 A CN201711235152 A CN 201711235152A CN 109857998 A CN109857998 A CN 109857998A
Authority
CN
China
Prior art keywords
configuration information
information
column
gauge outfit
cell
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201711235152.XA
Other languages
Chinese (zh)
Inventor
张思文
苗辉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xiamen Baishan Hard Science & Technology Co Ltd
Original Assignee
Xiamen Baishan Hard Science & Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Xiamen Baishan Hard Science & Technology Co Ltd filed Critical Xiamen Baishan Hard Science & Technology Co Ltd
Priority to CN201711235152.XA priority Critical patent/CN109857998A/en
Publication of CN109857998A publication Critical patent/CN109857998A/en
Pending legal-status Critical Current

Links

Abstract

Disclosed herein is the method and devices that a kind of intelligence generates EXCEL table, and the method includes: acquisition prime information and gauge outfit configuration information, the gauge outfit configuration information include the name identification sequencing information of each column;Identical information in the column of each name identification is clustered, the sequence of each name identification is set according to the name identification sequencing information, the prime information after cluster is added to corresponding column, generates EXCEL table.The present invention can provide intelligent and simple and rapid EXCEL list processing deriving method, and quickly and effectively data are polymerize and arranged, and viewer is made to obtain better sensory experience.

Description

A kind of intelligence generates the method and device of EXCEL table
Technical field
The present invention relates to the method and devices that Internet technical field more particularly to a kind of intelligence generate EXCEL table.
Background technique
In Web development field, it will usually use HyperText Preprocessor (Hypertext Preprocessor, abbreviation ) etc. PHP the scripting language of open sources carries out writing exploitation, and php language can more quickly perform Dynamic Networks than CGI or Perl etc. Page, and execution efficiency is much higher than the CGI for generating HTML markup completely.
During carrying out web exploitation using php, it usually needs processing and the data arranged needed for downloading are allowed into For readability and the EXCEL table of clear logic.
The tool of generation EXCEL usually uses the phpEXCEL work under the phpoffice of open source under existing php environment Tool, phpoffice can support the function on the basis EXCEL, function to support including the metadata in editor's table, addition work Table/row/column, Merge Cells, operation formula etc., the EXCEL that can be preferably compatible in MS office, but under the prior art PhpEXCEL is difficult to solve there are still problem:
1) phpEXCEL is the data in processing table based on coordinate locating for table for the positioning of source data in table When, need to position each cell location for needing to modify, it is cumbersome;
2) phpEXCEL only supports simple cell span, can not carry out intelligent merging according to demand, need to research and develop Personnel carry out secondary artificial treatment;
3) process that phpEXCEL become privileged processing to cell style is cumbersome, and derived list is coarse and practicability It is low;
4) phpEXCEL needs individually to export single sheet, step is numerous when needing to carry out multiple sheet export It is trivial;
5) when derived data volume is very big, phpEXCEL can very big committed memory to there is performance bottleneck, cause to lead The slow inefficiency of process out;
In the case where list or data become increasingly complex, the format and content automatically generated is increasingly unable to satisfy research and development The demand of personnel.How intellectualized reconstruction is carried out to the EXCEL table of generation, makes more easy, easily configures and function is strong Big statistics summarizes tool as critical issue.
Summary of the invention
In order to solve the above-mentioned technical problems, the present invention provides the method and devices that a kind of intelligence generates EXCEL table.
The method that intelligence provided by the invention generates EXCEL table, comprising:
It obtains prime information and gauge outfit configuration information, gauge outfit configuration information includes the name identification sequencing information of each column;
Identical information in the column of each name identification is clustered, each title mark is arranged according to name identification sequencing information Prime information after cluster is added to corresponding column, generates EXCEL table by the sequence of knowledge.
Further, the method that above-mentioned intelligence generates EXCEL table also has the following characteristics that
It further include the merging configuration information of each column in gauge outfit configuration information;
Method further include: when merging instruction including identical content cell in merging configuration information, by the original after cluster Information is added to after corresponding column the sequential cells lattice in same column with identical content carrying out cell span.
Further, the method that above-mentioned intelligence generates EXCEL table also has the following characteristics that
It further include the merging configuration information of each column in gauge outfit configuration information;
Method further include: when in merging configuration information including the instruction of designated position cell span, by the original after cluster Information is added to the cell span of the designated position after corresponding column in instruction.
Further, the method that above-mentioned intelligence generates EXCEL table also has the following characteristics that
It further include the readjustment configuration information of each column in gauge outfit configuration information;
Method further include: when including the call back function of specified content cell in adjusting back configuration information, after cluster Prime information calls corresponding return according to readjustment configuration information after being added to corresponding column when the content of cell is specified content Letter of transfer number.
Further, the method that above-mentioned intelligence generates EXCEL table also has the following characteristics that
It further include the style configuration information of each column in gauge outfit configuration information;
Method further include: in style configuration information include permutation cell style configuration information when, after cluster Prime information is added to after corresponding column and the cell of respective column is carried out style configuration according to style configuration information.
Intelligence provided by the invention generates the device of EXCEL table, comprising:
Module is obtained, is set as obtaining prime information and gauge outfit configuration information, gauge outfit configuration information includes the title mark of each column Know sequencing information;
Cluster module is set as clustering the identical information in the column of each name identification;
Sorting module is set as that the sequence of each name identification is arranged according to name identification sequencing information;
Generation module is set as the prime information after cluster being added in corresponding column, generates EXCEL table.
Further, the device that above-mentioned intelligence generates EXCEL table also has the following characteristics that
It further include the merging configuration information of each column in gauge outfit configuration information;
Generation module further includes resolution unit and processing unit;
Resolution unit is set as the information of parsing gauge outfit configuration information;
Processing unit, be set as resolution unit parse further include in gauge outfit configuration information each column merging configuration information And when merging in configuration information including the merging instruction of identical content cell, the prime information after cluster is added to corresponding column The sequential cells lattice in same column with identical content are subjected to cell span afterwards.
Further, the device that above-mentioned intelligence generates EXCEL table also has the following characteristics that
It further include the merging configuration information of each column in gauge outfit configuration information;
Generation module further includes resolution unit and processing unit;
Resolution unit is set as the information of parsing gauge outfit configuration information;
Processing unit, being set as parsing in gauge outfit configuration information in resolution unit further includes merging configuration information and closing And when in configuration information including the instruction of designated position cell span, referring to after the prime information after cluster is added to corresponding column The cell span of designated position in order.
Further, the device that above-mentioned intelligence generates EXCEL table also has the following characteristics that
It further include the readjustment configuration information of each column in gauge outfit configuration information;
Generation module further includes resolution unit and processing unit;
Resolution unit is set as the information of parsing gauge outfit configuration information;
Processing unit, being set as parsing in gauge outfit configuration information in resolution unit further includes adjusting back configuration information and returning Adjust in configuration information includes that the prime information after cluster is added to root after arranging accordingly when specifying the call back function of content cell Corresponding call back function is called when the content of cell is specified content according to readjustment configuration information.
Further, the device that above-mentioned intelligence generates EXCEL table also has the following characteristics that
It further include the style configuration information of each column in gauge outfit configuration information;
Generation module further includes resolution unit and processing unit;
Resolution unit is set as the information of parsing gauge outfit configuration information;
Processing unit, be set as resolution unit parse further include in gauge outfit configuration information each column style configuration information And when including the style configuration information of permutation cell in style configuration information, the prime information after cluster is added to accordingly The cell of respective column is subjected to style configuration according to style configuration information after column.
The present invention can provide intelligent and simple and rapid EXCEL list processing deriving method, quickly and effectively to data into Row polymerization and arrangement, make viewer obtain better sensory experience.
Detailed description of the invention
The attached drawing for constituting a part of the invention is used to provide further understanding of the present invention, schematic reality of the invention It applies example and its explanation is used to explain the present invention, do not constitute improper limitations of the present invention.In the accompanying drawings:
Fig. 1 is the flow chart that the method for EXCEL table is intelligently generated in embodiment.
Fig. 2 is the device figure for the method that EXCEL table is intelligently generated in embodiment.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is A part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art Every other embodiment obtained without making creative work, shall fall within the protection scope of the present invention.It needs Illustrate, in the absence of conflict, the features in the embodiments and the embodiments of the present application can mutual any combination.
Fig. 1 is the flow chart that the method for EXCEL table is intelligently generated in embodiment, and the method includes:
Step 1, prime information and gauge outfit configuration information are obtained, gauge outfit configuration information includes the name identification sequence letter of each column Breath;
Step 2, the identical information in the column of each name identification is clustered, is arranged according to name identification sequencing information each Prime information after cluster is added to corresponding column, generates EXCEL table by the sequence of name identification.
Citing: prime information is as shown in table 1:
Great Qu It saves Operator Data
Northeast Telecommunications-Jilin Telecommunications X1
Northeast Telecommunications-Liaoning Telecommunications X2
Northeast Telecommunications-Heilungkiang Telecommunications X3
East China Telecommunications-Jiangxi Telecommunications X4
South China Connection-Hainan Connection Y1
East China Telecommunications-Shandong Telecommunications X5
Central China Telecommunications-Henan Telecommunications X6
South China Connection-Guangdong Connection Y2
Central China Telecommunications-Hubei Telecommunications X7
The name identification sequencing information respectively arranged in gauge outfit configuration information are as follows: operator, great Qu, province, data.
After the above method, the EXCEL table of generation is table 2:
In one embodiment, further include the merging configuration information of each column in gauge outfit configuration information, match confidence merging When including that identical content cell merges instruction in breath, will have in same column after the prime information after cluster is added to corresponding column The sequential cells lattice of identical content carry out cell span.
For example, obtaining table 3 after handling table 1 when including that permutation merges instruction with content in merging configuration information:
When merging, the preferential cell for merging written data, then to the cell of data is not written according to position Sequencing merges.
After this processing, multi-level sub-trees pattern is presented in the list automatically generated, the table after automatically generating cluster Meanwhile viewer is set to obtain better sensory experience compared to table 2.
The name identification sequence respectively arranged in gauge outfit configuration information are as follows: when great Qu, operator, province, data, by above-mentioned place The result of reason is table 4:
In one embodiment, further include the merging configuration information of each column in gauge outfit configuration information, match confidence merging When including cell span instruction in designated position in breath, the prime information after cluster is added to the finger after corresponding column in instruction Position the cell span set.
For example, include all cell spans to the column for being identified as operator in merging configuration information, it is big to being identified as The first of area is to third cell span, the 4th to the 5th cell span, the 6th to the 7th cell span.To table 1 handled after obtain table 3.
It in another embodiment, further include the readjustment configuration information of each column in this method, in gauge outfit configuration information, Adjust back in configuration information includes when specifying the call back function of content cell, after the prime information after cluster is added to corresponding column Corresponding call back function is called when the content of cell is specified content according to readjustment configuration information.This call back function can be The function of Merge Cells.The merging of cell is completed by way of calling call back function.
Further include the style configuration information of each column in this method, in gauge outfit configuration information, includes in style configuration information When the style configuration information of permutation cell, the prime information after cluster is added to will according to style configuration information after corresponding column The cell of respective column carries out style configuration.It wherein, include: cell width, font color, font alignment side in style configuration Pattern is arranged in the cells such as formula, cell color filling.
In this method, further include generate EXCEL table be it is multiple when, can be used for multiple times increase list (addSheet) function The export of multiple workspaces can be created, can disposably export all lists.
In this method, the data volume of EXCEL table is obtained, when this data volume is greater than preset threshold, exports non-EXCEL format Data, this non-EXCEL format can be CSV format.
Fig. 2 is the structure chart for the device that intelligence generates EXCEL table, this device includes:
Acquisition module is set as obtaining prime information and gauge outfit configuration information, gauge outfit configuration information include the name identification of each column Sequencing information;
Cluster module is set as clustering the identical information in the column of each name identification;
Sorting module is set as that the sequence of each name identification is arranged according to name identification sequencing information;
Generation module is set as the prime information after cluster being added in corresponding column, generates EXCEL table.
Wherein,
Generation module further includes resolution unit and processing unit.Resolution unit is set as the letter of parsing gauge outfit configuration information Breath.
It further include the merging configuration information of each column in gauge outfit configuration information;Processing unit is set as parsing in resolution unit Further include the merging configuration information of each column in gauge outfit configuration information and merges in configuration information including the conjunction of identical content cell And when instructing, the prime information after cluster is added to after corresponding column and carries out the sequential cells lattice in same column with identical content Cell span.
It further include the merging configuration information of each column in gauge outfit configuration information;Processing unit is set as parsing in resolution unit It further include merging configuration information and merging in configuration information to instruct including designated position cell span in gauge outfit configuration information When, the prime information after cluster is added to the cell span of the designated position after corresponding column in instruction.
It further include the readjustment configuration information of each column in gauge outfit configuration information;Processing unit is set as parsing in resolution unit It further include the readjustment letter adjusting back configuration information and adjusting back including specified content cell in configuration information in gauge outfit configuration information When number, it is specified content that the prime information after cluster, which is added to after corresponding column according to content of the configuration information in cell is adjusted back, When call corresponding call back function.
It further include the style configuration information of each column in gauge outfit configuration information;Processing unit is set as parsing in resolution unit It further include the pattern in the style configuration information of each column and style configuration information including permutation cell in gauge outfit configuration information When configuration information, by the prime information after cluster be added to after corresponding column according to style configuration information by the cell of respective column into Row style configuration.
The present invention is write by php language, and exploitation code amount is low, can be realized the intelligent regeneration to phpEXCEL, is made It is run with that component can be added at any time during phpEXCEL, not increase other deployments operation, facilitate research and development to greatest extent The use of personnel.
The present invention can provide intelligent and simple and rapid EXCEL list processing deriving method, quickly and effectively to data into Row polymerization and arrangement, make viewer obtain better sensory experience.
Descriptions above can combine implementation individually or in various ways, and these variants all exist Within protection scope of the present invention.
Those of ordinary skill in the art will appreciate that all or part of the steps in the above method can be instructed by program Related hardware is completed, and program can store in computer readable storage medium, such as read-only memory, disk or CD.It can One or more integrated circuits can be used also to realize in selection of land, all or part of the steps of above-described embodiment, correspondingly, above-mentioned Each module/unit in embodiment can take the form of hardware realization, can also be realized in the form of software function module. The present invention is not limited to the combinations of the hardware and software of any particular form.
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-row His property includes, so that including the article of a series of elements or equipment not only includes those elements, but also including not having There is the other element being expressly recited, or further includes for this article or the intrinsic element of equipment.Do not limiting more In the case where system, the element that is limited by sentence " including ... ", it is not excluded that in the article or equipment for including the element There is also other identical elements.
The above examples are only used to illustrate the technical scheme of the present invention and are not limiting, reference only to preferred embodiment to this hair It is bright to be described in detail.Those skilled in the art should understand that can modify to technical solution of the present invention Or equivalent replacement should all cover in claim model of the invention without departing from the spirit and scope of the technical solution of the present invention In enclosing.

Claims (10)

1. a kind of method that intelligence generates EXCEL table characterized by comprising
It obtains prime information and gauge outfit configuration information, the gauge outfit configuration information includes the name identification sequencing information of each column;
Identical information in the column of each name identification is clustered, each title mark is arranged according to the name identification sequencing information Prime information after cluster is added to corresponding column, generates EXCEL table by the sequence of knowledge.
2. the method that intelligence as described in claim 1 generates EXCEL table, which is characterized in that
It further include the merging configuration information of each column in the gauge outfit configuration information;
The method also includes: when merging instruction including identical content cell in the merging configuration information, after cluster Prime information be added to after corresponding column the sequential cells lattice in same column with identical content be subjected to cell span.
3. the method that intelligence as described in claim 1 generates EXCEL table, which is characterized in that
It further include the merging configuration information of each column in the gauge outfit configuration information;
The method also includes: when in the merging configuration information including the instruction of designated position cell span, after cluster Prime information be added to the cell span of the designated position after corresponding column in the instruction.
4. the method that intelligence as described in claim 1 generates EXCEL table, which is characterized in that
It further include the readjustment configuration information of each column in the gauge outfit configuration information;
The method also includes: in the call back function adjusted back including specified content cell in configuration information, will cluster Prime information afterwards is added to after corresponding column and adjusts back configuration information calling when the content of cell is specified content according to described Corresponding call back function.
5. the method that intelligence as described in claim 1 generates EXCEL table, which is characterized in that
It further include the style configuration information of each column in the gauge outfit configuration information;
The method also includes: in the style configuration information include permutation cell style configuration information when, will cluster Prime information afterwards is added to after corresponding column and the cell of respective column is carried out style configuration according to style configuration information.
6. the device that a kind of intelligence generates EXCEL table characterized by comprising
Module is obtained, is set as obtaining prime information and gauge outfit configuration information, the gauge outfit configuration information includes the title mark of each column Know sequencing information;
Cluster module is set as clustering the identical information in the column of each name identification;
Sorting module is set as that the sequence of each name identification is arranged according to the name identification sequencing information;
Generation module is set as the prime information after cluster being added in corresponding column, generates EXCEL table.
7. the device that intelligence as claimed in claim 6 generates EXCEL table, which is characterized in that
It further include the merging configuration information of each column in the gauge outfit configuration information;
The generation module further includes resolution unit and processing unit;
The resolution unit is set as parsing the information of the gauge outfit configuration information;
The processing unit, be set as the resolution unit parse further include in the gauge outfit configuration information each column merging When including that identical content cell merges instruction in configuration information and the merging configuration information, the prime information after cluster is added It adds to after corresponding column and the sequential cells lattice in same column with identical content is subjected to cell span.
8. the device that intelligence as claimed in claim 6 generates EXCEL table, which is characterized in that
It further include the merging configuration information of each column in the gauge outfit configuration information;
The generation module further includes resolution unit and processing unit;
The resolution unit is set as parsing the information of the gauge outfit configuration information;
The processing unit, being set as parsing in the gauge outfit configuration information in the resolution unit further includes merging with confidence When ceasing and including the instruction of designated position cell span in the merging configuration information, the prime information after cluster is added to phase The cell span of designated position after the column answered in the instruction.
9. the device that intelligence as claimed in claim 6 generates EXCEL table, which is characterized in that
It further include the readjustment configuration information of each column in the gauge outfit configuration information;
The generation module further includes resolution unit and processing unit;
The resolution unit is set as parsing the information of the gauge outfit configuration information;
The processing unit, being set as parsing in the gauge outfit configuration information in the resolution unit further includes readjustment with confidence When ceasing and including the call back function of specified content cell in the readjustment configuration information, the prime information after cluster is added to Corresponding call back function is called when the content of cell is specified content according to the readjustment configuration information after corresponding column.
10. the device that intelligence as claimed in claim 6 generates EXCEL table, which is characterized in that
It further include the style configuration information of each column in the gauge outfit configuration information;
The generation module further includes resolution unit and processing unit;
The resolution unit is set as parsing the information of the gauge outfit configuration information;
The processing unit, be set as the resolution unit parse further include in the gauge outfit configuration information each column pattern When including the style configuration information of permutation cell in configuration information and the style configuration information, by the prime information after cluster It is added to after corresponding column and the cell of respective column is subjected to style configuration according to style configuration information.
CN201711235152.XA 2017-11-30 2017-11-30 A kind of intelligence generates the method and device of EXCEL table Pending CN109857998A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711235152.XA CN109857998A (en) 2017-11-30 2017-11-30 A kind of intelligence generates the method and device of EXCEL table

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711235152.XA CN109857998A (en) 2017-11-30 2017-11-30 A kind of intelligence generates the method and device of EXCEL table

Publications (1)

Publication Number Publication Date
CN109857998A true CN109857998A (en) 2019-06-07

Family

ID=66887950

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711235152.XA Pending CN109857998A (en) 2017-11-30 2017-11-30 A kind of intelligence generates the method and device of EXCEL table

Country Status (1)

Country Link
CN (1) CN109857998A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120030555A1 (en) * 2010-07-30 2012-02-02 Kevin Scott system and method for providing dynamic normalization of terminal source excel files
CN103257959A (en) * 2012-02-15 2013-08-21 深圳市金蝶友商电子商务服务有限公司 Method and device for generating spreadsheet report
CN104714949A (en) * 2013-12-11 2015-06-17 航天信息股份有限公司 Method for customizing report dynamically
CN105573765A (en) * 2015-12-29 2016-05-11 武汉传神信息技术有限公司 Implementation method for dynamic form, client and server

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120030555A1 (en) * 2010-07-30 2012-02-02 Kevin Scott system and method for providing dynamic normalization of terminal source excel files
CN103257959A (en) * 2012-02-15 2013-08-21 深圳市金蝶友商电子商务服务有限公司 Method and device for generating spreadsheet report
CN104714949A (en) * 2013-12-11 2015-06-17 航天信息股份有限公司 Method for customizing report dynamically
CN105573765A (en) * 2015-12-29 2016-05-11 武汉传神信息技术有限公司 Implementation method for dynamic form, client and server

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
李文瑞等: "《VBA/Excel 2000让我把工作变轻松了》", 北京:高等教育出版社, pages: 290 *

Similar Documents

Publication Publication Date Title
CN110096689A (en) Template type legal documents information fill method and device
CN102981941B (en) A kind of alert processing method and alarm treatment device
CN102663103A (en) Configurable method for automatically generating database and accessing data
CN106528006A (en) Page printing method and device
CN105701165B (en) Browser model switching method and switching device
EP2831717A1 (en) System and method of hierarchical data containers
CN102799574A (en) Data partitioning and merging method for electronic forms
CN105468571B (en) It is a kind of for automatically generating the method and device of report
CN104636400A (en) Browser webpage generating method, browser and system
CN105068812A (en) Form generation method and device
CN109002560A (en) Document deriving method, device, computer equipment and computer readable storage medium
CN105278961B (en) Generate the method and system of database table structure document
CN106293669A (en) A kind of generation method and apparatus of web pages component
CN107908747A (en) A kind of page generation method and device
CN104657123B (en) A kind of method of dynamic export
CN107403110A (en) HDFS data desensitization method and device
CN103123646B (en) XML document is converted into automatically conversion method and the device of OWL document
CN102253986A (en) Method and device for improving webpage displaying effect in multiple terminals
CN110007919A (en) A kind of dynamic density screen adaptation method and system for the automatic airport of unmanned plane
CN109857998A (en) A kind of intelligence generates the method and device of EXCEL table
CN110134468A (en) Text box method for adjusting and device
CN106776275B (en) A kind of testing process automatic generation method based on Packet Multiplexing
CN105468570B (en) A kind of document synthesis methods of exhibiting and device
CN104793837A (en) Picture generation method and device
CN110083845A (en) Web page translation method and system

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20190607