Application development system and method based on database and spreadsheet software

A spreadsheet and database technology, applied in the computer field, can solve problems such as poor compatibility, increased workload, and limited big data processing capacity of Excel office software, and achieve good compatibility and facilitate secondary development.

Inactive Publication Date: 2019-07-16
刘浩
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the Excel file is a static file and cannot be automatically associated with other Excel files to form a logical loop structure and branch structure. To achieve this function, repeated manual operations are required; calling data from other computers, It needs to be called and transferred multiple times manually, and the transferred data often needs to be manually adjusted by statistics before filling in the report, which cannot avoid human errors and increases the workload
[0003] In addition, the big data processing capability of Excel office software is limited
However, database software such as SQL with large data storage and processing capabilities can be accessed remotely, but its data processing is not as convenient as Excel
[0004] Using existing programming methods to develop an application with automatic data processing function often requires a structured programming language, which requires relatively high levels of English and logic for developers; during the development process, many s

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
  • Application development system and method based on database and spreadsheet software
  • Application development system and method based on database and spreadsheet software
  • Application development system and method based on database and spreadsheet software

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0062] The embodiment of the present invention provides an application development method based on a database and electronic spreadsheet software, and performs data call and intercommunication association between an Excel table and the database software, so as to realize the all-round extension of the information system.

[0063] An aspect of the embodiments of the present invention provides an application development system based on database and spreadsheet software.

[0064] The electronic form software in the embodiment of the present invention can be the electronic form component Excel in Microsoft OFFICE software, the electronic form etc. in domestic CCED (Chinese character table editing software), Kingsoft WPS, below is example to illustrate the present invention and implement with Excel example.

[0065] A schematic diagram of a database-based and Excel-based application development and data processing system provided by an embodiment of the present invention is as foll...

Embodiment 2

[0110] This embodiment provides a database and Excel-based application development information platform system and method.

[0111] This embodiment provides a schematic structural diagram of an application development information platform system based on a database and Excel, such as Figure 5As shown, the system includes: database, processor, application designer, web designer and web server. Among them, the functions of the database, the processor, and the application designer are as described in the first embodiment, and the database is placed in a local area network or a wide area network according to the user's needs, so as to facilitate user access.

[0112] The Web designer is used to design the interaction mode between the database and the webpage in the user's web browser (data addition, deletion, modification and query), design the interaction mode between the webpage and the user in the user's web browser (page jump, user operation authority, etc.), and design the w...

Embodiment 3

[0122] This embodiment provides a kind of application development and data processing method based on database and Excel, and this method can be used in labor and management department statistics salary, and this method comprises:

[0123] Step 1: Install. Install the database, processor, application designer, web designer and web server; wherein, the database and web server are installed together and placed on the public network for easy access as a data center. The processor, the application designer and the web designer are installed on a PC, and the web designer is specially used for data processing as a data processing center. Install the application designer on a PC in the labor and management department.

[0124] Step 2: Authentication. Authenticate the processor, application designer, web designer, and web server to obtain corresponding permissions. Among them, the authority of the application designer of the data processing center can be used for designing, publish...

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 embodiment of the invention provides an application development system and method based on a database and spreadsheet software. The system comprises an application designer, a processor and a database; the application designer is used for constructing a logical relationship of data and obtaining a table file with the logical relationship; the processor is used for managing and executing logicof the form file; and the database is used for storing the operation parameters in the application designer and the processor and storing the user data. By installing the application designer, the processor and the database, the processor and the application designer are authenticated, logic design is carried out on the application designer according to user requirements to generate a form file, and the form file generation application is released to process data of the database to obtain a processing result. The interface and logic can be separated, software design is specialized, compatibility is good, and secondary development of the application is facilitated; and cross-server operation and distributed calculation can be realized, complex applications can be constructed, and differentuse requirements of users can be met.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to an application development system and method based on database and electronic form software. Background technique [0002] At present, the Excel office software has been deeply rooted in the hearts of the people, and its rich automatic office functions have brought great convenience to users' daily office life. However, the Excel file is a static file and cannot be automatically associated with other Excel files to form a logical loop structure and branch structure. To achieve this function, repeated manual operations are required; calling data from other computers, It needs to be manually called and transmitted multiple times, and the transmitted data often needs to be manually statistically adjusted before filling in the report, which cannot avoid human errors and increases the workload. [0003] In addition, the big data processing capability of the Excel office software is...

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
IPC IPC(8): G06F8/20
CPCG06F8/20
Inventor 刘浩
Owner 刘浩
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap