Office Business Applications (OBAs) Hands-on Lab

image Diese Woche haben wir in Zürich und Yverdon einen MSDN TechTalk und anschliessend ein MSDN Hands-on Lab (HOL) zu OBA durchgeführt. An den Hands-on Labs haben knapp 100 Personen teilgenommen und wissen nun, was 2007 Office in Ergänzung mit Visual Studio 2008 zu bieten hat!

Download

Falls Sie nicht an der Veranstaltung teilnehmen konnten, jedoch trotzdem an dem HOL interessiert sind, können Sie die Unterlagen jetzt herunterladen.

Inhalt

Das gesamte Lab durchzuarbeiten, dauert ca. drei Stunden. Die folgenden Technologien werden behandelt:

  • Entwicklung von 2007 Office Applikationen mit Hilfe von Visual Studio 2008 (Visual Studio Tools for Office)
  • Open XML (Standard Dateiformat ab 2007 Office)

Diese Themen werden gestreift:

  • SQL Server Compact Edition
  • Windows Communication Foundation (WCF)
  • LINQ (LINQ to XML)

Das HOL ist in Englisch geschrieben, daher sind die nächsten Zeilen in Englisch verfasst.

Lab 1 – Developing an Application-level Add-in for Excel 2007

After completing this lab you’ll be able to understand how to

  • develop Visual Studio Tools for Office based add-ins for 2007 Office
  • develop custom task panes
  • extend the Office Fluent Ribbon using the Ribbon Designer
  • work with SQL Server Compact Edition 3.5

Lab 2 – Developing an Outlook 2007 Add-in

After completing this lab you’ll be able to understand how to

  • develop Visual Studio Tools for Office based add-ins for Outlook 2007
  • develop Outlook form regions
  • provide a WCF service and how to call it

Lab 3 – ClickOnce Deployment of Application-based Add-ins

After completing this lab you’ll be able to understand

  • how ClickOnce works for applications-based add-ins
  • how to configure and test ClickOnce applications on your development environment
  • that ClickOnce deployment is easy for the developer and provides a good user experience for the information worker

Lab 4 – Developing a Document-level Add-in for Word 2007

After completing this lab you’ll be able to understand

  • How to develop Visual Studio Tools for Office based document-level add-ins for 2007 Office
  • the difference between application-level and document-level add-ins
  • develop context specific custom action panes
  • that Office Business Application can not only read, but also modify backend data
  • the object model of the new Word 2007 content controls including events
  • the basics of the Word object model
  • that the Office object model is not the most intuitive for the .NET developer

Lab 5 – Creating Word documents on the Server using Open XML

After completing this lab you’ll be able to understand

  • how to create and change Office documents without using the Office object model due to Open XML
  • that Word 2007 content controls allow the separation of layout and data
  • that Open XML documents are ZIP containers and contain several files
  • that executing Open XML programs is several times faster than programs which use the Office object model
  • that the Word 2007 Content Control Toolkit is helpful when it comes to separation of layout and data
  • LINQ to XML (Language Integrated Query) offers a handier way to work with XML

Ich wünsche viel Spass beim Durcharbeiten des HOLs und hoffe, dass Sie einiges für eigene Projekte wiederverwenden können!