Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and platform for quickly and dynamically generating form based on EXCEL

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

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
  • Method and platform for quickly and dynamically generating form based on EXCEL
  • Method and platform for quickly and dynamically generating form based on EXCEL
  • Method and platform for quickly and dynamically generating form based on EXCEL

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

No 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
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/24G06F9/44
Inventor 徐桂红万成许荻蒋振华赵敦奎
Owner SHANGHAI BAOSIGHT SOFTWARE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com