Spreadsheet system based on multi-user environment and implementation method of spreadsheet system

Abstract

The invention discloses a spreadsheet system based on multi-user environment and an implementation method of the spreadsheet system. The spreadsheet system comprises a data storage module, a macro driving module, a VBA (Visual Basic for Applications) driving script module and a function module, wherein the data storage module comprises an Excel worksheet, a data source sheet, a macro sheet and a user prompt sheet; the macro driving module reads the macro sheet when a user logs in, drives macro script to judge whether to forbid macro and responds; the VBA driving script module encrypts the worksheet and forbids a user to open a VBE (Visual Basic Editor), judges whether login of the user is legal and responds; the function module acquires and analyzes user function, and then, calls an ExcelCOM interface to search data in a reference data source sheet, and returns back to result to fill and display cells. The implementation method comprises a step of creating the data storage module, the function module, the macro driving module and the VBA driving script module. The spreadsheet system based on multi-user environment and the implementation method of the spreadsheet system have extremely high flexibility, usability and practicability, and can greatly improve working efficiency of managers.

Description

technical field [0001] The invention belongs to the technical field of electronic documents, and in particular relates to an electronic form system with safety, flexibility, ease of use and practicality in a multi-user environment and a realization method thereof. Background technique [0002] Microsoft Excel is one of the components of Microsoft Office, the office software of Microsoft Corporation. Due to the large number of formula functions available in Excel, Excel can perform calculations, analyze information, and manage data information lists and data charts in spreadsheets or web pages. It can realize many convenient functions and bring convenience to users. It is widely used in many fields such as management, statistics, finance, and finance. [0003] Since Excel can only encrypt the entire workbook or a single worksheet, it is difficult to implement multi-user access control. Therefore, access control in a multi-user environment is mostly implemented through complex...

AI Technical Summary

Problems solved by technology

Salary data is confidential information. The previous processing method was that the company salary administrator sorted the detailed monthly salary data by unit, then copied and pasted the salary data of employees in the same unit into a new Excel worksheet, and saved it as an Excel file. , as many units as there are, follow this step repeatedly to create as many Excel files one by one; and then distribute the Excel files created above to each unit of the company one by one through instant messaging software or email, which is very cumbersome. Time-consuming and inefficient, it also makes the payroll administrator feel boring and boring in the long run

Images