As described in previous articles, we can publish EXCEL to SharePoint Server through Excel services, so that users can browse the Excel worksheet online. If necessary, we can further set it, allow users to interact with the Excel worksheet. You can also write an application to interact with it.
To use Excel services, you must first start excel in Moss
Calculation Services Service, and ensure that the directory for storing Excel documents has been set to a trusted path...
Let's just say, let's create an Excel document first.
I entered a formula in cell B3, equivalent to the B1 + B2 value, and generated a bar chart.
There are two release methods available for us:
First, log on to SharePoint
Server site. The Excel file is uploaded to the server as an attachment through the webpage.
The second upload method is to use the Release Feature of excel2007 (this time, the MS product line is closely supported ):
Enter the path to be released in the address bar.
Click Save to save the file on the server.
Then we can browse the Excel documents on the web page and enter the Excel document directory on the site.
We can see the previously uploaded Excel document.
Move the mouse over the document name. A drop-down list box is displayed on the periphery of the file name.
Click the drop-down box and select View in Web browser.
Next, the page will jump to the displayed page.
We can also select the sheet to display on the webpage:
By default, the published Excel files cannot be modified in the browser, and the displayed content cannot be controlled. If you want to implement this function, you must make further settings at the time of release:
Open the Excel document you just created, select "publish", and enter the "Save as" form. We can see that there is an "Excel services option" button at the top of the "save" button.
Click this button, then we can see two option boards in the "Excel services Options" form. The "show" option Board (the first option board) can control which sheet is displayed. Here, we hook sheet1 and sheet3.
The "parameter" option board controls which cells in Excel can be edited:
Click the Add button and a prompt will appear:
We also need to name the cells in Excel (the default name cannot be used), return to the sheet just now, right-click cell B1, and a menu will appear, select "named cell region "....
Then, we select "add" again. The cell name is displayed on the form. Select All
Then we save the document to the server for browsing, and we will find that sheet2 is gone; but the unit in the table still cannot be edited :(. Don't worry, look at the right side of the page: There is an editing form, and the above is the cell we want to boundary. Enter a few numbers! :)
Enter a number and click "Apply". The page will be refreshed and the result will be returned to us: the corresponding cells and images will change. If necessary, we can save this page. But it cannot be saved as an Excel file. Sorry... Of course, Ms still provides us with this function, but it must be implemented using a program: I will discuss it with you in the next article. Thank you for choosing