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

A spreadsheet and system implementation technology, applied in word processing, digital data authentication, etc., can solve problems such as low efficiency, cumbersome, and boring, and achieve the effect of flexible use, reduced workload, and simple operation

Inactive Publication Date: 2014-02-26
WUKUN STEEL
View PDF2 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 th

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 system based on multi-user environment and implementation method of spreadsheet system
  • Spreadsheet system based on multi-user environment and implementation method of spreadsheet system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0046] Such as figure 2 As shown, take the implementation process of the salary schedule of 18 subordinate units of a steel company as an example.

[0047] S101: Create an Excel workbook file according to the number of users and their requirements for querying data, and save the Excel workbook file to the disk under the name "schedule of wages of each unit";

[0048] S102: Create 20 Excel worksheets in the created Excel workbook, the first worksheet Sheet1 is used as a user prompt sheet, write concise operation prompts in this sheet, and explain the operation steps of this multi-user electronic form to the user , and the name of the worksheet was renamed as "reminder"; the 2nd to 19th worksheets were used by 18 units to query the salary data of their own units, and the name of the worksheet was renamed as the name of the 18 units; the last worksheet It is used to store the data source, renamed as "data".

[0049] S103: Copy the detailed salary data of the current month to t...

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

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): G06F21/31
CPCG06F21/31G06F40/18
Inventor 普太文
Owner WUKUN STEEL
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