Spreadsheet data management method based on B/S mode

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...

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