The power of Word, Excel, Access and Visio Services come to light in this unit. A number of tasks can now be pushed to these server-side services for processing. For instance, you can convert your documents at scale into other formats, whether fixed (XPS, PDF) or fluid (RTF), using Word Services. And Access Web databases can be published to SharePoint via Access Services where Access tables become Lists, forms become ASPX pages, macros become workflows, etc.
Hands-On Labs
Office 2010 Service Applications Lab
Now with both C# and VB code samples! In this lab, you will use the Office 2010 services applications to build a report generation application. This application uses Excel Services to access an Excel workbook via REST services and generate a Word document based on the data. Word Services converts the Word document into a PDF and XPS file and stores it in a report repository. Finally, Visio Services presents a graphical representation of the process to the user showing which reports have been generated.
Using the Excel Services ECMAScript Object Model Lab
In this Hands-On Lab you will learn how to use the Excel Services ECMAScript Object Model to automate and interact with an Excel Web Access web part.
Using the ECMAScript Object Model for Visio Services
The objective of this Hands On Lab is to provide you with a foundation for using the Visio ECMAScript object model to expand the functionality of a Visio Web Access web part.
Designing Excel Solutions for the Web
Excel Services, part of SharePoint Server 2010, offers new capabilities to developers looking to create server-based Excel solutions either on-premise or in the cloud with Office 365. This Hands-On Lab will explore some of the common tasks that developers perform while designing and migrating Excel client-based solutions to Excel Services-based solutions.
Videos
Developing With Word Services
Word Services can convert documents into other formats, both fixed (XPS, PDF) and fluid layouts (RTF) are supported. An important feature is the ability of Word Services to recalculate fields during processing allowing details such as a Table of Contents to be built dynamically. Coupled with the power of Open XML, which is well suited for modifying the document contents, a tremendous opportunity for scaling document creation, modification and conversion on the server is available. This video introduces the capabilities of Word Services.
Developing With Access Services
Design an Access database for the Web and you can publish it to SharePoint via Access Services. Access tables become SharePoint Lists and queries, reports and forms are all automatically converted to their SharePoint equivalent. This video introduces the all new capabilities of Access Services.
Developing With Visio Services
This video introduces the capabilities of Visio Services including data-bound shapes, the Visio viewer Web part and the JavaScript Object Model.
Designing Excel Solutions for the Web Part 1
In part one of this two-part series, Larry Waldman, Excel Program Manager, discusses how to think about designing Excel solutions for the Web. As the Program Manager for Excel Services extensibility, Larry talks through the power of solutions built on Excel Services and what's now available in SharePoint 2010. This includes some additions to the Excel Web Services as well as the all new Excel REST API and JavaScript object model (JSOM). Using one or all of these APIs in concert allows developers to incorporate Excel Services as a component in much broader Web-based and rich client solutions. Watch as Larry covers this and more.
Designing Excel Solutions for the Web Part 2
In part two of this two-part series, Larry Waldman, Excel Program Manager, talks in detail about how to execute the migration of Excel client solutions to web-based Excel Services solutions. Larry walks through the migration of a sample Excel client application to its new incarnation as a Web-based solution. Along the way, he shows specific code for how to use the Excel Services JavaScript object model. The Excel Services REST API and Excel Web Service were also used to round-out the new web solution.