CN103778107B - Method and platform for quickly and dynamically generating form based on EXCEL - Google Patents
Method and platform for quickly and dynamically generating form based on EXCEL Download PDFInfo
- Publication number
- CN103778107B CN103778107B CN201210411393.6A CN201210411393A CN103778107B CN 103778107 B CN103778107 B CN 103778107B CN 201210411393 A CN201210411393 A CN 201210411393A CN 103778107 B CN103778107 B CN 103778107B
- Authority
- CN
- China
- Prior art keywords
- data
- list
- user
- excel
- template
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a platform for quickly and dynamically generating a form based on EXCEL. The method for quickly and dynamically generating the form based on the EXCEL comprises the steps that form data trends are analyzed, and a form scheme is established; according to an existing or new EXCEL document, a form frame is adjusted or established; data are organized, converted into data items which can be recognized by a system and written into all cells; a template is uploaded to a server; template cell data descriptive analysis is executed, processing is carried out cell by cell, and information is recorded into a form scheme detail table item by item; after analysis is completed, master-slave correlation is carried out on a form data model and data items, a structure is converted into a database script, and a data format is generated after execution; the form is accessed through a menu. According to the method and the platform for quickly and dynamically generating the form based on the EXCEL, encapsulation is carried out by accessing the database, programming is transformed into configuration, and the common office software EXCEL is used as the template, developing workload can be reduced effectively, the object of reducing 10%-60% of form making workload can be achieved, and adjustment is easy.
Description
Technical field
The present invention relates to data processing field, in particular it relates to a kind of method for generating list based on the quick dynamics of EXCEL
With platform.
Background technology
List is a ring important in business administration, and often there is characteristic in different enterprise or field for form list
Demand, and then management personnel preferably carry out business decision and management.List is different from enterprise report, and form is often based upon data
Collect and process, and list is commonly used to record the daily management of enterprise, and its complexity part is must have interactivity, and
Can be circulated between all departments of enterprise and personnel.
The design of list usually contains three parts：Layout, two parts of data processing.Layout determines the displaying of data
Structure, the final purpose of list be exactly provide the user that easy-to-use, typing is convenient, data feedback clearly interface；Data processing is used
To safeguard the data of list, and in normal handling, list generally requires to process various necessary not only for simple Characters
Data type, such as date, combobox, files passe.
At present, during enterprise's form design, main technical schemes are according to customer's need by exploitation or enforcement personnel
Ask and be customized, which is mostly difficult to by configuring extension, needs to carry out substantial amounts of data pick-up and process, process, packet
The work such as classification and list layout, establishment also needs to be compiled after finishing, and either increases newly or adjustment is required for
Expend manpower and the time of a large amount of specialties.
Jing is retrieved, and China Patent Publication No. is 101968800A, and the invention is related to based on the dynamic list of metadata driven
Method, comprises the following steps:1) cell in list is classified, corresponding table is set up to the cell of each type
Single function collection;2) by metadata description rule, cell structure is described, forms metadatabase;3) by metadata engine from
Capture with form metadata information is obtained in metadatabase, to list dynamically metadata about load;4) list function collection, dynamic is selected to generate
User's list.And for example, China Patent Publication No. is 101661508A, a kind of generation for being applied to many technology platforms of the disclosure of the invention
The method of list, it is characterised in that include：Obtain and Preservation Metadata description information；It is fixed according to the metadata description information
The capture with form metadata that adopted list and list are included, by the list and its capture with form metadata for being included with the first data structure
Form stored；The capture with form metadata that list is included is produced, the element property in capture with form metadata is set up and industry
It is engaged in corresponding business datum table and preserving；The table in element object and business datum table in first data structure
Forms data, produces the corresponding form interface of target platform and Business Processing data.
Compared with foregoing invention：
1. the present invention for user require it is lower, towards be not only developer itself, be even ignorant of system
As long as software end user can be skilled use EXCEL and grasp certain data base and simply can also participate in the customization of software
And development process.Designed based on EXCEL, additionally it is possible to the existing list of effectively utilizes enterprise, with more motility and representativeness.
And two above invention is both for developer's design, need higher programming relevant knowledge to support, generally require by
Development environment and developer in specialty.
2. what a kind of dynamic generation list method of the present invention can be seamless with software system is integrated, without the need for extra volume
Translate.Patent publication No. describes the function that a kind of dynamic generates picture code building for the invention of 101661508A, needs program
Compiling.
3. the data processing module that the present invention is included, can automatically form data definition foot according to the EXCEL templates of user
This（DDL）, directly database table is generated according to template description, so as to by database schema, Software Development Platform black box, use
Person need not pay close attention to underlying platform.And above-mentioned two invention all must by hand set up tables of data in data base, this is transported for
, generally there is operating right and limit and potential safety hazard in the software system in row.
4. the present invention includes customized parameter, supports for the different disposal business of current picture, such as inquiry, modification, deletes
Authority is separated.Coordinate the functions such as the menu authorization of current software system, different functions can be specified for different user's requests.
This function is not all mentioned in above-mentioned two invention.
5. the present invention contains the authentication function of picture data details, and picture contains field length, type and default value
The service logics such as setting, it is ensured that the quality of list.This function is not all mentioned in above-mentioned two invention.
The content of the invention
For defect of the prior art, it is an object of the invention to provide a kind of generate list based on the quick dynamics of EXCEL
Method and platform, so as to solve the above problems.
According to an aspect of the invention, there is provided a kind of method for generating list based on the quick dynamics of EXCEL, including with
Lower step：
Step one：Form data trend analysis are carried out, main list model data is taken out, list scheme, table is set up
Folk prescription case is mainly including the numbering of list, Chinese, master data table name, the person liable of list, approved by, entry-into-force time and mistake
Time phase；
Step 2：According to existing or newly-built EXCEL document, form framework is adjusted or set up, design Microsoft Excel, adjustment
Frame, Merge Cells, fixed text；
Step 3：According to user's request, list is needed to show or the data of typing are arranged, and be converted to system
Discernible data item, in write each unit lattice；Data item information mainly includes two parts：Control description information and data are retouched
State information；For control description information, need to include control type, control data Source Type, control data source, column locations,
Merge Cells, size, frame；Data specifying-information includes Database field name, major key, data type, length, precision, silent
Recognize value, Chinese；
Step 4：Template is uploaded to server, template file is saved in into server end；
Step 5：Modular unit lattice data descriptive analysis are performed, is processed by cell, the description letter of analytic unit lattice
Breath, during information recorded one by one list scheme detail list；
Step 6：After the completion of analysis, principal and subordinate's association is carried out to form data model and data item, according in list scheme
Data specifying-information, by structure database script is converted to, and tables of data is generated after execution；
Step 7：The enrollment form in the menu of application system, user can pass through menu access list.
According to a further aspect in the invention, there is provided it is a kind of dynamic generate list platform, including：Stencil design module, mould
Plate parsing module, picture rendering module, data processing module and menu page management module, wherein：
Stencil design module：For the list pattern of user's request, a EXCEL file is designed as template, for retouching
State the layout of list, including color, font, cell span, frame content；For the form data of user's request, need
Add the description information of the desired data that show or operate of each user in EXCEL template files；For user's request
Interactive form, needs add the desired interactive requirements information to be shown of each user in EXCEL template files；
Template parsing module：After user uploads template, template file is analyzed, and travels through unit lattice, point
List pattern therein, data and interactive form description information are analysed, and list scheme detail list will be stored in after all finish messages
In；
Picture rendering module：When user needs to show list, list scheme detailed data is analyzed, is drawn automatically
Form layout, disposes unit lattice control；
Data processing module：Template parsing module completes template parsing and information is stored in after list scheme detail list, point
Form data description information in analysis detailed data, by built-in DDL management functions, believes with reference to the tables of data of list scheme
Breath, generates database script, and after performing automatically, the establishment work of tables of data is completed in data base；If user have adjusted
The data field of list, in addition it is also necessary to the change of automatic detection table structure, the final modification operation for performing tables of data；
Menu page management module：For the demand of user, it is allowed to which enrollment form is newly-increased, change, inquire about three kinds of pictures, and
Support to be distinguished by constructing variable, by the module, list is articulated in System menu, there is provided access and use to user.
Compared with prior art, the present invention has following beneficial effect：
The present invention is separated by representing with data access, and using EXCEL softwares worksheet is easily generated.The present invention
Software Change risk can be effectively reduced, and the end user of the technology that is ignorant of can be introduced software design and development process.
By the designing form layout simply in EXCEL, and design data stores logic and represents content in cell, it is possible to
By list engine, layout is converted to into list and database data item.
The present invention by being packaged to database access, using the EXCEL softwares functional characteristics of itself, can be effective
Developing instrument amount is reduced, the target of the form customization workload for reducing 10%-60% is reached, and is easy to adjustment.The present invention can also
Effectively using the management wealth of user itself, allowing be ignorant of programming can also work out list and be flowed with the user of data base
Turn, control enterprise application software Change risk.
Description of the drawings
The detailed description by reading non-limiting example made with reference to the following drawings, the further feature of the present invention,
Objects and advantages will become more apparent upon：
Fig. 1 is the newly-increased flow chart of list；
Fig. 2 is form templat process of analysis figure；
Fig. 3 is platform assembly figure.
Specific embodiment
With reference to specific embodiment, the present invention is described in detail.Following examples will be helpful to the technology of this area
Personnel further understand the present invention, but the invention is not limited in any way.It should be pointed out that the ordinary skill to this area
For personnel, without departing from the inventive concept of the premise, some deformations and improvement can also be made.These belong to the present invention
Protection domain.
Embodiment 1
As shown in Figure 1-2, a kind of method for generating list based on the quick dynamics of EXCEL, comprises the following steps：
Step one：Form data trend analysis are carried out, main list model data is taken out, list scheme is set up.Table
Folk prescription case is mainly including the numbering of list, Chinese, master data table name, the person liable of list, approved by, entry-into-force time and mistake
Time phase etc..
Step 2：According to existing or newly-built EXCEL document, form framework is adjusted or set up, design Microsoft Excel, adjustment
Frame, Merge Cells, fixed text etc..
Step 3：According to user's request, list is needed to show or the data of typing are arranged, and be converted to system
Discernible data item, in write each unit lattice.Data item information mainly includes two parts：Control description information and data are retouched
State information.For control description information, need to include control type, control data Source Type, control data source, column locations,
Merge Cells, size, frame etc.；Data specifying-information include Database field name, major key, data type, length, precision,
The information such as default value, Chinese.
Step 4：Template is uploaded to server, template file is saved in into server end.
Step 5：Modular unit lattice data descriptive analysis are performed, is processed by cell.The description letter of analytic unit lattice
Breath, during information recorded one by one list scheme detail list.
Step 6：After the completion of analysis, principal and subordinate's association is carried out to form data model and data item, according in list scheme
Data specifying-information, by structure database script is converted to, and tables of data is generated after execution.
Step 7：The enrollment form in the menu of application system, user can pass through menu access list.
In the present embodiment, in step one defined in list model data list corresponding data source and list circulation duty
Unit information, i.e., the circulation accountability unit of all lists and the Data Source of list is appointed to define simultaneously.
In the present embodiment, the letter being shown as in the future needed for the content of form controls is contained in step 3 in data item information
Breath, describes the data field and control type of list.This definition information will be believed for generating control content and Database field
Breath.
In the present embodiment, the principal and subordinate's corresponding relation between list model and form data item in step 6, is by linking
Relation, by the relation of list model and data item the relation of table and Biao Lie is converted to, and is ultimately converted to a database table.
In the present embodiment, in step 3 and step 6, list model and form data item are changed, and closed by principal and subordinate
System, is mapped as database table structure and defines script, and the function of database table is finally generated in data base.
Embodiment 2
As shown in figure 3, a kind of dynamic generates the platform of list, including：Stencil design module, template parsing module, picture
Rendering module, data processing module and menu page management module.Wherein：
Stencil design module：For the list pattern of user's request, a EXCEL file is designed as template, for retouching
State the layout of list, including the content such as color, font, cell span, frame；For the form data of user's request, need
Add the description information of the desired data that show or operate of each user, such as field, data class in EXCEL template files
The information such as type, length, precision；For the interactive form of user's request, needs add each user's phase in EXCEL template files
The interactive requirements information to be shown such as control type, code, the default value etc. hoped；
Template parsing module：After user uploads template, template file is analyzed, and travels through unit lattice, point
List pattern therein, data and interactive form description information are analysed, and list scheme detail list will be stored in after all finish messages
In；
Picture rendering module：When user needs to show list, list scheme detailed data is analyzed, is drawn automatically
Form layout, disposes unit lattice control；
Data processing module：Template parsing module completes template parsing and information is stored in after list scheme detail list, point
Form data description information in analysis detailed data, by built-in DDL management functions, believes with reference to the tables of data of list scheme
Breath, generates database script, and after performing automatically, the establishment work of tables of data is completed in data base；If user have adjusted
The data field of list, in addition it is also necessary to the change of automatic detection table structure, the final modification operation for performing tables of data；
Menu page management module：For the demand of user, it is allowed to which enrollment form is newly-increased, change, inquire about three kinds of pictures, and
Support to be distinguished by constructing variable, by the module, list is articulated in System menu, there is provided access and use to user.
In the present embodiment, the picture rendering module, when user data is shown, it is necessary to obtain customer parameter, it is determined that working as
The editable state of front all data.State convention is as follows：N- is increased newly, M- modifications, Q- inquiries；When state is N, perform initial
Change operation, each control load initial value, it is allowed to edit；When state is M, data loading operations are performed, it is allowed to edit；Work as state
For Q when, perform data loading operations, do not allow editor；
In the present embodiment, the data processing module, when user needs to show list, the detailed data to list scheme
It is analyzed.It is each according to control default value, the initialization of dropdown control data source information when there is no form data in data base
The initial value of control；When list corresponding data in the presence of, according to data-base recording load list data.
In the present embodiment, the data processing module, when user's modification list is recorded, automatic detection modification information, and
It is stored in a queue to be saved.When user selects to preserve list modification, queue to be saved is processed.Data are obtained first
Record case in storehouse, when there is record in data base, compares, if data are repaiied to each data item in queue
Change, then in including modification sentence；When no record in data base, newly-increased operation is performed according to queue.
Realize that dynamic generates list process using above-mentioned platform specific as follows：
1. the newly-built list protocol in stencil design module, is input into the code of list, title, the entry-into-force time, expired
The information such as time and necessary tables of data.
2. EXCEL file is set up, the basic layout of list is drawn hereof, completed cell drafting, frame design, consolidate
Determine text input.
3. in template parsing module, it is to needing displaying or the data of typing to arrange list, and being converted to
Unite discernible data item.Data item information mainly includes field name, Chinese, data type, length, default value, control
Part type etc..
4. template parsing module calls data processing module to carry out principal and subordinate's association to form data model and data item automatically,
And structure is converted to into database script, tables of data is generated after execution.
5. user is articulated to dynamic list by specifying different parameter registration pictures in menu page management module
In system.
6. user can click on menu and be tested or used list.Now, picture rendering module is called in data base and protected
The configuration deposited, and parse the configuration drafting page and control, initialization picture data.By the authorization function of menu page module,
With heavily loaded list, and can make list that there are different operating rights.
7. when user is newly-increased or changes picture data, the data processing module automatic capture modification of system, when submitting to
Information that is newly-increased or changing is saved in data base.
From above-described embodiment as can be seen that the present invention to database access by being packaged, programming is converted into into configuration,
And by the use of conventional office software EXCEL as template, development amount amount can be effectively reduced, reach reduction 10%-60%
Form customization workload target, and be easy to adjustment.
The specific embodiment of the present invention is described above.It is to be appreciated that the invention is not limited in above-mentioned
Particular implementation, those skilled in the art can within the scope of the claims make various modifications or modification, this not shadow
Ring the flesh and blood of the present invention.
Claims (4)
1. it is a kind of based on the quick dynamic systems for generating list of EXCEL, it is characterised in that to include：Stencil design module, template solution
Analysis module, picture rendering module, data processing module and menu page management module, wherein：
Stencil design module：For the list pattern of user's request, a EXCEL file is designed as template, for describing table
Single layout, including color, font, cell span, frame content；For the form data of user's request, need in EXCEL
Add the description information of the desired data that show or operate of each user in template file；For the interactive shape of user's request
Formula, needs add the desired interactive requirements information to be shown of each user in EXCEL template files；
Template parsing module：After user uploads template, template file is analyzed, and travels through unit lattice, analyze it
In list pattern, data and interactive form description information, and will be stored in after all finish messages in list scheme detail list；
Picture rendering module：When user needs to show list, list scheme detailed data is analyzed, list is drawn automatically
Layout, disposes unit lattice control；
Data processing module：Template parsing module completes template parsing and information is stored in after list scheme detail list, analyzes bright
Count the form data description information according in accurately, it is raw with reference to the data table information of list scheme by built-in DDL management functions
Into database script, and after performing automatically, the establishment work of tables of data is completed in data base；If user have adjusted list
Data field, in addition it is also necessary to the change of automatic detection table structure, the final modification operation for performing tables of data；
Menu page management module：For the demand of user, it is allowed to which enrollment form is increased newly, changed, three kinds of pictures of inquiry, and is supported
Distinguished by constructing variable, by the menu page management module, list is articulated in System menu, there is provided accessed to user
With use.
2. it is according to claim 1 based on the quick dynamic systems for generating list of EXCEL, it is characterised in that the picture
Rendering module, when user data is shown, it is necessary to obtain customer parameter, it is determined that the editable state of current all data, state
Agree as follows：N- is increased newly, M- modifications, Q- inquiries；When state is N, initialization operation is performed, each control load initial value permits
Perhaps edit；When state is M, data loading operations are performed, it is allowed to edit；When state is Q, data loading operations are performed, no
Allow editor.
3. it is according to claim 1 based on the quick dynamic systems for generating list of EXCEL, it is characterised in that the data
Processing module, when user needs to show list, is analyzed, when there is no table in data base to the detailed data of list scheme
During forms data, the initial value of each control is initialized according to control default value, dropdown control data source information；When list corresponding data
In the presence of, the data of list are loaded according to data-base recording.
4. it is according to claim 1 based on the quick dynamic systems for generating list of EXCEL, it is characterised in that the data
Processing module, when user's modification list is recorded, automatic detection modification information, and a queue to be saved is stored in, in user's choosing
When selecting preservation list modification, queue to be saved is processed：The record case in data base is obtained first, when depositing in data base
In record, each data item in queue is compared, if data are changed, in including modification sentence；Work as data base
During middle no record, newly-increased operation is performed according to queue.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210411393.6A CN103778107B (en) | 2012-10-25 | 2012-10-25 | Method and platform for quickly and dynamically generating form based on EXCEL |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210411393.6A CN103778107B (en) | 2012-10-25 | 2012-10-25 | Method and platform for quickly and dynamically generating form based on EXCEL |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103778107A CN103778107A (en) | 2014-05-07 |
| CN103778107B true CN103778107B (en) | 2017-05-03 |
Family
ID=50570354
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210411393.6A Active CN103778107B (en) | 2012-10-25 | 2012-10-25 | Method and platform for quickly and dynamically generating form based on EXCEL |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103778107B (en) |
Families Citing this family (40)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105205071A (en) * | 2014-06-24 | 2015-12-30 | 阿里巴巴集团控股有限公司 | Method and system for showing data table |
| CN104090850B (en) * | 2014-06-24 | 2017-07-14 | 上海铀尼信息科技有限公司 | Online form system and its data managing method |
| CN105573602A (en) * | 2014-10-13 | 2016-05-11 | 远光软件股份有限公司 | Visualized multi-form display device and method |
| CN104391832A (en) * | 2014-11-18 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | Method for combining data in multiple EXCEL data sheets by using VBA (Visual Basic for Applications) |
| CN105069092B (en) * | 2015-08-05 | 2018-08-17 | 深圳联友科技有限公司 | A kind of method, system and the mobile terminal of report displaying |
| CN106598919A (en) * | 2015-10-14 | 2017-04-26 | 中兴通讯股份有限公司 | Document generation method and device |
| CN105278961B (en) * | 2015-10-28 | 2018-07-13 | 广州华多网络科技有限公司 | Generate the method and system of database table structure document |
| US9696967B2 (en) * | 2015-11-09 | 2017-07-04 | Microsoft Technology Licensing, Llc | Generation of an application from data |
| CN106933559A (en) * | 2015-12-31 | 2017-07-07 | 阿里巴巴集团控股有限公司 | Forms pages data processing method and device |
| CN105630514A (en) * | 2016-02-24 | 2016-06-01 | 浪潮通用软件有限公司 | Form designing method based on modularization |
| CN106339441A (en) * | 2016-08-22 | 2017-01-18 | 浪潮通用软件有限公司 | Form calling method, device and system |
| CN106598927B (en) * | 2016-11-30 | 2019-08-30 | 国云科技股份有限公司 | A method of quickly generating Excel list |
| CN106980606A (en) * | 2017-03-30 | 2017-07-25 | 北京兴农丰华科技有限公司 | A kind of acquisition method of the customizable list data in mobile terminal |
| CN115098084A (en) * | 2017-05-09 | 2022-09-23 | 合肥汉腾信息技术有限公司 | Non-coding form design and drawing method |
| CN107329756B (en) * | 2017-06-29 | 2020-06-26 | 网易（杭州）网络有限公司 | Program file generation method and device, storage medium, processor and terminal |
| CN110019025B (en) * | 2017-07-20 | 2021-12-21 | 中移动信息技术有限公司 | Stream data processing method and device |
| CN107544808A (en) * | 2017-09-07 | 2018-01-05 | 北京奥威科软信息技术有限公司 | The generation method and device of a kind of web form |
| CN107578217B (en) * | 2017-09-13 | 2021-02-12 | 深圳市沃易科技有限公司 | Working electronic flow autonomous generation method and device and office management system |
| CN108021367B (en) * | 2017-12-15 | 2020-11-17 | 广州赛意信息科技股份有限公司 | UI development system and method based on metadata framework |
| CN108469953A (en) * | 2018-03-13 | 2018-08-31 | 深圳市易聆科信息技术股份有限公司 | A kind of generation method of page table list, server and storage medium |
| CN110399368B (en) * | 2018-04-23 | 2022-08-19 | 华为技术有限公司 | Method for customizing data table, data operation method and device |
| CN108958712A (en) * | 2018-06-28 | 2018-12-07 | 上海卫星工程研究所 | The test template generation method of satellite multi-mode complication system |
| CN109684326A (en) * | 2018-11-13 | 2019-04-26 | 平安科技（深圳）有限公司 | Tables of data creation method, device, equipment and computer readable storage medium |
| CN109857735B (en) * | 2018-12-29 | 2021-05-04 | 上海瑞家信息技术有限公司 | Data construction method and system for rule description through excel |
| CN109977383A (en) * | 2019-03-11 | 2019-07-05 | 湖南纬拓信息科技有限公司 | A kind of form information extracting method based on Excel |
| CN110083342B (en) * | 2019-04-26 | 2023-04-18 | 重庆紫光华山智安科技有限公司 | Program generation method and device and computer readable storage medium |
| CN110705226A (en) * | 2019-08-22 | 2020-01-17 | 平安科技（深圳）有限公司 | Spreadsheet creating method and device and computer equipment |
| CN110531964B (en) * | 2019-08-30 | 2023-03-14 | 苏州中弘软件技术有限公司 | Personalized intelligent software development method |
| CN110717320A (en) * | 2019-10-11 | 2020-01-21 | 上海管和信息科技有限公司 | Form/report designer and method suitable for multiple platforms and information management system |
| CN110780859B (en) * | 2019-10-29 | 2023-01-31 | 成都阳帆网络科技有限公司 | Method for realizing service architecture based on user-defined form |
| CN113495887A (en) * | 2020-03-20 | 2021-10-12 | 北京沃东天骏信息技术有限公司 | Data form processing method, device and system |
| CN111796803B (en) * | 2020-07-08 | 2024-03-08 | 宝牧科技（天津）有限公司 | Template report generation method based on multi-stage container restocking |
| CN111783407A (en) * | 2020-07-17 | 2020-10-16 | 西思艾(北京)软件有限公司 | Electronic form creating system |
| CN113420080A (en) * | 2021-05-31 | 2021-09-21 | 北京三维天地科技股份有限公司 | Toxicology experiment data management system |
| CN113283224A (en) * | 2021-06-09 | 2021-08-20 | 京东方科技集团股份有限公司 | Form generation method and device, electronic equipment and storage medium |
| CN114064716B (en) * | 2021-10-29 | 2023-10-20 | 北京市农林科学院信息技术研究中心 | Metadata-based automatic WEB report generation method and device |
| CN114372177A (en) * | 2022-03-22 | 2022-04-19 | 创意信息技术股份有限公司 | Excel table data matching method |
| CN114896214B (en) * | 2022-04-18 | 2024-06-21 | 宝信软件(武汉)有限公司 | Batch transmission method and system for multiple data sets of host platform |
| CN115563111B (en) * | 2022-09-27 | 2024-07-23 | 国网江苏省电力有限公司超高压分公司 | Dynamic model configuration method and system for converter station system |
| CN117908862B (en) * | 2024-01-31 | 2024-07-12 | 和创（北京）科技股份有限公司 | Method and device for establishing field anti-false deletion system under object conversion configuration |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US1211624A (en) * | 1915-03-04 | 1917-01-09 | Goodyear S Metallic Rubber Shoe Company | Covering for irregular surfaces. |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN101706902A (en) * | 2009-11-10 | 2010-05-12 | 南京涛如雪工贸实业有限公司 | Excel multi-page form-based method for managing production and order |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102360290A (en) * | 2011-09-29 | 2012-02-22 | 用友软件股份有限公司 | Form building device and form building method |
-
2012
- 2012-10-25 CN CN201210411393.6A patent/CN103778107B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US1211624A (en) * | 1915-03-04 | 1917-01-09 | Goodyear S Metallic Rubber Shoe Company | Covering for irregular surfaces. |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN101706902A (en) * | 2009-11-10 | 2010-05-12 | 南京涛如雪工贸实业有限公司 | Excel multi-page form-based method for managing production and order |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102360290A (en) * | 2011-09-29 | 2012-02-22 | 用友软件股份有限公司 | Form building device and form building method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103778107A (en) | 2014-05-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103778107B (en) | Method and platform for quickly and dynamically generating form based on EXCEL | |
| Koch | Transformation techniques in the model-driven development process of UWE | |
| US8560941B2 (en) | Schema based user interface mechanisms | |
| Mori et al. | Tool support for designing nomadic applications | |
| Antkiewicz et al. | FeaturePlugin: Feature modeling plug-in for Eclipse | |
| US10699067B2 (en) | Form design and data input in which a server provides a repository of form templates that are distributed to multiple form filing client systems | |
| CN104035772B (en) | Source code multi version function calling relationship otherness identification method based on static analysis | |
| Langer et al. | EMF Profiles: A Lightweight Extension Approach for EMF Models. | |
| US20180300125A1 (en) | Analyzing components related to a software application in a software development environment | |
| US20070234201A1 (en) | Information Management Device | |
| CN101776999A (en) | Platform for developing and implementing software system | |
| Engel et al. | A Concerted Model-driven and Pattern-based Framework for Developing User Interfaces of Interactive Ubiquitous Applications. | |
| US20100169333A1 (en) | Document processor | |
| Neubauer et al. | XMLText: from XML schema to Xtext | |
| CN104156199B (en) | A kind of automatic continuous integrated approach of software and system | |
| US20070208995A1 (en) | Document Processing Device and Document Processing Method | |
| Trias | Building CMS-based Web applications using a model-driven approach | |
| WO2003009071A1 (en) | System and method for exporting or importing object data in a manufacturing execution system | |
| US11423210B2 (en) | System and method for dynamically defining digital forms | |
| Schlegel et al. | Extracting Provenance of Machine Learning Experiment Pipeline Artifacts | |
| Goonetillake et al. | An integrity constraint management framework in engineering design | |
| CN104657340B (en) | Expansible Word report preparing systems and method based on script | |
| Wojszczyk et al. | The process of verifying the implementation of design patterns—used data models | |
| EP1744271A1 (en) | Document processing device | |
| US7730105B2 (en) | Time sharing managing apparatus, document creating apparatus, document reading apparatus, time sharing managing method, document creating method, and document reading method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |