Сохранение на сервере данных из клиента 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
To create a workbook with ranges
Запустите 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.
Сохранение в службы Excel
В меню Файл выберите команду Сохранить & Отправить, а затем — Сохранить в 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.
To change values by using parameters
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.
См. также
Задачи
How to: Save to the Server to Prepare for Programmatic Access
Понятия
Loop-Back SOAP Calls and Direct Linking
Другие ресурсы
Пошаговое руководство. Разработка настраиваемого приложения с помощью веб-служб Excel