Сохранение на сервере данных из клиента Excel

This example shows you how to:

Create a workbook with editable ranges.
Save the workbook to a SharePoint document library that is a trusted location.

Примечание.

[!Примечание] It is assumed that you have already created a SharePoint document library and made it a trusted location. Дополнительные сведения см. в разделе Практическое руководство. Доверие к расположению.
Change values in a workbook by using the parameters pane in Веб-клиент Excel.

Saving a Workbook to Excel Services

Запустите Excel.
In cell A1, type 8.
In cell A2, type =3*A1.
To make cell A1 editable in Веб-клиент Excel, you must first make cell A1 into a named range:
Click the Formulas tab, and then click cell A1 to select it.
On the Formulas tab, in the Defined Names group, click Define Name.
In the New Name dialog box, in the Name text box, typeMyAOneParam.

В меню Файл выберите команду Сохранить & Отправить, а затем — Сохранить в SharePoint.
In the Save to SharePoint dialog box, click Publish Options.
In the Publish Options dialog box, on the Show tab, ensure that Entire Workbook is selected.
On the Parameters tab, click Add..
In the Add Parameters list, select the MyAOneParam check box.
Click OK. You should now see "MyAOneParam" in the Parameters list.
Click OK to close the Publish Options dialog box.
In the Save to SharePoint dialog box, click Save As.
In the Save As dialog box, ensure that the Open with Excel in the browser check box is selected.
In the File name text box, type the path to the trusted SharePoint document library where you want to store this workbook. For example,http:// MyServer002/Shared%20Documents/TestParam.xlsx.
Click Save. You should see TestParam.xlsx in Веб-клиент Excel.

In the Parameters pane, you should see the named range for cell A1that is, MyAOneParam.
You can change the values in cell A1 and cell A2 by typing a number in the text box next to MyAOneParam. For example, if you type 10 and then click Apply, cell A1 changes to 10 and cell A2 changes to 30.