appcmd recycle apppool /apppoolname:<the name of the app pool> in Microsoft Office

Drawing QR in Microsoft Office appcmd recycle apppool /apppoolname:<the name of the app pool>

You ve already learned the two ways for SharePoint to reference UDF assemblies: either directly via file path or indirectly via the Global Assembly Cache I covered the steps required to reference an assembly via a file path in a development environment and the steps required to debug UDF assemblies Now that development of our UDF is complete, let s take a look at the steps required to reference our assembly via the GAC: 1 Within Visual Studio, right-click the SampleFunctions node in the SolutionExplorer pane Select Properties from the context menu 2 In the Solution Properties Designer, click the Signing tab and check the Sign The Assembly checkbox

3 From the Choose A Strong Name Key File drop-down, select <New > to create a new Strong Name Key 4 Now that we ve specified that the assembly should be signed, we must recompile it before the signature is applied Choose Build | Build SampleFunctions 5 Now copy our assembly to the C:\Windows\Assembly folder to register it with the Global Assembly Cache 6 Switch over to the SharePoint 2010 Central Admin site, where we ll change the UDF configuration within the Manage Excel Services page Delete the previous development entry for SampleFunctionsdll 7 Click Add User-Defined Function Assembly Set the Assembly Location to Global Assembly Cache 8 To find the strong name for our assembly, switch back to Visual Studio 2010 Either press ctrl-alt-a or choose View | Other Windows | Command Window to display the Visual Studio Command Window 9 In the command window, enter the following command:

The resulting output will be the strong name for our assembly:

10 Copy this value into the Assembly text box on our Add User-Defined Function Assembly page, as shown:

11 Click OK to register the assembly and then recycle the SharePoint Web Services application pool to pick up the new reference We can now test using the REST API URL that we created earlier to confirm that our assembly is being correctly picked up from the GAC

12

We ve almost met the requirements of our demonstration scenario The only item missing is a user-interface element that can be used to switch currencies Let s move on and take a look at how we can implement this functionality using the JavaScript Object Model (JSOM)

Before we jump into adding script to the page, let s look at the objects that are exposed via JSOM and the mechanism for connecting to EWA web parts

The EwaControl is the entry point to the object model and represents an EWA web part As well as representing a specific instance of an EWA web part, the EwaControl has a static getInstances method that can be used to retrieve a collection of the EWA web parts on a page For example, the following code snippet returns an EwaControl object that represents the first EWA web part on a page:

As well as the methods mentioned, all events exposed by JSOM are defined on the EwaControl object These include events such as activeCellChanged, gridSynchronized, and workbookChanged Event-handling delegates can be hooked up using JavaScript code similar to this snippet:

var myEwa; _spBodyOnLoadFunctionNamespush("EwaPageLoad"); function EwaPageLoad() { EwaEwaControladd_applicationReady(GetEwa); } function GetEwa(){ myEwa = EwaEwaControlgetInstances()getItem(0); if(myEwa) { myEwaadd_activeSelectionChanged(activeSelectionChangedHandler); } }

The Workbook object represents an Excel workbook A reference to the workbook used by a particular EwaControl can be retrieved using the following code:

var myWorkbook = myEwagetActiveWorkbook();

The Workbook object provides a number of methods that can be used to retrieve particular ranges, worksheets, or named ranges As well as these methods, refreshing the underlying data of a workbook can be performed by calling the refreshAllAsync method Note that to refresh a workbook, the referenced EWA web part must have the Refresh Selected Connection, Refresh All Connections option checked