CN103778107A - 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
- CN103778107A CN103778107A CN201210411393.6A CN201210411393A CN103778107A CN 103778107 A CN103778107 A CN 103778107A CN 201210411393 A CN201210411393 A CN 201210411393A CN 103778107 A CN103778107 A CN 103778107A
- Authority
- CN
- China
- Prior art keywords
- data
- list
- excel
- user
- database
- 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
Images
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, particularly, relate to a kind of method and platform that dynamically generates fast list based on EXCEL.
Background technology
List is a ring important in business administration, and often there is the demand of characteristic in different enterprises or field for form list, and then managerial personnel carry out business decision and management better.List is different from enterprise's form, and form is often based on the gathering and process of data, and list is commonly used to record the daily management of enterprise, and its complicated part is to have interactivity, and can between all departments of enterprise and personnel, circulate.
The design of list often comprises three parts: layout, two parts of data processing.Layout has determined the display structure of data, and the final purpose of list is exactly for user provides easy-to-use, typing is convenient, data feedback interface clearly; Data processing is used for safeguarding the data of list, and in daily processing, list not only needs simple Characters, often needs to process numerous types of data, as date, combobox, file are uploaded etc.
At present, in enterprise's form design process, main technical schemes is by developing or enforcement personnel customize according to customer's demand, which is mostly difficult to expand by configuration, need to carry out a large amount of data pick-ups and processing, process the work such as grouping and classifying and list layout, after establishment, also need to compile, increase or adjust no matter be the manpower and the time that all need to expend a large amount of specialties newly.
Through retrieval, China Patent Publication No. is 101968800A, and this invention relates to the dynamic table folk prescription method based on metadata driven, comprises the following steps: 1) cell in list is classified, the cell of each type is set up to corresponding list function collection; 2), by metadata description rule, description unit lattice structure, forms metadatabase; 3) from metadatabase, obtain table unit data message by metadata engine, to dynamically metadata about load of list; 4) select list function collection, dynamically generate user's list.And for example, China Patent Publication No. is 101661508A, and the method for a kind of generation list that is applied to many technology platforms of this disclosure of the invention, is characterized in that, comprising: obtain and Preservation Metadata descriptor; The table unit data that comprise according to described metadata description information definition list and list, store described list and the table unit data that comprise thereof with the form of the first data structure; Produce the table unit data that list comprises, set up the business datum table corresponding with business and preserve according to the element property in table unit data; According to the form data in element object and business datum table in described the first data structure, produce corresponding form interface and the business processing data of target platform.
Compared with foregoing invention:
The present invention require for user lower, towards be not only developer itself, as long as or even be ignorant of the use EXCEL that the software final user of system can be skilled and grasp certain database just also participating in customization and the performance history of software.Design based on EXCEL, can also effectively utilize the existing list of enterprise, have more dirigibility and representativeness.And above two inventions are all for developer's design, need higher programming relevant knowledge to support, generally need to be by means of professional development environment and developer.
A kind of dynamic generation list method of the present invention can with seamless integrated of software systems, without extra compiling.Patent publication No. is that the function that a kind of dynamic generation picture code generates has been explained in the invention of 101661508A, needs program compilation.
3. the data processing module that the present invention comprises, can automatically form data definition script (DDL) according to user's EXCEL template, directly describe generating database table according to template, thereby by database schema, Software Development Platform black box, user is without paying close attention to underlying platform.And above-mentioned two inventions all must be set up by hand tables of data in database, in operating software systems, there is operating right restriction and potential safety hazard for just in this conventionally.
4. the present invention includes customized parameter, support the different disposal business for current picture, as inquiry, modification, erase right separate.Coordinate the functions such as the menu authorization of current software systems, can specify different functions for different user's requests.In above-mentioned two inventions, all do not mention this function.
5. the authentication function that the present invention has comprised picture data details, picture has comprised the service logics such as field length, type and default value setting, guarantees the quality of list.In above-mentioned two inventions, all do not mention this function.
Summary of the invention
For defect of the prior art, the object of this invention is to provide a kind of method and platform based on the quick dynamically generation of EXCEL list, thereby address the above problem.
According to an aspect of the present invention, provide a kind of method that dynamically generates fast list based on EXCEL, comprised the following steps:
Step 1: carry out form data trend analysis, take out main list model data, set up list scheme, list scheme mainly comprises the numbering of list, Chinese, master data table name, the person liable of list, Approved by, entry-into-force time and expired time;
Step 2: according to existing or newly-built EXCEL document, adjust or set up list framework, design Microsoft Excel, adjusts frame, Merge Cells, fixed text;
Step 3: according to user's request, list need to be shown or the data of typing arrange, and the discernible data item of the system that is converted to, write in each cell; Data item information spinner will comprise two parts: control descriptor and data description information; For control descriptor, need to comprise control type, control data source type, control data source, ranks position, Merge Cells, size, frame; Data description information comprises Database field name, major key, data type, length, precision, default value, Chinese;
Step 4: upload template to server, template file is saved in to server end;
Step 5: carry out the analysis of modular unit lattice data description, process by cell, the descriptor of analytic unit lattice, by information itemize in list scheme detail list;
Step 6: after having analyzed, form data model and data item are carried out to principal and subordinate associated, according to the data description information in list scheme, structure is converted to database script, generated data table after carrying out;
Step 7: enrollment form in the menu of application system, user can pass through menu access list.
According to a further aspect in the invention, provide a kind of platform of dynamic generation list, comprising: stencil design module, template parsing module, picture rendering module, data processing module and menu page administration module, wherein:
Stencil design module: for the list pattern of user's request, design a EXCEL file as template, be used for describing the layout of list, comprise color, font, cell span, frame content; For the form data of user's request, need in EXCEL template file, add the descriptor of the data that will show or operate of each user's expectation; For the interactive form of user's request, need in EXCEL template file, add the interactive requirements information that will show that each user expects;
Template parsing module: when user uploads after template, template file is analyzed, and traveled through unit lattice, analyze list pattern, data and interactive form descriptor wherein, and will deposit in after all finish messages in list scheme detail list;
Picture rendering module: in the time that user need to show list, his-and-hers watches folk prescription case detailed data is analyzed, and automatically draws list layout, disposes unit lattice control;
Data processing module: template parsing module completes template and resolves and information is deposited in after list scheme detail list, analyze the form data descriptor in detailed data, by built-in DDL management function, the tables of data information of associative list folk prescription case, generating database script, and after automatically performing, in database, complete the building work of tables of data; If user has adjusted the data field of list, also need automatically to detect the change of list structure, the retouching operation of final executing data table;
Menu page administration module: for user's demand, allow enrollment form to increase, revise, inquire about three kinds of pictures newly, and support to distinguish by constructing variable, by this module, list is articulated in System menu, offer user's access and use.
Compared with prior art, the present invention has following beneficial effect:
The present invention separates by representing with data access, utilizes EXCEL software to generate easily worksheet.The present invention can reduce software Change risk effectively, and the final user who is ignorant of technology can be introduced to software design and development process.By simple designing form layout in EXCEL, and in cell design data stored logic and represent content, just can pass through list engine, layout is converted to list and database data item.
The present invention, by database access is encapsulated, utilizes the functional characteristics of EXCEL software itself, can effectively reduce developing instrument amount, reaches the target of the form customization workload that reduces 10%-60%, and is easy to adjust.The present invention can also effectively utilize user's management wealth itself, and the user who is ignorant of programming and database also can be worked out list and circulate, and controls enterprise application software Change risk.
Accompanying drawing explanation
By reading the detailed description of non-limiting example being done with reference to the following drawings, it is more obvious that other features, objects and advantages of the present invention will become:
Fig. 1 is the newly-increased process flow diagram of list;
Fig. 2 is form templat process of analysis figure;
Fig. 3 is platform assembly figure.
Embodiment
Below in conjunction with specific embodiment, the present invention is described in detail.Following examples will contribute to those skilled in the art further to understand the present invention, but not limit in any form the present invention.It should be pointed out that to those skilled in the art, without departing from the inventive concept of the premise, can also make some distortion and improvement.These all belong to protection scope of the present invention.
Embodiment 1
As shown in Figure 1-2, a kind of method that dynamically generates fast list based on EXCEL, comprises the following steps:
Step 1: carry out form data trend analysis, take out main list model data, set up list scheme.List scheme mainly comprises the numbering of list, Chinese, and master data table name, the person liable of list, Approved by, entry-into-force time and expired time etc.
Step 2: according to existing or newly-built EXCEL document, adjust or set up list framework, design Microsoft Excel, adjusts frame, Merge Cells, fixed text etc.
Step 3: according to user's request, list need to be shown or the data of typing arrange, and the discernible data item of the system that is converted to, write in each cell.Data item information spinner will comprise two parts: control descriptor and data description information.For control descriptor, need to comprise control type, control data source type, control data source, ranks position, Merge Cells, size, frame etc.; Data description information comprises the information such as Database field name, major key, data type, length, precision, default value, Chinese.
Step 4: upload template to server, template file is saved in to server end.
Step 5: carry out modular unit lattice data description and analyze, process by cell.The descriptor of analytic unit lattice, by information itemize in list scheme detail list.
Step 6: after having analyzed, form data model and data item are carried out to principal and subordinate associated, according to the data description information in list scheme, structure is converted to database script, generated data table after carrying out.
Step 7: enrollment form in the menu of application system, user can pass through menu access list.
In the present embodiment, defined data source that list is corresponding and the circulation accountability unit information of list in step 1 in list model data, the circulation accountability unit of all lists and the Data Source of list define simultaneously.
In the present embodiment, in step 3, in data item information, comprise the required information of content that is shown as form controls in the future, described data field and the control type of list.This definition information will be used for generating control content and Database field information.
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, is the relation of table and tabular, and is finally converted to a database table by the relationship conversion of list model and data item.
In the present embodiment, in step 3 and step 6, by list model and the conversion of form data item, and by master slave relation, be mapped as database table structure definition script, finally the function of generating database table in database.
Embodiment 2
As shown in Figure 3, a kind of platform of dynamic generation list, comprising: stencil design module, template parsing module, picture rendering module, data processing module and menu page administration module.Wherein:
Stencil design module: for the list pattern of user's request, design a EXCEL file as template, be used for describing the layout of list, comprise the contents such as color, font, cell span, frame; For the form data of user's request, need in EXCEL template file, add the descriptor of the data that will show or operate of each user's expectation, as information such as field, data type, length, precision; For the interactive form of user's request, need in EXCEL template file, add the interactive requirements information that will show of each user's expectation as control type, code, default value etc.;
Template parsing module: when user uploads after template, template file is analyzed, and traveled through unit lattice, analyze list pattern, data and interactive form descriptor wherein, and will deposit in after all finish messages in list scheme detail list;
Picture rendering module: in the time that user need to show list, his-and-hers watches folk prescription case detailed data is analyzed, and automatically draws list layout, disposes unit lattice control;
Data processing module: template parsing module completes template and resolves and information is deposited in after list scheme detail list, analyze the form data descriptor in detailed data, by built-in DDL management function, the tables of data information of associative list folk prescription case, generating database script, and after automatically performing, in database, complete the building work of tables of data; If user has adjusted the data field of list, also need automatically to detect the change of list structure, the retouching operation of final executing data table;
Menu page administration module: for user's demand, allow enrollment form to increase, revise, inquire about three kinds of pictures newly, and support to distinguish by constructing variable, by this module, list is articulated in System menu, offer user's access and use.
In the present embodiment, described picture rendering module, when showing when user data, must obtain customer parameter, and that determines current all data can editing mode.State agree as follows: N-is newly-increased, and M-revises, Q-inquiry; In the time that state is N, carry out initialization operation, each control load initial value, allows editor; In the time that state is M, executing data load operation, allows editor; In the time that state is Q, executing data load operation, does not allow editor;
In the present embodiment, described data processing module, in the time that user need to show list, the detailed data of his-and-hers watches folk prescription case is analyzed.In the time there is not form data in database, according to the initial value of control default value, the each control of drop-down control data source information initialization; In the time that list corresponding data has existed, load the data of list according to data-base recording.
In the present embodiment, described data processing module, in the time that user revises list and records, automatically detects modification information, and deposits a queue to be preserved in.In the time that user selects to preserve list modification, treat preservation queue and process.First obtain the record case in database, in the time that existence in database is recorded, each data item in queue is compared, if data are revised, include in and revise in statement; When in database when no record, carry out newly-increased operation according to queue.
Adopt above-mentioned platform to realize dynamic generation list process specific as follows:
1. newly-built list scheme data in stencil design module, the information such as code, title, entry-into-force time, expired time and necessary tables of data of input list.
2. set up EXCEL file, draw hereof the basic layout of list, complete cell drafting, frame design, fixed text input.
3. in template parsing module, to list being shown or the data of typing arrange, and the discernible data item of the system that is converted to.Data item information spinner will comprise field name, Chinese, data type, length, default value, control type etc.
4. that form data model and data item are carried out to principal and subordinate is associated for template parsing module Automatically invoked data processing module, and structure is converted to database script, generated data table after carrying out.
5. user, by specifying different parameter registration pictures in menu page administration module, is articulated to dynamic list in system.
6. user can click menu and test or use list.Now, the configuration of preserving in picture rendering module calling data storehouse, and resolve configuration and draw the page and control, initialization picture data.By the authorization function of menu page module, all right heavily loaded list, and make list there is different operating rights.
7. in the time that user is newly-increased or revise picture data, the data processing module of system is caught modification automatically, in the time submitting to, information newly-increased or that revise is saved in database.
Can find out from above-described embodiment, the present invention is by encapsulating database access, programming is converted into configuration, and utilize conventional office software EXCEL as template, can effectively reduce development amount amount, reach the target of the form customization workload that reduces 10%-60%, and be easy to adjust.
Above specific embodiments of the invention are described.It will be appreciated that, the present invention is not limited to above-mentioned specific implementations, and those skilled in the art can make various distortion or modification within the scope of the claims, and this does not affect flesh and blood of the present invention.
Claims (9)
1. a method that dynamically generates fast list based on EXCEL, is characterized in that comprising the following steps:
Step 1: carry out form data trend analysis, take out main list model data, set up list scheme, list scheme mainly comprises the numbering of list, Chinese, master data table name, the person liable of list, Approved by, entry-into-force time and expired time;
Step 2: according to existing or newly-built EXCEL document, adjust or set up list framework, design Microsoft Excel, adjusts frame, Merge Cells, fixed text;
Step 3: according to user's request, list need to be shown or the data of typing arrange, and the discernible data item of the system that is converted to, write in each cell; Data item information spinner will comprise two parts: control descriptor and data description information; For control descriptor, comprise control type, control data source type, control data source, ranks position, Merge Cells, size, frame; Data description information comprises Database field name, major key, data type, length, precision, default value, Chinese;
Step 4: upload template to server, template file is saved in to server end;
Step 5: carry out the analysis of modular unit lattice data description, process by cell, the descriptor of analytic unit lattice, by information itemize in list scheme detail list;
Step 6: after having analyzed, form data model and data item are carried out to principal and subordinate associated, according to the data description information in list scheme, structure is converted to database script, generated data table after carrying out;
Step 7: enrollment form in the menu of application system, user can pass through menu access list.
2. the method that dynamically generates fast list based on EXCEL according to claim 1, it is characterized in that, in described step 1, in list model data, defined data source that list is corresponding and the circulation accountability unit information of list, the circulation accountability unit of all lists and the Data Source of list define simultaneously.
3. the method that dynamically generates fast list based on EXCEL according to claim 1, it is characterized in that, in described step 3, in data item information, comprise the required information of content that is shown as form controls in the future, data field and the control type of having described list, this definition information will be used for generating control content and Database field information.
4. the method that dynamically generates fast list based on EXCEL according to claim 1, it is characterized in that, principal and subordinate's corresponding relation between list model and form data item in described step 6, by linking relation, be the relation of table and tabular by the relationship conversion of list model and data item, and be finally converted to a database table.
5. the method that dynamically generates fast list based on EXCEL according to claim 1, it is characterized in that, in described step 3 and step 6, by list model and the conversion of form data item, and pass through master slave relation, be mapped as database table structure definition script, finally the function of generating database table in database.
6. that realizes method described in claim 1 dynamically generates the platform of list fast based on EXCEL, it is characterized in that comprising: stencil design module, template parsing module, picture rendering module, data processing module and menu page administration module, wherein:
Stencil design module: for the list pattern of user's request, design a EXCEL file as template, be used for describing the layout of list, comprise color, font, cell span, frame content; For the form data of user's request, need in EXCEL template file, add the descriptor of the data that will show or operate of each user's expectation; For the interactive form of user's request, need in EXCEL template file, add the interactive requirements information that will show that each user expects;
Template parsing module: when user uploads after template, template file is analyzed, and traveled through unit lattice, analyze list pattern, data and interactive form descriptor wherein, and will deposit in after all finish messages in list scheme detail list;
Picture rendering module: in the time that user need to show list, his-and-hers watches folk prescription case detailed data is analyzed, and automatically draws list layout, disposes unit lattice control;
Data processing module: template parsing module completes template and resolves and information is deposited in after list scheme detail list, analyze the form data descriptor in detailed data, by built-in DDL management function, the tables of data information of associative list folk prescription case, generating database script, and after automatically performing, in database, complete the building work of tables of data; If user has adjusted the data field of list, also need automatically to detect the change of list structure, the retouching operation of final executing data table;
Menu page administration module: for user's demand, allow enrollment form to increase, revise, inquire about three kinds of pictures newly, and support to distinguish by constructing variable, by this module, list is articulated in System menu, offer user's access and use.
7. the platform that dynamically generates fast list based on EXCEL according to claim 6, it is characterized in that, described picture rendering module, in the time showing user data, must obtain customer parameter, that determines current all data can editing mode, and state agree as follows: N-is newly-increased, M-revises, Q-inquiry; In the time that state is N, carry out initialization operation, each control load initial value, allows editor; In the time that state is M, executing data load operation, allows editor; In the time that state is Q, executing data load operation, does not allow editor.
8. the platform that dynamically generates fast list based on EXCEL according to claim 6, it is characterized in that, described data processing module, in the time that user need to show list, the detailed data of his-and-hers watches folk prescription case is analyzed, in the time there is not form data in database, according to the initial value of control default value, the each control of drop-down control data source information initialization; In the time that list corresponding data has existed, load the data of list according to data-base recording.
9. the platform that dynamically generates fast list based on EXCEL according to claim 6, it is characterized in that, described data processing module, in the time that user revises list and records, automatically detect modification information, and deposit a queue to be preserved in, in the time that user selects to preserve list modification, treat preservation queue and process: first obtain the record case in database, in the time that existence in database is recorded, each data item in queue is compared, if data are revised, include in and revise in statement; When in database when no record, carry out newly-increased operation 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 true CN103778107A (en) | 2014-05-07 |
| CN103778107B 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) |
Cited By (40)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104090850A (en) * | 2014-06-24 | 2014-10-08 | 上海铀尼信息科技有限公司 | Online table system and data management method thereof |
| CN104391832A (en) * | 2014-11-18 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | Method for combining data in multiple EXCEL data sheets by using VBA (Visual Basic for Applications) |
| CN105069092A (en) * | 2015-08-05 | 2015-11-18 | 深圳联友科技有限公司 | Report display method, system and mobile terminal |
| CN105205071A (en) * | 2014-06-24 | 2015-12-30 | 阿里巴巴集团控股有限公司 | Method and system for showing data table |
| CN105278961A (en) * | 2015-10-28 | 2016-01-27 | 广州华多网络科技有限公司 | Method and system for generating database table structure document |
| CN105573602A (en) * | 2014-10-13 | 2016-05-11 | 远光软件股份有限公司 | Visualized multi-form display device and method |
| 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 |
| CN106598919A (en) * | 2015-10-14 | 2017-04-26 | 中兴通讯股份有限公司 | Document generation method and device |
| CN106598927A (en) * | 2016-11-30 | 2017-04-26 | 国云科技股份有限公司 | Method for rapidly creating Excel |
| CN106933559A (en) * | 2015-12-31 | 2017-07-07 | 阿里巴巴集团控股有限公司 | Forms pages data processing method and device |
| CN106980606A (en) * | 2017-03-30 | 2017-07-25 | 北京兴农丰华科技有限公司 | A kind of acquisition method of the customizable list data in mobile terminal |
| CN107329756A (en) * | 2017-06-29 | 2017-11-07 | 网易（杭州）网络有限公司 | Generation method, device, storage medium, processor and the terminal of program file |
| CN107544808A (en) * | 2017-09-07 | 2018-01-05 | 北京奥威科软信息技术有限公司 | The generation method and device of a kind of web form |
| CN107578217A (en) * | 2017-09-13 | 2018-01-12 | 深圳市沃易科技有限公司 | A kind of working electronic stream is autonomously generated method, apparatus and office management system |
| CN108021367A (en) * | 2017-12-15 | 2018-05-11 | 广州赛意信息科技股份有限公司 | A kind of UI development systems and method based on metadata framework |
| CN108292231A (en) * | 2015-11-09 | 2018-07-17 | 微软技术许可有限责任公司 | It generates and applies from data |
| CN108469953A (en) * | 2018-03-13 | 2018-08-31 | 深圳市易聆科信息技术股份有限公司 | A kind of generation method of page table list, server and storage medium |
| 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 |
| CN109857735A (en) * | 2018-12-29 | 2019-06-07 | 上海瑞家信息技术有限公司 | A kind of data configuration method and system carrying out regular description by excel |
| CN109977383A (en) * | 2019-03-11 | 2019-07-05 | 湖南纬拓信息科技有限公司 | A kind of form information extracting method based on Excel |
| CN110019025A (en) * | 2017-07-20 | 2019-07-16 | 中国移动通信集团公司 | A kind of stream data processing method and device |
| CN110083342A (en) * | 2019-04-26 | 2019-08-02 | 重庆紫光华山智安科技有限公司 | A kind of program creating method, device and computer readable storage medium |
| WO2019205790A1 (en) * | 2018-04-23 | 2019-10-31 | 华为技术有限公司 | Data operating method and device |
| CN110531964A (en) * | 2019-08-30 | 2019-12-03 | 苏州中弘软件技术有限公司 | The intelligent developed method of software personalisation |
| CN110705226A (en) * | 2019-08-22 | 2020-01-17 | 平安科技（深圳）有限公司 | Spreadsheet creating method and device and computer equipment |
| CN110717320A (en) * | 2019-10-11 | 2020-01-21 | 上海管和信息科技有限公司 | Form/report designer and method suitable for multiple platforms and information management system |
| CN110780859A (en) * | 2019-10-29 | 2020-02-11 | 成都阳帆网络科技有限公司 | Service architecture based on user-defined form |
| CN111783407A (en) * | 2020-07-17 | 2020-10-16 | 西思艾(北京)软件有限公司 | Electronic form creating system |
| CN111796803A (en) * | 2020-07-08 | 2020-10-20 | 宝牧科技（天津）有限公司 | Template report generation method based on multi-level container unloading |
| CN113283224A (en) * | 2021-06-09 | 2021-08-20 | 京东方科技集团股份有限公司 | Form generation method and device, electronic equipment and storage medium |
| CN113420080A (en) * | 2021-05-31 | 2021-09-21 | 北京三维天地科技股份有限公司 | Toxicology experiment data management system |
| CN113495887A (en) * | 2020-03-20 | 2021-10-12 | 北京沃东天骏信息技术有限公司 | Data form processing method, device and system |
| CN114064716A (en) * | 2021-10-29 | 2022-02-18 | 北京市农林科学院信息技术研究中心 | Metadata-based WEB report automatic generation method and device |
| CN114372177A (en) * | 2022-03-22 | 2022-04-19 | 创意信息技术股份有限公司 | Excel table data matching method |
| CN114896214A (en) * | 2022-04-18 | 2022-08-12 | 宝信软件(武汉)有限公司 | Host platform multi-data set batch transmission method and system |
| CN115098084A (en) * | 2017-05-09 | 2022-09-23 | 合肥汉腾信息技术有限公司 | Non-coding form design and drawing method |
| CN115563111A (en) * | 2022-09-27 | 2023-01-03 | 国网江苏省电力有限公司超高压分公司 | Method and system for configuring dynamic model of converter station system |
| CN117908862A (en) * | 2024-01-31 | 2024-04-19 | 和创（北京）科技股份有限公司 | 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 |
Cited By (56)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104090850B (en) * | 2014-06-24 | 2017-07-14 | 上海铀尼信息科技有限公司 | Online form system and its data managing method |
| CN105205071A (en) * | 2014-06-24 | 2015-12-30 | 阿里巴巴集团控股有限公司 | Method and system for showing data table |
| CN104090850A (en) * | 2014-06-24 | 2014-10-08 | 上海铀尼信息科技有限公司 | Online table system and data management method thereof |
| 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) |
| CN105069092A (en) * | 2015-08-05 | 2015-11-18 | 深圳联友科技有限公司 | Report display method, system and mobile terminal |
| 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 |
| CN105278961A (en) * | 2015-10-28 | 2016-01-27 | 广州华多网络科技有限公司 | Method and system for generating database table structure document |
| CN108292231A (en) * | 2015-11-09 | 2018-07-17 | 微软技术许可有限责任公司 | It generates and applies from data |
| CN108292231B (en) * | 2015-11-09 | 2021-09-28 | 微软技术许可有限责任公司 | Method and system for generating applications 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 |
| CN106598927A (en) * | 2016-11-30 | 2017-04-26 | 国云科技股份有限公司 | Method for rapidly creating Excel |
| 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 |
| CN107329756A (en) * | 2017-06-29 | 2017-11-07 | 网易（杭州）网络有限公司 | Generation method, device, storage medium, processor and the terminal of program file |
| CN107329756B (en) * | 2017-06-29 | 2020-06-26 | 网易（杭州）网络有限公司 | Program file generation method and device, storage medium, processor and terminal |
| CN110019025A (en) * | 2017-07-20 | 2019-07-16 | 中国移动通信集团公司 | A kind of stream data processing method and device |
| 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 |
| CN107578217A (en) * | 2017-09-13 | 2018-01-12 | 深圳市沃易科技有限公司 | A kind of working electronic stream is autonomously generated method, apparatus and office management system |
| CN107578217B (en) * | 2017-09-13 | 2021-02-12 | 深圳市沃易科技有限公司 | Working electronic flow autonomous generation method and device and office management system |
| CN108021367A (en) * | 2017-12-15 | 2018-05-11 | 广州赛意信息科技股份有限公司 | A kind of UI development systems 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 |
| WO2019205790A1 (en) * | 2018-04-23 | 2019-10-31 | 华为技术有限公司 | Data operating 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 |
| CN109857735A (en) * | 2018-12-29 | 2019-06-07 | 上海瑞家信息技术有限公司 | A kind of data configuration method and system carrying out regular description by excel |
| 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 |
| CN110083342A (en) * | 2019-04-26 | 2019-08-02 | 重庆紫光华山智安科技有限公司 | A kind of program creating method, device and computer readable storage medium |
| CN110705226A (en) * | 2019-08-22 | 2020-01-17 | 平安科技（深圳）有限公司 | Spreadsheet creating method and device and computer equipment |
| CN110531964A (en) * | 2019-08-30 | 2019-12-03 | 苏州中弘软件技术有限公司 | The intelligent developed method of software personalisation |
| 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 |
| CN110780859A (en) * | 2019-10-29 | 2020-02-11 | 成都阳帆网络科技有限公司 | 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 |
| CN111796803A (en) * | 2020-07-08 | 2020-10-20 | 宝牧科技（天津）有限公司 | Template report generation method based on multi-level container unloading |
| 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 |
| CN114064716A (en) * | 2021-10-29 | 2022-02-18 | 北京市农林科学院信息技术研究中心 | Metadata-based WEB report automatic generation method and device |
| 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 |
| CN114896214A (en) * | 2022-04-18 | 2022-08-12 | 宝信软件(武汉)有限公司 | Host platform multi-data set batch transmission method and system |
| CN115563111A (en) * | 2022-09-27 | 2023-01-03 | 国网江苏省电力有限公司超高压分公司 | Method and system for configuring dynamic model of converter station system |
| CN115563111B (en) * | 2022-09-27 | 2024-07-23 | 国网江苏省电力有限公司超高压分公司 | Dynamic model configuration method and system for converter station system |
| CN117908862A (en) * | 2024-01-31 | 2024-04-19 | 和创（北京）科技股份有限公司 | Method and device for establishing field anti-false deletion system under object conversion configuration |
| CN117908862B (en) * | 2024-01-31 | 2024-07-12 | 和创（北京）科技股份有限公司 | Method and device for establishing field anti-false deletion system under object conversion configuration |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103778107B (en) | 2017-05-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103778107A (en) | Method and platform for quickly and dynamically generating form based on EXCEL | |
| US10606573B2 (en) | System and method for computer language migration using a re-architecture tool for decomposing a legacy system and recomposing a modernized system | |
| 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 | |
| CN104133772B (en) | Automatic test data generation method | |
| US9411798B1 (en) | Methods and apparatus for reusing report design components and templates | |
| US7383234B2 (en) | Extensible data mining framework | |
| US20140172827A1 (en) | In-memory, columnar database multidimensional analytical view integration | |
| US20190188272A1 (en) | Personalized content authoring driven by recommendations | |
| CN111061475B (en) | Software code generating method, device, computer equipment and storage medium | |
| CN102810057A (en) | Log recording method | |
| CN101776999A (en) | Platform for developing and implementing software system | |
| US8407235B2 (en) | Exposing and using metadata and meta-metadata | |
| WO2020223997A1 (en) | Data analysis software architecture design method capable of implementing global configuration of storage, calculation and display | |
| US20150052157A1 (en) | Data transfer content selection | |
| CN101853163B (en) | Industry application software system construction method based on assembly business modeling | |
| US20080263018A1 (en) | Method and System for Mapping Business Objects to Relational Database Tables | |
| CN104573053A (en) | Configuration item template dynamic customizing method based on XML | |
| US8332746B2 (en) | Transformation of physical and logical layout forms to logical layout pages | |
| CN109344306B (en) | Method and system for customized online transaction and service of field multi-standard metadata | |
| CN114371845A (en) | Form generation method and device | |
| US10706225B2 (en) | Form management system and method | |
| KR101902191B1 (en) | Apparatus and method for dynamic customization and execution of query based software logic for multitenant | |
| US11934773B2 (en) | Systems and techniques for securely processing disparate data sets in spreadsheets | |
| Goonetillake et al. | An integrity constraint management framework in engineering design | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template |
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 |