Method and platform for quickly and dynamically generating form based on EXCEL
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
A dynamic generation and form technology, applied in the field of data processing, can solve problems such as operation authority restrictions and potential safety hazards, and achieve the effects of easy adjustment, reduced risk of change, and reduced workload of form customization
Active Publication Date: 2014-05-07
SHANGHAI BAOSIGHT SOFTWARE CO LTD
View PDF7 Cites 45 Cited by
Summary
Abstract
Description
Claims
Application Information
AI Technical Summary
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
Problems solved by technology
Both of the above two inventions must manually establish data tables in the database, which usually has operation authority restrictions and potential safety hazards for the running software system
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more
Image
Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
Examples
Experimental program
Comparison scheme
Effect test
Embodiment 1
[0036] like Figure 1-2 As shown, a method for quickly and dynamically generating forms based on EXCEL includes the following steps:
[0037] Step 1: Analyze the tendency of form data, abstract the main form model data, and establish a form scheme. The form scheme mainly includes the number of the form, the Chinese name, the name of the master data table, the person in charge of the form, the approver, the effective time and the expiration time, etc.
[0038] Step 2: According to the existing or newly created EXCEL document, adjust or establish the form frame, design the EXCEL table, adjust the border, merge cells, fix the text, etc.
[0039]Step 3: According to user needs, organize the data that needs to be displayed or entered in the form, and convert it into data items that the system can recognize, and write it into each cell. Data item information mainly includes two parts: control description information and data description information. For control description inform...
Embodiment 2
[0049] like image 3 As shown, a platform for dynamically generating forms includes: a template design module, a template analysis module, a screen rendering module, a data processing module, and a menu page management module. in:
[0050] Template design module: Design an EXCEL file as a template to describe the layout of the form, including color, font, cell merge, border, etc., for the form style required by the user; for the form data required by the user, it needs to be in the EXCEL template Add the descriptive information of the data that each user expects to be displayed or manipulated in the file, such as fields, data types, length, precision, etc.; for the interactive form of user needs, it is necessary to add the desired data to be displayed by each user in the EXCEL template file Interaction request information such as control type, code, default value, etc.;
[0051] Template parsing module: After the user uploads the template, analyze the template file, traverse...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more
PUM
Login to view more
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 [0001] The invention relates to the field of data processing, in particular to a method and platform for quickly and dynamically generating forms based on EXCEL. Background technique [0002] Forms are an important part of enterprise management. Different enterprises or fields often have unique requirements for reports, so that managers can better conduct enterprise decision-making and management. Forms are different from enterprise reports. Reports are often based on the summarization and processing of data, while forms are usually used to record the daily management of enterprises. The complexity lies in the fact that they must be interactive and can be transferred between various departments and personnel of the enterprise. [0003] Form design often includes three parts: layout and data processing. The layout determines the display structure of the data. The ultimate goal of the form is to provide users with an interface that is easy to use, easy to ente...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more
Application Information
Patent Timeline
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to view more 
Login to view more