Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Spreadsheet data management method based on B/S mode

A spreadsheet and data management technology, applied in the field of data processing, can solve the problems of data size limitation, data modification, deletion of original data inconsistency, difficult data management, etc., and achieve the effect of reducing slow data loading and friendly interaction

Inactive Publication Date: 2014-12-24
SUZHOU JINGYIHUI INFORMATION TECH
View PDF2 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] A single economic entity can barely cope with the use of Excel or WPS forms, but enterprises with multiple stores need to obtain the operating data of each store in a timely manner. The Excel or WPS spreadsheets delivered by stores are independent, and scattered data is difficult to manage. , and special personnel are required to further maintain the received form data; furthermore, if the permission settings for the summary data are not clear enough, there will be problems such as data modification, deletion, etc. that are inconsistent with the original data, and data security cannot be guaranteed. Guaranteed
[0005] 2) data size limit
[0006] A single data file in an Excel or WPS table has a limit on the size of the data. When the saved data reaches the data limit, a new table needs to be created to continue the data in the previous table; in the case of a large data volume, the data loading is slow, affecting Operate on data files
[0007] 3) It is difficult to change user habits

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
  • Spreadsheet data management method based on B/S mode
  • Spreadsheet data management method based on B/S mode
  • Spreadsheet data management method based on B/S mode

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] In order to make the electronic form data management method based on the B / S mode and its advantages mentioned in the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings.

[0030] figure 1 The flow chart of the electronic form data management method based on the B / S mode provided by the embodiment of the present invention, figure 2 The flow chart of the relevant settings of the electronic form template file provided for the embodiment of the present invention, in order to clearly illustrate the method of the present invention, combined with figure 1 and figure 2 , the method includes the following steps:

[0031] Step 101, complete the relevant settings of the electronic form template file in advance.

[0032] Electronic form in the present invention refers to Excel or a form based on Excel, or a WPS form or a form based on a WPS form, and a VBA program needs to be installed when usi...

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 spreadsheet data management method based on a B / S mode. The method includes the steps of S1, completing the related settings of a spreadsheet template file in advance; S2, by a browser, uploading the spreadsheet template file which is selected by a user and contains data to a server; S3, by the server, detecting whether the title content of the received template file is consistent with the field name saved by a database table or not according to unique identification, and if so, writing the template file data confirmed by the user into the corresponding table of a database; or else, allowing the template file data not be written into the database. The method has the advantages that the spreadsheet template file data passing detection is managed through the database, and the defect that data is scattered and hard to manage when only the spreadsheet is used is overcome; data file data amount limitation of collected data is avoided; spreadsheet using habits of the user are unchanged, and friendly user interaction is achieved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a B / S mode-based electronic form data management method. Background technique [0002] With the continuous development of information technology, Internet technology is widely used in various fields, and the combination of office automation and Internet technology is gradually being favored by more and more users. The spreadsheet software is represented by Excel and WPS. With its very friendly man-machine interface and powerful calculation functions, it has become the right-hand man for the majority of users to manage company and personal finances, statistical data, and draw various specialized tables. Use Excel or WPS forms to achieve daily operations, which can save the cost of purchasing and maintaining special data management software. For enterprises with weak economic strength or enterprises that have no purchase plan, more funds can be used for other aspects. Howe...

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): G06F17/30
CPCG06F16/162G06F16/16G06F16/951
Inventor 牟春林
Owner SUZHOU JINGYIHUI INFORMATION TECH
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
Eureka Blog
Learn More
PatSnap group products