CN108959221A - A kind of the electrical form deriving method and system in the electrical form export library based on open source - Google Patents
A kind of the electrical form deriving method and system in the electrical form export library based on open source Download PDFInfo
- Publication number
- CN108959221A CN108959221A CN201810564862.5A CN201810564862A CN108959221A CN 108959221 A CN108959221 A CN 108959221A CN 201810564862 A CN201810564862 A CN 201810564862A CN 108959221 A CN108959221 A CN 108959221A
- Authority
- CN
- China
- Prior art keywords
- open source
- electrical form
- variable
- data information
- information
- 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
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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Stored Programmes (AREA)
Abstract
The present invention relates to software technology fields, and in particular to a kind of the electrical form deriving method and system in the electrical form export library based on open source.Creation needs to generate the electronic form template of report；Pass through the electrical form rule file generator create-rule file of this programme；Template file and rule file are all placed in the project for needing to generate report；It calls the method in this programme to carry out data information integrated treatment and data information is filled into the corresponding statistical tables and reports of template file generation.By specific implementation step as above and system, irregular electronic form template report can be filled.
Description
Technical field
The present invention relates to software technology fields, and in particular to a kind of electrical form in the electrical form export library based on open source
Deriving method and system.
Background technique
Electrical form export can all use in many projects, and the form report export of current electrical form is main to be used
Open source electrical form export library come realize electrical form export function (NPOI is an open source operational group of electrical form
Part, it is on the basis of the open source electrical form of JAVA exports library for .NET (software of Microsoft is run and development platform) platform
Exploitation, hereinafter referred to as open source electrical form exports library).
Simple electronic report forms directly can be generated by writing code either using open source electrical form export library
NPOI is called to add data into template using the form of electronic report forms template.The template that can be realized at present using NPOI
Report export is all some simple templates, template content comparison rule, for the open source electrical form export of irregular template
Library is not very practical.
Summary of the invention
It is not very practical problem for the above irregular template open source electrical form export library, the present invention provides one kind
The electrical form deriving method and system in the electrical form export library based on open source, by first generating electronic form template, then
Software Create rule file is generated using rule file, electronic form template and the rule file of generation are all put into specified text
Under part folder, then imported data in template by integrated treatment.
The present invention is realized especially by following technical scheme:
A kind of electrical form deriving method in the electrical form export library based on open source, the method specifically include following step
It is rapid:
Step S10 obtains open source module data information；
Step S20, in conjunction with variable information, treats derived data information and is integrated according to open source module data information
Processing；
It is regular to treat derived data information, and produces corresponding template file by step S30；
Step S40 stores template file into specified file.
Further, before the step S10 further include:
Step S01 is determined and is obtained open source device source and open source component count, type；
Step S02, creation electrical form are maternal.
Further, among the step S20 further include:
Step S21, confirmation open source module data information；
Step S22 defines and confirms the variable information that editor is completed according to the open source module data information of confirmation；
Step S23 determines variable information position in electrical form female parent；
Step S24 is passed to variable information parameter, and data are filled in variable information position in table female parent.
Further, the variable information includes local variable, cell formats variable, table format variable, again
Multiple content format variable and the control program based on variable；
The control process control based on variable realizes that local variable, cell formats variable, table formatization become
Amount and the operation of duplicate contents formatted variable.
Further, described to treat derived data information regular, including by corresponding to incoming data source and table
Numerical value electron table female parent assignment.
In order to achieve the above objectives, the present invention also provides a kind of, and the electrical form based on open source exports the electrical form export in library
System, the system specifically include:
Open source module data information acquisition unit, for obtaining open source module data information；
Data information integrated treatment unit, in conjunction with variable information, treating derived according to open source module data information
Data information carries out integrated treatment；
Template file generation unit, it is regular for treating derived data information, and produce corresponding template file；
Template file storage element, for storing template file into specified file.
Further, the system also includes:
First confirmation module obtains open source device source and open source component count, type for determining；
Creation module, for creating electrical form female parent.
Further, the data information integrated treatment unit further include:
Second confirmation module, confirmation open source module data information；
Definition module defines and confirms the variable information that editor is completed according to the open source module data information of confirmation；
Third confirmation module determines variable information position in electrical form female parent；
Module is filled, variable information parameter is passed to, data are filled in variable information position in table female parent.
Compared with prior art, the invention has the following advantages:
The present invention can fill irregular electronic form template report by specific implementation step as above and system.Energy
Enough any one cells in electronic form template or across variable is filled in cell, then by local format device come
Local variable position in filling template.Variable can be filled in electronic form template cell, then by unit sound of laughing
Formula device comes the position of cell internal variable in filling template.Gauge outfit can be created in electronic form template, then in table
Content part, which fills, needs column variable to be used, then the corresponding position of adopting form formatter filling table variable.Energy
It is enough that the content template for needing to repeat display is created in electronic form template, after generating template XML file, then calls and repeat
Content in template style device populating electronic forms.
Detailed description of the invention
To describe the technical solutions in the embodiments of the present invention more clearly, make required in being described below to embodiment
Attached drawing is briefly described, it should be apparent that, drawings in the following description are only some embodiments of the invention, for
For those of ordinary skill in the art, without creative efforts, it can also be obtained according to these attached drawings other
Attached drawing.
Fig. 1 is the electrical form deriving method framework process signal that a kind of electrical form based on open source of the present invention exports library
Figure；
Fig. 2 is the electrical form deriving method step S10 side arm that a kind of electrical form based on open source of the present invention exports library
Structure flow diagram；
Fig. 3 is that a kind of electrical form based on open source of the present invention exports frame in the electrical form deriving method step S20 in library
Structure flow diagram；
Fig. 4 is the electrical form guiding system configuration diagram that a kind of electrical form based on open source of the present invention exports library；
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
Purposes, technical schemes and advantages to facilitate the understanding of the present invention are clearer, with reference to the accompanying drawing and have
The invention will be further described for the embodiment of body, and those skilled in the art can be by content disclosed in the present specification easily
Understand further advantage and effect of the invention.The present invention also can be implemented or be applied by other different specific examples, this
Every details in specification also can based on different viewpoints and application, carry out without departing from the spirit of the present invention various modifications with
Change.
It is to be appreciated that if relating to directionality instruction (such as up, down, left, right, before and after ...) in the embodiment of the present invention,
Then directionality instruction be only used for explain under a certain particular pose (as shown in the picture) between each component relative positional relationship,
Motion conditions etc., if the particular pose changes, directionality instruction is also correspondingly changed correspondingly.
In addition, being somebody's turn to do " first ", " second " etc. if relating to the description of " first ", " second " etc. in the embodiment of the present invention
Description be used for description purposes only, be not understood to indicate or imply its relative importance or implicitly indicate indicated skill
The quantity of art feature." first " is defined as a result, the feature of " second " can explicitly or implicitly include at least one spy
Sign.It in addition, the technical solution between each embodiment can be combined with each other, but must be with those of ordinary skill in the art's energy
It is enough realize based on, will be understood that the knot of this technical solution when conflicting or cannot achieve when occurs in the combination of technical solution
Conjunction is not present, also not the present invention claims protection scope within.
The present invention is to realize quickly to page feature operation, a kind of electricity in the electrical form export library based on open source provided
Sub-table deriving method and system, as shown in Figure 1, the method specifically includes step:
Step S10 obtains open source module data information；
Step S20, in conjunction with variable information, treats derived data information and is integrated according to open source module data information
Processing；
It is regular to treat derived data information, and produces corresponding template file by step S30；
Specifically, it is regular to treat derived data information, corresponding template XML file is generated by using Xml generator.
Step S40 stores template file into specified file.
Specifically, the pattern rule XML file of template file and generation is all put into the file specified in project, institute
Stating specified file and open source file components and electrical form female parent is same file folder, is stored in different
In file or in customized file.
Preferably, as shown in Fig. 2, before the step S10 further include:
Step S01 is determined and is obtained open source device source and open source component count, type；
Specifically, the electrical form export component for quoting open source in the project (can be downloaded or logical by open source website
Cross the developing instrument program expanding packet installation of Microsoft).
Step S02, creation electrical form are maternal.
Specifically, an electrical form female parent is created, in electrical form female parent, creation needs derived data information female
This content, can creating multiple variables in female parent, (mode of variable uses $ [variable name] indicates that wherein variable name cannot weigh
It is multiple), variable can be used alone to be placed in table female parent and use.
In embodiments of the present invention, as shown in figure 3, among the step S20 further include:
Step S21, confirmation open source module data information；
Step S22 defines and confirms the variable information that editor is completed according to the open source module data information of confirmation；
Step S23 determines variable information position in electrical form female parent；
Step S24 is passed to variable information parameter, and data are filled in variable information position in table female parent.
Preferably, the variable information includes local variable, cell formats variable, table format variable, repeats
Content format variable and control program based on variable；
The control process control based on variable realizes that local variable, cell formats variable, table formatization become
Amount and the operation of duplicate contents formatted variable.
Described to treat derived data information regular, including passing through numerical value electron corresponding to incoming data source and table
Table female parent assignment.
Specifically, in the present invention, variable information includes providing local format device, and local format device uses dollar mark ()
In addition bracket, define the title of local variable in bracket, local format device can across cell, across column either across
Row is ok.Local format device generates electronic form template XML file after editting spreadsheet report female parent, is generating
Electronic form template XML file in determined that the position of local variable.Electrical form mould can be read when use
Plate XML file is passed to local format device parameter, fills data in the position where local format variable.
The principle of cell formats device is with above, and after defining template, the definition cell in female parent
Formatter variable generates the maternal corresponding XML file of electrical form.Using when this programme be passed to need unit sound of laughing
Formula device parameter, so that it may the position where fills unit lattice formatter.
Table format device is realized by assembled unit lattice formatter.It is defined in electronics statistical tables and reports female parent first
Position where good table, defined in grid column each column variable (variable name using dollar mark () plus bracket, in
Write name variable to realize inside bracket), corresponding electronic form template XML text is then generated by electrical form female parent
Part.Using definition tables formatter parameter when this programme, pass through the column and column correspondence where incoming data source and table
Every a line of table for coming in electron form template of numerical value carry out assignment.
For the implementation of duplicate contents formatter as table format device, the effect only finally shown is different
Sample.
Present invention method operating process is specific as follows:
The electrical form export component for quoting open source in the project (can be by the downloading of open source website or by Microsoft
Developing instrument program expanding packet installation).
In electrical form female parent, creation needs derived data information female parent content, can create multiple changes in female parent
Amount (mode of variable uses $ [variable name] to indicate, wherein variable name cannot repeat), variable, which can be used alone, to be put
It is used in table female parent.
Corresponding template XML file is generated using Xml generator.
The pattern rule XML file of template file and generation is all put into the file specified in project.
The component export data for calling this programme to realize are into template file.
As shown in figure 4, the electrical form in the electrical form export library that the present invention also provides a kind of based on open source exports system
System, the system specifically include:
Open source module data information acquisition unit, for obtaining open source module data information；
Data information integrated treatment unit, in conjunction with variable information, treating derived according to open source module data information
Data information carries out integrated treatment；
Template file generation unit, it is regular for treating derived data information, and produce corresponding template file；
Template file storage element, for storing template file into specified file.
The system also includes:
First confirmation module obtains open source device source and open source component count, type for determining；
Creation module, for creating electrical form female parent.
The data information integrated treatment unit further include:
Second confirmation module, confirmation open source module data information；
Definition module defines and confirms the variable information that editor is completed according to the open source module data information of confirmation；
Third confirmation module determines variable information position in electrical form female parent；
Module is filled, variable information parameter is passed to, data are filled in variable information position in table female parent.
The present invention obtains open source module data information by open source module data information acquisition unit；Data information General Office
Unit is managed according to open source module data information, in conjunction with variable information, derived data information is treated and carries out integrated treatment；Template text
It is regular to treat derived data information, and produces corresponding template file for part generation unit；Template file storage element, by mould
Plate file storage can fill irregular electronic form template report into specified file.
Preferably, provide the function of local format device, can in electronic form template any one cell or
Across variable is filled in cell, then by local format device come the local variable position in filling template.
Cell formats device is provided, variable can be filled in electronic form template cell, then passes through cell
Formatter comes the position of cell internal variable in filling template.
Table format device is provided, gauge outfit can be created in electronic form template, is then filled in table content part
Column variable to be used is needed well, then the corresponding position of adopting form formatter filling table variable.
Duplicate contents formatter is provided, the interior molar for needing to repeat display can be created in electronic form template
Plate after generating template XML file, then calls the content repeated in template style device populating electronic forms.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously
Limitations on the scope of the patent of the present invention therefore cannot be interpreted as.It should be pointed out that for those of ordinary skill in the art
For, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to guarantor of the invention
Protect range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (8)
1. a kind of electrical form deriving method in the electrical form export library based on open source, which is characterized in that the method includes
Step:
Step S10 obtains open source module data information；
Step S20, in conjunction with variable information, treats derived data information and carries out integrated treatment according to open source module data information；
It is regular to treat derived data information, and produces corresponding template file by step S30；
Step S40 stores template file into specified file.
2. a kind of electrical form deriving method in the electrical form export library based on open source according to claim 1, feature
It is, before the step S10 further include:
Step S01 is determined and is obtained open source device source and open source component count, type；
Step S02, creation electrical form are maternal.
3. a kind of electrical form deriving method in the electrical form export library based on open source according to claim 1, feature
It is, among the step S20 further include:
Step S21, confirmation open source module data information；
Step S22 defines and confirms the variable information that editor is completed according to the open source module data information of confirmation；
Step S23 determines variable information position in electrical form female parent；
Step S24 is passed to variable information parameter, and data are filled in variable information position in table female parent.
4. according to claim 1 or a kind of 3 electrical form deriving methods in the electrical form export library based on open source, special
Sign is,
The variable information includes local variable, cell formats variable, table format variable, duplicate contents formatting change
Amount and the control program based on variable；
The control process control based on variable realize local variable, cell formats variable, table format variable and
The operation of duplicate contents formatted variable.
5. a kind of electrical form deriving method in the electrical form export library based on open source according to claim 1, feature
It is, described to treat derived data information regular, including passing through numerical value electron table corresponding to incoming data source and table
Lattice female parent assignment.
6. a kind of electrical form guiding system in the electrical form export library based on open source, which is characterized in that the system comprises:
Open source module data information acquisition unit, for obtaining open source module data information；
Data information integrated treatment unit, for treating derived data in conjunction with variable information according to open source module data information
Information carries out integrated treatment；
Template file generation unit, it is regular for treating derived data information, and produce corresponding template file；
Template file storage element, for storing template file into specified file.
7. a kind of electrical form guiding system in the electrical form export library based on open source according to claim 6, feature
It is, the system also includes:
First confirmation module obtains open source device source and open source component count, type for determining；
Creation module, for creating electrical form female parent.
8. a kind of electrical form guiding system in the electrical form export library based on open source according to claim 6, feature
It is, the data information integrated treatment unit further include:
Second confirmation module, confirmation open source module data information；
Definition module defines and confirms the variable information that editor is completed according to the open source module data information of confirmation；
Third confirmation module determines variable information position in electrical form female parent；
Module is filled, variable information parameter is passed to, data are filled in variable information position in table female parent.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810564862.5A CN108959221A (en) | 2018-06-04 | 2018-06-04 | A kind of the electrical form deriving method and system in the electrical form export library based on open source |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810564862.5A CN108959221A (en) | 2018-06-04 | 2018-06-04 | A kind of the electrical form deriving method and system in the electrical form export library based on open source |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108959221A true CN108959221A (en) | 2018-12-07 |
Family
ID=64493430
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810564862.5A Pending CN108959221A (en) | 2018-06-04 | 2018-06-04 | A kind of the electrical form deriving method and system in the electrical form export library based on open source |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108959221A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110032595A (en) * | 2019-04-15 | 2019-07-19 | 广东电网有限责任公司 | A kind of data processing method, system, equipment and storage medium |
| CN111104784A (en) * | 2019-12-19 | 2020-05-05 | 金蝶软件（中国）有限公司 | Data integration method and related device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN103294796A (en) * | 2013-05-24 | 2013-09-11 | 上海申腾信息技术有限公司 | XML (extensive markup language) parsing method and implementation method of custom XML structural forms in medical records |
| CN103617284A (en) * | 2013-12-11 | 2014-03-05 | 北京金和软件股份有限公司 | Data field extension method |
| CN105045775A (en) * | 2015-08-12 | 2015-11-11 | 深圳联友科技有限公司 | Method and apparatus for generating Excel document in designated format |
| CN107133203A (en) * | 2016-02-29 | 2017-09-05 | 阿里巴巴集团控股有限公司 | A kind of chart generation method and device |
-
2018
- 2018-06-04 CN CN201810564862.5A patent/CN108959221A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN103294796A (en) * | 2013-05-24 | 2013-09-11 | 上海申腾信息技术有限公司 | XML (extensive markup language) parsing method and implementation method of custom XML structural forms in medical records |
| CN103617284A (en) * | 2013-12-11 | 2014-03-05 | 北京金和软件股份有限公司 | Data field extension method |
| CN105045775A (en) * | 2015-08-12 | 2015-11-11 | 深圳联友科技有限公司 | Method and apparatus for generating Excel document in designated format |
| CN107133203A (en) * | 2016-02-29 | 2017-09-05 | 阿里巴巴集团控股有限公司 | A kind of chart generation method and device |
Non-Patent Citations (1)
| Title |
|---|
| SPORTSKY: ""NPOI生成excel并下载"", 《博客园HTTPS://WWW.CNBLOGS.COM/SPORTSKY/P/5042510.HTML》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110032595A (en) * | 2019-04-15 | 2019-07-19 | 广东电网有限责任公司 | A kind of data processing method, system, equipment and storage medium |
| CN111104784A (en) * | 2019-12-19 | 2020-05-05 | 金蝶软件（中国）有限公司 | Data integration method and related device |
| CN111104784B (en) * | 2019-12-19 | 2024-03-12 | 金蝶软件（中国）有限公司 | Data integration method and related device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110058856A (en) | Page configuration method and device | |
| CN109388396A (en) | Page generation method, device, computer equipment and storage medium | |
| CN110955410B (en) | Code automatic generation method, device, equipment and medium | |
| CN103677952B (en) | Codec generating means and method | |
| CN108268525A (en) | A kind of report implementation method and device based on Excel template | |
| CN110244936B (en) | Method and device for supporting VISIO flow chart to automatically import DCS algorithm configuration software | |
| CN107168749A (en) | A kind of Compilation Method, device, equipment and computer-readable recording medium | |
| CN108804322A (en) | Automated testing method, device, computer equipment and storage medium | |
| CN108132925A (en) | A kind of report file generation method and device | |
| CN108959221A (en) | A kind of the electrical form deriving method and system in the electrical form export library based on open source | |
| CN110580174B (en) | Application component generation method, server and terminal | |
| CN109445775A (en) | One key activity inline code method, apparatus and computer readable storage medium | |
| CN106681788A (en) | Method and device for reducing application installation packages and electronic equipment | |
| CN105204859A (en) | Animation management method and system | |
| CN109375943A (en) | A kind of program file generation method and device | |
| JP2022545489A (en) | Smart contract client program generation method, system, device, and medium | |
| CN104267966A (en) | Method and device for generating program codes of software | |
| CN102929646A (en) | Application program production method and device | |
| CN106293770A (en) | The general of a kind of table data leads table system and method | |
| CN109086147A (en) | Service interface call method, device and the storage medium of application program | |
| CN103268242A (en) | Method and device for installing information system | |
| CN106775916A (en) | Method and device for reducing application installation packages and electronic equipment | |
| KR20040014671A (en) | System and method for exporting or importing object data in a manufacturing execution system | |
| CN117407048A (en) | Flow configuration method and system of plug-in data processing software | |
| CN107506227A (en) | The method and apparatus for managing compiled code |
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: 20181207 |
|
| RJ01 | Rejection of invention patent application after publication |