You can only view and edit specified sheet pages after opening an Excel file.

How does the system control that users can only view and edit specified sheet pages after opening an Excel file?

Code download: http://ishare.iask.sina.com.cn/f/10323532.html

This problem may not have been encountered by me alone, but I have studied this method together. Of course, it depends on whether you are using soaoffice. This product is used in the company project. It supports js to call the VBA interface on the client to control the Excel performance on the webpage. The method is very simple. The key is the following function. Loop hides the sheet page that does not need to be displayed. Sheet has the visible attribute in VBA:

Function onlyshow (sheetname)

{

VaR OBJ = Document. getelementbyid ("soaofficectrl"). Document;

For (VAR I = 1; I

Previous: drop-down menu and soaoffice control in the Web

Next article: When editing a word in a webpage, only traces of the specified user are displayed.