Spreadsheet data management method based on C/S mode

Abstract

The invention provides a spreadsheet data management method based on a C/S mode. The method includes the steps of S1, completing the related settings of a spreadsheet template file in advance; S2, by a client, acquiring the setting information associated with the unique identification corresponding to the template file from a sever, and saving the setting information; S3, by the client, detecting whether the title content of the template file which is about to be submitted by a user and contains data is consistent with the title content saved by a database or not according to the setting information associated with the unique identification; S4, by the server, writing the received template file data uploaded by the client into the corresponding table of 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 an electronic form data management method based on a C / S mode. 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....

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

Images