Enregistrer à partir du client Excel sur le serveur

Cet exemple montre comment :

créer un classeur avec des plages modifiables ;
Save the workbook to a SharePoint document library that is a trusted location.

Remarque

Cette étape suppose que vous ayez déjà créé une bibliothèque de documents SharePoint qui soit un emplacement approuvé. Pour plus d’informations, consultez Guide pratique pour approuver un emplacement.
Change values in a workbook by using the parameters pane in Excel Web Access.

Enregistrement d'un classeur dans Excel Services

Démarrez Excel.
In cell A1, type 8.
In cell A2, type =3*A1.
To make cell A1 editable in Excel Web Access, 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.

Dans le menu Fichier , cliquez sur Enregistrer & Envoyer, puis sur Enregistrer dans 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 Web Access.

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.