CN109388612A - A kind of method, equipment, system and the medium of data summarization document structure tree - Google Patents
A kind of method, equipment, system and the medium of data summarization document structure tree Download PDFInfo
- Publication number
- CN109388612A CN109388612A CN201811073238.1A CN201811073238A CN109388612A CN 109388612 A CN109388612 A CN 109388612A CN 201811073238 A CN201811073238 A CN 201811073238A CN 109388612 A CN109388612 A CN 109388612A
- Authority
- CN
- China
- Prior art keywords
- data
- document
- filled
- filling
- xml file
- 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
Classifications
-
- 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/186—Templates
Abstract
The disclosure provides a kind of document structure tree method, comprising: establishes document template, label has each one-to-one filling position of data to be filled in the document template；XML file is established, record has data storage index, data filling index and data calculation formula in the XML file；XML file is obtained, index is stored according to data and obtains data to be filled, filling data are treated according to data calculation formula and are calculated, is filled and is indexed according to data, the data to be filled after calculating are filled into document template, generate destination document.This method greatly improves the timeliness and normalization of document structure tree work, reduces cost of human resources.The disclosure also provides a kind of electronic equipment of document structure tree, a kind of document creating system and a kind of computer-readable medium.
Description
Technical field
This disclosure relates to data statistics field more particularly to a kind of method of data summarization document structure tree, equipment, system and
Medium.
Background technique
In the daily work, enterprises and institutions can constantly generate largely data summarization document relevant to business, these are all
It is to be obtained according to certain business rule by complicated calculating and analysis based on the basic data in enterprises and institutions' database.
In order to more intuitively show the data in work, part enterprises and institutions require to be changed into the data in row, column more intentionally
The figure of justice, so that policymaker quickly has found new phenomenon or rule from mass data.Unit same for different times
Proprietary data summarize document, although not having big variation substantially in format and pattern, need in specific time
The many and diverse data of magnanimity carry out collect statistics.Currently, most enterprises are all by special messenger using artificial enquiry, manually recorded side
Formula summarizes data, calculated and is edited, and not only working efficiency is low, but also also very big a possibility that bring mistake, therefore, such as
What quickly, specification, comprehensively obtain a proprietary data and summarize document, have become constituent parts problem in the urgent need to address.
In recent years, there are many researchs also automatically generated both at home and abroad about document, such as based on workflow engine, to document
Necessary operation and document template in generating process are defined to realize the automatic of certain complicated calculations in electric power manufacturing enterprise
Change；In conjunction with Visual Basic for Applications (VBA), ActiveX Data Objects (ADO) and Active
The multiple technologies such as Server Pages (ASP), establish document template database, and design is suitable for satellite hot control system design documentation
Document template Customization Tool and document automatic Generation Platform.
The studies above achievement is all based on staff mostly and is manually entered content at runtime, or by simple meter
Formula the data obtained is calculated, the label editted in advance in template is replaced, so that document needed for generating, service logic are more simple
It is single, it cannot achieve the complex operations step such as drafting of chart in relatively complicated logic calculation and document.In addition, existing
Document auto-generating method usable condition is very single, can not solve automatically generating for Word and Excel format file simultaneously and ask
Topic.
Summary of the invention
In view of the deficiencies in the prior art, the disclosure proposes a kind of method of data summarization document structure tree, equipment, is
System and medium, it is single for solving the data summarization document automatic creation method scope of application in the prior art, it can not carry out cumbersome
Logic calculation and document in icon drafting the problems such as.
The disclosure provides a kind of data summarization document structure tree method, comprising: establishes document template；XML file is established, it should
Record has data storage index, data filling index and data calculation formula in XML file；XML file is obtained, is deposited according to data
Storage index obtains data to be filled, treats filling data according to data calculation formula and is calculated, is filled and indexed according to data, will
Data to be filled after calculating are filled into document template, and destination document is generated.
Optionally, document template is established, comprising: establish blank document；It is marked in the blank document each wait fill out
The filling position for evidence of making up the number generates the document template.
Optionally, XML file is established, comprising: the storage location for obtaining each data to be filled obtains the data storage
Index, and the XML file is written；The data calculation formula of the data to be filled is edited, and the XML file is written；It obtains
The filling position for taking each data to be filled obtains the data filling index, and the XML file is written.
Optionally, it is filled and is indexed according to the data, the data to be filled after the calculating are filled to the document mould
In plate, destination document is generated, comprising: call replacement function that the data to be filled after the calculating are filled into the document template
In the corresponding filling position of the data to be filled.
Optionally, index is stored according to the data and obtain data to be filled, treated and filled out according to the data calculation formula
It makes up the number according to being calculated, comprising: obtained according to the sequence of the filling index of data described in the XML file and described in calculating wait fill out
It makes up the number evidence, and records the quantity of reduced data filling index.
Optionally, it is filled and is indexed according to the data, the data to be filled after the calculating are filled to the document mould
In plate, destination document is generated, further includes: judge that the data to be filled are according to the quantity of reduced data filling index
No filling is completed, if filling is completed, directly exports the destination document, if filling does not complete, repetitive operation S3 is to being not filled by
Data handled.
Optionally, the filling position that each data to be filled are marked in the blank document, utilizes bookmark or ranks
Label marks the filling position of each data to be filled in the blank document.
Another aspect of the present disclosure provides a kind of electronic equipment of data summarization document structure tree, comprising: processor；Storage
Device is stored with computer executable program, and the program by the processor when being executed, so that the processor is executed such as this
Disclosed document automatic creation method.
Another aspect of the present disclosure also provides a kind of data summarization document creating system, comprising: and document template establishes module,
For establishing document template, label has each one-to-one filling position of data to be filled in the document template；XML file
Module is established, for establishing XML file, record has data storage index, data filling index and data to calculate in the XML file
Formula；Data processing module stores index according to data and obtains data to be filled, calculated according to data for obtaining XML file
Formula is treated filling data and is calculated, and is filled and is indexed according to data, the data to be filled after calculating are filled to the document
In template, destination document is generated.
Another aspect of the present disclosure also provides a kind of computer-readable medium, is stored thereon with computer program, feature
It is, the document structure tree method such as the disclosure is realized when which is executed by processor.
Detailed description of the invention
In order to which the disclosure and its advantage is more fully understood, referring now to being described below in conjunction with attached drawing, in which:
Fig. 1 diagrammatically illustrates the schematic diagram of embodiment of the present disclosure data summarization document structure tree method.
Fig. 2 diagrammatically illustrates the flow chart of the data summarization document structure tree method according to the embodiment of the present disclosure.
Fig. 3 diagrammatically illustrates the XML file schematic diagram according to the embodiment of the present disclosure.
Fig. 4 diagrammatically illustrates the gyrounit temperature variation curve schematic diagram according to the embodiment of the present disclosure.
Fig. 5 diagrammatically illustrates the block diagram of the electronic equipment of the data summarization document structure tree according to the embodiment of the present disclosure.
Fig. 6 diagrammatically illustrates the block diagram of the data summarization document creating system according to the embodiment of the present disclosure.
Specific embodiment
Hereinafter, will be described with reference to the accompanying drawings embodiment of the disclosure.However, it should be understood that these descriptions are only exemplary
, and it is not intended to limit the scope of the present disclosure.In the following detailed description, to elaborate many specific thin convenient for explaining
Section is to provide the comprehensive understanding to the embodiment of the present disclosure.It may be evident, however, that one or more embodiments are not having these specific thin
It can also be carried out in the case where section.In addition, in the following description, descriptions of well-known structures and technologies are omitted, to avoid
Unnecessarily obscure the concept of the disclosure.
Term as used herein is not intended to limit the disclosure just for the sake of description specific embodiment.It uses herein
The terms "include", "comprise" etc. show the presence of the feature, step, operation and/or component, but it is not excluded that in the presence of
Or add other one or more features, step, operation or component.
Shown in the drawings of some block diagrams and/or flow chart.It should be understood that some sides in block diagram and/or flow chart
Frame or combinations thereof can be realized by computer program instructions.These computer program instructions can be supplied to general purpose computer,
The processor of special purpose computer or other programmable data processing units, so that these instructions are when executed by this processor can be with
Creation is for realizing function/operation device illustrated in these block diagrams and/or flow chart.Therefore, the technology of the disclosure
It can be realized in the form of hardware and/or software (including firmware, microcode etc.).
Fig. 1 diagrammatically illustrates the schematic diagram of the data summarization document structure tree method of the embodiment of the present disclosure.
As shown in Figure 1, basic principle are as follows: firstly, according to different types of data to be filled to the scope of a variable in document into
Line flag generates document template, wherein each type of data are identified with corresponding filling, each data have therewith
Corresponding filling position；Then, document descriptive model is established, converts a mathematical model for the process of document structure tree, according to
The formulation of the document descriptive model can expand markup language (Extensible Markup Language, XML) file, XML text
Required key message when record has the data of filling document template scope of a variable in part, whens subsequent calculating data, need to use this
A little key messages, these key messages include that user needs Business Name corresponding to the data that count, English mark, inquiry letter
Breath (data query index), chart title, filling mark (data filling index) and data calculation formula etc.；Finally, to
Family needs the data counted to be solved, specifically reading XML file, and data to be filled are obtained according to query information, according to
Calculation formula is treated filling data and is calculated, and identifies further according to filling, calls replacement function that the result of calculating is filled into text
The corresponding scope of a variable of the data after having summarized data, needs to judge whether all need to generate destination document in shelves template
The data to be counted all are recorded in destination document, if it is not, obtaining the number to be filled not counted according to query information
It is calculated according to and to it, the result of calculating is filled into the scope of a variable in document template, until statistics completes all data.
Identical comprising content in the destination document of above-mentioned generation, format, pattern are consistent with format, and the area that position is fixed
Domain is constant field, and the region other than constant field is scope of a variable, and scope of a variable is used to fill user and needs the data that count, constant field with
Data in scope of a variable are also possible to picture either text, and data type included by scope of a variable can be summarized as it is following
Six seed types:
1) data directly acquired are defined as including the data for being inputted by user or being directly read from external file
Direct Data；
2) by database retrieval the data obtained, it is defined as Database Data；
3) it is based on Direct Data combination business formula computed information, is defined as Calculated Data；
4) Database Data/Calculated Data is reused, combined data library searching and business formula are integrated
Computed information is defined as Complicated Data；
5) increase decline class text, such as increase/reduction, rise/fall etc. are defined as Trend Word；
6) chart for reacting data variation trend within the scope of certain time, it is fixed in conjunction with the data that business formula is calculated
Justice is Chart.
It is not intended that being this six kinds of data types in destination document, it can be a kind of data in one embodiment,
It is also possible to a variety of data, specific introduction is done to the process of data summarization document structure tree below.
Fig. 2 diagrammatically illustrate the disclosure it is real apply a flow chart for data summarization document structure tree method.
As shown in Fig. 2, specific method includes:
S1 establishes document template.
In aforesaid operations S1, blank document is established, constant field and scope of a variable are divided, according to six seed types of above-mentioned conclusion
Data need the data in the destination document that counts to classify user, according to each data to be filled in blank document
Scope of a variable be marked, retain the constant field in the blank document, document template generated, in subsequent operation, by data
The scope of a variable being filled into document template is to generate destination document.
Wherein, the variable domain identifier and each data one-to-one correspondence to be filled scope of a variable being marked, such root
The data that data to be filled after computation can be accurately filled into the type in document template according to this corresponding relationship are corresponding
Filling position.
Wherein, the format of the document of label selects according to the demand of user, because of the constant field of documents in various formats and change
Measure domain position it is different, can not unified definition, but when a kind of document template of format generation after, the data of this kind of formats
Summarizing document can be automatically generated using the document template of this format.For example, the document template for being Word for format, this
Embodiment uses mark of the bookmark function as scope of a variable, to solve the navigation problem of scope of a variable, in the position of each band filling
It is inserted into corresponding bookmark, the position where quickly navigating to.The document module for being Excel for format, the present embodiment is using row
Unique identification of the column label as each data position, the position of scope of a variable where in marking document.
S2 establishes XML file, and record has data storage index, data filling index and data to calculate public in the XML file
Formula.
In aforesaid operations S2, in order to facilitate the calculating of data during data summarization document structure tree, a text need to be established
Shelves descriptive model, automatically generates this process for data summarization document and is converted into a mathematical model, by document template, document mould
The mark to scope of a variable in plate, destination document and the data type being related to are stated with mathematic sign and language, then
According to this mathematical model of foundation, an XML file, key needed for record filling document template generates destination document are write
Information, these key messages include data storage index (such as the storage location of data to be filled, the i.e. data in what title
Library field inquires data to be filled inside the database list of what title), data calculation formula (needs to be filled
Data make what kind of calculate) and data filling index (data to be filled after the completion of processing need to be filled into document template
Label which position, i.e., the mark of scope of a variable in document template) etc. information, i.e. XML file is equivalent to mating with document template
Secondary file, play the role of index.In this way during follow-up data summarizes, according to XML file record index relative,
Different data are directed to, corresponding calculation formula and function is matched final data is filled into document template and generate target
Document.
For the aggregation process of the data of above-mentioned six seed type, the document descriptive model of foundation can are as follows:
1) document template is abstracted as a binary group T (C, K), wherein C is the constant field part in document template, and K is text
Mark (bookmark or ranks label) part in shelves template, the value of K is a hexa-atomic group of K={ K1,K2…,Kn, K=< αK,
βK,γK,δK,μK,σK>, in formula, αK,βK,γK,δK,μK,σKRespectively represent six kinds of element (Direct of destination document scope of a variable
Data, Database Data, Calculated Data, Complicated Data, Trend Word, Chart) in document mould
Corresponding variable domain identifier in plate, i.e. data filling index.
2) destination document is a binary group D (C, V), wherein C is constant field part in document, and V is to become in destination document
Measure final value of the domain under given input condition.The final value of V is a hexa-atomic group of V={ V1,V2…,Vn, V=< αV,
βV,γV,δV,μV,σV>, α in formulaV,βV,γV,δV,μV,σVRespectively represent six dvielement included in scope of a variable.
According to the document descriptive model of above-mentioned foundation, the redaction rule of XML file information is formulated, wherein in order to calculate
The type of data is judged in the process, and the data filling index (label of root element) in XML file is document template scope of a variable mark
Know.The specific write-in rule of XML file inner element is as follows:
1) Direct Data: Business Name and unique English mark；
2) Database Data: Business Name, unique English mark, and the Database field and list that need to inquire
Information；
3) Calculated Data: Business Name, the calculation formula of unique English mark and the data；
4) Complicated Data: the query information or calculating of Business Name, unique English mark and the data
Formula；
5) Trend Word: Business Name, unique English mark and referenced data English mark；
6) Chart: the self-defined informations such as chart title, data source and reference axis and title.
By taking " holding of certain position of certain satellite " as an example, XML file example is as shown in figure 3, for example, Business Name is ignition point
The corresponding data filling index of semi-major axis is σK_1, then judge the data type of the data for Database Data, English mark
For FIREAXIS, the Database field of inquiry is Axis_Fire, and the form information of inquiry is Sys_Dictionary, according to this
A little information can accurately inquire the numerical value of ignition point semi-major axis from database.
S3 obtains XML file, stores index according to data and obtains data to be filled, is treated and filled out according to data calculation formula
It makes up the number according to being calculated, and is filled and indexed according to data, the data to be filled after calculating are filled into document template, generate mesh
Mark document.
In aforesaid operations S3, reads the data that the key message recorded in XML file counts needs and handle, have
Body is shown in steps are as follows:
S301 judges whether data type to be filled is Direct Data, if it is, calling replacement function will
Direct Data is filled into α in document templateKThe scope of a variable of mark, calculation formula are as follows:
RSα=R (αV,αK)
α in formulaVRepresent the Direct Data, α directly readKRepresent Direct Data corresponding mark in document template
Know；If it is not, then continuing to calculate in next step.
S302 judges whether data type to be filled is Database Data, if it is, calling formula RDB=Q
(CN, TN, F) obtains required data by database retrieval, and CN represents Database field title in formula, and TN represents database table
Single-character given name claims, and F represents the screening conditions such as selection criteria, such as date-time (data directly acquired).Then replacement function is used
The Database Data of acquisition is filled into document template βKThe scope of a variable of mark, calculation formula are as follows:
RSβ=R (RDB,βK)
R in formulaDBRepresent the Database Data, β obtained by database retrievalKDatabase Data is represented in text
Corresponding mark in shelves template；If it is not, then continuing in next step.
With β shown in Fig. 3K_1For, need to calculate " the ignition point that certain position of certain satellite on January 12 in 2016 is kept
Semi-major axis " calls following formula first:
RDB=Q (' Axis_Fire ', ' Sys_Dictionary ', ' 2016-1-12 ')
It obtains executing database structure query statement (Structured Query Language, SQL): " select
Axis_Fire from Sys_Dictonary where Date=to_date (' 2016-01-12 ', ' YYYY-MM-DD ') "
Data FireAxis (the i.e. β in destination document inquiredVThe corresponding data of categorical variable), then call RSβ=R (RDB,βK_1)
Replace the β in document templateK-1Corresponding satellite igniting thirty long axis.
S303 judges whether data type to be filled is Calculated Data, if so, firstly the need of weight is obtained
Direct Data, is then calculated γVThe corresponding Calculated Data of categorical variable, and by Calculated
Data is filled into γKThe scalar domain of mark, specific formula for calculation are as follows:
RSγ=C (VF, RSα,γK)
VF represents variable formula needed for solution obtains Calculated Data, RS in formulaαRepresent the data reused
Direct Data, γKRepresent Calculated Data corresponding mark in document template；If it is not, then continuing next
Step.
With γ shown in Fig. 3K_1For, it needs to calculate " pulse period that certain position is kept ", it is public to obtain required calculating
Formula simultaneously searches the data for needing to reuse, and the data for needing to reuse at this time are pulse frequency, then calculate the pulse period, and pulse is all
Phase is filled into γ in document templateK_1The scope of a variable of mark, specific formula for calculation are as follows:
RSγ=C (' 1/MCPL ', ' 0.4 ', γK_1)
Variable formula needed for ' 1/MCPL ' represents solution pulse period MCZQ in formula, what ' 0.4 ' representative had directly acquired
The numerical value (i.e. Direct Data) of pulse frequency MCPL, γK_1Represent pulse period corresponding mark in document template.
S304 judges whether data type to be filled is Complicated Data, needs weight if so, obtaining first
Data Direct Data/Calculated Data, and determine whether all Direct Data/Calculated Data
It has been be acquired that, handled if it is not, repeating S302 and S303, until all data have been disposed, then passed through
Be calculated Complicated Data to Direct Data/Calculated Data, and by Complicated
Data filling tape data δ in document templateKThe scope of a variable of mark, specific formula is as follows:
RSδ=C (VF, RSβ||RSγ,δK)
Variable formula needed for VF represents solution Complicated Data in formula, RSβ||RSγRepresent the number for needing to reuse
According to Direct Data/Calculated Data, δKRepresent Complicated Data corresponding mark in document template；Such as
Fruit is not then to continue in next step.
With δ shown in Fig. 3K_1For, it needs to calculate " variable of certain satellite position semi-major axis ", obtains igniting first
The value of point semi-major axis FireAxis and cut-off point semi-major axis CutAxis, and judge whether the two has all been acquired, if not provided,
It is then searched, and matched in XML file by the corresponding unique English mark symbol of ignition point semi-major axis and cut-off point semi-major axis
Corresponding derivation algorithm obtains the value of ignition point semi-major axis FireAxis and cut-off point semi-major axis CutAxis, then obtains and calculates
The variable formula " FireAxis-CutAxis " of semi-major axis knots modification AxisChangeData, calculates semi-major axis knots modification, then
The result of calculating is filled into δ in document templateK_1The scope of a variable of mark, specific formula for calculation are as follows:
RSδ=C (' FireAxis-CutAxis ', ' 1200 | | 1300 ', δK_1)
Variable needed for ' FireAxis-CutAxis ' represents solution semi-major axis knots modification AxisChangeData in formula is public
Formula, ' 1200 ' represent the numerical value of the ignition point semi-major axis obtained, and ' 1300 ' represent the numerical value of the cut-off point semi-major axis obtained,
δK_1Represent semi-major axis knots modification AxisChangeData corresponding mark in document template.
S305 judges whether data type to be filled is Trend Data, if so, differentiating variation firstly the need of obtaining
The reference data of trend, and determine whether the reference data has been acquired, if it is not, repeating S302, S303 and S304
The reference data is got, then judges the positive and negative of the reference data, obtains the variation tendency class number for being referred to the reference data
According to Trend Data, specific formula for calculation is as follows:
RSμ=W (RSβ||RSγ||RSδ,μK)
RS in formulaβ||RSγ||RSδIt represents and solves data referenced by Trend Data, μKTrend Data is represented in document
Corresponding mark in template；If it is not, then continuing in next step.
With μ shown in Fig. 3K_1For, it needs to judge " certain satellite position semi-major axis is to increase or reduce ", obtains first
It takes semi-major axis knots modification AxisChangeData and judges whether AxisChangeData has obtained, if it is not, passing through
The unique English mark of AxisChangeDat variable is searched in configuration file, and matches corresponding derivation algorithm, obtains reference number
According to then obtaining Trend Data according to reference data, and Trend Data be filled into μ in document templateK_1The variable of mark
Domain, specific calculation formula are as follows:
RSμ=W (' -100 ', μK_1)
' -100 ' represent semi-major axis knots modification AxisChangeData, μ in formulaK_1Representing semi-major axis is to increase or reduce
The corresponding mark in document template.
S306, for Chart categorical data, first calling formula RDB=Q (CN, TN, F), is obtained by database retrieval
It draws a diagram required data source, CN represents the Database field title of inquiry in formula, and TN represents the database table single-character given name of inquiry
Claim, F represents the standard of inquiry, such as has directly acquired the screening conditions such as date-time, then, is drawn and is schemed using following formula
Table:
RSσ=(RDB,AI,σK)
R in formula Chinese styleDBRepresent the data source of chart, AI represents attribute information to be drawn a diagram (such as reference axis, title
With the self-defined informations such as legend), σKRepresent the chart corresponding mark in document template.
With σ shown in Fig. 3K_1For, need draw " gyrounit temperature variation curve ", firstly, call following formula into
Row database retrieval obtains data source:
RDB=Q (' TK16, TK22, TK23, TK24, TK25 ', ' Sys_Parameter ', ' 2016-01-12 ')
Above-mentioned formula is called to execute database SOL sentence " select TK16, TK22, TK23, TK24, TK25 from
Sys_Parameter where Time between to_TimeStamp (' 2016-01-12 00:00:00 ', ' YYYY-MM-
DD HH:mm:ss ') and to_TimeStamp (' 2016-01-13 00:00:00 ', ' YYYY-MM-DD HH:mm:ss ') " it returns
Return as a result, then, call formula RSσ=D (RDB,AI,σK_1) draw a diagram and the chart of drafting is filled into document template
σK_1Corresponding scope of a variable, drawing result are as shown in Figure 4.
Wherein, in operation S3, after the completion of data processing, need to judge data to be filled in document template whether all
It has been be disposed that, if being disposed, directly export destination document, if not being disposed, according to the method for operation S3
Unfinished data are handled, until user needs the data that count to handle completion, then export destination document again.
In addition, the definition for the method that above-mentioned document automatically generates is not limited in the specific formula or side mentioned in embodiment
Formula, those skilled in the art can to carrying out change or replacement simply, such as: element included by scope of a variable in destination document
If lacking a kind of or a few class data, the differentiation and solution of corresponding data type in operation S3 can be directly omitted, if target
The data marked in document only include Direct Data, then operation S302-S306 can be omitted.
In conclusion the present embodiment provides a kind of data summarization document structure tree method based on self-defined template, by right
The data type for needing to count in destination document carries out classification analysis, and corresponding document template and configuration file is specified to store rule
Then, the data of solution are filled into document template according to the key message that configuration file provides, convert spy for document template
The data summarization document of timing phase greatly improves the timeliness and normalization of document structure tree work.Meanwhile it can be according to not
Same functional requirement formulates the document template of the formats such as Word, Excel, manages data needed for grabbing, automatically generates destination document,
Reduce cost of human resources.
Present disclose provides a kind of electronic equipments of data summarization document structure tree, as shown in figure 5, the electronic equipment 500 wraps
Include processor 510 and memory 520.The method that the electronic equipment 500 can execute the embodiment of the present disclosure according to Fig.2,.
Specifically, processor 510 for example may include general purpose microprocessor, instruction set processor and/or related chip group
And/or special microprocessor (for example, specific integrated circuit (ASIC)) etc..Processor 510 can also include using for caching
The onboard storage device on way.Processor 510 can be the different movements for executing the method flow according to the embodiment of the present disclosure
Single treatment unit either multiple processing units.
Memory 520, such as can be the arbitrary medium can include, store, transmitting, propagating or transmitting instruction.For example,
Readable storage medium storing program for executing can include but is not limited to electricity, magnetic, optical, electromagnetic, infrared or semiconductor system, device, device or propagate Jie
Matter.The specific example of readable storage medium storing program for executing includes: magnetic memory apparatus, such as tape or hard disk (HDD)；Light storage device, such as CD
(CD-ROM)；Memory, such as random access memory (RAM) or flash memory；And/or wire/wireless communication link.
Memory 520 may include computer program 521, which may include that code/computer can be held
Row instruction, executes processor 510 according to the method for the embodiment of the present disclosure or its any change
Shape.
Computer program 521 can be configured to have the computer program code for example including computer program module.Example
Such as, in the exemplary embodiment, the code in computer program 521 may include at least one program module, for example including module
521A, module 521B ....It should be noted that the division mode and number of module are not fixation, those skilled in the art can
To be combined according to the actual situation using suitable program module or program module, when these program modules are combined by processor 510
When execution, processor 510 is executed according to the method for the embodiment of the present disclosure or its any deformation.
Fig. 6 diagrammatically illustrates the system block diagram of the data summarization document structure tree according to the embodiment of the present disclosure.
As shown in fig. 6, system 600 includes that document template establishes module 610, XML file establishes module 620 and destination document
Generation module 630.
Document template establishes module 610, and for establishing document template, in the document template, label, which has in XML file, remembers
The data filling of record indexes one-to-one filling position.
XML file establishes module 620, and for establishing XML file, record has data storage index, data in the XML file
Filling index and data calculation formula, data storage index obtain data to be filled for marking from what storage location, number
According to calculation formula for calculating the data to be filled of acquisition, data filling index will be to be filled after calculating for marking
In data filling tape document template where.
Destination document generation module 630 obtains XML file, stores index according to data and obtain for generating destination document
Data to be filled are treated filling data according to data calculation formula and are calculated, according to data filling index by after calculating to
Filling data are filled into the document template, and destination document is generated.
It should be appreciated that document template establishes module 610, XML file establishes module 620 and destination document generation module 630
It may be incorporated in a module and realize or any one module therein can be split into multiple modules.Alternatively, these
At least partly function of one or more modules in module can be combined at least partly function of other modules, and one
It is realized in a module.According to an embodiment of the invention, document template establishes module 610, XML file establishes module 620 and target
At least one of document creation module 630 can at least be implemented partly as hardware circuit, such as field-programmable gate array
Arrange (FPGA), programmable logic array (PLA), system on chip, the system on substrate, the system in encapsulation, specific integrated circuit
(ASIC), it or can be realized with carrying out the hardware such as any other rational method that is integrated or encapsulating or firmware to circuit, or
It is realized with software, the appropriately combined of hardware and firmware three kinds of implementations.Alternatively, document template establishes module 610, XML
File, which establishes at least one of module 620 and destination document generation module 630, can at least be implemented partly as computer
Program module can execute the function of corresponding module when the program is run by computer.
The disclosure additionally provides a kind of computer-readable medium, which, which can be in above-described embodiment, retouches
Included in the equipment/device/system stated；It is also possible to individualism, and without in the supplying equipment/device/system.On
It states computer-readable medium and carries one or more program, when said one or multiple programs are performed, realize root
According to the method for the embodiment of the present disclosure.
In accordance with an embodiment of the present disclosure, computer-readable medium can be computer-readable signal media or computer can
Read storage medium either the two any combination.Computer readable storage medium for example can be --- but it is unlimited
In system, device or the device of --- electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor, or any above combination.It calculates
The more specific example of machine readable storage medium storing program for executing can include but is not limited to: have the electrical connection, portable of one or more conducting wires
Formula computer disk, hard disk, random access storage device (RAM), read-only memory (ROM), erasable programmable read only memory
(EPROM or flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), light storage device, magnetic memory device or
The above-mentioned any appropriate combination of person.In the disclosure, computer readable storage medium can be it is any include or storage program
Tangible medium, which can be commanded execution system, device or device use or in connection.And in this public affairs
In opening, computer-readable signal media may include in a base band or as carrier wave a part propagate data-signal,
In carry computer-readable program code.The data-signal of this propagation can take various forms, including but not limited to
Electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be computer-readable
Any computer-readable medium other than storage medium, the computer-readable medium can send, propagate or transmit for by
Instruction execution system, device or device use or program in connection.The journey for including on computer-readable medium
Sequence code can transmit with any suitable medium, including but not limited to: wireless, wired, optical cable, radiofrequency signal etc., or
Above-mentioned any appropriate combination.
Although the disclosure, art technology has shown and described referring to the certain exemplary embodiments of the disclosure
Personnel it should be understood that in the case where the spirit and scope of the present disclosure limited without departing substantially from the following claims and their equivalents,
A variety of changes in form and details can be carried out to the disclosure.Therefore, the scope of the present disclosure should not necessarily be limited by above-described embodiment,
But should be not only determined by appended claims, also it is defined by the equivalent of appended claims.
Claims (10)
1. a kind of document structure tree method characterized by comprising
S1 establishes document template；
S2 establishes XML file, and record has data storage index, data calculation formula and data filling rope in the XML file
Draw；
S3 obtains the XML file, stores index according to the data and obtains data to be filled, is calculated according to the data public
Formula is treated filling data and is calculated, and is filled and is indexed according to the data, the data to be filled after the calculating are filled to institute
It states in document template, generates destination document.
2. document structure tree method according to claim 1, which is characterized in that in aforesaid operations S1, document template is established,
Include:
Establish blank document；
The filling position that each data to be filled are marked in the blank document, generates the document template.
3. document structure tree method according to claim 2, which is characterized in that in aforesaid operations S2, XML file is established,
Include:
The storage location for obtaining each data to be filled obtains the data storage index, and the XML file is written；
The data calculation formula of the data to be filled is edited, and the XML file is written；
The filling position for obtaining each data to be filled obtains the data filling index, and the XML file is written.
4. document structure tree method according to claim 1, which is characterized in that in aforesaid operations S3, according to the data
Filling index, the data to be filled after the calculating are filled into the document template, generate destination document, comprising:
It calls replacement function that the data to be filled after the calculating are filled into the data to be filled of this in the document template to correspond to
Filling position.
5. document structure tree method according to claim 1, which is characterized in that in aforesaid operations S3, according to the data
Storage index obtains data to be filled, treats filling data according to the data calculation formula and is calculated, comprising:
The data to be filled are obtained and calculated according to the sequence of the filling index of data described in the XML file, and are recorded
Handle the quantity of data filling index.
6. document structure tree method according to claim 5, which is characterized in that in aforesaid operations S3, according to the data
Filling index, the data to be filled after the calculating are filled into the document template, generate destination document, further includes:
Judge whether the data to be filled fill completion according to the quantity of reduced data filling index, if having filled
At, directly export the destination document, if filling do not complete, repetitive operation S3 handles unfilled data.
7. document structure tree method according to claim 2, which is characterized in that marked in the blank document it is each to
Fill the filling position of data, comprising:
The filling position of each data to be filled is marked in the blank document using bookmark or ranks label.
8. a kind of document structure tree electronic equipment, comprising:
Processor；
Memory is stored with computer executable program, and the program by the processor when being executed, so that the processor
It executes such as the document structure tree method in claim 1-7.
9. a kind of document creating system, which is characterized in that the document creating system includes:
Document template establishes module, and for establishing document template, label has each data to be filled one in the document template
One corresponding filling position；
XML file establishes module, and for establishing XML file, record has data storage index, data filling in the XML file
Index and data calculation formula；
Data processing module stores index according to the data and obtains data to be filled for obtaining the XML file, according to
Data calculation formula is treated filling data and is calculated, and is filled and is indexed according to the data, by the number to be filled after the calculating
According to filling into the document template, destination document is generated.
10. a kind of computer-readable medium, is stored thereon with computer program, which is characterized in that the program is executed by processor
Document structure tree method in Shi Shixian such as claim 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811073238.1A CN109388612B (en) | 2018-09-14 | 2018-09-14 | Method, equipment, system and medium for generating data summary document |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811073238.1A CN109388612B (en) | 2018-09-14 | 2018-09-14 | Method, equipment, system and medium for generating data summary document |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109388612A true CN109388612A (en) | 2019-02-26 |
| CN109388612B CN109388612B (en) | 2021-01-15 |
Family
ID=65418711
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811073238.1A Active CN109388612B (en) | 2018-09-14 | 2018-09-14 | Method, equipment, system and medium for generating data summary document |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109388612B (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109977385A (en) * | 2019-03-18 | 2019-07-05 | 合肥智慧联接科技有限公司 | A kind of data intelligence fill method, device, storage medium and terminal |
| CN110008461A (en) * | 2019-04-16 | 2019-07-12 | 北京中电普华信息技术有限公司 | Document structure tree method and relevant apparatus |
| CN110263221A (en) * | 2019-06-21 | 2019-09-20 | 福建南威软件有限公司 | A kind of method and system based on xml operation word document |
| CN110309496A (en) * | 2019-06-24 | 2019-10-08 | 招商局金融科技有限公司 | Data summarization method, electronic device and computer readable storage medium |
| CN110826297A (en) * | 2019-11-05 | 2020-02-21 | 北京锐安科技有限公司 | Data export method, device, equipment and storage medium |
| CN110866383A (en) * | 2019-10-15 | 2020-03-06 | 中国直升机设计研究所 | Interactive electronic data list generation method and system |
| CN110909520A (en) * | 2019-11-14 | 2020-03-24 | 北京天融信网络安全技术有限公司 | Document construction method and electronic equipment |
| CN111079388A (en) * | 2019-11-15 | 2020-04-28 | 中国水利水电第八工程局有限公司 | Method, system and medium for automatically generating river closure hydraulic calculation result of hydraulic and hydroelectric engineering |
| CN111159995A (en) * | 2020-01-16 | 2020-05-15 | 江西金格科技股份有限公司 | Method for generating word document in template mode |
| CN111581937A (en) * | 2020-05-15 | 2020-08-25 | 航天科工智慧产业发展有限公司 | Document generation method and device, computer readable medium and electronic equipment |
| CN111859899A (en) * | 2020-07-06 | 2020-10-30 | 合肥森亿智能科技有限公司 | Method, device, equipment and storage medium for parsing and filling Word document |
| CN112115694A (en) * | 2020-08-21 | 2020-12-22 | 江苏徐工工程机械研究院有限公司 | Simulation report generation method and device based on multi-element data structure |
| CN112560423A (en) * | 2020-12-22 | 2021-03-26 | 北京来也网络科技有限公司 | Document processing method, device, equipment and medium combining RPA and AI |
| CN112668041A (en) * | 2020-12-17 | 2021-04-16 | 平安消费金融有限公司 | Document file generation method and device, computer equipment and storage medium |
| CN112818655A (en) * | 2021-04-19 | 2021-05-18 | 中建电子商务有限责任公司 | Excel data processing method and tool based on template and file additional writing |
| CN113435175A (en) * | 2021-06-17 | 2021-09-24 | 长沙通诺信息科技有限责任公司 | Generation method and device of examination batch, terminal equipment and storage medium |
| CN114387369A (en) * | 2022-03-23 | 2022-04-22 | 湖北交投智能检测股份有限公司 | Automatic generation method and system for road water transport test detection graph |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650711A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Method for generating report |
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN101894115A (en) * | 2009-05-18 | 2010-11-24 | 北京大学 | Image data processing method of electronic document and device thereof |
| US20110066937A1 (en) * | 2009-09-17 | 2011-03-17 | International Business Machines Corporation | Method and system for handling non-presence of elements or attributes in semi-structured data |
| CN102156741A (en) * | 2011-04-16 | 2011-08-17 | 武钢集团昆明钢铁股份有限公司 | Custom dynamic report system and implementation method thereof |
-
2018
- 2018-09-14 CN CN201811073238.1A patent/CN109388612B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101894115A (en) * | 2009-05-18 | 2010-11-24 | 北京大学 | Image data processing method of electronic document and device thereof |
| CN101650711A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Method for generating report |
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| US20110066937A1 (en) * | 2009-09-17 | 2011-03-17 | International Business Machines Corporation | Method and system for handling non-presence of elements or attributes in semi-structured data |
| CN102156741A (en) * | 2011-04-16 | 2011-08-17 | 武钢集团昆明钢铁股份有限公司 | Custom dynamic report system and implementation method thereof |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109977385A (en) * | 2019-03-18 | 2019-07-05 | 合肥智慧联接科技有限公司 | A kind of data intelligence fill method, device, storage medium and terminal |
| CN109977385B (en) * | 2019-03-18 | 2023-04-25 | 合肥智慧联接科技有限公司 | Intelligent data filling method and device, storage medium and terminal |
| CN110008461A (en) * | 2019-04-16 | 2019-07-12 | 北京中电普华信息技术有限公司 | Document structure tree method and relevant apparatus |
| CN110263221A (en) * | 2019-06-21 | 2019-09-20 | 福建南威软件有限公司 | A kind of method and system based on xml operation word document |
| CN110309496A (en) * | 2019-06-24 | 2019-10-08 | 招商局金融科技有限公司 | Data summarization method, electronic device and computer readable storage medium |
| CN110309496B (en) * | 2019-06-24 | 2023-08-22 | 招商局金融科技有限公司 | Data summarizing method, electronic device and computer readable storage medium |
| CN110866383A (en) * | 2019-10-15 | 2020-03-06 | 中国直升机设计研究所 | Interactive electronic data list generation method and system |
| CN110866383B (en) * | 2019-10-15 | 2023-09-19 | 中国直升机设计研究所 | Interactive electronic data list generation method and system |
| CN110826297A (en) * | 2019-11-05 | 2020-02-21 | 北京锐安科技有限公司 | Data export method, device, equipment and storage medium |
| CN110909520A (en) * | 2019-11-14 | 2020-03-24 | 北京天融信网络安全技术有限公司 | Document construction method and electronic equipment |
| CN111079388A (en) * | 2019-11-15 | 2020-04-28 | 中国水利水电第八工程局有限公司 | Method, system and medium for automatically generating river closure hydraulic calculation result of hydraulic and hydroelectric engineering |
| CN111079388B (en) * | 2019-11-15 | 2023-06-09 | 中国水利水电第八工程局有限公司 | Automatic generation method, system and medium for river interception hydraulic calculation result of hydraulic and hydroelectric engineering |
| CN111159995A (en) * | 2020-01-16 | 2020-05-15 | 江西金格科技股份有限公司 | Method for generating word document in template mode |
| CN111581937A (en) * | 2020-05-15 | 2020-08-25 | 航天科工智慧产业发展有限公司 | Document generation method and device, computer readable medium and electronic equipment |
| CN111859899A (en) * | 2020-07-06 | 2020-10-30 | 合肥森亿智能科技有限公司 | Method, device, equipment and storage medium for parsing and filling Word document |
| CN112115694B (en) * | 2020-08-21 | 2023-07-04 | 江苏徐工工程机械研究院有限公司 | Simulation report generation method and device based on multi-element data structure |
| CN112115694A (en) * | 2020-08-21 | 2020-12-22 | 江苏徐工工程机械研究院有限公司 | Simulation report generation method and device based on multi-element data structure |
| CN112668041A (en) * | 2020-12-17 | 2021-04-16 | 平安消费金融有限公司 | Document file generation method and device, computer equipment and storage medium |
| CN112668041B (en) * | 2020-12-17 | 2023-07-04 | 平安消费金融有限公司 | Method and device for generating document file, computer equipment and storage medium |
| CN112560423A (en) * | 2020-12-22 | 2021-03-26 | 北京来也网络科技有限公司 | Document processing method, device, equipment and medium combining RPA and AI |
| CN112818655A (en) * | 2021-04-19 | 2021-05-18 | 中建电子商务有限责任公司 | Excel data processing method and tool based on template and file additional writing |
| CN113435175A (en) * | 2021-06-17 | 2021-09-24 | 长沙通诺信息科技有限责任公司 | Generation method and device of examination batch, terminal equipment and storage medium |
| CN114387369A (en) * | 2022-03-23 | 2022-04-22 | 湖北交投智能检测股份有限公司 | Automatic generation method and system for road water transport test detection graph |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109388612B (en) | 2021-01-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109388612A (en) | A kind of method, equipment, system and the medium of data summarization document structure tree | |
| CN113553420B (en) | Power grid fault processing rule recommendation method and system based on knowledge graph | |
| CN109241141A (en) | The training data treating method and apparatus of deep learning | |
| CN107958028A (en) | Method, apparatus, storage medium and the terminal of data acquisition | |
| CN110109896B (en) | UAV flight parameter intelligent reduction method | |
| US9910870B2 (en) | System and method for creating data models from complex raw log files | |
| CN106649239A (en) | Method and device for generating report in cloud monitoring system based on visualization | |
| US10891314B2 (en) | Detection and creation of appropriate row concept during automated model generation | |
| CN111078702A (en) | SQL sentence classification management and unified query method and device | |
| CN110196884A (en) | Method for writing data, storage medium and electronic equipment based on distributed data base | |
| CN112540975B (en) | Multi-source heterogeneous data quality detection method and system based on petri net | |
| CN112836018A (en) | Method and device for processing emergency plan | |
| US20160026708A1 (en) | Selection of data storage settings for an application | |
| CN110765750A (en) | Report data entry method and terminal equipment | |
| CN109284367A (en) | Method and apparatus for handling text | |
| CN112541692B (en) | Scientific data management plan generation method and device | |
| CN109145092A (en) | A kind of database update, intelligent answer management method, device and its equipment | |
| CN112241399B (en) | NoSQL-based PSD-BPA data analysis and management method and system | |
| CN108052637B (en) | Real-time image-text monitoring method for power grid time scale measurement data access full life cycle | |
| CN109871856B (en) | Method and device for optimizing training sample | |
| CN109190034A (en) | For obtaining the method and device of information | |
| CN111488437B (en) | Implementing unstructured content utilization from structured sources in answer questions systems | |
| CN111081327B (en) | Information processing method, information processing device, electronic equipment and computer readable medium | |
| CN109857818A (en) | Determine method, apparatus, storage medium and the electronic equipment of the relations of production | |
| Morocho et al. | Framework for Training a VA that Supports Territorial Planning |
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 |